Track your health and fitness goals in Excel - Microsoft Support
Let's plan, organize, and track your health and fitness goals with Excel nutrition trackers, exercise plans, meal planners, and other useful content.
Apply sensitivity labels to your files and email - Microsoft Support
You can apply sensitivity labels to your files and emails to keep them compliant with your organization's information protection policies.
Use Slicers to filter data - Microsoft Support
Training: When working with large amounts of data in Microsoft Excel, you can use slicers in your table to filter and view your data. Watch this online video to learn how.
Look up values with VLOOKUP, INDEX, or MATCH - Microsoft …
Here's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE) In this example, B2 is the first argument —an element of data that the function needs to work. For VLOOKUP, this first argument is the value that you want to find. This argument can be a cell reference, or a fixed value such as "smith" or 21,000.
Apply shading to alternate rows or columns in a worksheet
One way to apply shading to alternate rows or columns in your worksheet is by creating a conditional formatting rule. This rule uses a formula to determine whether a row is even or odd numbered, and then applies the shading accordingly. The formula is shown here:
Guidelines for organizing and formatting data on a worksheet
Microsoft Office Excel has a number of features that make it easy to manage and analyze data. To take full advantage of these features, it is important that you organize and format data in a worksheet according to the following guidelines.
Using wildcard characters in searches - Microsoft Support
Use wildcard characters as comparison criteria for text filters, and when you're searching and replacing content. This feature enables you to find values that share a simple pattern. These characters can be the asterisk (*), the question mark (?), and the tilde (~).
Import data from data sources (Power Query) - Microsoft Support
Use Power Query in Excel to import data into Excel from a wide variety of popular data sources, including CSV, XML, JSON, PDF, SharePoint, SQL, and more.
Identify insights with Copilot in Excel - Microsoft Support
Copilot can show insights based on your data or a specific question you ask about your data. Select the Copilot button in the ribbon. Select Understand. Copilot analyzes your data to show …
Frequently asked questions about Copilot in Excel - Microsoft …
Copilot in Excel works for Excel tables of up to two million cells. Some skills like formula column suggestions, highlight, sort, and filter do not have a limit on the amount of data you can interact with. However, it can take a long time, even 30 seconds or more, to get a response from Copilot when interacting with large tables.
Manage your household budget in Excel - Microsoft Support
Using a budgeting spreadsheet can help make your financial health a priority by keeping spending in check and savings on the rise! DIY with the Personal budget template. Prefer to do things yourself? This Excel template can help you track your monthly budget by income and expenses.