Is this the correct course for your needs? Use this quick ‘Which Excel Course should I do‘ questionnaire to establish which course is correct for you.
In order to do this course we also recommend a skill level of >3 (we offer a free Skills Assessment to make sure you get the correct level of training).
This is a very hands-on, non-intimidating, course – delegates work through various exercises under the supervision, and with the help, of the facilitator to get to grips with the nuances of Excel’s Pivot Table features.
How to (quickly) convert non-compliant data into Pivot friendly data
Zero is an interesting number in Excel (and in mathematics in general) and causes lots of problems for a ‘nothing’ number. Below some quick tips on dealing with zero in Excel. Hide/ Show Zero in Excel- Change the options If … Continue reading
Negative numbers in Excel can sometimes cause some confusion for users. Below some of the most common issues/ questions addressing Excel negative numbers. Entering a negative number in Excel At its very simplest you need to add a negative symbol … Continue reading
...The course was so useful I learned a couple of tricks to aid me with my own work as well....They were able to ask a few specific questions...– Procter & Gamble
Your (AuditExcel) Advance Excel and Financial Modeling course is one of the best courses available on the market, it is well structured, relevant and insightful. I will recommend it to anyone who would like to improve his/her Excel and/or Financial Modeling skills.– Namibia
This was by far the most comprehensive and beneficial Excel training I have received while at Pick n Pay.- James H– PowerPivot Course Reviews
We have used AuditExcel over the last 5 years to develop large scale property modelling developments. All the templates are still in use and allow for intricate sensitivity analysis. As a result we are better able to assess projects and choose the optimal ones. Their response times also make it easy to rely on them for new developments.– Property Modelling- Basil Read
...After eleven years we still use the model for financial planning and to provide information to the banks. The key feature is the logical layout which makes it easy to understand and adapt on our own, and the flexibility to combine actual and forecast data...– Financial Model development- SA Prisons
Practical examples of how the various tools & functions can be used in different contexts make it quite easy to grasp the concepts and see the benefits of using these functions. The course is very practical and allows you to engage with the various exercises, make mistakes and learn....– Corporate financial modelling in excel Feedback
...Not only did I learn a lot about Access on this course, but I also gained quite a few useful Excel skills. The fact that Jonny is an accountant meant that he understood the daily challenges with data in a finance role...– Excel with access- Hannover Re
...A key feature was their ability to understand the problem first time and work on the correct solution. These timely responses enabled us to make decisions quickly...– Rental investment spreadsheets- JHC
...AuditExcel are professional, technically competent and provide solution suited to individual business needs. We are still using the reports and the budget tool they designed and have since been able to enhance the reports ourselves– Spreadsheet budget app- BDO Auditors
... I have always found them to be very adaptable to the various clients we send them to and they are able to solve the most complex of modelling problems...– Investment property spreadsheets- Old Mutual
....As an example, the training in VLOOKUP had applicability in differing ways for each employee and they learned then and there how to use it in their own work. They left the training with clear expectations on improvement in their areas of responsibility...– Benefits of inhouse training- Health and Accident Underwriting Managers
I can testify that since I have been trained by you online, I really improved my Excel knowledge. But as you know, I am not living in South Africa but I am in Democratic Republic of Congo.– Congo
Please let me know if you have an online version of this session and I will be part of it.
Adrian was really good. He explained everything really professionally- Bookkeeper.– Excel Testimonials
It dealt with my daily challenges at work- IS Management Accountant.
There was nothing I did not like about the workshop. Adrian was fantastic- Accountant.
It was most interesting and filled with very useful and relevant tricks and tools that one can start to use immediately. The course was well constructed with a logical flow to be able to reference information easily in the take home materials, with exercises covering many different scenarios.– Hyatt Hotels