Trusted Training Partners
Home / Non-Accredited / Software & IT Non-Accredited / Ms Office Excel Advanced 2013 Training Course
Quick Look Course Summary:Ms Office Excel Advanced 2013 Training Course
-
Next Public Course Date:
-
Length: 1 day(s)
-
Price (at your venue): 1 Person R 4,811 EX VAT 3 Person R 3,654 EX VAT 10 Person R 2,719 EX VAT
-
Certification Type:Accredited
-
Locations & Venues: Off-site or in-house. We train in all major city centres throughout South Africa.
Get Free & personalised
Training Advice
Ms Office Excel Advanced 2013 Training Course Course: Introduction
One of many Excel courses to choose from, we are sure we have an Excel course with you in mind. The advanced course in Excel follows on from the Intermediate course. Participants cover Excel comprehensively in this course.
Ms Office Excel Advanced 2013 Training Course Course :Course Outline
1. Advanced Functions and formulas
Logical functions
Conditional functions
Financial functions
Text functions
Date and time functions
Array formulas
Calculation options
2. Lookups and Data Tables
Using lookup functions
Creating data tables
3. Advanced Data Management
Validating cell entries
Advanced filtering
4. Advanced Charting
Chart formatting options
Combination charts
Graphical objects
5. PivotTables and Pivot Charts
Working with PivotTables
Modifying PivotTable data
Formatting PivotTables
Using Pivot Charts
Power Pivot
6. Exporting and Importing data
Exporting and importing text files
7. Analytical Tools
Goal Seek
Scenarios
Instant data analysis
Ms Office Excel Advanced 2013 Training Course Course: Course Duration
1 day/s
Who should attend: Ms Office Excel Advanced 2013 Training Course Course
This course is intended for advanced users of Microsoft Excel.
**Quote does not include Any Exam Fees (if applicable)
IMPORTANT ACTION: Do Not Wait To Improve Your Skills. Â
Book Now By Completing Online Booking Form / Customised Proposal or Obtain Approval For Your Already Received Customised Proposal
About this course
This course is not accredited. It is delivered as a professional skills programme, and delegates receive a BOTI certificate of attendance.
If you need a credit-bearing outcome for B-BBEE skills development, SETA grant or learnership purposes, please see our accredited qualifications and skills programmes, or read about BOTI accreditations.
Frequently Asked Questions
Is this course accredited?
No. This course is delivered as a practical, facilitator-led skills programme and delegates receive a BOTI certificate of attendance. If you need a credit-bearing outcome for B-BBEE skills development, SETA grant or learnership purposes, ask us about our accredited qualifications, skills programmes and unit standards.
Can this course be delivered in-house at our premises?
Yes. Every BOTI course can be delivered on-site at your offices anywhere in South Africa, or at a scheduled public venue, and can be customised to your team and industry.
How do I book or get a quote?
Use the enquiry form on this page for a tailored quote, or call 011 882 8853 / email [email protected]. The course length and next public course date are shown in the Quick Look summary.
Can this training count towards our B-BBEE scorecard?
Spend on this course still counts as skills development expenditure for B-BBEE purposes, but it does not count as accredited training spend, and the Codes limit how much non-accredited training can contribute. Please confirm the treatment with your skills development facilitator or B-BBEE verification agency.
Do you tailor the training to our industry?
Yes. Our training is built around your business, using practical, real-world examples relevant to your team and sector.