How to write an IF statement in Excel, and nest IF statements to test for multiple conditions. Key tips and rules about IFs and nested IFs in Excel.
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.