Introduction: Ms Office Excel Advanced 2013 training Course
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.
Outline: Ms Office Excel Advanced 2013 Training Course
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
Course duration and fees: Ms Office Excel Advanced 2013 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 2013 Training Course
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
Advanced Excel Quiz
Free test of your Advanced Excel knowledge- click below:
Upcoming Public Courses
Please click on link below for related public course/s:
Accredited Computer Courses
Introduction to Computers, Johannesburg
February 25 @ 8:00 am - 5:00 pm SASTIntroduction to Computers, Cape Town
March 4 @ 8:00 am - 5:00 pm SAST
MS Word for Beginners, Johannesburg
February 26 @ 8:00 am - 5:00 pm SASTMS Word for Beginners, Cape Town
March 5 @ 8:00 am - 5:00 pm SAST
Excel for Beginners, Johannesburg
February 27 @ 8:00 am - 5:00 pm SASTExcel for Beginners, Cape Town
March 6 @ 8:00 am - 5:00 pm SAST
MS PowerPoint for beginners, Johannesburg
February 28 @ 8:00 am - 5:00 pm SASTMS PowerPoint for beginners, Cape Town
March 7 @ 8:00 am - 5:00 pm SAST
MS Outlook for Beginners, Johannesburg
March 1 @ 8:00 am - 5:00 pm SASTMS Outlook for Beginners, Cape Town
March 8 @ 8:00 am - 5:00 pm SAST
Creating Spectacular Graphs & Charts With Excel, Johannesburg
February 28 @ 8:00 am - 5:00 pm SASTCreating Spectacular Graphs & Charts With Excel, Cape Town
March 7 @ 8:00 am - 5:00 pm SAST
Solving Problems With Excel, Johannesburg
March 1 @ 8:00 am - 5:00 pm SASTSolving Problems With Excel, Cape Town
March 8 @ 8:00 am - 5:00 pm SAST
Excel Combo – Beginners to Graphs and Problem Solving, Johannesburg
February 27 @ 8:00 am - March 1 @ 5:00 pm SASTExcel Combo – Beginners to Graphs and Problem Solving, Cape Town
March 6 @ 8:00 am - March 8 @ 5:00 pm SAST
Microsoft All-in-One Basic Computer Course , Johannesburg
February 25 @ 8:00 am - March 1 @ 5:00 pm SASTMicrosoft All-in-One Basic Computer Course , Cape Town
March 4 @ 8:00 am - March 8 @ 5:00 pm SAST
Book or Obtain Instant Quote
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:
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