The fact of the matter is that you will excel when you master how to use Excel
Most projects fail because they are poorly planned: causing projects to exceed time, scope and budget.
Whether a project manager, project team member or business analyst, you will be required to deal with the planning, tracking, reporting and handling of estimates and budgets. Your proficiency in using spreadsheets will affect how well you achieve your objectives. These courses are held in following locations:
Excel courses Johannesburg, Cape Town, Durban and all major centres
The Solution (Johannesburg and all major centres)
This two-day program will assist project managers and business analysts alike with saving time and in their project management activities. The course will equip delegates with skills to aid with the planning process; create dashboards to track and monitor project progress and learn better solutions to their existing problems.
This hands-on course has two main modules: Planning & Budgeting and Tracking & Reporting. Case studies will be used to demonstrate and apply acquired skills to tackle the different problems involved in project management.
Course Overview
Learn how to create effective Dashboards which will eventually help you track your project on real time
You will learn how to effectively implement planning, tracking and reporting
Systematically forecast cost and time to complete a project
Conduct Cost Benefit analysis
Using Excel for Process Mapping
Choosing the appropriate graph for conveying information
The Pareto
Keeping abreast with budget and actual expenses
Tracking scope creep
Delivery Method (Excel Training Johannesburg)
Two-day Instructor Led classroom based training
Strong delegate participation and practical application of theory
Our objective is to ensure that the acquired tools and knowledge are user friendly and easily applied in the workplace. This we believe is essential in order to achieve the outcomes of this training initiative.
All delegates will receive:
Handbook
Tea, lunch and refreshments
Memory stick (with relevant tools and models that can be easily accessed when applied back at work)
Certificate
After training assistance for 3 months
Advanced Excel Quiz
Time limit: 0
Quiz-summary
0 of 10 questions completed
Questions:
1
2
3
4
5
6
7
8
9
10
Information
You must specify a text.
You must specify a text.
You must specify a text.
You must specify a text.
You must fill out this field.
Free test of your Advanced Excel knowledge- click below:
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading...
You must sign in or sign up to start the quiz.
You have to finish following quiz, to start this quiz:
Results
0 of 10 questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 points, (0)
Categories
Question - Excel - Advanced0%
1
2
3
4
5
6
7
8
9
10
Answered
Review
Question 1 of 10
1. Question
1 points
What is SmartArt?
Correct
Incorrect
Question 2 of 10
2. Question
1 points
What is a contextual tab?
Correct
Incorrect
Question 3 of 10
3. Question
1 points
What is a precedent cell?
Correct
Incorrect
Question 4 of 10
4. Question
1 points
If there is something wrong with the results of dependent cells, how do you find the error?
Correct
Incorrect
Question 5 of 10
5. Question
1 points
An axis on a chart is a reference line for plotting data – true or false
Correct
Incorrect
Question 6 of 10
6. Question
1 points
You cannot insert a Pivot table based on a Pivot chart because it’s the same thing – true or false.
Correct
Incorrect
Question 7 of 10
7. Question
1 points
What are common errors in Excel formulas?
Correct
Incorrect
Question 8 of 10
8. Question
1 points
Where is the error checking option?
Correct
Incorrect
Question 9 of 10
9. Question
1 points
What is a macro?
Correct
Incorrect
Question 10 of 10
10. Question
1 points
What options does the Pivot table list include?
Correct
Incorrect
Excel is an essential skills. As JFK said Leadership and learning are indispensable to each other.
Upcoming Public Courses
Please click on link below for related public course/s:
Accredited Computer Courses
There are no upcoming events at this time.
There are no upcoming events at this time.
There are no upcoming events at this time.
There are no upcoming events at this time.
There are no upcoming events at this time.
There are no upcoming events at this time.
There are no upcoming events at this time.
There are no upcoming events at this time.
There are no upcoming events at this time.
Book Now or Obtain Instant Quote
We also offer customized courses across the country: Anytime, Anywhere. Click on the link to get get instant proposal or book you course:
We are a diverse and dynamic team of passionate training specialists who believe that self-betterment and additive education are transformative elements that can help people realise their full potential. We are in the constant pursuit of excellence and proud of our authentic BBEEE roots. We want to work with companies who share our vision. Learn More