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 chevron_right

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

Virtual

Events

10 assets
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
Virtual Event
The Oscars Timeline Visualization - Intro To Problem Of The Week #9 (Power Query)

The Oscars Timeline Visualization - Intro To Problem Of The Week #9 (Power Query)

Problem of the Week gives you real-world DAX and Power Query scenarios that will challenge your analytical skills.
Virtual Event
Where is All Your Data

Where is All Your Data

Where is all your data with Oakley Turvey
Virtual Event
Correlation and Regression in Excel

Correlation and Regression in Excel

Explore the relationship between correlation and causation
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
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.
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.
Virtual Event
Use Excel To Build & Validate Complex DAX

Use Excel To Build & Validate Complex DAX

Discover how to visualize, debug, validate and solve complex DAX problems using Excel
Summit
Enterprise Analytics Summit - November 2021

Enterprise Analytics Summit - November 2021

Enterprise DNA Analytics Summit are action packed live events showcasing a variety of beginner to advanced Power BI & Power Platform tips and techniques. 
Summit
2022 My Data Summit on Power BI & Excel

2022 My Data Summit on Power BI & Excel

Boost your productivity and performance by mastering Microsoft’s latest technology updates

Resources

10 assets
Resource
Common Methods to Conjure Tables in Power Query/ M

Common Methods to Conjure Tables in Power Query/ M

Resource
Exploring Expression Functions in Power Query/ M

Exploring Expression Functions in Power Query/ M

Resource
Constructing records in the Power Query M language

Constructing records in the Power Query M language

Resource
Exploring How to Handle Missing Fields in Power Query/ M

Exploring How to Handle Missing Fields in Power Query/ M

Resource
Row Index and Key Match Lookup in Power Query/ M

Row Index and Key Match Lookup in Power Query/ M

Resource
Best practices Commenting/Documenting M Code.

Best practices Commenting/Documenting M Code.

Resource
Visual Guide to item, field access, lookup, selection and projection in Power Query

Visual Guide to item, field access, lookup, selection and projection in Power Query

Resource
Dynamic start and end dates for date tables in Power Query

Dynamic start and end dates for date tables in Power Query

Resource
Unlock the ‘Each’ expression in Power Query/M

Unlock the ‘Each’ expression in Power Query/M

Resource
Relative Date functions and How They Deal with Weeks

Relative Date functions and How They Deal with Weeks