Course Content
Starting Excel 2016
0/1
Lesson: 1
11:46
Excel Free Templates
0/1
How to use Free Excel Templates
11:46
Manage Worksheet/Workbook
0/2
Organize your worksheet/workbooks
13:39
Move and arrange your worksheet/workbook
10:15
Flash Fill
0/1
Using the Flash Fill feature in Excel
15:30
Formatting Excel file
0/1
How to format Excel File
15:41
Manipulating Data in Excel
0/6
Sorting 1
09:54
Sorting 2
09:54
Sorting 3
06:33
Sorting 4
02:25
Sorting Days of the week
06:00
Unsorting
02:45
Filtering
0/2
Single level Filtering of data
04:54
Multi-Level Filtering in Excel
09:40
Excel Tables
0/4
Table Properties 1
11:06
Table Properties 2
09:39
Table Properties 3
14:06
Table Properties 4
12:52
Subtotals
0/1
Lesson 1
08:00
Introduction to Excel Charts
0/3
Quick analysis tool & charts to understand trends in data (i)
14:25
Quick analysis tool & charts to understand trends in data (ii)
11:25
Spark lines Charts
14:55
Intermediate Excel formulas and functions
0/3
Intermediate formulas and functions (i)
15:00
Intermediate formulas and functions (ii)
17:00
Intermediate formulas and functions (iii)
08:00
Pivot Tables in Excel
0/6
Introduction and inserting pivot table
09:00
Creating your first pivot table
09:00
Create Pivot Tables using guiding questions (i)
21:00
Create Pivot Tables using guiding questions (ii)
18:48
Introduction to slicers and using them in pivot tables
16:40
Pivot Charts
26:50
Importing Data into Excel
0/2
Import Data from workbook
08:00
Import Data from the web
12:50
Data Validation
0/1
All about Data validation
21:50
Ms Excel Mastery Course ( Intermediate)

Previous
Next
0% Complete