Trusted Training Partners
Home / Uncategorized / Ms Office Excel Intermediate 2010 Sat Training Course Course
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 4,475.00 EX VAT 3 Person R 3,399.06 EX VAT 10 Person R 2,529.41 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
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
Duration: 1 day(s)
Delegates: 1
Cost (incl):