1

1

1

1

1

1

1

1

Manipulating imported .CSV data files in Excel

Let’s look at a scenario where data is given to you in .CSV format or already has been imported into Excel for you. It may be the case that you have a list of ID numbers, when they are pasted or imported into READ MORE

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 and it has READ MORE

Locking and Protecting Cells in Excel

Locking down all Cells: 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 particular sheet. To simply protect the sheet READ MORE

How to find the minimum value in a range while ignoring the 0 value

In this example we cannot use the function Min (Minimum), because it will only find the smallest value in a range of cells. However the Small Function allows you to choose the Smallest and also the second smallest, third smallest and so on. READ MORE

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 only half of what it’s capable of? What if you need READ MORE

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 project or course READ MORE

Excel VBA Common Question: What is ‘Option Explicit’ for?

From time to time I thought I would post answers to the most common questions I get asked during the classroom based courses that we run. We will also do this for the online Excel courses and also feel free to ask questions READ MORE

Creating a form for data entry

Have you ever created a Workbook in Excel as part of a business process and defined how you wanted people to enter the data just to find that they disregard your method and just put the information anywhere. This can be frustrating but READ MORE

Next 1 2