Enterprise DNA Tools

Excel

Expand your ability to organize, analyze, and visualize data in various formats.

Start Learning for Free
Excel Cover

New to Excel?

Start here.
Microsoft Excel for Beginners Cover

Paid Course

Microsoft Excel for Beginners

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

beginner
beginner
3 Hours
Learn More

Learning

Paths
3 assets
Path
Mastering M Code for Power Query

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

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

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
6 assets
Course
Microsoft Excel for Beginners

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

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

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

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

Geospatial Analysis in Power BI II

Bridging the gap between GIS software and Power BI mapping visuals
Advanced
2 Hours
Assessment
Excel Expert

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
42 assets
Virtual Event
Power Query Route To M(astery): Challenge Yourself!

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)

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

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)

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

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

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

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

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
4 assets
Resource
Row Index and Key Match Lookup in Power Query/ M

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

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

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

Excel Formulas Cheat Sheet: Advanced Guide

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