Free Training & Career Tips... Subscribe to Get Weekly Career Tips
By Subscribing You are Agreeing to Terms and Conditions
Introduction: Ms Office Excel Intermediate 2013 Training Course
Microsoft Office Excel Intermediate 2013 should be completed once Microsoft Office Excel Basic 2013 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 2013 Training Course
Johannesburg (Sandton), Cape Town, Durban, Port Elizabeth, Pretoria – South Africa
Key outcomes of the course include:
Session 1: Worksheets and Workbooks management – Viewing , Linking, Printing large worksheets, multiple worksheets
Session 2: Subtotals and Outlining – consolidating data
Session 3: Formatting in advanced manner, utilizing special number formats, themes, advanced formatting
Session 4: Sharing and Web usage
Session 5: Naming ranges and cells
Session 6: Tables and Data Structures , filtering
Session 7: Application settings and Working with templates
Session 8: Auditing and documentation
Course duration and fees: Ms Office Excel Intermediate 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 Intermediate 2013 Training Course
The course (Ms Office Excel Intermediate 2013 Training Course) is designed for the following attendees:
0
For the Ms Office Excel Intermediate 2013 Training Course it is advisable that you have the following experience/knowledge:
Excel 2013: Basic or equivalent experience.
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 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