Introduction: Ms Office Excel Advanced 2010 Saturday Training Course
Microsoft Office Excel Advanced courses is followed by Microsoft Excel: Beginners and Microsoft Excel: Intermediate, this course will extend your knowledge into some of the more specialized and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others, and sharing Excel data with other applications.
Outline: Ms Office Excel Advanced 2010 Saturday Training Course
Johannesburg (Sandton), Cape Town, Durban, Port Elizabeth, Pretoria – South Africa
Key outcomes of the course include:
1. Data Sets analysis – Scenario Summary, Scenario Manager, Goal Seek, Solver, descriptive statistics
2. Advanced Functions
If formulas, using other And, Or, Not, nested formulas, Rounding PMT Function, Showing / Hiding Formulas
3. Pivot Tables – Using Slicers to filter data, Rearranging Pivot Tables, Refreshing Data, Subtotals, and Creating Pivot Tables from external data import
4. Producing Graphics & Charts, Trendline, Sparklines, Pivot Charts, Smart Art Mathematical Equations
5. Repetitive Tasks automation by utilizing Macros
6. Interaction with other Microsoft Office Programs – Embedding/ linking other office files
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
Course duration and fees: Ms Office Excel Advanced 2010 Saturday Training Course
Our two day training course is designed so that the knowledge acquired is applied practically, so that the business environment can be enhanced.
Please consult schedule for course costs or contact BOTI for a quote.
Recommended Prior Experience and Knowledge: Ms Office Excel Advanced 2010 Saturday Training Course
The course (Ms Office Excel Advanced 2010 Saturday Training Course) is designed for the following attendees:
Targeted to wishing to acquire the acumen required to produce macros, analyze and data within worksheets, collaborate with others user, intergrate data from multiple sources and data export and import.
For the Ms Office Excel Advanced 2010 Saturday Training Course it is advisable that you have the following experience/knowledge:
Microsoft Office Excel: Beginners and Microsoft Excel: Intermediate or equivalent working knowledge
Upcoming Public Courses
Please click on link below for related public course/s:
Accredited Computer Courses
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 Public Course Schedule
Please Phone Us Now To Speak to One of Our Friendly Consultants
Tel:011-882-8853
OR
FOR CELL PHONES CLICK TO CALL
Please Fill in the Form – We Will Get Back to You Within 15 minutes