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.


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

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:

4th Floor, Block 2
Protea Hotel (Conference Centre)
Cnr Gordon Hood and Hendrik Verwoerd Drive
Centurion 0046
South Africa
VAT No: 4410263224

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