Business Optimization Training Institute
Quick Look Course Summary:Ms Office Excel Intermediate 2010 Sat Training Course Course
  • Next Public Course Date:

  • Length: 1 day(s)

  • Price: 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.

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

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.


Input this code: captcha

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


Simply Select a date to see cost

Select Date *

Premises Provided by *

Laptop Provided by *

Region *

Accredited Courses

Software & IT Courses

Top Rated