Introduction: Ms Office Excel Advanced 2013 training Course
Microsoft Office Excel Advanced 2013 follows Microsoft Office Excel Intermediate 2013. Here the more advanced and complex abilities of Excel will be taught with an emphasis on task automation. Here one will utilsie more advanced analysis methods on bigger data sets. In addition the student will be taught how to work on the same worksheets with others.
Sharing Excel data with other applications will also be taught.
Outline: Ms Office Excel Advanced 2013 Training Course
Johannesburg (Sandton), Cape Town, Durban, Port Elizabeth, Pretoria – South Africa
Key outcomes of the course include:
Module 1: Advanced Formulas and Functions ( Logical, Text , time Conditional, Financial
Functions, Array formulas)
Module 2: Data Tables and Lookups
Module 3: Data Management – advanced ( Validations, filtering)
Module 4: Charting – advanced
Module 5: PivotCharts and PivotTables
Module 6: Importing and exporting
Module 7: Analytical Tools, Scenarios, Goal Seek
Course duration and fees: Ms Office Excel Advanced 2013 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 2013 Training Course
The course (Ms Office Excel Advanced 2013 Training Course) is designed for the following attendees: All
For the Ms Office Excel Advanced 2013 Training Course it is advisable that you have the following experience/knowledge:
Intermediate or equivalent experience on Excel 2013
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
Upcoming Public Courses
Please click on link below for related public course/s:
Accredited Computer Courses
Book or Obtain Instant Quote
In addition to the related public courses, we offer the above course across the country: Anytime, Anywhere. Click on the link to get an instant proposal or book your course NOW:
Or alternatively click on the button below to view our full Public Course Calendar of close to 100 events:
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