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.
Geospatial Analysis in Power BI II Cover

Paid Course

Geospatial Analysis in Power BI II

Bridging the gap between GIS software and Power BI mapping visuals

advanced
advanced
2 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
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
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
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
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
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
Using WORKOUTS to Master Data Skills

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)

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

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

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

Correlation and Regression in Excel

Explore the relationship between correlation and causation
00:33:45 Hours
Virtual Event
LAMBDA - Taking Control of Your Functions

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

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

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
4 assets
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
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 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.
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.