Look up values with VLOOKUP, INDEX, or MATCH - Microsoft …
It's actually quite easy to do with a lookup function. The VLOOKUP and HLOOKUP functions, together with INDEX and MATCH, are some of the most useful functions in Excel. Note: …
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 unique values among duplicates - Microsoft Support
Count the number of unique values by using a filter. You can use the Advanced Filter dialog box to extract the unique values from a column of data and paste them to a new location. Then you …
Create and share a Dashboard with Excel and Microsoft Groups
A dashboard is a visual representation of key metrics that allow you to quickly view and analyze your data in one place. Dashboards not only provide consolidated data views, but a self …
View or change the properties for an Office file - Microsoft Support
Custom properties are properties that you define for an Microsoft 365 document. You can assign a text, time, or numeric value to custom properties, and you can also assign them the values …
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 …
Insert images, icons, and more in Microsoft 365
Try it. On the Insert tab, select Pictures and then Stock Images. Select one or more items from Images, Icons, Cutout People, Stickers, Videos (PPT only), Illustrations or Cartoon People. …
CONVERT function - Microsoft Support
Converts a number from one measurement system to another. For example, CONVERT can translate a table of distances in miles to a table of distances in kilometers. Syntax. CONVERT …
Use Excel as your calculator - Microsoft Support
Instead of using a calculator, use Microsoft Excel to do the math! You can enter simple formulas to add, divide, multiply, and subtract two or more numeric values. Or use the AutoSum feature …
Work with links in Excel - Microsoft Support
Insert a hyperlink in a worksheet cell or specific chart element to link to a related file or Web page in Excel. You can also modify or remove hyperlinks.
Apply or remove cell shading - Microsoft Support
Apply or remove cell shading. Applies To. You can add shading to cells by filling them with solid colors or specific patterns. If you have trouble printing the cell shading that you applied in …