Advanced Excel Course

INTRODUCTION

While there is a lot of value in mastering the basic and intermediate array of functions of excel, for some, simply automating the day-to-day arithmetic functions when working with data or reporting on data in a large company, a more in-depth knowledge is required. This course will equip you with the skills to significantly improve your ability to analyse data, reporting functions and built techniques to improve your performance

Our methodology is developed to breach a huge learning curve during the morning of the first day. The delegates are normally amazed at the formulas they can do by lunch on day 1. We have developed methods to better understand formulas and to teach yourself. On day two the delegates can normally understand formulas much quicker and more importantly have the tools to teach themselves after the workshop.

It is thus important to ensure the delegates are not on a basic excel level. We can do this assessment for free prior to the workshop.

CONTENT

This is the most advanced content you will be able to get. The following main topics will be covered:

  1. Formula basics (Basics, absolute referencing)
  2. Logical formulas (LOGICAL TESTS, AND, OR, IF, IFERROR, ISERROR)
  3. Lookup formulas (VLOOKUP, INDEX, MATCH, ADDRESS, SUBTOTAL, AUTOFILTERS)
  4. Text formulas (MID, LEFT, RIGHT, PROPER, UPPER, LOWER, SEARCH, REPLACE, TEXT, VALUE, TRIM, SUBSTITUTE)
  5. Reporting formulas (Pivottables, Pivotcharts, Pivot Slicers, SUMIFS, INDIRECT, Macros)
  6. Formatting functions (Conditional formatting, Paste Special for formules)
  7. Other (COUNTIF, COUNTA, HYPERLINKS, CELL NAME DEFINING, BREAKING LINKS)
  8. Dates (Date principles, Calculation of time, NETWORKINGDAYS, TODAY, NOW, YEAR, MONTH, DAY, DATE).

DURATION OF THIS ADVANCED EXCEL COURSE

This course is normally 12 hours in total. These 12 hours can be delivered in different ways:

  1. Two full days consecutively
  2. Two days split (This can be split over different weeks or different months)
  3. 4 Sessions of 3 hours each. (This can be split over different weeks or different months)

ASSESSMENTS

If you are not sure of your level, click here to do our excel assessment.

PRICING

The cost for this course is R20,000 for the two days. This excludes traveling and accomodation. Maximum 15 delegates.

You can also do the course online for $50. Our elearning platform is one of the best in the world and includes videos, simulations, assessments, examples and examinitions. You can print your own certificate on completion of the examination.. Contact us for a free demo.

CERTIFICATION

You will also get a certificate of competence once you pass the exam after the course. This exam is on our elearning site.

WHAT DO YOU GET INCLUSIVE OF THIS PRICE

You get the following when attending the course

  1. Manuals
  2. 12 months Elearning access (videos, assessments, exam, simulations, more examples)
  3. Support during working days

Empower Yourself - BOOK NOW!

Advanced  excel course

Address:

Unit 11, Block 2
Falcon Crest Office Park
142 South Street
Die Hoewes
Centurion
South Africa

Contact Details:

Advanced  excel course



*


Everyone can rise above their circumstances and achieve success
if they are dedicated to and passionate about what they do
Nelson Mandela