Keyboard shortcuts in Microsoft 365
网页Here you'll find links to most keyboard shortcut articles for Microsoft 365 apps. Windows macOS Office for iOS Office for Android Web. Keyboard shortcuts for Outlook. Keyboard shortcuts in Word. Keyboard shortcuts in Excel. Use keyboard shortcuts to create PowerPoint presentations.
Find what you need with search in Microsoft 365 apps
网页At the top of your Microsoft 365 apps on Windows you'll find the new Microsoft Search box. This powerful tool helps you quickly find what you're looking for, from text to commands to help and more. Let's take a look at what it can do for you.
Manage workbook links - Microsoft Support
网页In the Excel web app, you can manage workbook links to ensure that your data is up to date and accurate. This article explains how to manage workbook links, including how to refresh and update them, how to fix broken links, and how to …
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)
Using wildcard characters in searches - Microsoft Support
网页Use wildcard characters as comparison criteria for text filters and when you're searching and replacing content. These can also be used in the Conditional Formatting rules that use the "Format cells that contain specific text" criteria.
Add a conditional column (Power Query) - Microsoft Support
网页With Power Query, you can add a conditional column to your query. You can define IF-THEN-ELSE conditions in your query. When the conditions are fulfilled, the conditional column will automatically display the values that you specified.
Excel functions (by category) - Microsoft Support
网页Worksheet functions are categorized by their functionality. Click a category to browse its functions. Or press Ctrl+F to find a function by typing the first few letters or a descriptive word. To get detailed information about a function, click its name in the first column.
Use the SUM function to sum numbers in a range
网页You can use a simple formula to sum numbers in a range (a group of cells), but the SUM function is easier to use when you’re working with more than a few numbers. For example =SUM (A2:A6) is less likely to have typing errors than =A2+A3+A4+A5+A6.
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 …
COUNTIFS function - Microsoft Support
网页The COUNTIFS function syntax has the following arguments: criteria_range1 Required. The first range in which to evaluate the associated criteria. criteria1 Required. The criteria in the form of a number, expression, cell reference, or text that define which cells will be counted.
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.