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.
AllAdobe InDesignAdobe PhotoshopManagementMicrosoft ExcelMicrosoft Power AutomateMicrosoft Power BIMicrosoft PowerPointMicrosoft ProjectMicrosoft SharePointMicrosoft WordSQLTime Management
Excel Statistics: Facts & Figures [Original Research]
To inform how we teach our Excel training courses, we have conducted new, original research. We wanted to know just how many people are using Excel, and how confident they are with it. For full details of our sample size…
Transform Your Excel Data [8 Easy Methods!]
Data is crucial for your business. It offers insights into customer behaviour, and supports predictive forecasting for future product trends. However, raw data is rarely usable as-is. Issues such as missing values, duplicates, or errors can render datasets unreliable. To…
Excel’s SUM Function [inc 2 Examples & Troubleshooting]
The SUM Function quickly adds up numbers in a range of cells. It’s simply how adding in Excel is handled! It’s a simple and powerful tool, taught in our intro to Excel course. SUM Function Details Available in: All…
Excel’s TRIM Function [inc 2 Examples & Troubleshooting]
The TRIM Function in Excel is useful for removing extra spaces from text. It’s especially handy when cleaning data imported from other sources. TRIM Function Details Available in: All versions of Microsoft Excel User Level: Beginners Inputs: “Text”: The…
Excel’s COUNT Function [With 2 Examples & Troubleshooting!]
The COUNT Function in Excel quickly counts the number of cells in a range. It simplifies data analysis by providing a fast way to quantify numeric data in your spreadsheets. COUNT Function Details Available in: All versions of…
Import Data To Excel With Power Query! [2 Step-By-Step Examples]
Power Query transforms data and makes it usable. You can import any data into a Microsoft Excel sheet and then transform it for your needs. This includes adding or deleting columns, filtering data, changing the data type, merging tables,…
Why Should You Learn Excel?
Excel is more than just a spreadsheet program. It is an essential tool to and can guide your way to success. No matter which field you work in or plan to work in, you should master your Excel skills.…
Top 10 AI Excel Tools – Reviewed & Ranked
Over half of the modern world is using AI at work. If you’ve not used it before Excel spreadsheets are a great place to start. But which one should you use? We decided to test the top 10 AI Excel…
2 Ways To Make A Heat Map In Excel [Advanced Guide]
Heat Maps distinguish important figures through vibrant colours. They are a unique visualisation tool, they are approachable while keeping important data intact. On our advanced Microsoft Excel courses, you’ll learn all about heat maps with the help of our…
Global Excel Summit 2025 Announced!
The Global Excel Summit for 2025 has finally been announced! It will take place from the 3rd to the 7th of February 2025, in London. You can register your interest early on through the Excel Summit website. We strongly recommend…
[Introduction] Get Started With Charts In Excel
Charts are how you visualise data in Excel. These visualisations are fantastic for presenting data for others, as well as summarising it for yourself. Delegates on our Excel courses always want to learn how to make great charts! What…
Excel For Web: A Comprehensive Guide
Excel for Web is a cloud-based tool that aligns with the needs of modern businesses. Spreadsheet management has is a vital part of operational tasks. With it, data analysis, decision-making, and reporting is all possible on the go. Why…