1.     Basic Formula

·        Formulae that Add / Subtract / Multiply / Divide

·        BODMAS / Formula Error Checking

·        The Sum Function

2.     Absolute Referencing

·        Problems with Absolute / Relative Cell Referencing

·        Creating Absolute / Mixed References

3.     LOOKUP Functions

·        The VLOOKUP/ HLOOKUP Functions

·        PivotTables

·        Creating, Formatting Simple PivotTables

·        Page Field in a PivotTable

·        Formatting a PivotTable

·        Creating / Modifying a PivotChart

4.     Logical Functions 

·        IFs and Nested IF Functions

·        Using AND / OR / NOT Functions

·        Statistical Functions 

·        Using The SUMIF / COUNTIF Functions

·        Using The AVERAGE / COUNT / LARGER / SMALLER Functions

·        Pivot Tables – Advance

5.     AWCPE Educational

·        Adding new calculated Fields / Items

·        Changing the Summary Function

·        Consolidate Pivot table

6.     LOOKUP Functions – Advance 

·        MATCH with VLOOKUP Functions

·        INDEX & MATCH Functions

·        OFFSET / INDIRECT functions

7.     Logical Functions – Advance

·        If Loop and Nested IF Loop Functions

·        Using IF / ISERROR Functions

8.     Chart Data Techniques 

·        The Chart Wizard

·        Chart Types

·        Adding Title / Legends / Labels

·        Printing Charts

·        Adding Data to a Chart

·        Formatting / Renaming / Deleting Data Series

·        Changing the Order of Data Series

9.     Date / Time Functions

·        Using The Today

·        Now & Date Functions

·        Using The Datedif / Networkdays / Eomonth Functions 

·        Using The Weeknum Functions

·         Using The  Edate / Networkdays. Intl / Weekdays .Intl Functions

10. Text Functions Using

·        The Mid / Search / Left / Right Functions

·        Using The Trim / Clean / Upper/ Lower Functions

·        Using The Substitute / Text Functions

·        Using The Trim / Clean / Proper / Dollar Function

11. Validations

·        Input Messages / Error Alerts / Drop-Down Lists

·        Conditional Formatting

12. Advanced Filters 

·        Extracting Records with Advanced Filter

·        Using Formulas in Criteria

13. Advanced Sorting

·        Sorting by Top to Bottom / Left to Right

·        Creating / Deleting Custom List

·        Sort by using Custom List

14. Hyper / Data Linking

·        Hyper linking data, within sheet / workbook

·        Linking & Updating links between workbooks & application

15. Math & Trigonometry Functions

·        Using SUMPRODUCT Functions

·        Using FLOOR / CEILING/ MROUND / MOD / QUOTIENT Functions

16. Summarizing Data

·        Creating Subtotals / Nested Subtotals

·        SUBTOTALS Formula

17. Outlining

·        Creating / Working with an Automatic / Manual Outline

·        Grouping / Ungrouping

18. Consolidation

·        Consolidating Data with Identical / Different Layout

·        Using Auditing Tools

·        Displaying / Removing Dependent & Precedent Arrows

·        Evaluate Formula – Step IN / Step Out

19. Custom Views

·        Creating Custom Views

·        Displaying Custom Views

·        Deleting Custom Views

20. Sharing and Protecting Workbooks

·        Sharing Workbooks & Tracking Changes

·        Protecting sheets/workbooks / Files

21. Importing & Exporting Data

·        Importing Data from Database / Text Files / Web

·        Exporting Data

·        Changing External Data Range

Practical Projects & Assessment

·        Real-World Project

·        Quiz + Practical Assignment

·        Final Assessment & Certification