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)
Introducing the trainer and the course
Download
Business Data Analysis with Excel Training Manual.pdf
Download
Business Data Analysis with Excel Training Manual.pdf
Exceljet Excel Shortcuts.pdf
Download
Exceljet Excel Shortcuts.pdf
Complete and Continue
Discussion
4
comments
Load more
4 comments