Sunday, February 28, 2021

How Do I Produce A Graph From A Table In Excel?

A frequently asked question by many of our readers, so we thought we'd tackle this little task first, and show you how to make...

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...

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 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...

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...

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...

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...

A Fast and Easy Way to Separate Data

If you're an Excel user, chances are that at some point in your life, you have come across a spreadsheet stacked full of data...

Excel – Create Useful Datasets with Data Validation

If you have had experience in using Excel to create databases of information, it’s quite possible that at one time or another you have...

Increase your efficiency with a customised toolbar in Microsoft Office

The quick access toolbar is an incredibly useful feature that in my mind is often overlooked. If you regularly use Microsoft office, and particularly if...

DON'T MISS