Product Description

Laminated quick reference guide showing step-by-step instructions and shortcuts for Charts (graphs) and Table features of Microsoft Office Excel 2007. This card is suitable as an accompaniment for Intermediate level Excel training. The following topics are covered:

Excel Charts: Inserting a Chart, Resizing and Moving Chart Objects, Changing Chart Type, Charting Non-Adjacent Data, Adjusting Scale, Two-Scaled Charts, Adding,
Removing and Formatting: Legend, Gridlines, Data Series, Explanatory Text, Callouts, Arrows and Circles, Data Labels, Adding a Projection or Trendline to a Data Series, Setting the Default Chart, Creating the Default Chart with one Keystroke, Creating Chart Templates, Applying Custom Chart Types, Changing Chart Location (Chart Object vs. Chart Sheet).
Excel Tables: Creating an Excel Table, Excel Table vs. Normal Range, Changing the Table Area, Adding New Rows or Columns to the Table, Toggle Total Row, Table Selection Shortcuts, Sorting a List, Multi-Level Sorting, Custom Sort Orders, Subtotals.
Filtering a Table: AutoFilter & Advanced Filters, Creating Pivot Tables, Rearranging PivotTables, Adding/Removing PivotTable Fields, Show/Hide the PivotTable Field List, Refreshing a PivotTable, Creating a PivotChart, Changing the Summary Function, Filtering in a PivotTable, Sorting in a PivotTable, Grouping by Dates or Time.
This guide is suitable as a training handout, or simply an easy to use reference guide, for any type of user.

This guide is one of several titles available for Excel 2007: Excel 2007 Introduction, Excel 2007 Charts & Tables, Excel 2007 Advanced & Macros.

Product Details

• Amazon Sales Rank: #16532 in Books
• Published on: 2007-01-31
• Binding: Pamphlet
• 2 pages

About the Author
Beezix has been publishing quick reference computer guides for trainers, training companies, corporations, and individuals across the US and Canada for over 15 years. Founded by trainers, and with a strong focus on the learner, extensive industry experience made us aware of the need for a line of high-quality, trainer-produced courseware, and led to the creation of Beezix Quick Reference guides in 1994. Our cards are designed for casual computer users right through to trainers and trouble-shooters.

Customer Reviews

Most helpful customer reviews

10 of 10 people found the following review helpful.
Quick reference
By R. Norman
I would like a little more information on the sheet. It was just basics and probably would work for someone just starting to use Excel/

0 of 0 people found the following review helpful.
Microsoft Excell 2007 charts & tables quick reference card
By Amy
This was laminated so in excellent shape! These will help me a lot! Amazon's recommendations to me was where I found them! Thanks so much!

0 of 0 people found the following review helpful.
Great Reference Guide
By L. Pino
This Excel 2007 Charts & Tables reference guide definitely helps me accomplish my work, so I do not have to lug around a big book. The tips and instructions are written clearly and are easily understood. The laminated coating definitely helps with keeping it clean and wrinkle free. Highly recommend.