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 IllustratorAdobe InDesignAdobe PhotoshopAutoCADGuides & TipsManagementMicrosoft AccessMicrosoft ExcelMicrosoft OutlookMicrosoft Power AutomateMicrosoft Power BIMicrosoft PowerPointMicrosoft ProjectMicrosoft SharePointMicrosoft WordNewsResilienceSQLTime Management
Excel’s SUM Function [inc 2 Examples & Troubleshooting]
The SUM Function quickly adds up numbers in a range of cells. It’s a simple and powerful tool, taught in our intro to Excel course. SUM Function Details Available in: All versions of Microsoft Excel User Level: Beginners…
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…
Excel’s SEARCH Function [inc 2 Examples & Troubleshooting]
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. We believe is an underrated function, which is why we include it on our…
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…
How Are People Using AI In The UK? 2024 Stats
AI is nothing new. But what is new is the rate at which adoption is increasing in 2023. The past few months have seen millions of people trying their hand at using platforms like ChatGPT. They use it to increase…