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,006 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 for Auditors: Empowering Auditors with specialised audit-specific Excel skills

As Auditors you know how precious every minute of every day is. By attending the Microsoft Excel for Auditors training course you will save valuable time by using Excel more effectively when working with audit information, such as fixed assets. Unlike most advanced Excel courses, the Excel for Auditors programme is not a tour of functionality, but focuses on developing advanced understanding and practical know-how that will result in significant time-saving each month. The learning is experiential; therefore, all exercises and examples use auditing data that relates to practical situations.

For SAICA members, Excel for Auditors workshops contributes 8 verifiable CPD hours.

Please Note: Intermediate Excel skills are required for delegates. An excellent ‘Discovering Excel’ training course is available to bring skills up to the required level.

Course Outcomes:

Session 1: Asset Register

• Working with Multiple Sheets
• Sheet Protection and Grouping Sheets
• Paste Special
• Nesting Functions and Absolute Referencing
• Logical, Lookup, Mathematical and Financial Functions
• Named Ranges
• Conditional Formatting
• Auditing a Formula
• Pivot Table
• Consolidation and Linking of Sheets
• Hyperlinks

Session 2: Customer Transactions

• Importing a Text File
• Text and Subtotal Functions
• Duplication
• Group and Outline
• Using Subtotaling
• Filtering Data
• Charts and Pivot Charts
• Macros
• Sampling and Review Tool

Course Cost: R1,412 excl. VAT

---

Tobie Oosthuizen (National training manager), BDO Spencer Steward
“All the delegates walked away with an enhanced understanding of Excel. If this translates in a 10 minute a day savings it equates to almost 40 hours a year increased productivity."

---

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,525 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 eos@alchemex.com or Fax to 086 662 2835

Click here for a Demo.

Book your training   0861 102 302 086 662 2835 eos@alchemex.com

Support   +27 11 304 3800 support@alchemex.com