This course is designed to help you to develop your skills in using the spreadsheet tool Microsoft Excel. You will learn to use more advanced functions and create more complex formulas. You will learn to manage and link together multiple worksheets.

Next Microsoft Excel 2003 Intermediate Open Training Course
30/01/2012

Manchester City Centre Venue
Limited Places-Book Now -
Call 0161 408 0435
Or
Book Online

Course Content

Working with Multiple Worksheets 
Using Multiple Worksheets 
Linking Worksheets by Using 3-D Formulas 
Managing Workbooks 
Data Consolidation 
Linking across Applications

Advanced Formulas
Sumif and Countif 
Round and Integer 
Lookups and Named Ranges 
IF Statements 
And & Or 
LookUps
 

List Management 
Introducing Lists 
Sorting and Filtering Lists 
Advanced Filtering 
Custom Lists 
Text to Columns 
Custom Views
 

Notation and Auditing 
Comments and Text Boxes 
Auditing Features 
Data Validation 
Protection 
Workgroup Collaboration

Working with Large Worksheets 
Viewing Options 
Hiding and Displaying Data 
Printing Large Worksheets
 

Advanced Charting 
Chart Formatting Options 
Creating Combination Charts 
Using Graphic Elements

 

Last Updated (Saturday, 17 December 2011 16:51)