During the period 23/12 to 6/1, we will have slightly longer response times than usual. Merry Christmas and a Happy New Year! 🎄✨

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.

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 a limitation in Excel. The article underscores SQL's role in enhancing data analysis and its ability to efficiently handle massive datasets. It also emphasizes how SQL skills can broaden career opportunities, improve collaboration between technical and non-technical teams, and be a valuable competence in today's data-driven decision-making. Ultimately, the article highlights that learning SQL is a critical skill for anyone interested in working with databases and advanced data analysis.

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 quick and effective data validation. These charts, simple visual representations, are essential for detecting errors and anomalies in data, and are a key tool for iterative analysis and continuous quality control in data preparation.

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 their similarities, differences, and use cases.

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 data sharing. Microsoft Excel, when combined with Office 365, stands out as a potent solution to address this demand. This article delves into the utilization of Excel for collaborative workbooks in Office 365, shedding light on how it can bolster productivity and teamwork within your company.

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, SORT, UNIQUE, SEQUENCE, and RANDARRAY, simplify complex calculations and data manipulation tasks. They enable users to perform multiple calculations efficiently, reducing errors and saving time in data analysis.

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 of Swedish and talks English fluently. She will be a great asset this summer, and will mainly focus on the Norwegian courses. Throughout her studies, she has used Excel to solve data related problems, and know the tool well. We wish her welcome onboard!

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, and manipulating data. Mastering these functions can greatly enhance your Excel skills and improve productivity in data management tasks.

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 this article you'll learn more about some of these tools.