Home About Newsroom Resellers Accountants 3rd Party Developers Careers Contact Sage Pastel Payroll & HR
Alchemex Academy

Discovering Excel – Microsoft Excel Training Programmes

Giving self-taught Excel users a comprehensive all round knowledge of Excel

The ‘Discovering Excel’ training course is ideal for anyone interested in solidifying a basic understanding of the workings of Excel. Course material entails developing spreadsheets using formulae and formatting, and chart creation.

Course Outcomes:

  • Refresher of what Excel is
  • Working with Workbooks & Worksheets
  • Entering in Data
  • Using Multiple Worksheets
  • Managing Worksheets
  • Creating Multiple Views
  • Working with Formulae
  • Creating a 3-D formula
  • Using Functions
  • Circular Reference
  • Editing & Formatting
  • Printing & Page Setup
  • Charts

Course Cost: R1,000 excl. VAT

These online courses can be done at a time & place suitable to you. Each delegate will be given three months access to the online academy, with e-mail support throughout this period. On completion of each course you will need to complete the assessment, and on achieving a pass mark of 70% or above, you will receive a printable certificate.

Excel on Steroids: Designed to enhance your business reporting and decision making skills in Excel

Do you use Excel extensively for reporting but spend 15 hours a week trying to develop your report? Would you like to save 25% of your time by working smarter, using methods you didn’t know about?

Excel on Steroids (EOS) is a specialised training programme designed to help you develop the necessary skills to maximise the use of Excel to create business value. Unlike most advanced Excel courses, the EOS programme is not a tour of functionality, but focuses on turning an intermediate Excel user into an accomplished Excel report writer by providing comprehensive and practical training.

Course Outcomes:


Workshop 1: Managing Worksheets and Formulae

  • Insert, Delete, Rename, Copy and Move worksheets
  • Grouping Worksheets
  • Using Paste Special and Named Ranges
  • Using Conditional Formatting and Worksheet Protection
  • Using Lookup Functions, Text Functions, Logical Functions, Information Functions, Statistical Functions and Mathematical Functions

Workshop 2: Managing Data Lists and Macros

  • Sort, Filter and use Subtotals
  • Use Data Validation
  • Use Group and Outline and create Custom Views
  • Create Scenarios and Macros

Workshop 3: Pivot Tables and Pivot Charts

  • Give a definition of a Pivot Table and describe its layout
  • Create a Pivot Table from selected data using the Pivot Table Wizard
  • Modify and Format an existing Pivot Table
  • Move or copy a Pivot Table
  • Create a Calculated field and Group dates

For SAICA members the workshops contribute 12 verifiable CPD hours.

Please Note: Intermediate Excel skills are required for delegates to take full advantage of the EOS Programme. An excellent ‘Discovering Excel’ course is available to bring skills up to the required level.

Course Cost: R2,600 excl. VAT

Hanlie du Toit – Preferred Solutions
“No self respecting Excel user should go without this course."

These online courses can be done at a time & place suitable to you. Each delegate will be given three months access to the online academy, with e-mail support throughout this period. On completion of each course you will need to complete the assessment, and on achieving a pass mark of 70% or above, you will receive a printable certificate. To register, please download the registration form here.
To register, please download the registration form here.

Once complete, please E-mail to [email protected] or Fax to 086 662 2835
Click here for a Demo.

Book your training

 
0861 102 302
086 662 2835
[email protected]
 

Support

 
+27 11 304 1400
[email protected]