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)
Data consistency, starting with the end in view
Download
Download
Data consistency, starting with the end in view.xlsx
Complete and Continue
Discussion
10
comments
Load more
Lesson Content Locked
Your session expired. Please sign in again to continue.
Login
10 comments