The Ultimate Guide to Excel 2003 Advanced Book (Training Manual)


The Ultimate Guide to Excel 2003 Advanced book or training manual can be used as a reference guide for you to discover the most advanced features in Excel. It is divided into chapters, as you can see from the TOC below.

Among the topics that you can learn included Advanced Functions; Views, Scenarios & Reports; Managing Excel Lists; Advanced Charts; Templates and Auditing.



TABLE OF CONTENTS:

Introduction
About This Manual

Chapter 1: Advanced Worksheet Functions
Names
Using Names
Conditional & Logical Functions
And, Or, Not
Lookup Functions
Hlookup
Vlookup
Nested Lookups
Goal Seek And Solver
Goal Seek
Solver

Chapter 2: Views, Scenarios & Reports
Views & Scenarios
Custom Views
Scenario Manager
Print Reports

Chapter 3: Using Excel To Manage Lists
Excel Lists
List Terminology
Sorting Data
Custom Sorting Options
Subtotals
Filtering A List
Wildcards
Data Form
Advanced Filtering
List Statistics
Pivot Tables

Chapter 4: Charts
Introduction To Chart
Terminology
Excel Charts
Chart Wizard
Data Layout
Chart Toolbar
Chart Toolbar
Chart Types
Formatting Chart
Basic Chart Formats
3-D Chart Formatting Options
Manipulating Chart Data
The Series Function
Charting With Blocks Of Data
Picture Charts

Chapter 5: Templates
Introduction To Templates
Standard Templates
Custom Templates
Autotemplates

Chapter 6: Auditing
Auditing Features
Precendents And Dependants
Comments


Some info about the book:

File name: The Ultimate Guide to Excel 2003 Advanced (ebook)
File length: 126 pages, downloadable pdf format
File size: 1.21 MB
Price: USD 6.99
To order online, click the Buy Now button.

Note: You can checkout using your credit card without a PayPal account. Once ordered, you will bring to the download page to download the e-book.