Course Modules
MODULE 1
1.1 Introduction
1.2 Excel Templates
MODULE 2
2.1 Overview
2.2 Knowing the Worksheet
2.3 Recap of file format of excel
MODULE 3
3.1 Understanding Basic Formulas
3.2 Filling Date Range 1
3.3 Basic Functions
3.4 Filling Data Range 2
3.5 Recap of Filling Data
MODULE 4
4.1 Basic Function of IF
4.2 Recap of Basic Functions
4.3 Introduction to SumIF and SumIFS
4.4 Understanding SumIF and SumIFS
4.5 IF Error
4.6 Formatting Data
MODULE 5
5.1 Introduction to Conditional Formatting
5.2 Understanding Conditional Formatting
5.3 Recap of Conditional Formatting
5.4 Introduction to Consolidate Function
5.5 Understanding Consolidate Function
5.6 Recap of Consolidate Function
MODULE 6
6.1 Introduction to Sentence Case
6.2 Understanding Sentence Case
6.3 Recap of Sentence Case
MODULE 7
7.1 Introduction to Concatenate
7.2 Understanding Concatenate
7.3 Recap of Concatenate
7.4 Introduction to Data Validation
7.5 Understanding Data Validation
7.6 Recap of Data Validation
MODULE 8
8.1 Introduction to Flash Fill and Text to Column
8.2 Understanding Flash Fill
8.3 Understanding Text to Column
8.4 Recap of Flash Fill
8.5 Recap of Text to Column
8.6 Sorting and Filtering
8.7 Freeze Panes
MODULE 9
9.1 Introduction to Lookup Values
9.2 Understanding Lookup Values
9.3 Recap of Lookup Values
9.4 Introduction to Nested Lookups
9.5 Introduction to Pivot Table
9.6 Understanding Pivot Table
9.7 Recap of Pivot Table
MODULE 10
10.1 Introduction to Excel Charts
10.2 Understanding Excel Charts
10.3 Charts 2
10.4 Chart Colouring
10.5 Data Charts
10.6 Types of Charts
10.7 Recap of Excel Charts
10.8 Excel Data Security
10.9.1 Introduction to If Function
10.9.2 Understanding If Function 10.9.3 Understanding If Function 2
10.9.4 Understanding If Function 3
10.9.5 Recap of IF function
MODULE 11
11.1 Introduction to Date and Time
11.2 Base Text Solving
11.3 Base Date and Time-Solving
11.4 Advanced Date and Time-Solving Method
11.5 Recap of Date and Time
MODULE 12
12.1 Introduction to Macros and VBA
12.2 Understanding Developer
12.3 Tool and Code
12.4 VBA Colour Code
12.5 Creating a code in VBA
12.6 Macro – Font, Align, Insert and Delete
12.7 Save and Close
12.8 If Project
12.9 Recap of Macros and VBA
