Excel 2013 – New feature: Apps for Office

Excel 2013 – New feature: Apps for Office Excel 2013 New Feature Apps for Office. We are all used to downloading apps for our smart phones and tablets, we can now download apps for our office applications too. Excel 2013 has this option in the INSERT tab. In order to...

Excel 2013 – The New Features at a glance

Excel 2013 – The New Features at a glance Excel 2013 The New Features at a Glance. When you open Excel 2013, straight away you will see the difference in the interface. Excel 2013 seems less colourful and flatter but when you look closer, you will see that it is...

5 Useful Functions in Excel

5 Useful Functions in Excel 5 Useful Functions in Excel. Let’s take a look at the following really useful functions that will help us every day in Excel. Functions that help with CASE This set of 3 functions are very handy to use when text has been imported into Excel...

Locking and Protecting Cells in Excel

Locking and Protecting Cells in Excel Locking and Protecting Cells in Excel. There are times when working in Excel that you want to protect an entire worksheet from someone making changes to it, without protecting the entire workbook. Excel allows you to protect a...

What you didn’t know about the Format Painter

What you didn’t know about the Format Painter What you didn’t know about the Format Painter. Format Painter is a great tool, it can be used in any of the Office Applications, it allows you to copy formatting from one area/object to another, but did you know that’s...

Conditional Formatting and Dropdown Menus

Conditional Formatting and Dropdown Menus How to create a menu of options that when selected will change the colour of the cell. For example, selecting Cancelled from a list should change the cell background colour to red to indicate clearly to the user that the...