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
Geospatial Analysis in Power BI II
Bridging the gap between GIS software and Power BI mapping visuals
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

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

Microsoft Excel for Beginners
Build a strong foundation on your MS Excel skills as you progress to advanced level
Beginner
3 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

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

Using WORKOUTS to Master Data Skills
WORKOUTS is an innovative approach that combines hands-on exercises,
practical applications, and collaborative learning to help data
practitioners master data skills effectively.
Beginner
00:44:04 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

The Journey of Record Extraction in Excel
Extracting Records has always been an important task for Excel users. In this session, you will learn how this task evolved
00:52:32 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
Virtual Event

Correlation and Regression in Excel
Explore the relationship between correlation and causation
00:33:45 Hours
Virtual Event

LAMBDA - Taking Control of Your Functions
In this presentation, you will learn the new LAMBDA function in Excel. How to use this to simplify functions that do not currently exist.
00:52:16 Hours
Virtual Event

The Ultimate Power BI Freestyle Session
Build a comprehensive and compelling Power BI report within an hour from scratch!
01:10:29 Hours
Virtual Event

Pivot Table Tips and Tricks
Take a deep dive in pivot tables with Bill Jelen from MrExcel. Learn awesome pivot table techniques in both pivot cache pivot tables and data model pivot tables.
01:03:10 Hours
Guides
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

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 Formulas Cheat Sheet: Advanced Guide
This Excel formulas cheat sheet covers advanced forecasting formulas, statistical analysis, data manipulation functions, error handling, and more.
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.