Enterprise DNA Tools
Excel
Expand your ability to organize, analyze, and visualize data in various formats.
Start Learning for Free
New to Excel?
Start here.

Paid Course
Microsoft Excel for Beginners
Build a strong foundation on your MS Excel skills as you progress to advanced level
Learning
Paths
Path

Mastering M Code for Power Query
This Learning Path navigates learners through real-world scenarios to cultivate problem-solving skills using the M language in Power Query.
Intermediate
10 Hours
Path

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

Data Analytics Generalist
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.
Beginner
16 Hours
Learning
Center
Course

Microsoft Excel for Beginners
Build a strong foundation on your MS Excel skills as you progress to advanced level
Beginner
3 Hours
Course

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

ChatGPT to Improve Productivity in Excel
Boost your Excel productivity with our ChatGPT course designed to enhance your skills!
Beginner
1 Hours
Course

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

Geospatial Analysis in Power BI II
Bridging the gap between GIS software and Power BI mapping visuals
Advanced
2 Hours
Assessment

Excel Expert
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.
Intermediate
Virtual
Events
Virtual Event

Power Query Route To M(astery): Challenge Yourself!
Illustrate key techniques in Power Query/M by working through the Challenges
01:14:41 Hours
Virtual Event

Practical Power Query Solutions - Nested Structured Values (Part 2)
Explore structured columns containing Lists, Records or Tables
01:00:37 Hours
Virtual Event

Power BI For Excel Users - Kick Start Your Analytics Journey
Solve advanced analytical questions using Power BI
01:02:29 Hours
Virtual Event

Practical Power Query Solutions - Nested Structured Values (Part 1)
Explore structured columns containing Lists, Records or Tables
01:12:34 Hours
Virtual Event

Innovations In Power BI & Power Platform Summit
Learn what it takes to develop high quality Power BI & Power Platform reports
19:37:28 Hours
Virtual Event

Enterprise Analytics Summit - February 2022
Check the Replays of the Feb 2022 Analytics Summit Event for Analysts, Excel Users, Database Professionals, Data Enthusiasts and more.
18:05:06 Hours
Virtual Event

Track Changes Using Dimensions In Power Query
Showcase how to implement an SCD Type 2 using Power Query to allow a full historical analysis of a specific dimension
00:45:11 Hours
Virtual Event

VBA, PQ for a Simple Excel Utility
In this presentation, we would be developing a solution a simple solution to bulk rename files and folders in a folder.
00:53:34 Hours
Guides
Resource

Row Index and Key Match Lookup in Power Query/ M
This offers techniques to retrieve and manipulate data based on specific row indexes or key matches, enhancing the flexibility and precision of data analysis.
Resource

Excel Cheat Sheet: A Beginners Guide With Time-Saving Tips
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.
Resource

Excel Formulas Cheat Sheet: Intermediate Guide
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
Resource

Excel Formulas Cheat Sheet: Advanced Guide
This Excel formulas cheat sheet covers advanced forecasting formulas, statistical analysis, data manipulation functions, error handling, and more.