How to use Countif in Excel

How to use Countif in Excel

When working with large amounts of data in Excel, you can find yourself needing to count the number of records which meet specific criteria. This is when the Excel Countif function is going to come in very handy and save you a lot of time. Let’s take a look at how the Excel Countif function […]

Back up data using Windows Backup and Restore

How to back up data using Windows Backup and Restore

In an earlier post titled Backing up your files – a vital step to securing your data, I outlined the basic information needed for any user to begin the process of backing up data on a regular basis. In this post, I will step you through how to perform a back up using the Backup and […]

Backup data using File History (Windows 10)

How to backup data using File History (Windows 10)

In an earlier post titled Backing up your files – a vital step to securing your data, I outlined the basic information needed for any user to begin the process of backing up data on a regular basis. In this post, I will step you through how to back up data using File History options available […]

Create a Sparkline to show data trends in Excel

I can hear you asking it now, what is a Sparkline? It’s a very good question which I’m going to answer for you now. Sparklines were introduced in Excel 2010 and are a great feature for those who prefer a “visual” approach to data (like myself). Sparklines are miniature charts which are displayed within a […]

Create a quick and easy chart in Excel

Create a quick chart in Excel

Microsoft Excel provides a great way to summarise and analyse data within a spreadsheet using charts. Charts provide a graphical representation of data and allow you to highlight important information or trends that occur. I’ve said this before and I’m sure I’ll say it plenty more times but I’m a visual person and have always […]