How to add multiple rows or columns into an Excel spreadsheet
Look up values in a table, using Excel’s VLOOKUP with the CONCATENATE function to combine values in multiple cells for the lookup. For example, convert a long format data table to a wide format data table.
How to return an array of non-adjacent cells in Excel.
How to use Excel’s Sparklines — mini column, line and win-loss charts. See how to create and customize sparklines to show data trends, and how to clear or delete sparklines from a worksheet.
To equalise column widths or row heights 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.
How to use Excel’s RANDBETWEEN function to generate random numbers between two values. A short video shows how to turn the values from dynamic to static.
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.
Add a reference line, such as an average or benchmark, to a VERTICAL bar chart in Excel.