✔ 14-day money-back guarantee ✔ Flexible learning at your own pace ✔ Trusted by companies, schools and public sector organizations

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

Stop using “Merge & Center” – use this instead

Learn more about Center Across Selection!

Linear vs. Logarithmic Scales in Charts

Learn more about linear and logarithmic scales in Excel charts!

What is the difference between LOOKUP, VLOOKUP, and XLOOKUP?

What's the difference between LOOKUP, VLOOKUP and XLOOKUP?

How to Fix Formula Errors in Excel?

Learn how to fix your formula errors!

Vertical Lines in Excel Charts

Learn how you can customize your Excel Charts!

How are absolute and relative cell references used in Excel?

If you have worked a lot in Excel, you have probably encountered absolute and relative cell references before. Most people have likely had to learn about these references after noticing that their formulas or functions sometimes behave unexpectedly. Therefore, this…

How do you create a Gantt chart in Excel?

Microsoft offers its 365 subscribers downloadable templates for Gantt charts, but there is still no built-in Gantt chart in Excel. Therefore, this post will focus on how to create one completely from scratch. What is a Gantt chart? A Gantt…

How do you concatenate in Excel?

If you want to download the supporting material used in this article, you can click here. Concatenate or concatenation means joining two text strings together. The word originates from the Latin expressions con and catena, meaning “chaining together.” In this…

How do you calculate compound interest in Excel?

Learn how to compute compound interest in Excel!

Get to Know Mais at Learnesy!

Hi there! My name is Mais, 23 years old, product developer at Learnesy and a Master of Science student in Industrial Engineering and Management. As the newest member of the team, I’m super excited to kick off my very first…

How to create a FIFO calculation in Excel

The FIFO principle is an important principle in logistics, finance, and accounting. It stands for 'first in, first out', meaning that assets purchased first should also be sold first. It is applied to ensure older goods are used or sold first, reducing the risk of selling expired or obsolete items. In economic contexts, it is commonly used for assets like stocks, bonds, or currencies. Excel can be used to create a dynamic FIFO model for calculating costs, profits, and inventory values.

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.