Excel 2007 Charts & Tables
Laminated quick reference card showing step-by-step instructions and shortcuts for Charts (graphs) and Table features of Microsoft Office Excel 2007. This guide is also available in French. See topics below.
Volume Price
| |
| 1 – 49 | $3.60 |
| 50 – 99 | $2.90 |
| 100 – 499 | $2.40 |
| 500 – 999 | $2.25 |
| 1000 + | $2.00 |
ISBN # : 978-1-934433-62-1
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.
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
