Product Overview
Microsoft Excel is probably one of the most widely used spreadsheeting application in the world today. It has a wide range of features available for every-day office documents and professional spreadsheets with complex calculations and Macros.
Available Excel courses
Excel Basic | Excel Intermediate | Excel Advanced | PivotTables | VBA for Excel
Microsoft Excel Basic (1 day training session)
Kick-start your Excel skills by learning about the following topics:
- Excel Environment
- Excel Views
- Entering Data
- Constructing Basic Formulas & Functions
- Construct basic Formulas between Worksheets and Workbooks.
- Copy and Paste data and formulas
- Apply formatting
- Page Setup & Printing
|
|
Microsoft Excel Intermediate (1 day training session)
Master Excel reporting tools by learning about the following topics:
- Time savers and shortcuts
- Formulas
- Relative and Absolute references
- Functions
- Commonly used functions
- Date and Time functions
- Logical functions
- Finding and correcting errors
- Custom formats
- Outlining
- Charts
- Data Vallidation
|
|
Microsoft Excel Advanced (1 day training session)
Master Excel reporting tools by learning about the following topics:
- Using Names
- Using Tables
- Advanced Functions
- Advanced Sorting and Filtering
- PivotTables
- PivotCharts
- Basic Macros
|
|
Microsoft Excel PivotTables (1/2 day training session)
Master Excel PivotTablesby learning about the following topics:
- PivotTables
- Constructing PivotTables
- Data fields
- Filtering
- Hiding and showing field details
- Creating data groups
- Displaying Source Data
- PivotTable Options
- Formatting PivotTables
- Comparative Calculations
- Calculated fields
- Data Consolidation with PivotTables
- PivotCharts
- Creating a PivotChart
- Reorganising Chart Fields
- Filtering Chart Fields
|
|
VBA for Microsoft Excel (2 days training)
Master Excel PivotTablesby learning about the following topics:
- Record Macros
- Absolute Macros
- Relative Macros
- Using the VBA Editor
- Project Explorer
- Setting Break Points
- Using Bookmarks
- Stepping through Procedures
- Running Macros
- VBA Theory and Terminology
- Creating Procedures
- Using Variables
- Variable Declarations
- Variable Scope
- Arrays
- Using Excel Objects
- Methods, Properties and Events
- Programming Techniques
- Using Message Boxes
- Using IFs
- Using Loops
- Custom user Functions
- Creating Custom Forms
- Customising Excel's Menus and toolbars
- Event-driven Prcedures
- Error Handling
|
|
|
