Microsoft Excel

Without a doubt, the most popular data analysis tool on the planet!

Check out these articles designed to provide you with tips and tricks on how to use the amazing features of Microsoft Excel.

Want to learn a new Excel formula, or need to know how to use conditional formatting? Look no further and browse through the range of articles below.

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 Countif function ...
Read More
Conditional formatting an entire row

How to conditional format an entire row based on dates older than today

It seems my conditional formatting posts have become quite popular and with that, I've had some amazing questions asked about variations of how to use conditional formatting. If you haven't ...
Read More
Conditional Formatting date ranges

Use conditional formatting to identify dates within a specific range

My conditional formatting to identify dates earlier than today post has proven to be extremely popular. This post talks about how to conditional format dates within occur in the past ...
Read More
BIDMAS acronym

Excel giving you the wrong answer? Discover BIDMAS and Excel

An important part of understanding how Excel calculates formulas and functions is understanding BIDMAS. Let's think back to math class. I remember the teacher talking about BIDMAS and vividly thinking ...
Read More
Create a custom list in Excel

How to store a custom list in Excel

Do you have a list of entries you use frequently in Excel? Sick of having to type them in or copy and paste from another workbook? What if I told ...
Read More
Pin a File or Folder

Save time! Pin a file or folder to the Open list in Microsoft Office

At the start of every training course I run, I show participants through a few really useful tools. These tools will save you time during a busy workday. One such ...
Read More
Conditional Format Dates

Use conditional formatting to identify dates earlier than today

During a Microsoft Excel training session a few week's ago, I had a great question about using conditional formatting to highlight dates earlier than the current one, in other words, how can ...
Read More
Embed Excel in a Word Document

Embed an Excel worksheet within your Word document

Whenever I run Excel or Word training a common question pops up. What is the best way to add Excel data into a Word document? Like many things related to ...
Read More
The best keyboard shortcuts in Excel

The best keyboard shortcuts in Microsoft Excel

Want to become more efficient using Excel? Let me show you the best keyboard shortcuts in Excel. Anyone who has ever attended training with me, or even anyone who has ...
Read More
How to disable the Start Screen in Office

How to disable the Start Screen at startup in Office programs

In recent versions of the Microsoft Office programs, users now see a Start screen appear when any of the programs are launched. This Start Screen gives you quick access to ...
Read More
Open any Microsoft Office product

How to open any Microsoft Office product

For those starting out using Microsoft Office and even for those familiar with the programs, our computers can sometimes be a treasure trove full of so many programs that it's ...
Read More
Copy formatting using Format Painter

Copy formatting using Format Painter

Whenever I conduct a training course in any of the Microsoft products, I always touch on the Clipboard group of tools. These include the Cut, Copy and Paste functions and ...
Read More
Introduction to the AutoFill tool in Excel

How to use the AutoFill tool in Excel

Of all the features available within Microsoft Excel, the AutoFill tool has to be high up on the list of those used most frequently. Often though the AutoFill feature is ...
Read More
Convert workbooks to the latest file format in Excel

Convert workbooks to the latest file format in Excel

A common question I see during training is “Why do my files say [Compatibility Mode] in the title bar area?” and this is a good question. Today I want to ...
Read More

Customise a Sparkline in Excel

So you've discovered Sparklines in Microsoft Excel and now you want to jazz them up? You've come to the right place. In my previous post (link here) I outlined what ...
Read More

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

Create a Vlookup function in Excel

A common request in Excel training courses is to learn how to perform a vlookup function in Excel. Many people have heard about the VLOOKUP and HLOOKUP functions in Excel ...
Read More

How to create a screenshot using Office or Windows

For years I have been creating screenshots for various reasons; for use in training courseware; to illustrate to a remote user a button I want them to press; to relay ...
Read More
Create a quick chart in Excel

Create a quick and easy 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 ...
Read More

Introduction to Functions in Microsoft Excel

Microsoft Excel is a fantastic program allowing you to collate, analyse and sort data in various formats. Gone are the days of needing a calculator beside you to manually work ...
Read More
Microsoft Clipboard - a hidden treasure

The Office Clipboard – a hidden treasure

A common feature used within all of the Microsoft Office applications is the cut, copy and paste feature. I personally use this A LOT. The ability to cut, copy and ...
Read More
Quick Access toolbar customisation

Customise the Quick Access Toolbar

At the start of almost every Microsoft course I teach, I discuss the options you have to customise any of the Microsoft Office products. The Quick Access toolbar (QAT) is ...
Read More
Use Concatenate to join text together in Excel

Use Concatenate to join text together in Excel

This week I had a request to show how to join text together from different columns in Excel. I don’t know about anyone else but I personally know that in ...
Read More
Formula Basics in Excel

Formula Basics in Excel

For anyone who is completely new to Excel or is wanting to venture into the world of formulas and functions, this post is here to give you some basic tips ...
Read More
Create a PDF using Microsoft Office

Create a PDF file using Microsoft Office

Microsoft Office has the fantastic ability to create a PDF file for you. I’ve always been surprised at how many people are still unfamiliar that this function is now built-in ...
Read More
Using AutoCorrect in Microsoft Office

How to use AutoCorrect in Microsoft Office

Microsoft Office provides features which help to reduce typing errors whilst you work. AutoCorrect is one of those features and is set up by default to correct common spelling and ...
Read More
Navigating Microsoft Excel

Navigating within an Excel Workbook

When working in Microsoft Excel there are several references or names which will appear on a regular basis, as well as different methods for navigating within the program. Which navigation ...
Read More
Excel 2016 Window

Terminology in the Excel window

Let's take a look now at the terminology and names of the various areas within the Microsoft Excel 2016 window. Even if you have been an avid user of Excel ...
Read More
Conditional Formatting in Excel

How to use conditional formatting in Excel

Conditional formatting is one of my favourite parts of Microsoft Excel. I am a very visual person and would much rather look at colour charts or visual representations of data ...
Read More
Create Custom Number Formats in Excel

Create a custom number format to display phone numbers in Excel

Microsoft Excel provides various number formats allowing you to easily format numbers as currency, dates, percentages, time and even fractions. Occasionally you may run into a situation where the predefined ...
Read More