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
Data consistency, starting with the end in view
Download
Download
Data consistency, starting with the end in view.xlsx
Complete and Continue
Discussion
5
comments
Load more
5 comments