Advanced Excel Training
Our advanced Excel training courses are well-suited for individuals wanting to improve their spreadsheet skills for the purpose of better performance, accuracy, and even promotion. Small business owners, payroll clerks, and bookkeeping clerks also benefit from the advanced Excel training courses.
The courses are hands-on and presented by instructors with years of experience in auditing, financial analysis, and spreadsheet model development. Depending on the areas where you need to improve your skills, you will appreciate the comprehensiveness of the courses. All the courses are short. It will thus not take months out of your schedule to learn how to optimally apply the more advanced functions in Excel.
Practical situations and scenario building are used to ensure that you will be able to apply the information when back at office. These advanced Excel training courses are presented in Johannesburg and focus on the following main areas:
- Data analysis spreadsheet techniques
- Advanced spreadsheet techniques
- Financial modelling course.
Data analysis spreadsheet techniques
- Basics
- Data cleanup
- Data manipulation
- Data reporting
- Modelling features.
Advanced spreadsheet techniques
- Data protection
- Cell naming
- Modelling
- Hands-on exercises
- Creating formats
- Data validation
- Multiple sheet modelling
- Databases
- Logical tests
- COUNTIF
- Pivot table reports
- SUMIF
- Lookups
- Masks
- Indirect addressing
- String functions
- Data consolidation
- Controls
- Views
- Macros
Financial modelling
The course runs over three days and provides from basic to in-depth understanding of financial modelling enabling attendees to become power users of the program for the purpose of decision making and financial analysis.
Contact us to book any of the advanced Excel training courses whether for a group or individuals.
|
