/Microsoft Excel

Course Curriculum

Section 1 · Module 1: Introduction to Microsoft Excel

○ Introduction About this Course Preview ○ Introduction to Microsoft Excel ○ Ribbons ○ Ribbon Tabs ○ Groups ○ Row & Columns ○ Sheet & Workbook ○ Save & Save As ○ Address Status & Formula Bar ○ Opening Files

Section 2 · Module 2: Basic Data Entry & Formatting

○ Pivot Table ○ Pivot Table Structures ○ Pivot Table Additional Tabs ○ Pivot Table When & How ○ Remove Duplicates - Part 1 ○ Remove Duplicates - Part 2 ○ Sum Count CountA Countblank Max Min

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 3: Data Formatting & Filters

Text to Column

← Previous Continue →