How to calculate and plot custom error or confidence interval data on an Excel chart.
Create a list of items which can be selected from a dropdown selector in a cell in Excel, using data validation
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.
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 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.
Sum the current value and all those that precede it in a column. This topic also shows how to fill cells down a column.
Remove blank cells in a list of values in Excel using Advanced Filter, retaining the original list.