Ms Office Excel Intermediate 2010 Saturday Training Course

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.


Ms Office Excel Intermediate 2010 Saturday Training Course

 

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.

 

 

Course Schedule

Book Now!
View Calendar for the latest course

<