# Excel Tutorials

A collection of written and video based Excel tutorials## Excel’s 10,000 Hour Limitation

I was recently asked why a time value divided by a number generated a #VALUE! error. The reason was because the time value was over 10,000 hours. This tutorial shows a workaround.

read more## The New TEXTJOIN Function (Excel 2016)

In Excel 2016 for Windows, the new TEXTJOIN function allows you to combine the values from a range of cells.

read more## VMWare, PowerMap and DirectX

When I tried to run PowerMap on Excel 2016 for Windows, running in a VM on my iMac, up popped a message telling me that my video driver may not support DirectX. Here’s how I fixed it

read more## How to Display Exponential Numbers as Numbers

Excel displays numbers containing more than 11 digits in “exponential format” (e.g. 8.2978E+11). This tutorial shows how to display the numbers as proper numbers (e.g. 829780189348)

read more## Combining Vlookup and Match Functions

In this video I explain one of the short-comings of the VLOOKUP function and how to get around the problem using the MATCH function

read more## Adding Up Times in Excel Results in Zero

In this tutorial I explain why adding up a column of time values results in a 0 and how to fix the problem.

read more## How to Add a Line Break to a Formula

This short tutorial explains how to add a line break to a formula – with the added twist that the file containing the formula will be used on both Windows and Mac. Sounds simple – and it is – but with a small gotcha!

read more## How to Sum a Variable Number of Table Rows

What’s the best way to add up a column of figures when the number of rows in the column changes regularly? This tutorial answers the question.

read more## Convert Time into Minutes

In this tutorial, based on a real-life situation, you’ll learn how to convert a time that is representing a duration (e.g. 02:00:00) into minutes (120) and then calculate the number of 15 minute intervals in that duration.

read more