Modelling Course(1 Day Course, only on weekends)
WHAT IS THIS COURSE ABOUT?
We can explain to you that you will get an certification, or SETA or any other accreditation you can think off. But we are not here to simply give you a paper. We believe that there is a great gap in todays working environment where we use so much of excel, but know so little.
This course is thus designed to give you the best training needed to increase you efficiency and accuracy in you work.
In this course we take excel to a level which you have never seen. Some functions/methods explained here is unique to our course in South Africa.
We have only included the best and most sufficient content in this course.
WHO SHOULD ATTEND THIS COURSE?
Before attempting this course you have to know the 31 formulas tought in the advance excel course very well. We combine these in a way that only a few people in the world know how to do.
Anyone, in any business can attend. Financial and admin people see a great improvement in their work after this course.
CONTENT OF THIS COURSE?
1 Macro with the recording function
2 Models
- Using multiple pivottables to create one
- Reconciling in excel with formulas (thousands of lines with conditions in seconds)
- Count automatically with countif
- Find more than one result with vlookups
- Convert number like 20060731 in proper date formulas
- Use Hlookups and Vlookups together to create better reporting
- Simplify reporting by creating your own mapping with error checking (same concept as accounting functions use)
PRICING
Our prices becomes cheaper if you have delegates to attend. We only currently present in-house workshops at your company. if you are an individual, please visit the one-one-one turoring session which might suite you better and cost less.
Prices are as follows for this one day modelling course:
- One person = R2,500
- 2 people = R3,000
- 3 people = R4.200
- 4 or more people (max 10)= R6,000
OTHER
We also encourage you to bring along you spreadsheets so that we can go through them to see where you can apply what you have learned
By the end of this day, you will so much tools to improve yourself. You can go test and make your work great and let other people think you are amazing. You can also let your employees do what you employed them for.
Please send us any problems and questions you have after the workshop. We will gladly assist you for free.
Please discuss with us before if you want to anything to be added to the content.
BOOKING
If you are interested or need more details regarding this workshop please fill in the form below and we will contact you. Alternatively email us: Heinrich@31bestofexcel.com
Other courses:
- Basic course
- Intermediate course
- Advance course
- VBA coding course
- Spreadsheet development/fixing
- One-on-One tutoring
