Advance Excel Course(2 Day Course)
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.
We have only included the best and most sufficient content in this course.
WHO SHOULD ATTEND THIS COURSE?
We will never show anyone away, but we see to many people who think they can jump in and do an advance excel course and be good in excel. It is not that easy. You will have to have a good understanding of the basics of excel. Things like navigation, look and feel and basic formulas has to be second nature already. If it is not, then we recommend that you do our basic excel courses and intermediate excel courses first. Even after that you will have to practice a bit before attempting this course.
Anyone, in any business can attend. Engineers, financial and admin people see a great improvement in their work after this course.
CONTENT OF THIS COURSE?
We will start the day running through a few basic things users normally get wrong:
- What is a range, where do you use it and why is it important
- Fixing formula ranges, fixing rows, columns or both
- What is the developer tab, where to find it and when to use it
- What to do when formulas do not calculate and how to switch automatic calculator on or off
- Protecting worksheet, how to do it, what to protect and how to protect functions
- Using of dates in excel, calculate days, weeks and months and using correct formats
After mastering these basic things, we will take you through the only 31 formulas/functions you really need to know in excel. Off course there are thousands of formulas to use, but if you know these 31 formulas/functions and know how to combine them in certain situations, you will be able to do everything your mind sees possible.
These formulas/functions include the following
- Logical formulas (if,or,and,iserror)
- Lookup formulas (vlookup, autofilter, find, find and replace, search, replace)
- Reporting functions (pivottables, sumif, macros)
- Text formulas (concatenate,left,right,mid,trim,proper,upper,lower)
- Formatting formulas/functions (format painter, paste special, conditional formatting)
- Other (breaking links,average,countif,min,max,testing formulas)
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 two day advance excel course (our daily rates is half of these):
- One person = R5,000
- 2 people = R6,000
- 3 people = R8,400
- 4 or more people (max 10)= R12,000
OTHER
We also encourage you to bring along you spreadsheets so that we can go through them in day 2 to see where you can apply what you have learned
By the end of these days, you be the master of your own future. 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
- Modelling course
- VBA coding course
- Spreadsheet development/fixing
- One-on-One tutoring
