Insert
Helps filter PivotCharts
Slicer
Pathway to insert a page break
Page layout>Page setup> Break
Returns current date and time
=NOW()
How to show and remove filters
Filter button
How to check spelling
Proofing>Spelling
Used the chart to compare values across geographical regions
Map Chart
How to print a refence table
Print titles> Print
Creating a defined name
Defined name
Automatically fills in values
Flash fill
How to add a comment
Comments>New comment
Pathway to insert a text box
Insert>Text
Which group to hide headings
Sheet Options
Shows arrows that indicate which cells affect the value of the currently selected cell
Trace Precedent
Pathway for goal seek
Date>Forecast>What-if
Used to make provisions or give feedback
Track Change
Mini charts placed in single cells, each representing a row of data in your selection
Column Sparkline
How to change the background of the worksheet
Page Setup> Background
How to display the formula in each cell instead of the resulting value
Show formulas
Summarize data from separate ranges consolidating the results in a single output range
Consilidate
Sets up password protection on ranges
Allows users to edit ranges
Describing the object and its context to someone whos blind
Alt Text
Pathway to custom the header and footer
Page setup> Margins> Custom Margins>Header/Footer
Returns a vertical range of cells as a horizontal range
How to add subject to the constraints
Solver>add
How to allow users of this worksheet to see what you want them to see
Protect Sheet>Chose one