Formulas
Allows you to insert different formulas
What is Function Library?
used to compare values across various categories
What is Column Chart
Finds values quickly by going through your data
What is sort?
Gives your document an instant style with the right colors
What is Themes?
Combines and centers the data of the selected cells
What is Merge and Center?
Allows you to count the number of cells that have values greater than a certain number
What is COUNTIF?
Allows you to show cumulative effect of a series of positive and negative numbers
What is Waterfall Chart?
Get latest data of all sources in the workbook
What is Refresh All?
You can use a picture or colors to add to your document to give it some style
What is Background?
Easily spots trends and patterns in your data with bars and colors
Finds numbers
What is COUNT?
Compares parts to a whole
What is Hierarchy Chart?
What is Get Data?
Changes the spaces between things
What is Margins?
Changes the row height or column width, organizes sheets, or protect or hide cells
What is Format?
Locates text in a string
What is FIND?
Graphically summarize data and explore complicated data
What is PivotChart?
Allows you to split a single column of text into multiple columns
What is Text to Columns?
Chose rows or columns that you want repeated on every page
What is Print titles?
Automatically adds up your data
What is AutoSum?
This allows you to multiply ranges or arrays together and returns the sum of the products.
What is SUMPRODUCT?
Compares values and shows categories across geographical regions
What is Map Chart?
Allows you to try out various values for the formulas in your sheet using scenario Manger, Goal Seek and Data Tables
What is What-If Analysis?
Brings the selected object forward so that it's hidden behind fewer objects
Discovers more about your data
What is Ideas?