M365 Excel

Use slicers to filter data
Slicers provide buttons that you can click to filter tables. In addition to quick filtering, slicers also indicate the current filtering state, which make...
Tue, Sep 9, 2025 9:55 AM
Create a chart from start to finish
Charts help you visualize your data in a way that creates maximum impact on your audience. Learn to create a chart and add a trendline. Create a char...
Wed, Sep 10, 2025 5:34 AM
Add or remove titles in a chart
To make a chart easier to understand, you can add chart title. Add a chart title In the chart, select the "Chart Title" box and type in ...
Wed, Sep 10, 2025 9:16 AM
Show or hide a chart legend or data table
You can show or hide the legend of a chart. Showing a legend can give readers more information about the chart, while hiding a legend can give your chart a ...
Wed, Sep 10, 2025 9:26 AM
Add a secondary axis in a chart in Excel
When the numbers in a chart vary widely from data series to data series, or when you have mixed types of data (price and volume), plot one or more data seri...
Wed, Sep 10, 2025 9:31 AM
Add a trend or moving average line to a chart
Add a trendline to your chart to show visual data trends. Select a chart. Chart Select the + to the top right of the chart. Select + ...
Wed, Sep 10, 2025 9:40 AM
Analyze your data instantly
It is essential to quickly make accurate data analysis for business decisions when dealing with change. You need effective data analysis tools to understand...
Thu, Sep 11, 2025 10:04 AM
Update the data in an existing chart
You can update the data in an existing chart by making changes to the data source. Changes you make will instantly show up in the chart. You can also chang...
Thu, Sep 11, 2025 10:12 AM
Use sparklines to show data trends
A sparkline is a tiny chart in a worksheet cell that provides a visual representation of data. Use sparklines to show trends in a series of values, such as ...
Thu, Sep 11, 2025 10:45 AM
Use the Field List to arrange fields in a PivotTable
After you create a PivotTable, you'll see the Field List. You can change the design of the PivotTable by adding and arranging its fields. Use the ...
Thu, Sep 11, 2025 10:48 AM