Microsoft Excel 2003 Intermediate

Course Aims
This hands-on one-day training course has been designed to delegates a solid understanding of more advanced Excel tools and concepts in order to increase their knowledge and productivity.
Who Should Attend?
Users with a basic understanding of Microsoft Excel 2003 or XP who want to consolidate and expand on their knowledge of the basic features in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction course.
Course Outline: Microsoft Excel 2003 Intermediate
Working with Functions and Formulas
Using Formulas in Excel:· Relative and Absolute Cell References · Basic Mathematical Operators · Formulas and 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 · 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 · 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
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?
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
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