Track your health and fitness goals in Excel - Microsoft Support
Just enter your age, height, weight, gender, activity level, and goal weight to calculate a daily calorie intake that's realistic and easy to achieve. > Calorie amortization schedule. Exercise planner. Plan your fitness training program and log your workouts with this accessible template.
Design the layout and format of a PivotTable - Microsoft Support
To change the layout of a PivotTable, you can change the PivotTable form and the way that fields, columns, rows, subtotals, empty cells and lines are displayed. To change the format of the PivotTable, you can apply a predefined style, banded rows, and conditional formatting.
Create a PivotTable to analyze worksheet data - Microsoft Support
How to use a PivotTable in Excel to calculate, summarize, and analyze your worksheet data to see hidden patterns and trends.
Count how often a value occurs - Microsoft Support
There are several ways to count how often a value occurs. Count how often a single value occurs by using the COUNTIF function. Count based on multiple criteria by using the COUNTIFS function. Count based on criteria by using the COUNT and IF functions together.
Tutorial: Import Data into Excel, and Create a Data Model
Let’s start by creating a blank worksheet, then import data from an Excel workbook. Insert a new Excel worksheet, and name it Sports. Browse to the folder that contains the downloaded sample data files, and open OlympicSports.xlsx. Select and copy the data in Sheet1.
Change the plotting order of categories, values, or data series
Reverse the plotting order of categories or values in a chart. On a chart, do one of the following: To change the plotting order of categories, click the horizontal (category) axis. To change the plotting order of values, click the vertical (value) axis.
COUNTIF function - Microsoft Support
Use COUNTIF, one of the statistical functions, to count the number of cells that meet a criterion; for example, to count the number of times a particular city appears in a customer list. In its simplest form, COUNTIF says: =COUNTIF (Where do you want to look?, What do you want to look for?) For example: =COUNTIF (A2:A5,"London") =COUNTIF (A2:A5,A4)
Insert subtotals in a list of data in a worksheet - Microsoft Support
You can insert one level of subtotals for a group of data as shown in the following example. To sort the column that contains the data you want to group by, select that column, and then on the Data tab, in the Sort & Filter group, click Sort A to Z Sort Z to A. box, click the column to subtotal.
SORTBY function - Microsoft Support
The SORTBY function sorts the contents of a range or array based on the values in a corresponding range or array. In this example, we're sorting a list of people's names by their age, in ascending order. =SORTBY (array, by_array1, [sort_order1], [by_array2, sort_order2],…)
Use conditional formatting to highlight information in Excel
Conditional formatting can help make patterns and trends in your data more apparent. To use it, you create rules that determine the format of cells based on their values, such as the following monthly temperature data with cell colors tied to cell values.
Sort data using a custom list - Microsoft Support
Create or delete a custom list for sorting and filling data. Sort a list by days of the week or months of the year or sort by priorities in Excel. Or you can create your own custom list for items that don't sort well alphabetically.