Excel 2016 for Mac Charts, Sparklines, Tables & PivotTables

Excel 2016 for Mac Charts, Sparklines, Tables & PivotTables Quick Reference Guide (Cheat Sheet of Instructions, Tips & Shortcuts - Laminated Card)

Laminated quick reference card showing step-by-step instructions and shortcuts for Charts (graphs), Sparklines, Tables and PivotTables features of Microsoft Excel 2016 for Mac. Written with Beezix's trademark focus on clarity, accuracy, and the user's perspective, this guide will be a valuable resource to improve your proficiency in using Microsoft Excel 2016 for Mac. This card is suitable as an accompaniment for Intermediate level Excel training, or simply an easy to use reference guide, for any type of user.

The following topics are covered:

Charts: Creating a Chart; Charting Non-Adjacent Data; Deleting a Chart; Resizing a Chart Object; Changing Chart Type; Changing Specific Chart Features; Adjusting Axis Scale; Adding Explanatory Text; Adding a Legend; Adding a Data Series; Adding Data Labels; Chart Object vs Chart Sheet; Adding a Projection to a Data Series.

Sparklines: Creating a Sparkline; Grouping Sparklines; Changing Sparkline Type; Removing Sparklines; Hidden and Empty Cells in Sparklines.

Excel Tables: Creating an Excel Table; Adding a New Row or Column; Deleting a Table Row or Column; Turning On/Off or Changing the Total Row; Removing Duplicates; Structured References in Excel Tables; Convert a Table to a Normal Range; Using a List in a Normal Range; Sorting: Simple and Complex.

Filtering and Advanced Filtering: Show/Hide AutoFilter; Filtering with AutoFilter; Setting Criteria for Advanced Filters; Using Advanced Filters/Copying Filtered Data to Another Range; Selecting/Ordering Columns; Clearing Filtering; Creating Subtotals in a List.

PivotTables: Creating a PivotTable; Adding/Removing a PivotTable Field; Show/Hide the PivotTable Builder; Refreshing a PivotTable; Rearranging a PivotTable; Changing the Summary Function; Changing How Values are Shown; Sorting in a PivotTable.

This guide is one of multiple titles available for Excel 2016 for Mac, other Excel titles are: Excel 2016 for Mac Introduction (ISBN 978-1939791597); Excel 2016 for Mac Functions & Formulas (ISBN 978-1939791641).
Country USA
Manufacturer Beezix Inc
Binding Pamphlet
ItemPartNumber 43178-106861
UnitCount 1
EANs 9781939791658
ReleaseDate 0000-00-00

Country	USA
Manufacturer	Beezix Inc
Binding	Pamphlet
ItemPartNumber	43178-106861
UnitCount	1
EANs	9781939791658
ReleaseDate	0000-00-00

Excel 2016 for Mac Charts, Sparklines, Tables & PivotTables Quick Reference Guide (Cheat Sheet of Instructions, Tips & Shortcuts - Laminated Card)

You might also like...