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

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

---

Dynamic Array Functions in Excel: Efficient Data Manipulation

Dynamic array functions, introduced in Excel 365 and Excel 2019, have transformed data handling and analysis. These functions, including FILTER,...

---

AI & the Future of Data Analysis

In recent years, artificial intelligence has made remarkable strides, reshaping industries and work processes. ChatGPT, an advanced language model by...

---

Run simulations using Excel

In this article, we are going to have a look at how we can make simple simulations in Excel using...

---

Unlocking Excel: A Guide to Lookup and Reference Functions

Excel's lookup and reference functions, including VLOOKUP, HLOOKUP, INDEX, MATCH, CELL, INDIRECT, and OFFSET, are powerful tools for searching, retrieving,...

---