Free Training & Career Tips... Subscribe to Get Weekly Career Tips
By Subscribing You are Agreeing to Terms and Conditions
Introduction: Ms Office Excel Intermediate 2010 Saturday Training Course
Microsoft Office Excel Intermediate 2010 shoud be completed once Microsoft Office Excel Basic 2010 course has been undertaken . In the later course you would have created formatted, edited, basic spreadsheets. Now you need to repetitive that are repetitive and view spreadsheets in a better way. Here, you will use Microsoft Office Excel to refine and improve your spreadsheets by using charts, formulas, graphics and templates.
Outline: Ms Office Excel Intermediate 2010 Saturday Training Course
Johannesburg (Sandton), Cape Town, Durban, Port Elizabeth, Pretoria – South Africa
Key outcomes of the course include:
1. Undertaking Calculations, groups naming, Data range naming, Formulas and Formula Auditing, Tracing Errors, Precedents and Dependent cells
2. Modifying appearance of Workbook Appearance, Numbers formatting. Transposing, modifying Cell Orientation and cell Merging, filters, subtotal and aggregate function, Data Validation
3. Summarizing Data and sorting data, Sort Data, subtotals, Creating an outline, functions for Lookup
4. Multiple Sources data combining, Templates, protection, Linking and Consolidating data, Changes tracking comments and password protection,
Course duration and fees: Ms Office Excel Intermediate 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 Intermediate 2010 Saturday Training Course
The course (Ms Office Excel Intermediate 2010 Saturday Training Course) is designed for the following attendees:
Anyone that desires to gain necessary skill to create templates, sort and filter data, import and export data, analyze data and work with Excel on the Web.
For the Ms Office Excel Intermediate 2010 Saturday Training Course it is advisable that you have the following experience/knowledge:
Excel 2010: Basic or equivalent experience
Microsoft Office Excel: Beginners or equivalent working knowledge.
Excel Essentials 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 number. |
|
|
You must fill out this field. |
Free test of your Excel Essentials 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 - Essential 0%
-
Please also do our advanced Excel Quiz
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- Answered
- Review
-
Question 1 of 10
1. Question
1 pointsWhat is a worksheet?
Correct
Incorrect
-
Question 2 of 10
2. Question
1 pointsHow do you save a file?
Correct
Incorrect
-
Question 3 of 10
3. Question
1 pointsAutofill creates copies of cells based on the cell’s contents – true or false?
Correct
Incorrect
-
Question 4 of 10
4. Question
1 pointsWhat is Flashfill?
Correct
Incorrect
-
Question 5 of 10
5. Question
1 pointsHow do you create a custom view?
Correct
Incorrect
-
Question 6 of 10
6. Question
1 pointsWhat are some Arithmetic operators?
Correct
Incorrect
-
Question 7 of 10
7. Question
1 pointsA formula is a mathematical expression that you build yourself – true or false?
Correct
Incorrect
-
Question 8 of 10
8. Question
1 pointsAll functions begin with an addition sign – true or false?
Correct
Incorrect
-
Question 9 of 10
9. Question
1 points=SUM(A6*A7) and =SUM(A6:A7) are:
Correct
Incorrect
-
Question 10 of 10
10. Question
1 pointsWhat are Sparklines?
Correct
Incorrect
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 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