Excel Tips

Microsoft Excel is a powerful tool that offers a wide range of functions to help you manipulate and analyse data effectively. One of the most versatile and game-changing functions in Excel is XLOOKUP. Whether you're a seasoned Excel user or just getting started, understanding how to use the XLOOKUP function can significantly enhance your data processing capabilities.

Pivot Tables are one of the most powerful tools in Excel. A Pivot Table is a table of statistics that summarises data from a more extensive table. Here’s a quick overview of how to create your own Pivot Table.

Using checkboxes in Excel sounds rather trivial, but this particular skill opens up a range of new opportunities that can help you keep on track with goals, lists, schedules, and assignments. 

Take your data entry skills in Excel to the next level with the invaluable tool of custom drop-down lists. Explore this all-inclusive guide that not only introduces a straightforward five-step method but also provides invaluable expert insights and strategies for crafting personalised drop-down lists that will turbocharge your spreadsheet efficiency.

Autofill in excel is a massive time saver when dealing with lots of data at once. Learn how to execute a simple autofill manoeuvre.

One of the key basics to understand when getting started in Excel are rows and columns. In this article, we dive into a basic how to guide to get you started.

Everyone knows about the incredible business capabilities of Excel. Although considered an application for “number people” it can be a powerful visualisation tool. Take Power Maps – the handy tool that maps data.

Knowing how to effectively use Excel is a game-changer in workplace productivity, so it's time to ask the question: What is the best way to learn Excel online? Find this and other FAQs here

One of our recent discoveries is BERT aka the Basic Excel R Toolkit. This is a package for working with the R programming language functions from Excel. It's a wonderful resource for adding functionality to Excel and best of all, it is free!

Microsoft has just made AI and Excel a thing. The new updates from the Microsoft Ignite festival is something you don't want to miss. Check it out now.

If you are a Mac user and also delve into Excel then read on for some tips and tricks that could save you a ton of time!

I’ve been conducting Excel Courses for Excel Consulting for a couple of years now. Excel Intermediate is our most frequently offered course. In that course, Conditional Formatting seems to be the most favorite topic for most groups that I’ve come across.

Concatenate is one of the most effective ways of combining data in Microsoft Excel.

The most common function in Excel would most likely be the SUM function, but our vote is that the excel IF function is definitely the most useful.  This tutorial explains how to use the IF function and how this can become an integral part to simplifying your formula editing.

If you are looking at increasing your workplace productivity then learning how to use Microsoft Excel efficiently is a great step. We present 13 Microsoft Excel shortcuts that you need to know and will supercharge your skills.

In this blog, we will troubleshoot the most common mistakes made while using VLOOKUP in ExcelI and provide some quick and easy solutions.