✓ Trusted by 500+ organizations since 2014

Articles - All you need to know about Excel
Tips, guides & news

The new super function XLOOKUP in Excel

In this article our guest writer Carl Stiller deconstructs the function XLOOKUP and tell you why you should use it.

Cleaning data part 2 of 3 – Having numbers formated as text?

In this article, we'll be delving further into data cleansing and tackling the issue of handling numerical values presented in text format. It's not uncommon to come across numbers in text format, especially when dealing with exported data from sources like accounting systems or external data feeds. Such data might have numbers formatted as text or contain spaces between numerical values. In this session, we'll specifically focus on addressing the former scenario.

5 ways to insert reports from Excel

Learn different methods for exporting content from Excel

Conditional and custom formatting in Excel, is it worth the effort?

Is it…? Is it worth the time you need to spend before you learn the function… and even after? There is a lot you can do with this function but I would recommend learning formulas and basic functions first. In…

⭐ Master Excel’s SUMPRODUCT in 7 steps ⭐

We have now come to the post for the powerful function SUMPRODUCT… my favourite function. I became acquainted with this feature 12 years ago, setting up revenue forecasting models at CA Technologies, and am still finding new ways to use…

Smooth Performance Reporting in Excel! ⭐️

We have now come to the first posts that deal with reporting. I will show the most common types of reports and how to use formulas to populate the reports in a foolproof way? The new XLOOKUP function is said…

Excel
Onlinekurser
VLOOKUP
XLOOKUP

Why Excel is an indispensable tool?

Want to read the post in Swedish? Click here Who am I? My name is Carl Stiller, an energetic and happy economist with a Master of Science in Business and Economics from Linnaeus University with 14 years of experience in the…