Excel help & learning - support.microsoft.com
网页Find Microsoft Excel help and learning resources. Explore how-to articles, guides, training videos, and tips to efficiently use Excel.
Calculation operators and precedence in Excel - Microsoft Support
网页Operators specify the type of calculation that you want to perform on elements in a formula—such as addition, subtraction, multiplication, or division. There are four different types of calculation operators: arithmetic, comparison, text concatenation, and reference.
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)
Basic tasks in Excel - Microsoft Support
网页Get started with basic tasks in Excel such as opening a workbook, entering and formatting data, calculating data, and trying some quick analysis features..
Download and install or reinstall Microsoft 365 or Office 2021 …
网页Ready to install? Before you begin, make sure your PC or Mac meets the system requirements. If you already redeemed a product key, you're simply reinstalling the apps, or you know you have an assigned license through work or school, you can skip ahead and go to the section sign in to download and install Microsoft 365 or Office.
What's new in Excel 2021 for Windows - Microsoft Support
网页Excel 2021 for Windows allows you to collaboratively work with others and analyze data easily with new Excel capabilities including co-authoring, Dynamic Arrays, XLOOKUP, and LET functions. Note: Some features listed below are not included in Excel LTSC 2021 for commercial customers.
Free Excel for the web templates - Microsoft Support
网页Use create.microsoft.com to find and download free Excel for the web templates. Download free Excel templates for calendars, invoices, budgeting, and more.
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.
Create a workbook in Excel for the web - Microsoft Support
网页Create a workbook in Excel for the web. With Excel for the web running in your web browser, you can: Share your workbook with others and collaborate on the same file at the same time. Add tables and charts to make your data visual. Create a survey. Filter a table. Use AutoSum to quickly add totals. Notes:
Work in Excel for the web - Microsoft Support
网页Everything you do in Excel for the web — naming a file, entering data — is automatically saved to your OneDrive. Do your work. After you name your file, you can enter data and create tables, charts, and formulas. Select the tabs at the top to find the features you want.
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.