#N/A instead of content

#N/A Instead of Content This quick video explains how to Remove this very common Error in Excel. The #N/A error – is very common errors to appear in a spreadsheet. Learn what causes them and how to remove them from your worksheets [et_social_follow icon_style="slide"...

#NULL!, #REF!, #NAME?, #VALUE! Errors

#NULL!, #REF!, #NAME?, #VALUE! Errors This quick video explains how to correct the other Error Values that may appear in your cell. The #NULL!, #REF!, #NAME?, #VALUE! are very common errors to appear in a spreadsheet. Learn what causes them and how to remove them from...

Adding text to a number format

Adding Text to a Number Format This quick video explains how to add Text to a Number Format in Excel. Sometimes it is useful to be able to create a custom number format that displays units in the same cells as the number – e.g. 100Kgs, 100 units and ask Excel to treat...

Arranging Workbooks

Switch and Arrange Workbooks This quick video explains how to Switch and Arrange your Workbooks in Excel. Switching and Arranging workbooks allows us to work with multiple worksheets and workbooks at the same time. This is useful when comparing values on different...

Freeze panes

How to Freeze Panes in Excel This quick video will show you how you can Freeze a Row or a Column. As you scroll through your spreadsheet is often hard to know which row or column you are looking at. Freezing a row or column or both is a useful way to keep them...

Drop down lists

Drop Down Lists This quick video explains how to create a Drop Down List in Excel. Drop down lists are a useful way of presenting the user with a finite list of options. Learn how to create them Data Validation [et_social_follow icon_style="slide"...