Excel

This Learning Path navigates learners through real-world scenarios to cultivate problem-solving skills using the M language in Power Query.

This Learning Path delves into Power BI development, focusing on creating effective reports and visualizations. It covers parameter management, using PowerPoint and more!

This path is similar to the Data Analyst learning path above, but is geared to building a strong and broad foundation of data analysis skills, as compared to being more specifically focused on passing the PL 300 exam.

Integrate ChatGPT into Excel using Macros and APIs to enhance your learning experience and maximize productivity.

Bridging the gap between GIS software and Power BI mapping visuals

Build a strong foundation on your MS Excel skills as you progress to advanced level

Take your Excel skills to the next level with this intermediate course focused on Macros, VBA (Visual Basic for Applications), and automation.

Boost your Excel productivity with our ChatGPT course designed to enhance your skills!

Excel is a spreadsheet software developed by Microsoft that allows users to organize, analyze, and manipulate data using features such as formulas, charts, graphs, and pivot tables, and is commonly used for financial and accounting tasks, data analysis, and project management.

Discover how to visualize, debug, validate and solve complex DAX problems using Excel

In this session, Ken will show you how he can build a complex Excel BI model leveraging Power Query and Power Pivot very quickly. 

View Replays of the August 2022 Business Intelligence Summit Event for Analysts, Excel Users, Database Professionals, Data Enthusiasts and more...

Discover the foundations of Data Modelling in Power BI and Power Query

In this presentation, you will learn the new LAMBDA function in Excel. How to use this to simplify functions that do not currently exist. 

Learn how simple resources can generate amazing results in the charts, applicable to any analysis.

On this session, Cristiano Galvao MVP will cover the impact of recent changes in Excel that unleash the power of formulas. 

Showcase how to implement an SCD Type 2 using Power Query to allow a full historical analysis of a specific dimension

This guide is here to simplify your journey with Excel, offering you the key tools, shortcuts, and techniques at your fingertips, so make sure to save it for future reference. 

This Excel formulas cheat sheet covers advanced forecasting formulas, statistical analysis, data manipulation functions, error handling, and more.

This offers techniques to retrieve and manipulate data based on specific row indexes or key matches, enhancing the flexibility and precision of data analysis.

This Microsoft Excel intermediate cheat sheet covers a wide range of topics that will level up your skills in numerical analysis, text processing, and complex date and time logic