Analysis
Goal Seek
Goal Seek helps you calculate input value required to reach the result. For example, you can estimate how many products must be sold to reach a revenue goal of $2 million. Here's how you use Goal Seek to devise estimates: Go to Data > Goal Seek. In ...
Create pivot tables to analyze your data
How to create a pivot table To create a pivot table: Go to Insert > Pivot Table . Select the source range for the pivot table and where the table must be created. Drag and drop the required fields into the rows, columns and data sections of the pivot ...
Filter a set of data
How to filter data To filter any set of data: Select the range of cells you want to filter data from. Click Home > Filter Tap the drop-down inside the column header and select values or criteria you want to filter by. Only one filter can be applied ...
Sort
How to sort data To sort data: Select the range of cells to be sorted. In the Data menu, select to sort in the Ascending and to sort Descending. To set your conditions for sorting select Custom Sort. Alternatively, you can select under the Home menu ...
Apply conditional formatting to your cells
What is conditional formatting Conditional formatting highlights cells based on the rules you set up, helping you spot trends and analyze them effortlessly. Classic Color scales Icon sets Data bars How to apply classic conditional formats To apply ...