Trusted Training Partners

Quick Look Course Summary:Ms Office Excel Intermediate 2013 Sat Training 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 Intermediate 2013 Sat Training Course Course: Introduction

    This course is intended for all users of Excel. This course incorporates some new features and connectivity options in efforts to make collaboration and production as easy as possible. Also included are advanced formulas, data analyzing, tables, data charts, graphics and enhancing workbooks.

    Ms Office Excel Intermediate 2013 Sat Training Course Course :Course Outline

    1. Introduction
    Creating advanced formulas
    Apply range names

    2. Tables
    Create and modify tables
    Sort and filter data
    Use subtotal and database functions to calculate

    3. Visualising data with charts
    Create charts
    Modify and format charts
    Create a trend line
    Create advanced charts

    4. Inserting graphics
    Insert and edit graphics
    Layer and group graphics
    Add and edit SmartArt

    5. Enhancing workbooks
    Customise workbooks
    Manage themes
    Create and use templates
    Protect files
    Preparing a workbook for multiple audiences

    6. Auditing worksheets
    Trace cells
    Invalid data and formula errors
    Evaluate and monitor formulas
    Create a data list outline

    7. Multiple workbooks
    Consolidate data
    Link cells in different workbooks
    Merge workbooks
    Managing large workbooks
    Format and rename worksheet tabs
    Edit and monitor worksheets

    Ms Office Excel Intermediate 2013 Sat Training Course Course: Course Duration

    1 day/s

    Who should attend: Ms Office Excel Intermediate 2013 Sat Training Course Course

    This course is intended for intermediate 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