Excel Organise, Analyse Data

Discover posts that cover the Excel features that save you time.

Perfect if you spend hours formatting and updating data in worksheets.

If you use Excel often but find you seem to be spending way too much time getting the results you require, this category is a good place to hang out.

Excel Organise, Analyse Data

Find and break links in Excel

Linking from one worksheet to another is a fantastic way to connect data from one source to another, and a great way…

Read More Find and break links in Excel
Excel Organise, Analyse Data

Excel Count cells with Text (3 easy functions + 9 valuable formula examples)

Are you trying to count cells with text in Excel? Are you wondering why the COUNT function in Excel returns a result…

Read More Excel Count cells with Text (3 easy functions + 9 valuable formula examples)
Excel Organise, Analyse Data

Average formula in Excel – AVERAGE, AVERAGEIF, AVERAGEIFS function

There are many areas within business reporting where we are looking for the average of a selection of results. A good example…

Read More Average formula in Excel – AVERAGE, AVERAGEIF, AVERAGEIFS function
Excel Organise, Analyse Data

How to Freeze rows in Excel

Would you like to keep row headings in Excel when you are scrolling so that you can easily identify your columns? What…

Read More How to Freeze rows in Excel
Excel Organise, Analyse Data

Editing a Drop Down List in Excel

Learn how to edit a drop-down list in Excel. In this blog you will learn how to find, remove and add items…

Read More Editing a Drop Down List in Excel
Excel Organise, Analyse Data

How to Create Drop Down Menu in Excel (Drop Down List)

Learn how to create a drop-down list in Excel. In this blog you will learn two different ways to create a drop-down…

Read More How to Create Drop Down Menu in Excel (Drop Down List)
Excel Organise, Analyse Data

Remove Drop Down List in Excel

Need to remove a drop-down list in Excel? In this blog you will learn how to remove the drop-down list as well…

Read More Remove Drop Down List in Excel
Excel Organise, Analyse Data

Find, modify and break links to an Excel workbook

Learn how to find, modify and break links to an Excel workbook. Linking is great, until you no longer need it. Then…

Read More Find, modify and break links to an Excel workbook
Excel Organise, Analyse Data

How to Sum only visible cells in Excel when using Filter

A common question I get asked when I’m teaching people how to filter data is “how do I sum only the visible…

Read More How to Sum only visible cells in Excel when using Filter
Excel Organise, Analyse Data

Filter data in Excel

Learning how to filter data in Excel enables you to find and work with just a subset of a larger list or…

Read More Filter data in Excel
Excel Organise, Analyse Data

Excel – Restricting editing in worksheets and workbooks

Needing to create a single worksheet, or an entire workbook, where you do not want other users to be able to make…

Read More Excel – Restricting editing in worksheets and workbooks
Excel Organise, Analyse Data

Excel – Paste a link and Paste Special transpose your data

Without a doubt ‘Paste Link’ is one of the best time-saving features in Excel. Linking information from one cell to another saves…

Read More Excel – Paste a link and Paste Special transpose your data