Discovering Excel

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

If you want to gain a basic understanding of how Excel works the Discovering Excel course is for you. During this course you will be taught how to not only develop spreadsheets using formulas and formatting but will be shown how to create charts ensuring you leave with basic knowledge of how to make Excel work for you.

Course Outcomes:

Refresher of what Excel is.
Working with Workbooks & Worksheets.
Entering in Data.
Using Multiple Worksheets.
Managing Worksheets.
Creating Multiple Views.
Working with Formulas.
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 Excel for Auditors 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 the Excel for Auditors for SAICA members the workshops contribute 8 verifiable CPD hours.

Please Note: Intermediate Excel skills are required for delegates. An excellent “Discovering Excel” 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?

Then 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 the 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.

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