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.
Excel for Data Analytics: Leveraging Excel's Power for Data Analysis Cover

Paid Course

Excel for Data Analytics: Leveraging Excel's Power for Data Analysis

Mastering Excel for Comprehensive Data Analysis

beginner
beginner
2 Hours
Learn More chevron_right

Learning

Paths
11 assets
Path
Introduction to Power Automate for Workflow Automation

Introduction to Power Automate for Workflow Automation

This Learning Path delves into automating tasks using built-in connectors, emphasizing transformative functions and error handling. This Learning Path equips learners with practical skills, from basic flow creation to advanced error management using scopes and button trigger tokens.
Advanced
12 Hours
Path
Enterprise-Level Reporting with Power BI

Enterprise-Level Reporting with Power BI

This Learning Path delves into the transformative potential of Power BI, emphasizing strategic deployment, planning, and governance. It offers actionable insights to foster a sustainable data culture, leveraging Power BI's comprehensive capabilities
Intermediate
9 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
13 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
11 Hours
Path
Integrating Power BI with Excel and SharePoint

Integrating Power BI with Excel and SharePoint

This Learning Path guides you through mastering SharePoint, emphasizing its collaborative essence and diverse versions, all while seamlessly integrating with the Office 365 ecosystem.
Intermediate
12 Hours
Path
Advanced Excel: Mastering Pivot Tables and Data Analysis

Advanced Excel: Mastering Pivot Tables and Data Analysis

This Learning Path delves into advanced features, teaching students to efficiently utilize tables, automate formulas, and harness tools like Power Query and Pivot for dynamic data analysis and reporting. Master techniques for data extraction, transformation, and visualization in Excel.
Intermediate
6 Hours
Path
Data Engineering and Dataflows in Power BI

Data Engineering and Dataflows in Power BI

This Learning Path delves into the transformative power of Data Engineering with Dataflows in Power BI, emphasizing centralized data management for efficient reporting. Participants will learn hands-on techniques, ensuring consistent data usage and best practices across teams.
Intermediate
2 Hours
Path
Financial Analysis and Reporting in Power BI

Financial Analysis and Reporting in Power BI

This Learning Path delves into advanced data modeling techniques, focusing on Power BI and Enterprise DNA tools. Participants will learn to automate financial reports, utilize dynamic grouping formulas, and integrate various data sources for comprehensive analysis.
Intermediate
10 Hours

Learning

Center
12 assets
Course
Excel for Data Analytics: Leveraging Excel's Power for Data Analysis

Excel for Data Analytics: Leveraging Excel's Power for Data Analysis

Mastering Excel for Comprehensive Data Analysis
Beginner
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
4 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
GIS Meets Power BI: Advanced Geospatial Visualization

GIS Meets Power BI: Advanced Geospatial Visualization

Bridging the gap between GIS software and Power BI mapping visuals
Advanced
2 Hours
Course
Time Series Analysis: Forecasting and Trend Analysis

Time Series Analysis: Forecasting and Trend Analysis

An in-depth exploration into the world of Time Series Analysis, emphasizing forecasting and trend discernment.
Beginner
3 Hours
Course
Excel to Python for Data Analysis

Excel to Python for Data Analysis

Join us on this journey from cells to scripts, and unlock a new realm of possibilities for your data projects.
Beginner
1 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

Virtual

Events
57 assets
Virtual Event
Creating More Effective Charts

Creating More Effective Charts

In this session, we'll look at easy techniques to make your charts more effective and easier to understand, no matter if they are in Excel or PowerPoint.
00:48:50 Hours
Virtual Event
Exploring the Power of New Excel Functions

Exploring the Power of New Excel Functions

On this session, Cristiano Galvao MVP will cover the impact of recent changes in Excel that unleash the power of formulas. 
00:48:01 Hours
Virtual Event
Parameters from Regular Excel to Power BI

Parameters from Regular Excel to Power BI

The session include function Let and how to declare and using parameters in Power Query and DAX
00:51:49 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
Power Query Tricks Beyond the User Interface

Power Query Tricks Beyond the User Interface

Power Query Tricks beyond the User Interface with Chandeep Chhabra
00:56:02 Hours
Virtual Event
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. 
04:53:04 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
Guides
21 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
Quick Fix to Show All Fields in a Expand Column Operation

Quick Fix to Show All Fields in a Expand Column Operation

In this guide, we will address a common issue when performing an Expand Column operation in Power Query. 
Resource
Disassemble and assemble tables in Power Query/ M

Disassemble and assemble tables in Power Query/ M

 This resource illustrates how users can manipulate data structures at a granular level, offering insights into how tables can be deconstructed for detailed analysis or data-cleaning purposes. 
Resource
Common Methods to Conjure Tables in Power Query/ M

Common Methods to Conjure Tables in Power Query/ M

A the comprehensive reference guide that presents a variety of techniques and functions for creating and manipulating tables in Power Query/M
Resource
Introducing Group By or Table Group in Power Query/M

Introducing Group By or Table Group in Power Query/M

This is focused on one of the key functionalities of Power Query M – the 'Group By' or 'Table Group' operation.
Resource
Relative Date functions and How They Deal with Weeks

Relative Date functions and How They Deal with Weeks

Here you’ll find a quick fix and an overview of all other functions in these groups.
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

This cheatsheet elucidates how to access individual items and fields, perform lookups, and make specific selections in your data, providing tangible, visual aids for each step.
Resource
Unlock the ‘Each’ expression in Power Query/M

Unlock the ‘Each’ expression in Power Query/M

Unlock the ‘Each’ expression in Power Query/M