Create a list of items which can be selected from a dropdown selector in a cell in Excel, using data validation
Excel General Tips
How to use Excel’s group and summarize data functions.
How to create a chart with multi-level categories and sub-categories.
How to add multiple rows or columns into an Excel spreadsheet
How to make all columns the same width in excel, by selecting a range of columns/rows, and dragging a column/row divider.
To apply conditional formatting in Excel to non-adjacent, non-sequential cells.
Add, subtract, multiply or divide a set of values by another value, using ‘Paste Special’.
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, such as an average or benchmark, to a VERTICAL bar chart in Excel.
Absolute and relative cell references, and ranges in Excel