Data entry form in Excel
How to create and use a data entry form in Excel
Excel Quick Help Videos
Customize the ribbon in Excel
How to customize the ribbon in Excel – add commands, create a new tab and group of commands in the ribbon
Get started with Power Query – connect to data and add an Index
Short videos and step by step guide on how to get started with Power Query – connect to data and add an Index column.
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.
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.