Change the scale of the vertical (value) axis in a chart
By default, Excel determines the minimum and maximum scale values of the vertical (value) axis, also known as the y axis, when you create a chart. However, you can customize the scale to …
Change the scale of the horizontal (category) axis in a chart
To change the axis type to a text or date axis, expand Axis Options, and then under Axis Type, select Text axis or Date axis. Text and data points are evenly spaced on a text axis.
Use Excel as your calculator - Microsoft Support
Instead of using a calculator, use Microsoft Excel to do the math! You can enter simple formulas to add, divide, multiply, and subtract two or more numeric values. Or use the AutoSum feature …
AVERAGEIFS function - Microsoft Support
Returns the average (arithmetic mean) of all cells that meet multiple criteria. AVERAGEIFS (average_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...) The AVERAGEIFS …
Total the data in an Excel table - Microsoft Support
You can quickly total data in an Excel table by enabling the Total Row option, and then use one of several functions that are provided in a drop-down list for each table column. The Total Row …
Count numbers greater than or less than a number
Use COUNTIF to count the number of cells that meet a specific criteria. For example, you are preparing a report and want to count how many sales invoices were greater or lesser than a …
View previous versions of Office files - Microsoft Support
Restore a previous version of an item or file in SharePoint. Enable and configure versioning for a list or library. Use Version History to view previous versions of files stored in OneDrive or …
Change the color of a picture - Microsoft Support
You can adjust the color intensity (saturation) and color tone (temperature) of a picture or recolor it. You can apply multiple color effects to your picture. Click the picture that you want to …
Troubleshoot printing problems in Microsoft 365 apps
This article provides steps to diagnose and resolve issues that occur when you cannot print in a Microsoft 365 app, such as Excel, or Word on a PC or Mac. Try the following options to help …