Use the Field List to arrange fields in a PivotTable
网页Rearrange fields in your PivotTable (pivot table) by using the Field List, and show the Field List again when it disappears.
Group or ungroup data in a PivotTable - Microsoft Support
网页Create a PivotTable to analyze worksheet data. In Excel, show items or values in logical groups like months or quarters for ease of summarizing and performing data analysis.
Expand, collapse, or show details in a PivotTable or PivotChart
网页In a PivotTable or PivotChart, you can expand or collapse to any level of data detail, and even for all levels of detail in one operation. On Windows and the Mac, you can also expand or collapse to a level of detail beyond the next level.
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.
Excel video training - Microsoft Support
网页Make your first PivotTable. Download template > Get more out of PivotTables. Download template > Other training. Templates. A list of Excel training, from entry level to advanced …
Manage your household budget in Excel - Microsoft Support
网页This Excel template can help you track your monthly budget by income and expenses. Input your costs and income, and any difference is calculated automatically so you can avoid shortfalls or make plans for any projected surpluses. Compare projected costs with actual costs to hone your budgeting skills over time. > Get this personal budget template.
Convert an Excel table to a range of data - Microsoft Support
网页To convert a table into a range, right-click anywhere in a table, point to Table, and then click Convert to Range.
How to correct a #DIV/0! error - Microsoft Support
网页The simplest way to suppress the #DIV/0! error is to use the IF function to evaluate the existence of the denominator. If it’s a 0 or no value, then show a 0 or no value as the formula result instead of the #DIV/0! error value, otherwise calculate the formula.
Digital signatures and certificates - Microsoft Support
网页A digital signature is an electronic, encrypted, stamp of authentication on digital information such as email messages, macros, or electronic documents. A signature confirms that the information originated from the signer and has not been altered. The following is an example of a signature line. Top of Page.
Crop a picture to fit in a shape - Microsoft Support
网页With Microsoft PowerPoint, Word, Outlook, or Excel, you can easily change the outline of a photo by turning it into a shape like a circle or a rounded rectangle. The Crop to Shape feature provides options for cropping an image to a specific shape or starting with a shape and then inserting an image within it. Windows macOS Web.
Create a PivotChart - Microsoft Support
网页Create a PivotChart based on complex data that has text entries and values, or existing PivotTable data, and learn how Excel can recommend a PivotChart for your data.