MODULE: 1

• Introducing Excel
• Entering & Editing Worksheet Data
• Essential Worksheet Operations
• Working With Cells & Ranges
• Introducing Tables
• Introducing Formulas & Functions
• Worksheet Formatting
• Understanding Excel Files
• Using & Creating Templates
• Printing Your Work

MODULE: 2

• Introducing Formulas & Functions
• Creating Formulas That Manipulate Text
• Working With Dates & Times
• Creating Formulas That Count & Sum
• Creating Formulas That Look up Values
• Introducing Array Formulas
• Using Data Validation
• Introducing Pivot tables
• Getting started Making Charts
• Visualising Data Using Conditional Formatting

MODULE: 3

• Making Your Worksheets Error free
• Using Custom Number Formats
• Linking & Consolidating worksheets
• Performing Magic with Array Formulas
• Creating Formulas for Financial Applications
• Analyzing Data With Pivot Tables
• Getting Data From External Database Files
• Performing Spreadsheet What-If Analysis
• Analyzing Data using Goal Seeking & Solver
• Creating & Using worksheet Outlines
• Learning Advanced Charting
• Protecting Your Work
• Customising The Excel User Interface
• Introducing Visual Basic For Applications
• VBA Macro
• Variables in VBA
• Message Box and Input Box Function
• If and Select and Looping Statement
• Mail Function
• Workbook and Worksheet Function

Basic Information