Microsoft Excel
Our Excel articles below show clearly and simply how to use specific aspects of Microsoft Excel. We also cover these in our Excel training courses.
Creating Arrays – Excel Array Formulas
Array formulas are some of the most powerful functions in Excel. But we often find even on our advanced Excel courses that they are some of the hardest to understand! So let’s break down in clear and simple steps how…
Insert An Excel Chart In Word – Just 2 Steps!
This tutorial will show you how to insert your Excel Chart straight into a Word Document. This guide will have you put the charts from your own Excel workbook straight into Microsoft Word. This guide uses the most current versions…
Calculate Age From Date of Birth With Excel – Quick & Simple!
Everyone knows asking up front, “How old are you?” isn’t a great starter! But if you have someone’s date of birth, working their age out in your head can get a bit tricky too. So why not use Excel to…
Ultimate Guide: Highlighting Duplicate Values Excel
In the working world, data is never perfect and needs cleaning up before you analyse it. If you’ve ever been handed a big data set for analysis, you’ll know they come full of duplicate values! This means it’s crucial to…
Compare Two Columns In Excel (Ultimate Guide!)
When dealing with Data analytics, comparing data populated in two or more columns is common practice. Manually comparing data could take hours or even days, depending on the amount of the data in question. But when it comes to…
Convert Currencies With Excel – 5 Minutes Or Less!
Suppose you have financial statistics in prepared in USD, and need it converted to GBP. Why not use Excel to solve your problem? You can use currency pairs and currency exchange rates to convert currency. Excel doesn’t come packed with…
Calculate Percentage Difference in Excel [2 Practical Examples]
In this post, we will review how to calculate the Percentage Difference in Excel. Percentage Difference is the absolute value change of two values, divided by the average of them. The result is then multiplied by 100. Excel has…
Master Your Page Layout In Excel [Quick Guide]
Page Layout is the group of commands that control how you spreadsheet looks. This guide will go over the best options to keep control of your Excel Document. This will help you make your Excel pages more readable, more eye-grabbing…
Excel For SEO – Basic Training Guide
Excel has every data analysis tool that you’ll ever need. That’s great if you know about all of them. You can focus on the fun stuff and get Excel to do the heavy lifting. Our Microsoft Excel course has been…
Create Your Own Histogram In Excel
Histograms are visualisations of the distribution of your data. For a simple example, think about breaking down exam scores into grade bands. Professionals from industries across the globe rely on histograms to make sense of patterns and trends. Knowing how…
Use AI To Become An Excel Pro Today!
AI is rapidly changing the way we interact with technology and the world around us. In the simplest of words, AI is how machines perform tasks that typically require human intelligence. Like interpreting and communicating in natural language, recognizing images,…
Complete Guide To Percentages in Excel!
In this article, we will demonstrate how to calculate a percentage in Microsoft Excel, Word and PowerPoint. Additionally, we will go through some other important percentage related calculations. What is a Percentage? A percentage is defined, as a part or…