CONCATENATE in Excel
To join text and/or numbers together using Excel’s CONCATENATE / CONCAT function. An example is shown how to generate a a set of SUM(CASE WHEN) SQL statements.
Excel Quick Help Videos
Insert MULTIPLE ROWS or COLUMNS in Excel
How to add multiple rows or columns into an Excel spreadsheet
VLOOKUP with CONCATENATE in Excel
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.
Excel’s CHOOSE function with array
How to return an array of non-adjacent cells in Excel.
Excel Sparklines — create, resize, customize, and clear
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.
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.
Generate RANDOM numbers with Excel’s RANDBETWEEN function
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.
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.