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
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
- 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
|
|
|
