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.
Time Series Analysis: Forecasting and Trend Analysis Cover

Paid Course

Time Series Analysis: Forecasting and Trend Analysis

An in-depth exploration into the world of Time Series Analysis, emphasizing forecasting and trend discernment.

beginner
beginner
3 Hours
Learn More chevron_right

Learning

Paths
11 assets
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
8 Hours
Path
Excel Basics: Formulas, Functions, and Formatting

Excel Basics: Formulas, Functions, and Formatting

Embark on this Learning Path to delve into Excel! Discover IF statements, text functions, and data cleaning, while grasping the basics of functions and formulas. Start your data analysis journey!
Beginner
7 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
11 Hours
Path
ChatGPT for Advanced Excel Data Analysis

ChatGPT for Advanced Excel Data Analysis

Welcome to a transformative learning experience that fuses the power of Excel with the capabilities of ChatGPT. Our "ChatGPT for Advanced Excel Data Analysis " path introduces a paradigm shift in data analysis. By integrating the AI-driven insights of ChatGPT into Excel's robust framework, this path promises efficiency, automation, and a heightened proficiency in tackling complex data tasks.
Beginner
3 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
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
7 Hours
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
11 Hours
Path
Geospatial Insights in Power BI

Geospatial Insights in Power BI

This Learning Path delves into advanced data visualization techniques using Power BI, emphasizing environmental data storytelling, map integrations, and flight data representation. Participants will learn to transform static reports into interactive dashboards, ensuring accessibility and effective communication for diverse audiences.
Intermediate
6 Hours

Learning

Center
8 assets
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
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
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
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
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
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
57 assets
Virtual Event
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
29:24:35 Hours
Virtual Event
The Excel Features & Skills You Need to Automate a Reporting Procedure

The Excel Features & Skills You Need to Automate a Reporting Procedure

In this session, Celia will reveal her top list of Excel skills and features needed to automate the most common Excel reporting procedures.
00:54:08 Hours
Virtual Event
Rapid Excel BI Model Development

Rapid Excel BI Model Development

In this session, Ken will show you how he can build a complex Excel BI model leveraging Power Query and Power Pivot very quickly. 
00:51:33 Hours
Virtual Event
Python For Excel

Python For Excel

Learn how can Python augment and automate Excel
00:36:52 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
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
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
Correlation and Regression in Excel

Correlation and Regression in Excel

Explore the relationship between correlation and causation
00:33:45 Hours
Resources
21 assets
Resource
Dynamic start and end dates for date tables in Power Query

Dynamic start and end dates for date tables in Power Query

Creating dynamic start and end dates in Power Query allows for versatile date tables that automatically adjust according to the data's time frame, enhancing data analysis efficiency and accuracy.
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
Exploring How to Handle Missing Fields in Power Query/ M

Exploring How to Handle Missing Fields in Power Query/ M

A detailed resource that provides robust solutions to deal with missing fields in datasets when using Power Query/M. 
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
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
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
Exploring Expression Functions in Power Query/ M

Exploring Expression Functions in Power Query/ M