Excel on Steroids

Excel on Steroids™ is a specialized training program focusing on key Excel functionality for powerful business reporting and decision-making!

The course is divided into three workshops covering specific topics in Excel. The workshops are available for Microsoft Excel 2003, 2007, 2010 and 2013 with all content covered being available to download online.

It is important to understand the following:

  • Excel on Steroids™ is offered 100% online.
  • Online training is available on Alchemex Academy or Sage University (for Sage North American customers).
  • Certified Training Centres are also available throughout Africa and Australia.
  • Another option is onsite training which is available on request throughout Australia and New Zealand.
  • For all bookings of 6 or more delegates, the company qualifies for a group discount.

 

Workshop 1: Business Reporting using Formulas and Functions

  • Ribbons and Understanding Microsoft Excel
  • Copy & Move Worksheets between workbooks
  • Paste Special Functions
  • Conditional Formatting
  • Worksheet Protection
  • Named Ranges
  • Lookup
  • Text Fields
  • Logical Expressions
  • Information
  • Statistical and Mathematical Functions

 

Workshop 2: Managing Data lists and Macros

  • Custom Lists
  • Subtotals
  • Filtering
  • Data Validation
  • Custom Views
  • Scenarios
  • Macro’s

 

Workshop 3: Data analysis using PivotTables and Pivot Charts

  • Understanding and Creating PivotTables
  • Modifying and Formatting a PivotTable
  • Sparkline’s (Excel 2010 and later)
  • Calculated Fields
  • Grouping
  • Creating and Understanding PivotCharts