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.
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…
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,…
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. If you would like to learn more about Microsoft Excel, then please…
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…
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…
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…
Monitor Your Data With Freeze Panes In Excel!
In this post, we are going to review how to use the Freeze Panes feature in Microsoft Excel. Freeze Panes are a great tool to help you keep important data in view while scrolling around your sheet. Excel spreadsheets can…
Excel AI – New Usage Data & Statistics Q2 2024
Everyone is talking about artificial intelligence …. but how many people are actually using artificial intelligence day-to-day? To find out, we surveyed Excel users across the spectrum, from beginners to experienced professionals. Given the speed that AI is now being…
Introduction to Slicers in Excel
Slicers in Excel are often used together with Excel tables and Pivot tables. What are they used for? Quick filtering of data from huge, densely packed data sets. What distinguishes Slicers from ordinary data filters is their visual appeal and…
Master The XLOOKUP Function In Excel!
It’s time we introduce you to the new member of the modern function family of Excel – the XLOOKUP function. XLOOKUP is the successor to the conventional VLOOKUP, INDEX & MATCH, LOOKUP, and the HLOOKUP function. You must have heard…
Recover Unsaved Files in Excel 2024
We all have been through the unfortunate instances of power disruption and system crashes that do away with all our unsaved work. Even if you take measures to plot against any unexpected power outage or system crash, sometimes Excel would…
Create And Personalise Your Excel Dashboard!
In this tutorial, we will take you through the steps needed to create an Excel Dashboard. We will also review some best practices when it comes to dashboard creation and visualization. An Excel Dashboard is a powerful visualization tool that…