Module (1): Manipulate and Format Workbook
-
M1-1 Selection and highlighting cells and sheets in excel
-
M1-2 Protecting cells , rows, columns, worksheets and multiple worksheets in excel
-
M1-3 Validate cells in excel
-
M1-4 Advanced cut, copy paste in excel
-
M1-5 Format cells in excel ( date, time, text, numeric, currency, percentage, fractions)
-
M1-6 Format cell emphasis (including: colour, shading, merge, borders, comments)
-
M1-7 Conditional formatting
Module (2): Advanced Functions
-
M2-1 Use absolute and relative cell referencing, named cells and ranges in excel formulas and functions
-
M2-2 Use mathematical functions
-
M2-3 Use statistical functions 1
-
M2-4 Use statistical functions 2
-
M2-5 Logical functions 1
-
M2-6 Logical functions 2
-
M2-7 Use date & time functions 1
-
M2-8 Use date & time functions 2
-
M2-9 Use lookup functions
-
M2-10 Index-match functions
Module (3): Create summaries & Analyse Data
Module (4): Create & Format Charts
