Free Advanced Excel 2003 Training Manual

Here is an excellent Free Advanced Excel 2003 Training Manual, from microsofttrainingcourses.co.uk. This training document is 155 pages in length, the zipped download size is 1.1mb, and the resulting doc file size is 9.8mb. Advanced Excel features and functionality covered by this Excel training manual include: Conditional & Logical Functions, Lookup Functions, Goal Seeking And Solving, Views and Scenarios, Reports, Manage Lists, Advanced Filtering, Pivot Tables, Charting, Templates, Auditing, Validation Circles, Precendents And Dependants, and Comments. For step-by-step instructions for each Excel command demonstrated, look for the hand icon.


Table Of Contents of Advanced Excel 2003 Training Manual:

Introduction
How To Use This Guide

Section 1
Using Advanced Worksheet Functions
Using Names
Conditional & Logical Functions
If Statementsh
And, Or, Not
Lookup Functions
Vector Lookup
Hlookup
Vlookup
Nested Lookups
Goal Seeking And Solving
Solver

Section 2
Views, Scenarios & Reports
Views & Scenarios
Custom Views
Scenario Manager
Print Reports

Section 3
Using Excel To Manage Lists
Excel Lists
Sorting Data
Adding Subtotals To A List
Filtering A List
Data Form
Advanced Filtering
Copying Filtered Data
Database Functions
Pivot Tables
Modifying A Pivot Table
Grouping Pivot Table Items

Section 4
Excel Charts
Chartwizard
Moving And Resizing Embedded Charts
Chart Types
Formatting Charts
Format Chart Elements
Manipulating Chart Data
Chart, Edit Series
Swapping The X And Y Axes
Using Charts To Change Data

Section 5
Templates
Custom Templates
Autotemplates
Opening And Editing Templates
Template Properties

Section 6
Auditing
Tracers
Comments
Validation Circles
Go To Special
Precendents And Dependants
Comments

Popularity: 39% [?]