Ms Office Excel Advanced 2010 Saturday Training Course

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.


Ms Office Excel Advanced 2010 Saturday Training Course

 

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

Free test of your Advanced Excel knowledge- click below:

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

Advanced Excel Quiz

Free test of your Advanced Excel knowledge- click below:

Course Schedule

Book Now!
View Calendar for the latest course

<