What is Page Layout View and How do I Use it?

If you're using an Excel spreadsheet that contains a large amount of data or many columns, it can sometimes be difficult to adjust the...

How to create a drop down menu in Excel using data...

In a previous article we showed you how to create useful data sets with data validation, however in this walkthrough we are going to show you...

Custom Formats Part 1: Display numbers however you would like!

In Excel sometimes you need to format you cell in a way that is outside of the default and standard formatting provided. However, with...

Two easy ways to split text in Google Sheets

Manipulating data is one of the key functions of spreadsheet use, and you might already be aware of the various options for separating data...

How to create a double axis graph in Excel

Microsoft Excel’s chart functions help readers quickly visualise information and see insights buried within sheets of endless data. They can include bar charts, line...

Use Advanced Filter to Remove Duplicates from your Database in Excel

I love databases. It's true. I'm a secret geek and I love finding new ways of working with Excel and making it do things...

Identifying unique values in a database

Conditional formatting is a very useful tool in Microsoft Excel that can be used for a variety of purposes when analysing data. It's particularly...

Add a calculator into Microsoft Excel

Microsoft Excel has lots of little hidden tips, tricks and add-ons that many people don't know about, and it's my mission to make these...

Part II: What is Page Layout View and How do I...

If you're using an Excel spreadsheet that contains a large amount of data or many columns, it can sometimes be difficult to adjust the...

Using Conditional Formatting to Identify Duplicate Data in Excel

There are a couple of different ways of identifying duplicates within a dataset but by far the easiest way is with conditional formatting. There...

DON'T MISS