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
How to add a data label to just one data point on a chart 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
How to use Excel’s group and summarize data functions.
How to create a chart with multi-level categories and sub-categories.
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.
How to add multiple rows or columns into an Excel spreadsheet
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 return an array of non-adjacent cells in Excel.