1
Allows you to make logical comparisons between a value and what you expect
IF
The process of tracking erros and checking worksheet logic
Formula Auditing
Used to show the general pattern of data over time
Trendlines
a quick way to increase table readability and usability
Table styles
You can plot geographic and temporal data on a 3d globe or custom map
3d Maps
To determine if all conditions in a test are TRUE
AND
Allows you to identify upon which cell a particular formula
Trace Precedents
Powerful tool to calculate summarize and analyze data patterns and trends in your data
PivotTable
steps to remove Duplicates
Table Tools design tab > Tools Group
you impact or connect to external data and then clean that data
Power Query
Returns the serial number of the current data
TODAY
Improves the accuracy of your worksheet by controlling the type of data users can manually enter
Data Validation
is used to analyze data details on different levels
Drilling
Steps to Name a Table
Table Tools Design tab > Properties group
An excel add - in you can use to perform powerful data analysis and create sophisticated data modeles
PowerPivot
Returns the position of a cell in a row or column
MATCH
Formula for the Trace Precedents
Lets you perform a calculation on fields already in the pivotTable
Calculated Field
A table that stores the data you want to retrieve
Lookup Table
Located in the developer tab used when you want to easily reference and interact
Form Controls
To sum the values in a range that meet criteria that you specify
SUMIF
Find the optimal value for a specified cell based on one or more variables and it also allows you to put limits on the solution it finds
Solve
Provide buttons that you can click to filter
Slicers
Is the answer you want to appear as a result
Return Value
Returns visible data from a PivotTable
Get pivotData