How to use Excel’s TIME function to add time to time, with a worked example to create a series of appointments.
It can be useful to inspect a cell’s formula visually without having to click in it to display the formula in the formula bar. Excel’s FORMULATEXT function enables you to see the formula in another cell.
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.
How to remove blank cells from a set of data so that a plotted line is continuous. Example shows blank cells being replaced by ‘N/A’ values using an IF statement.
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.