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

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 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....

---

How do you calculate compound interest in Excel?

Learn how to compute compound interest in Excel!

---

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...

---

We create online courses that make a difference

Learn the basics of Excel and data analysis – quickly, smoothly, and practically. Perfect for those who want to get...

---

Discover Excel’s Function Translator

Learn how you can translate entire formulas with Excel's Function Translator, a Microsoft add-on that translates functions and delimiters.

---

Tip: Download our Excel Gantt Chart

Download our Gantt chart attached in the article.

---

Sanity check your data with disposable charts in Excel

This text explores the importance of 'sanity checks' in data analysis, highlighting the use of disposable charts in Excel for...

---

Excel vs. Power BI – which one should you choose?

In this article, two powerful tools for data management and analysis, namely Excel and Power BI, are compared. Learn about...

---

Boost Productivity and Teamwork with Collaborative Excel Workbooks

In the contemporary business landscape, effective collaboration is an imperative. Organizations are continually seeking streamlined methods for team cooperation and...

---