Create a DROPDOWN LIST in Excel
Create a list of items which can be selected from a dropdown selector in a cell in Excel, using data validation
Excel General Tips
GROUP and SUBTOTAL data in Excel
How to use Excel’s group and summarize data functions.
Create a MULTI-LEVEL CATEGORY chart in Excel
How to create a chart with multi-level categories and sub-categories.
Insert MULTIPLE ROWS or COLUMNS in Excel
How to add multiple rows or columns into an Excel spreadsheet
Make columns the same width in Excel
How to make all columns the same width in excel, by selecting a range of columns/rows, and dragging a column/row divider.
CONDITIONAL FORMATTING of non-adjacent cells in Excel
To apply conditional formatting in Excel to non-adjacent, non-sequential cells.
PASTE SPECIAL with formulas
Add, subtract, multiply or divide a set of values by another value, using ‘Paste Special’.
Add a REFERENCE LINE to a HORIZONTAL BAR chart in Excel
To add a reference line such as an average or benchmark to a horizontal bar chart. step by step guide with videos and screenshots.
Add a REFERENCE LINE to a VERTICAL BAR chart in Excel
Add a reference line, such as an average or benchmark, to a VERTICAL bar chart in Excel.
CELL references and ranges in Excel
Absolute and relative cell references, and ranges in Excel