![](/wp-content/uploads/2022/09/course-header.jpg.webp)
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.
![](/wp-content/uploads/2021/12/Image-5-768x402.png.webp)
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…
![Drag the cell handle to get the results](/wp-content/uploads/2022/06/Image-50.png.webp)
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 using…
![All USD prices converted to Euros](/wp-content/uploads/2022/02/Image-8-4.png.webp)
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…
![Screenshot showing the Format Cells Dialog Box with Percentage, Sample and Decimal places highlighted.](/wp-content/uploads/2022/01/Picture5-2-768x697.png.webp)
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 a…
![Highlights the Page Layout, Margins, Normal Margins and Custom Margins buttons](/wp-content/uploads/2021/10/ELA1.png.webp)
Master Your Page Layout In Excel
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…
![Shows what the Strings button can do](/wp-content/uploads/2022/01/seoExcel52.png.webp)
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. We’ve provided Excel training to a…
![Final histogram chart.](/wp-content/uploads/2024/02/Imagem12.png.webp)
Create Your Own Histogram In Excel
Excel’s versatility in handling data makes it a leader among data management tools. Now imagine transforming all that statistical data into a picture for more enhanced visualisation. This is where histograms come in. Professionals from industries across the globe rely…
![AI Stock Photo](/wp-content/uploads/2023/04/pexels-tara-winstead-8849282-768x512.jpg.webp)
Use AI To Become An Excel Pro
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,…
![Graphic showing the formula to calculate a simple percentage.](/wp-content/uploads/2022/08/Picture1-1-768x160.png.webp)
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…
![Box and whisker plot inserted](/wp-content/uploads/2023/11/Imagem38-768x367.png.webp)
Finding Outliers In Excel: A Detailed Guide
Microsoft Excel is an incredibly powerful data analysis tool that empowers users to store, analyse, and visualise data to derive valuable insights out of it. With so many basic and advanced level data analysis tools, Excel provides you with almost…
![](/wp-content/uploads/2023/11/Screenshot_8-1.jpg.webp)
Mastering Excel’s LEN Function
The LEN function in Excel calculates the number of characters in a text string, including spaces and punctuation. For example, using “=LEN(‘Excel Magic’)” would yield the result “11”. This function is essential for various data analysis tasks. Excel Function Details…
![](/wp-content/uploads/2023/11/Screenshot_9.jpg.webp)
Using The SEARCH Function In Excel
The SEARCH function in Excel is a powerful tool that locates one text string within another. It returns the starting position of the first text. For example, using “=SEARCH(‘Excel’, ‘I love Excel’)” would yield the result “8”, Excel Function Details…