Excel 2003 Charts & Lists (Intermediate) Quick Reference
Laminated quick reference card showing step-by-step instructions and shortcuts for Charts (graphs) and List features of Microsoft Excel 2003. This card is suitable as an accompaniment for Intermediate level Excel training. This guide is also available in French. See topics below.
Note: Quantity discounts are by title.
ISBN # : 978-1-934433-36-2
The following topics are covered:
Creating a Chart with the Wizard, 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
Setting the Default Chart
Creating a Graph with one Keystroke, Adding Custom Chart Types to the List, Changing Chart Location (Chart Object vs. Chart Sheet), Adding a Projection to a Data Series
Creating a List: Excel Lists vs. Normal Range, Changing List Area, Adding New Rows, Toggle Total Row, List Selection Shortcuts, Printing a List, Sorting a List, Custom Sort Orders
Filtering a List: AutoFilter & Advanced Filters
List Subtotals, Creating & Modifying Pivot Tables
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.