Telephone - 01905 726222
info@neos-it-training.com
Excel 2003
iNTERMEDIATE
1 Day
Create a basic worksheet by entering text, values, and formulas
Create formulas by using Excel’s built-in functions
Move and copy data by using shortcut menus, drag-and-drop editing, and toolbar buttons
Change the appearance of worksheet data by using a variety of formatting techniques
Prepare a document for printing by using the spell checking feature and a variety of printing options
Produce charts from the data
Delegates should have a working knowledge of Excel 2003 as can be gained from our Excel 2003 Core Skills course.
Toolbars and Views
Creating a Custom Toolbar
Resetting a Default Toolbar
Changing the View
Using Zoom
Viewing Multiple Workbooks
Comparing Two Workbooks
Saving a Custom View
Sorting and Filtering
Sorting Data
Mutli-level Sorting
Filtering a List with Autofilter
Filtering a List with Advanced Filter
Working with Graphics
Inserting Graphics
Creating AutoShapes
Formatting Graphic Objects
Multiple Worksheets and WorkBooks
Referencing Cells in Other WorkSheets
Referencing Cells in Other Workbooks
Opening Workbooks with External References
Advanced Formulas and Functions
Inserting Functions
Formula Building Recommendations
Naming Cells and Ranges
Logical Statements
Conditional Formulas (AND, OR, NOT)
IF Functions
Nested IF Functions
Combining IF with AND, OR, and NOT
IS Functions
Using IS with IF to Change Error Messages
Conditional Formatting
Database Formulas and Functions
The LOOKUP Function
Array Lookup
Vector Lookup
The VLOOKUP Function
The HLOOKUP Function
Detailed Functions
Date and Time Calculations
Text and Data Functions
Mathematical Functions
Statistical functions
Shared Workbooks
Sharing WorkBooks
Sharing a WorkBook
Opening a Shared WorkBook
Saving Changes to a Shared WorkBook
Resolving Conflicts
Importing and Exporting
Exporting Data From Excel
Importing Data From Other Applications
CSV files