New Excel Function - XLOOKUP | UrBizEdge

Autoplay
Autocomplete

Previous Lesson Complete and Continue

Basic Microsoft Excel and Business Data Analysis

Introduction

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)
Quiz

Charts

Charts (25:51)
Quiz

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)
Quiz

New Excel Function - XLOOKUP

Download

Complete and Continue

Discussion

0 comments