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

Why Learn SQL in 2024?

Focusing on 2024, this article highlights how SQL aids in managing larger datasets and performing more complex data manipulations, addressing...

---

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

---

Fall offer: Reduced price and extended access

499 SEK per month, immediate access, and throughout 2024!

---

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

---

We welcome Nora to Learnesy!

Learn more about our newest team member Nora in this article. Nora is Norwegian speaking, but has very good understanding...

---

4 ways to use Correlation in Excel for a Business Controller

Discover the hidden connections within your data using Excel's correlation analysis. Gain valuable insights and make informed decisions with ease.

---

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

---