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.
This course at BOTI todayMicrosoft Excel Intermediate to Advanced (2 days)
The current course runs at your offices anywhere in South Africa, live online or at a BOTI venue. The course page has the up-to-date outline and group prices.
See the current courseGet a quote for your teamSee all Microsoft Office and Computer Skills courses
Learning on your own? Self-paced e-learning from R595 (excl. VAT) · Ask your employer to pay
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
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.
There are no upcoming events.
There are no upcoming events.
There are no upcoming events.
There are no upcoming events.
There are no upcoming events.
There are no upcoming events.
There are no upcoming events.
There are no upcoming events.
<
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
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