13 Sections
50 Lessons
Lifetime
Expand all sections
Collapse all sections
Quick Tour of Microsoft Excel
3
1.1
Course Introduction
3 Minutes
1.2
Excel Startup Screen – Ribbon – Cells – Worksheet – Saving
14 Minutes
1.3
Excel Reference File
1 Minute
Formatting in Excel
4
2.1
Formatting Cells
21 Minutes
2.2
Custom Cell Styles
3 Minutes
2.3
Custom Number Formatting in Excel
18 Minutes
2.5
Custom Formats of Data
16 Minutes
Working with Mathematical Operations
2
3.1
BEDMAS Order
6 Minutes
3.2
Mathematical Operations without Functions
15 Minutes
Excel Function for Calculation and Analysis - Case Study I
4
4.1
IF Function
12 Minutes
4.2
Data Analysis with CountA – CountIf – CountIfs
27 Minutes
4.3
Sum – SumIf – SumIfs – Average – AverageIf – AverageIfs
20 Minutes
4.4
Max – Min – Determining Proportion of Salary
16 Minutes
Conditional Formatting
1
5.1
Heat Map – Data Bars etc.
8 Minutes
Working with Tables
4
6.1
Formatting Table
8 Minutes
6.2
Filtering and Sorting of Data
11 Minutes
6.3
Freeze and Split
6 Minutes
6.4
Printing and Layouts in Excel
13 Minutes
Introducing Pivot Tables - Case Study II
3
7.1
Pivot Tables
7 Minutes
7.2
Creating Custom Tables
10 Minutes
7.3
Organising Pivot Tables
10 Minutes
Introducing Graphs in Excel
5
8.1
Column Chart
15 Minutes
8.2
Bar Chart
10 Minutes
8.3
Line Chart
16 Minutes
8.4
Pie Chart
9 Minutes
8.5
Map Chart
10 Minutes
Common Errors in Excel
2
9.1
Common Errors
12 Minutes
9.2
More on Common Errors
8 Minutes
Functions Collection
6
10.1
Text Formula
10.2
Date & Time
8 Minutes
10.3
Logic
25 Minutes
10.4
Financial
20 Minutes
10.5
Informational
10 Minutes
10.6
Vlookup
20 Minutes
Advanced Excel Tools - Case Study 3
8
11.1
Text to Columns
3 Minutes
11.2
Grouping Tabs & Subtotals – Case Study 3
7 Minutes
11.3
Working with HyperLinks
9 Minutes
11.4
Data Validation
23 Minutes
11.5
Custom Views & Protection
6 Minutes
11.6
Slicers and Timers
7 Minutes
11.7
Sparklines
8 Minutes
11.8
Create a Sales Dashboard
48 Minutes
VBAs and Macros - Multiple Projects
8
12.1
Protocols in Creating Macros
7 Minutes
12.2
Creating My First Macro
4 Minutes
12.3
VBA Environment – Project Explorer
10 Minutes
12.4
VBA Environment – Properties
6 Minutes
12.5
Run – Design – Build a Calculator
24 Minutes
12.6
If Condition – Create an Age Category Checker
26 Minutes
12.7
Data List – Sector Data Presenter
35 Minutes
12.8
Chart – Create & Manipulate Chart
14 Minutes
Final Quiz
1
13.1
Assessment
5 Minutes
10 Questions
Master Microsoft Excel
Curriculum
This content is protected, please
login
and enroll in the course to view this content!
Home
Courses
Search
Search
Account
Login with your site account
Lost your password?
Remember Me
Modal title
Main Content