Trusted Training Partners

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

    This is one of several Excel courses we offer. This is a practical course and all materials needed by participants will be provided. This is also one of our Saturday courses to accommodate participants who find other times difficult to attend.

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

    1. Performing Calculations
    Named Ranges
    Creating Formulas to Calculate Values
    Summarising data using If function
    Formula Auditing
    Adding a watch Window
    Tracing Formula Errors
    Tracing Precedents and Dependent cells

    2. Changing Workbook Appearance
    Defining Styles
    Making Numbers easier to read
    Transposing data
    Changing Cell Orientation and Merging Cells
    Change appearance of data based on its value
    Focusing on specific data by using filters
    Inserting Filters
    Sort A to Z using Filters
    Number Filters
    Clear Filters
    Advanced Filtering
    Summarising worksheets with hidden and filtered rows (subtotal and aggregate functions)
    Data Validation

    3. Reordering and Summarising Data
    Sort Data
    Custom Lists
    Organising data into levels using subtotals
    Creating an outline
    Lookup Functions

    4. Combining Data from Multiple Sources
    Built-in Templates
    Using workbooks as templates for other workbooks
    Linking to data in other workbooks
    Consolidating data
    Saving workbooks as a workspace
    Comments in cells and workbooks
    Viewing Comments in a worksheet
    Adding and Removing comments
    Adding comments to a workbook
    Password protect a worksheet and workbook
    Unlock cells and protecting part of a worksheet
    Track Changes
    Mark a workbook as final

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

    1 day/s

    Who should attend: Ms Office Excel Intermediate 2010 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