Free Training & Career Tips... Subscribe to Get Weekly Career Tips

By Subscribing You are Agreeing to Terms and Conditions
Microsoft Office Excel Advanced 2013 follows Microsoft Office Excel Intermediate 2013. Here the more advanced and complex abilities of Excel will be taught with an emphasis on task automation. Here one will utilsie more advanced analysis methods on bigger data sets. In addition the student will be taught how to work on the same worksheets with others.
Sharing Excel data with other applications will also be taught.
Johannesburg (Sandton), Cape Town, Durban, Port Elizabeth, Pretoria – South Africa
Key outcomes of the course include:
Module 1: Advanced Formulas and Functions ( Logical, Text , time Conditional, Financial
Functions, Array formulas)
Module 2: Data Tables and Lookups
Module 3: Data Management – advanced ( Validations, filtering)
Module 4: Charting – advanced
Module 5: PivotCharts and PivotTables
Module 6: Importing and exporting
Module 7: Analytical Tools, Scenarios, Goal Seek
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.
The course (Ms Office Excel Advanced 2013 Training Course) is designed for the following attendees: All
For the Ms Office Excel Advanced 2013 Training Course it is advisable that you have the following experience/knowledge:
Intermediate or equivalent experience on Excel 2013
Free test of your Advanced Excel knowledge- click below:
Please click on link below for related public course/s:
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:
Copyright text 2020 by Business Optimization Training Institute.