Microsoft Excel 2003 Intermediate
Aims for this course
This course is designed for those users who wish to increase their current knowledge of Excel to take advantage of the more complex features. You will learn how to create, edit and format large or multiple spreadsheets. You will also learn how to perform calculations and functions within a workbook, manipulate data lists and create custom charts which will enable the user to maintain and present data in a professional environment.
Course Agenda
Working With Functions And Formulas
Using Formulas
In Excel
Understanding
Relative And Absolute Cell References
The Basic Mathematical Operators
Using Formulas With Multiple Cell References
The Formula Auditing Bar
Fixing Formula Errors
Displaying And Printing Formulas
Exploring
Excel Functions
What Are Functions?
Finding The Right Function
Some Useful And Simple Functions
Using Functions
In Excel
Inserting
Functions
Using Functions And Autofill To Perform Difficult Calculations
Using The If Function
Working With Nested Functions
Working
With Names And Ranges
What Are Range
Names?
Defining And Using Range Names
Selecting Nonadjacent Ranges
What Is Auto Calculate?
Working
With Array Formulas
What Are Array
Formulas
Using Basic Array Formulas
Using Functions With Array Formulas
Using The If Function In Array Formulas
Managing
Lists
Working With
Lists
What Is A
List?
Creating Lists
Modifying Lists
What Is The Total Row?
Working
With Records And Fields
What Are Records
And Fields?
Adding Fields By Inserting Columns
Adding Records By Inserting Rows
Adding Records With A Data Form
Finding And Deleting Records
Practice Exercise
Working
With Lists And Filters
Sorting A
List
What Is An Autofilter
Custom Autofilters
Using An Advanced Filter
Copying Filtered Records
Using Excel As A Database
Filtering
With Wild Card Characters
Validating Your Data
What Are Database Functions?
What Are Lookup Functions?
Practice Exercise
Review Questions
Working With Macros And Controls
Creating Macros
In Excel
What Is A Macro?
Creating A Macro
Playing A Macro
Assigning A Shortcut Key To Macro
Macros, Buttons, And Toolbars
Excel Form Controls
What Is A
Form Control?
The Form Toolbar
Adding A Control To A Worksheet
Assigning A Macro To A Control
Using Form Controls
Using Excel
With Other Programs
Using Excel
In Word
Inserting Excel Data In Word
Modifying Excel Data After Insertion
Linking Excel Data In Word
Linking An Excel Chart In Word
Practice Exercise
Using Excel
With Other Programs And Files
Using Outlook
To Send Excel Data
Opening An Excel File In A Different Format
Importing Data From A Text File
Importing Data From A Database
Course Title
Microsoft Excel 2003 Intermediate
Cost per delegate
£145 +vat
Who is this course for?
Users with some experience in MS Excel 2003, or who have attended the MS Excel 2003 Foundation course
Related courses
> MS Excel 2003 Foundation
> MS Excel 2003 Advanced
When is this course running?
Click here to view the latest course schedule
