Microsoft Excel 2003 Intermediate Guide
By the end of this course you will be able to write advanced formulae to lookup records and perform decision making in Excel; use advanced formatting tools to make data easier to understand and highlight important information; sort and filter a data list and create and format charts.
Don't forget the end of tutorial quiz to test what you have learnt
Sorting a Filtering
Sorting a data list
Autofilter
Custom Autofilter
Formatting a Worksheet
Date Formatting
Custom Number Formatting
Conditional Formatting
More Functions
Vlookup
Hlookup
If Function
AND and OR functions
Nested Functions
SumIf
CountIf
Named Ranges
Creating a Range Name
Using Range Names in Formulas
Managing Range Names
Charts
Creating a Chart
Resizing and Moving a Chart
Working with Chart Labels
Formatting a Charts Axis
Change a Charts Source Data
Change the Chart Type
Add a Trendline
Custom Charts
Working with Multiple Workbooks
Consolidating Data
Linking Cells
Workspace Files
Excel Protection
Excel File Protection
Workbook Protection
Worksheet Protection
