SheetWorkflow Guide 
Make PivotTable Filters Visible with Slicers
Slicers provide clickable controls for filtering an Excel PivotTable.
Add Only the Chart Titles Supported by the Visual
Chart titles and axis titles give Excel readers different kinds of context.
Add a Trendline That Matches the Chart's Purpose
Excel can add a trendline or moving average to an appropriate chart series.
Preserve Linked Excel Chart Titles by Editing Their Source Cells
A chart title or data label can be linked to a worksheet cell.
Use a Trendline to Show a Chart's Overall Pattern
An Excel trendline represents the general direction of data rather than connecting every actual observation.
Choose Clearer Content and Formatting for Chart Labels
Excel's Format Data Labels pane controls which information appears beside chart values, including category names, series names and percentages where supported.
Learn Relational Reporting from Excel's Legacy Model Tutorial
Microsoft's Excel 2016 tutorial introduces importing data and building a Data Model through an Olympics example.
Create Sparklines in Excel for Mac Without Range Errors
Excel for Mac creates sparklines from a selected data range and an output location.
Keep the Current Excel Filter Selection Visible On Screen
The source describes a slicer as a visible way to filter a table, using a country field as an example.
Ask Excel to Summarize a Selected Data Range
Analyze Data in Excel can produce visual summaries and suggested insights from a selected range.
Set Data and Destination Ranges for Excel Sparklines
Creating a sparkline requires both the source data range and the worksheet location where the small chart should appear.
Preview Report Options with Excel Quick Analysis
Excel's Quick Analysis tool appears beside a selected range and offers access to tables, charts, sparklines, and other analysis options.
Make Excel Charts Readable in Black and White
Excel chart patterns can help distinguish data series when color printing is unavailable.
Treat Excel Chart Creation as a Report-Building Sequence
Microsoft describes chart creation as a sequence that starts with suitable data, chooses a chart, and then refines the details.
Align Excel Report Objects with Snap Settings
Excel provides snap options for arranging shapes and other objects in a worksheet report.
Choose an Excel Graph That Fits the Data Relationship
Excel charts can represent numeric information through bars, columns, lines, slices, and other visual forms.
Understand the Assumptions Behind a Bell Curve Example
Microsoft's bell curve guide builds a demonstration with sample values, a mean and a standard deviation.
Move Chart Labels Away from Crowded Data
Excel lets you reposition data labels through preset locations or by dragging them.
Extend a Numeric Series with Linear or Growth Steps
Excel can continue a numerical series using either a repeated addition or a repeated multiplication.
Connect an Excel Chart Title to a Worksheet Cell
A chart title, label or text box can display the contents of a worksheet cell through a reference.
