Change the display of a 3-D chart - Microsoft Support
You can change the plotting order of data series so that large 3-D data markers do not block smaller ones. On a chart, click the depth axis, or select Depth axis from the Chart elements list under Current Selection on the Format tab.
Change how rows and columns of data are plotted in a chart
When you create a chart, Microsoft Office Excel determines the axis on which the data series are plotted, based on the number of worksheet rows and columns that are included in the chart, placing the larger number on the horizontal axis.
Turn off Scroll Lock - Microsoft Support
Here's how to turn off Scroll Lock.
Change the shape fill, outline, or effects of chart elements
You can instantly change the look of chart elements (such as the chart area, the plot area, data markers, titles in charts, gridlines, axes, tick marks, trendlines, error bars, or the walls and floor in 3-D charts) by applying a predefined shape style.
Subtotal and total fields in a PivotTable - Microsoft Support
In a PivotTable, select an item of a row or column field. Make sure it is a field and not a value. If a field contains a calculated item, you can't change the subtotal summary function.
Change the display of chart axes - Microsoft Support
For most chart types, you can display or hide chart axes. To make chart data easier to understand, you can also change the way they look. Important: This article does NOT cover changing the scale of chart axes. For information about how to change to the scale, see:
Available chart types in Office - Microsoft Support
When you create a chart in an Excel worksheet, a Word document, or a PowerPoint presentation, you have a lot of options. Whether you’ll use a chart that’s recommended for your data, one that you’ll pick from the list of all charts, or one from our selection of chart templates, it might help to know a little more about each type of chart.
Video: Draw shapes - Microsoft Support
Watch this online video tutorial to learn how.
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.
Freeze panes to lock rows and columns - Microsoft Support
How to freeze panes in Excel to keep rows or columns in your worksheet visible while you scroll, or lock them in place to create multiple worksheet areas.
Count unique values among duplicates - Microsoft Support
You can use the Advanced Filter dialog box to extract the unique values from a column of data and paste them to a new location. Then you can use the ROWS function to count the number of items in the new range. Select the range of cells, or make sure the active cell is in a table.