Add, move, group, copy, hide and protect Excel worksheets
How to add, move, group and copy worksheets within and between Excel workbooks, and how to navigate between sheets in large multi-worksheet file, and how to hide and unhide worksheets.
Excel Quick Help Videos
Add a DATA LABEL to ONE POINT on a chart in Excel
How to add a data label to just one data point on a chart in Excel.
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
GROUP and SUBTOTAL data in Excel
How to use Excel’s group and summarize data functions.
Create a MULTI-LEVEL CATEGORY chart in Excel
How to create a chart with multi-level categories and sub-categories.
Excel’s CONCATENATE / CONCAT function — create a SUM(CASE WHEN) SQL statement
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.
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.