Quick Look Course Summary:Ms Office Excel Advanced 2013 Training Course Course
  • Next Public Course Date:

  • Length: 1 day(s)

  • Price: 1 Person R 3,982.50 EX VAT 3 Person R 2,509.17 EX VAT 10 Person R 1,795.98 EX VAT

  • Certification Type:Accredited

  • Locations & Venues: Off-site or in-house. We train in all major city centres throughout South Africa.

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

Get Free & personalised
Training Advice

Enjoy incredible savings the more delegates
you send. See for yourself...

BOTi COURSE COST CALCULATOR

Simply Select a date to see cost

Select Date *

Premises Provided by *

Laptop Provided by *

Region *

Administrative Courses

Human Resources Courses

Leadership & Management Courses

RPL & Learnerships Courses

Soft Skills Courses

Software & IT Courses

Specialist Courses

Top Rated