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