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.
Integrate ChatGPT into Excel using Macros and APIs Cover

Paid 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
beginner
1 Hours
Learn More

Learning

Paths
3 assets
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
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

Learning

Center
6 assets
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
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
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
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
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 Going Back To Basics

Power Query Going Back To Basics

Learn the basics of data types in Power Query and some helpful hints
00:51:53 Hours
Virtual Event
Business Intelligence Summit - August 2022

Business Intelligence Summit - August 2022

View Replays of the August 2022 Business Intelligence Summit Event for Analysts, Excel Users, Database Professionals, Data Enthusiasts and more...
17:42:31 Hours
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
Excel Automation with Office Scripts and Power Automate

Excel Automation with Office Scripts and Power Automate

In this session, we will look at the online tools available inside Office 365 to automate our Excel processes.
01:06:06 Hours
Virtual Event
Clean Your Data Like A Pro

Clean Your Data Like A Pro

Use Power Query/ M effectively to prepare data for analysis
00:37:02 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
Exploratory Data Analysis in Excel

Exploratory Data Analysis in Excel

Prepare, profile and analyze data in Excel workbooks
00:32:25 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 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: 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 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.