New Excel Function - XLOOKUP | UrBizEdge

Autoplay
Autocomplete

Previous Lesson Complete and Continue

Business Data Analysis with Microsoft Excel

Introduction

Introducing the trainer and the course (10:49)
Course Platform Walk-through (4:25)

Data Manipulation in Excel and setting the foundation.

How Excel handles different data types (5:43)
Data consistency, starting with the end in view (13:27)
Building Datasheets that can scale (12:49)
Sorting (11:14)
Filtering (17:46)
Data Cleaning (21:28)
Data Formatting (15:01)

Charts

Charts (25:51)

Creative Excel Use and Tips

Creative Excel Features (24:35)
Specials -- Creative Excel Use (24:19)
Special Video -- Excel Keyboard Shortcuts (26:10)

Business Data Analysis

Pivot Table, Pivot Chart and PowerPivot (14:23)
Mail Merge (13:25)
Business Data Analysis - part 1 (22:05)
Business Data Analysis - part 2 (22:45)
Forecasting using Excel 2016 Forecast tool (4:21)
Data Visualization (21:05)
Excel Reports And Presentation (11:11)
NamedRange, Goal Seek, Scenario Manager (37:40)
Excel Web Query (20:11)
Power Excel Functions (47:40)
Power Excel Function - SUMPRODUCT (10:16)
New Excel Function - XLOOKUP (14:07)
New Excel Function - UNIQUE (7:08)
New Excel Function - SORT (2:44)
Connect to Google Sheets from Excel (4:36)
Fuzzy Lookup for matching inconsistently typed entries (3:40)

Excel Macros (VBA)

Excel Macros (6:48)
Userform and more Macros (34:45)
Excel Store: Nigeria Market Data App (14:43)

Special Webinar Sessions

Webinar on Using Microsoft Excel for Investment Planning and Personal Finance (71:30)
Webinar on Predictive Analysis in Microsoft Excel (76:07)
Webinar on Power Query and Power Pivot (61:11)

Power BI (bonus section, not in-depth)

Power BI (27:47)

Excel for Mac Tips

How to Enable Developer tab in Excel for Mac (1:42)
Set Calculation Options in Excel for Mac (1:19)
How to Check for Excel for Mac version (1:15)
Custom Lists in Excel for Mac (5:10)
How to Change Default Font Type and Size in Excel for Mac (1:05)
Grouping Menu Items Titles in Excel for Mac (1:30)

New Excel Function - XLOOKUP

Download

Complete and Continue

Discussion

6 comments