Trusted Training Partners

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

  • Length: 1 day(s)

  • Price (at your venue): 1 Person R 3,982.50 EX VAT 3 Person R 2,729.81 EX VAT 10 Person R 1,885.40 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

    Knowing your course will help us prepare for our consultation and phone call.

    The more people you send on our courses, the cheaper the unit cost.

    YesNo

    Input this code: captcha

    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

    Realize incredible savings by sending more delegates

    Do you want to save costs by doing training at your premises?

    Save costs by providing own laptop

    Region *

    Accredited Courses

    Additional Courses

    Software & IT Courses

    Top Rated