Basic & Advance Excel:

• Module 01: Intermediate Excel Recap
• Basic Workbook Skills (e.g. creating a workbook, saving a workbook )
• Using Ranges
• Using Simple Formulae
• Copying & Moving Data in Excel
• Basic Formatting in Excel
• Working with Multiple Worksheets
• Using Basic Functions (e.g. AVERAGE, SUM, COUNT, MIN, MAX )
• Using Basic Charts
• Creating & Editing Charts
• Managing Large Worksheets
• Using Objects and Effects
• Using AutoShapes & Diagrams
• Practical Exercises

Module 02: Advanced Conditional Formatting

• Intermediate CF in excel recap
• What is Advanced CF?
• Using Formulas in CF
• Advanced CF Options (e.g. Icons, Data Bars, Heat-Maps, Dates )
• Handling Duplicate Data and CF
• Using Complex CF
• Practical Exercises

Module 03: Advanced Formulas + Functions

• Types of Advanced Formulae
• Text Functions
• Date Functions
• Logical functions
• Lookup Functions
• Handling Formula Errors
• Auditing a Formula
• Practical Exercises

Module 04: PivotTables

• What is PivotTable?
• Using PivotTables
• PivotTable Formatting
• What is Pivot Reporting?
• Using Report Filter in PivotTable
• Using Slicers
• Practical Exercises

Module 05: Advanced Charts

• What are Advanced Charts?
• Types of Advanced Charts
• Selecting the Right Chart
• Combination Charts (e.g. PivotChart)
• Using In-Cell charts
• Using Dynamic Charts
• Using Sparklines
• Practical Exercises

Module 06: Filters

• What are Data Filters?
• Using Auto Filters and Advanced filters
• Practical Exercises

Module 07: Validations & Subtotal

• What are Cell level validations?
• Specifying a valid range of values for a cell
• Specifying a list of valid values for a cell
• Specifying custom validations based on formula for a cell
• Practical Exercises

Module 08: Managing Data

• Consolidating multiple workbooks
• Using Excel as a database
• Optimizing Excel data (e.g. LEN, TRIM, CONCATENATE )
• Data Validation in Multiple Sheets
• Practical Exercises

Module 10: Dashboards

• What are Dashboards?
• How to construct Dashboards
• Using Business Dashboards
• Practical Exercises

Module 11: Protection

• Applying Protections
• Worksheet protection and locking of cells
• Workbook Protection