Nested IFs in Excel
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.
Excel Intermediate
How to add custom ERROR BARS in Excel charts
How to calculate and plot custom error or confidence interval data on an Excel chart.
Create a DROPDOWN LIST in Excel
Create a list of items which can be selected from a dropdown selector in a cell in Excel, using data validation
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.
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 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.
Calculate a RUNNING TOTAL in Excel
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 using Excel’s ADVANCED FILTER
Remove blank cells in a list of values in Excel using Advanced Filter, retaining the original list.