Free Online Microsoft Training

Free tips and tricks for using Microsoft Office and Windows

Free Online Microsoft Training

Free tips and tricks for using Microsoft Office and Windows

Create a Sparkline to show data trends in Excel

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

How to create a Vlookup in Excel

How to create a Vlookup in Excel

Do you know how to create a Vlookup in Excel? The Vlookup function in Excel is a very popular function but sometimes can be a little tricky to work out. The Excel Vlookup function is a fantastic time-saver as it is a perfect example of how Excel can “do the work for you”. The Vlookup […]

How to create a screenshot using Office

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 information about a technical problem or error, and the list goes on. Anytime I want someone to see something on my screen or I need […]

Create an Excel graph or chart in under 30 sec

Create an Excel graph or chart in under 30 seconds

Microsoft Excel provides a great way to summarise and analyse data using charts. The terminology used can differ between referring to them as charts or an Excel graph. Either way it is the charting feature within Excel which will create these eye catching visual represeation of your data. Charts allow you to highlight important information […]

Introduction to Functions in Microsoft Excel

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 out results from your data analysis. Microsoft Excel has the ability to perform this and more for you all with a few clicks of the […]

Customise the Quick Access Toolbar

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 right up there on my list of favourite ways to make each program work better for me. All the Office programs have the QAT including […]

How to use Concatenate in Excel

How to use Concatenate in Excel

This week I had a request to show how to join text together from different columns in Excel. For this example, the Concatenate function in Excel works perfectly as it allows you to join strings of information together dynamically. The term “dynamically” means that if any data in the original location changes, our Concatenate function […]

Formula Basics in Excel

Using Formulas 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 and tricks to get started with formulas in Excel. Many people attending training may have been using Excel for several years but are still performing […]

Navigate an Excel Workbook

Navigate 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 option users choose mainly depends on personal preference however it is advisable to know the different options available. If you are new to Excel then […]

Terminology in the Excel 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 for a long period, it’s always a good idea to be familiar with the correct terminology of elements so that when using online references (such […]