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.
Using structured references with Excel tables - Microsoft Support
Excel automatically creates a calculated column and copies the formula down the entire column for you, adjusting it for each row. What happens when I use explicit cell references? If you enter explicit cell references in a calculated column, it can be harder to see what the formula is calculating. In the formula bar, enter =C2*D2 and press Enter.
Use slicers to filter data - Microsoft Support
You can use a slicer to filter data in a table or PivotTable with ease. A slicer will be created for every field that you selected. Clicking any of the slicer buttons will automatically apply that filter to the linked table or PivotTable. Select and hold the corner of a slicer to adjust and resize it.
Create a 3-D reference to the same cell range on multiple …
You can use a 3-D reference to add up budget allocations between three departments, Sales, HR, and Marketing, each on a different worksheet, by using the following 3-D reference: =SUM (Sales:Marketing!B3) You can even add another worksheet, and then move it into the range that your formula refers to.
Create a reference to the same cell range on multiple worksheets
Each of these examples use the formula =SUM (Sheet2:Sheet6!A2:A5) to add cells A2 through A5 on worksheets 2 through 6: Insert or copy If you insert or copy worksheets between Sheet2 and Sheet6 (the endpoints in this example), Excel includes all values in cells A2 through A5 in the constituent worksheets in the calculations.
Video: Resize table rows and columns - Microsoft Support
Adjust row and column size in tables when you need to fit text, make all rows or columns a uniform size, or simply make the table look how you want. To change the width, do one of the following: Select the boundary of the column or row you want to move and drag it to the width or height you want.
INDIRECT function - Microsoft Support
How to use the INDIRECT function in Excel to change the reference to a cell within a formula without changing the formula itself.
Define and solve a problem by using Solver - Microsoft Support
Solver is a Microsoft Excel add-in program you can use for what-if analysis. Use Solver to find an optimal (maximum or minimum) value for a formula in one cell — called the objective cell — subject to constraints, or limits, on the values of other formula cells on a worksheet.
OFFSET function - Microsoft Support
This article describes the formula syntax and usage of the OFFSET function in Microsoft Excel. Returns a reference to a range that is a specified number of rows and columns from a cell or range of cells. The reference that is returned can be a single cell or a range of cells.
Use the Selection pane to manage objects in documents
You can use the Selection pane to manage objects in your document: re-order them, show or hide them, and group or ungroup them. Tip: In Word, you might want to set the location of objects within a paragraph. When you move a paragraph, the corresponding anchored image (s) move with the paragraph.
Insert, move, or delete page breaks in a worksheet
Microsoft Excel inserts automatic page breaks based on the paper size, margin settings, scale options, and the positions of any manual page breaks that you insert. To print a worksheet with the exact number of pages that you want, you can adjust the …