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

Competition: Share your diploma and win an iPad & all our courses!

Competition time!

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.

The new super function XLOOKUP in Excel

In this article our guest writer Carl Stiller deconstructs the function XLOOKUP and tell you why you should use it.

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.

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 OpenAI, stands out as a significant breakthrough. With its capacity for human-like text generation and comprehension, ChatGPT is set to redefine data analysis. It offers a natural language interface, streamlining complex tasks like data cleansing, exploratory analysis, predictive modeling, and decision support. This evolution promises a more inclusive, efficient, and insightful future for data analysis, but it's crucial to remember that AI complements rather than replaces human expertise.

How AI and ChatGPT are changing the way we learn.

Technology's impact on our lives is undeniable. Enter ChatGPT, a revolutionary AI that blurs the lines between human and machine interaction. It's a boon for learning, offering personalized tutoring and creative inspiration. However, concerns over its misuse linger. Let's explore how ChatGPT can reshape our world while treading carefully.