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

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

---

Text Functions in Excel: Powerful Tools for Efficient Text Manipulation

While Excel is often associated with numbers and calculations, it also provides robust tools for working with text data. In...

---

8 visualizations for your dashboard in Excel, part 1

In this article you will find tips and visualizations for your next dashboard in Excel.

---

Discover the advantages and benefits of Excel’s PivotTables

Learn more about Excel pivot tables and why you should use them. Excel's PivotTables are great for summarize, analyze and...

---