/Microsoft Excel

Course Curriculum

Section 1 · Module 1: Introduction to Microsoft Excel

Section 2 · Module 2: Basic Data Entry & Formatting

Section 3 · Module 3: Data Formatting & Filters

○ Customised Tabs ○ Text to Column ○ ABS Function ○ Quick Access Toolbar ○ Filters ○ Text to Column Fixed With ○ Text to Column Delimited ○ Trim ○ Basic Text Functions 1 ○ Basic Text Functions 2

Section 4 · Module 4: Data Sorting & Functions

○ Exact & Equal ○ IsFunction ○ Row & Column Function ○ Search & Find ○ Font & Alignment ○ Data Validation ○ Sorting ○ GoTo

Section 5 · Module 5: Special Functions

○ Intro & Time Function ○ Date Function ○ Paste Special ○ Custom View ○ Excel Table

Section 6 · Module 6: Working with Cells

○ Left Right Mid ○ Number Date & Time Format

Section 7 · Module 7: Day to Day Tasks

○ Intro ○ Vlookup Function ▶ Hlookup Function ○ Networkdays Function ○ Workday Function ○ Text Function ○ Rank Function ○ Round Function ○ Dashboard ○ Basic Tricks

Section 8 · Test Papers

○ Q1 - P1 ○ Q1 - P5 ○ Q1 - P6 ○ Q9 - P9 ○ Congratulations!

Module 7: Day to Day Tasks

Hlookup Function

← Previous Continue →