Excel 2010 Adavanced

Description

This free Excel 2010 eBook should be used as a point of reference after following attendance of the advanced level Excel 2010 training course. It covers all the topics taught and aims to act as a support aid for any tasks carried out by the user after the course.

The manual is divided into sections, each section covering an aspect of the advanced course. The table of contents lists the page numbers of each section and the table of figures indicates the pages containing tables and diagrams.
Content
1. Advanced worksheet functions

Conditional & Logical Functions
Counting And Totalling Cells Conditionally
And, Or, Not
Lookup Functions
2. Views, scenarios, goal seek, solver

Goal Seeking And Solving
Advanced Solver Features
Scenarios
Views
3. Using excel to manage lists

Excel Lists,List Terminology
Sorting Data
Subtotals
Filtering A List
Advanced Filtering
Criteria Tips
Multiple Criteria
Calculated Criteria
Data Consolidation
Pivottables
Modifying A Pivottable
Managing Pivottables
Formatting A Pivottable
Banding
Slicers
4. Charts

Introduction To Charting 143 Creating Charts 145 Formatting Charts 157 Changing The Chart Layout 163 Sparklines
5. Templates

Introduction To Templates
Create Custom Templates
6. Drawing and formatting

Inserting, Formatting And Deleting Objects
More Formatting