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
XLOOKUP.xlsx
Download
Complete and Continue
Discussion
6
comments
Load more
6 comments