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 […]

Embed an Excel worksheet within your Word document

Embed Excel in a 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 Microsoft Office, there are several different ways to achieve this. There are several benefits from being able to embed an Excel worksheet into your Word […]

The best keyboard shortcuts in Microsoft Excel

The best keyboard shortcuts in 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 my other “shortcut key” posts, should know that I am a big fan of shortcuts. Anything that can improve efficiency and workflow is a […]

How to disable the Start Screen at startup in Office programs

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 various functions such as any recent files you have opened and the ability to choose a new blank document or file or various templates which […]

How to open any Microsoft Office product

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 impossible to find the one we want. Being able to open any Microsoft Office program can sometimes take longer than it should. The vast majority […]

How to use the AutoFill tool in Excel

Introduction to 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 underutilised and users do not know the full potential of this nifty little tool. In this post, I will give you an introduction to the […]

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 explain Compatibility Mode and file formats for Microsoft Office. To understand compatibility mode and how we fix this you need to understand file extensions. In […]

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 a Sparkline was and how to insert one into your worksheet. Now let’s look at how to customise a sparkline. Sparkline Tools Once you have […]

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 contained within a […]