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.

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

Follow us on

Facebook  Twitter  You Tube