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
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 - Advanced 0%
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- Answered
- Review
-
Question 1 of 10
1. Question
1 pointsCorrect
Incorrect
-
Question 2 of 10
2. Question
1 pointsWhat is a contextual tab?
Correct
Incorrect
-
Question 3 of 10
3. Question
1 pointsWhat is a precedent cell?
Correct
Incorrect
-
Question 4 of 10
4. Question
1 pointsIf 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 pointsAn axis on a chart is a reference line for plotting data – true or false
Correct
Incorrect
-
Question 6 of 10
6. Question
1 pointsYou 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 pointsWhat are common errors in Excel formulas?
Correct
Incorrect
-
Question 8 of 10
8. Question
1 pointsWhere is the error checking option?
Correct
Incorrect
-
Question 9 of 10
9. Question
1 pointsWhat is a macro?
Correct
Incorrect
-
Question 10 of 10
10. Question
1 pointsCorrect
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:
Book This Course Or Obtain Quote – Now
View Calendar for the latest course