Free Training & Career Tips... Subscribe to Get Weekly Career Tips
By Subscribing You are Agreeing to Terms and Conditions
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.
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
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