Using IF with AND, OR, and NOT functions in Excel
网页In Excel, the IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if that condition is True or False. =IF (Something is True, then do something, otherwise do something else)
Use conditional formatting to highlight information in Excel
网页Use a percentile when you want to visualize a group of high values (such as the top 20th percentile) using a particular icon and low values (such as the bottom 20th percentile) using another icon, because they represent extreme values …
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: The Lookup Wizard feature is no longer available in Excel. Here's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE)
Track your health and fitness goals in Excel - Microsoft Support
网页Easily calculate fat % of your meals. Log the foods you eat each day, along with their calories and fat grams, and this accessible template will calculate the percentage of fat in your diet to help you make optimal nutritional choices. > Daily food calorie and fat log
Create a drop-down list - Microsoft Support
网页You can help people work more efficiently in worksheets by using drop-down lists in cells. Drop-downs allow people to pick an item from a list that you create. Windows macOS Web. In a new worksheet, type the entries you want to appear in your drop-down list.
Repeat specific rows or columns on every printed page
网页In the Columns to repeat at left box, enter the reference of the columns that contain the row labels. For example, if you want to print column labels at the top of every printed page, you could type $1:$1 in the Rows to repeat at top box.
Overview of formulas in Excel - Microsoft Support
网页If you’re new to Excel, or even if you have some experience with it, you can walk through Excel’s most common formulas in this tour. With real-world examples and helpful visuals, you’ll be able to Sum, Count, Average, and Vlookup like a pro.
Ways to format a worksheet - Microsoft Support
网页In Excel, there are many ways to formatt a worksheet, such as applying themes, styles, borders and colors, to name a few.
Analyze Data in Excel - Microsoft Support
网页Analyze Data in Excel empowers you to understand your data through natural language queries that allow you to ask questions about your data without having to write complicated formulas. In addition, Analyze Data provides high-level visual summaries, trends, and …
Basic tasks in Excel - Microsoft Support
网页Excel is an incredibly powerful tool for getting meaning out of vast amounts of data. But it also works really well for simple calculations and tracking almost any kind of information. The key for unlocking all that potential is the grid of …
Reduce the file size of your Excel spreadsheets - Microsoft Support
网页Reduce the file size of your Excel spreadsheets. Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016. If the file size of your spreadsheet is too large, try the following tips to make it more manageable. Newer versions Office 2016.