Intermediate 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 will help you move to the next step in excel, by starting to know a bit more help yourself even more.
We have only included the best and most sufficient content in this course.
WHO SHOULD ATTEND THIS COURSE?
You have to have a basic understanding of excel before attempting this course. This does not mean that you saw excel ones and know how to open it.
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?
1 Formula Basic
- How to use text in formulas
- How to refer to blanks in formulas
- How to refer to Spaces in formulas
- How to use brackets in formulas
- Types of errors
2 Using dates and corresponding formulas
3 Other basics
- Freeze pains
- Fixing ranges
- Autofilter
- Breaking links
4 Protecting your worksheets
5 Starting on formulas (countif and text formulas)
- Countif
- Concatenate
- Left
- Right
- Mid
- Trim
- Average
- Min
- Max
- Proper
- Upper
- Lower
6 Conditional formatting
7 Other
- Custom formatting
- Conditional formatting
- Hyperlinks
- Cell name define
- Watch window
- Protecting your worksheet
- 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 one day intermediate excel cource):
- One person = R5,000
- 2 people = R6,000
- 3 people = R8,400
- 4 or more people (max 10)= R12,000
OTHER
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
- Advance course
- Modelling course
- VBA coding course
- Spreadsheet development/fixing
- One-on-One tutoring
