Curriculum
8 Sections
57 Lessons
10 Weeks
Expand all sections
Collapse all sections
Module 1: Introduction to Microsoft Excel
10
1.1
Introduction About this Course
1.2
Introduction to Microsoft Excel
1.3
Ribbons
1.4
Ribbon Tabs
1.5
Groups
1.6
Row & Columns
1.7
Sheet & Workbook
1.8
Save & Save As
1.9
Address Status & Formula Bar
1.10
Opening Files
Module 2: Basic Data Entry & Formatting
7
2.1
Pivot Table
2.2
Pivot Table Structures
2.3
Pivot Table Additional Tabs
2.4
Pivot Table When & How
2.5
Remove Duplicates – Part 1
2.6
Remove Duplicates – Part 2
2.7
Sum Count CountA Countblank Max Min
Module 3: Data Formatting & Filters
10
3.1
Customised Tabs
3.2
Text to Column
3.3
ABS Function
3.4
Quick Access Toolbar
3.5
Filters
3.6
Text to Column Fixed With
3.7
Text to Column Delimited
3.8
Trim
3.9
Basic Text Functions 1
3.10
Basic Text Functions 2
Module 4: Data Sorting & Functions
8
4.1
Exact & Equal
4.2
IsFunction
4.3
Row & Column Function
4.4
Search & Find
4.5
Font & Alignment
4.6
Data Validation
4.7
Sorting
4.8
GoTo
Module 5: Special Functions
5
5.1
Intro & Time Function
5.2
Date Function
5.3
Paste Special
5.4
Custom View
5.5
Excel Table
Module 6: Working with Cells
2
6.1
Left Right Mid
6.2
Number Date & Time Format
Module 7: Day to Day Tasks
10
7.1
Intro
7.2
Vlookup Function
7.3
Hlookup Function
7.4
Networkdays Function
7.5
Workday Function
7.6
Text Function
7.7
Rank Function
7.8
Round Function
7.9
Dashboard
7.10
Basic Tricks
Test Papers
5
8.1
Q1 – P1
8.2
Q1 – P5
8.3
Q1 – P6
8.4
Q9 – P9
8.5
Congratulations!
Microsoft Excel
Search
Introduction About this Course
WhatsApp us
Login with your site account
Lost your password?
Remember Me
Not a member yet?
Register now
Register a new account
Are you a member?
Login now
Modal title
Main Content