How to Concatenate a Range (without using VBA)

This week I received an email from someone who had 258 cells containing strings that they wanted to combine into a single cell. Rather than using VBA, I worked out another way to do it. This video shows you how. Note that the CONCATENATE function has a limit of 255...

Excel 2013: How to Record a Macro

Macros are used to save you time by automating tasks. Any task can be automated using a macro. For example, I have a friend who works for a small company. He often has to print Excel reports using different paper sizes – A4 and Letter. Although it’s easy...

Excel 2013: How To Use Conditional Formatting

Conditional Formatting enables you to apply formatting to a cell (for example, background colour, font, text colour, bold, etc) if a condition or set of conditions are true. For example, “apply a red background to A1 if it contains the word COMPLETE and a green...

Convert a PDF to Excel

All recent versions of Excel have the ability to create a PDF of your spreadsheet without requiring 3rd Party tools. In this short video tutorial, in addition to demonstrating how to do this, I also show how to convert a PDF into an editable Excel file using a free...

Customising The Ribbon in Excel (Windows)

The Ribbon is the strip of buttons and icons that appears at the top of the screen in Excel 2007 and above. It replaces the toolbars and menus found in earlier versions. In Excel 2010 and above you can edit The Ribbon – adding your own buttons, removing ones...

Customising The Ribbon in Excel (Mac)

The Ribbon is the strip of buttons and icons that appears at the top of the screen in Excel 2011 and 2016 for the Mac. You can edit The Ribbon – adding your own buttons, removing ones that you personally don’t find useful and rearranging the layout to make...