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.
Introduction to ChatGPT's Advanced Data Analysis (ADA) Cover

Paid Course

Introduction to ChatGPT's Advanced Data Analysis (ADA)

Unlock data insights with ADA. Elevate your analysis skills using ChatGPT's advanced algorithms and transform your data interpretation.

beginner
beginner
2 Hours
Learn More

Learning

Paths
3 assets
Path
Data Analytics Generalist

Data Analytics Generalist

Gain a versatile skill set covering a wide range of data analysis techniques and tools, preparing you for diverse roles in the dynamic field of data analytics!
Beginner
17 Hours
Path
Python for Data Analysis

Python for Data Analysis

Take your data analysis to the next level with Python. Seamlessly integrate Python and AI for efficient workflows and game-changing insights.
Beginner
12 Hours
Path
M Code for Power Query

M Code for Power Query

Master the art of creating visually appealing and insightful dashboards and reports using Power BI, leveraging its wide range of visualization options and features.
Intermediate
11 Hours

Learning

Center
14 assets
Course
Introduction to ChatGPT's Advanced Data Analysis (ADA)

Introduction to ChatGPT's Advanced Data Analysis (ADA)

Unlock data insights with ADA. Elevate your analysis skills using ChatGPT's advanced algorithms and transform your data interpretation.
Beginner
2 Hours
Course
Excel to Python for Data Analysis

Excel to Python for Data Analysis

Transform your data approach with Python expertise! Transition from Excel and open the door to limitless possibilities for your projects, seamlessly moving from cells to scripts.
Beginner
1 Hours
Course
ChatGPT to Improve Productivity in Excel

ChatGPT to Improve Productivity in Excel

Revolutionize your Excel experience with ChatGPT! Master AI-powered techniques to streamline tasks, boost efficiency, and excel in data management.
Beginner
1 Hours
Course
Time Series Analysis Fundamentals

Time Series Analysis Fundamentals

Discover the power of Time Series Analysis! Learn to forecast and identify trends, gaining valuable insights into the patterns of temporal data.
Beginner
3 Hours
Course
Mastering VBA Through Projects

Mastering VBA Through Projects

An in-depth course designed to teach advanced VBA techniques through the completion of three intermediate to advanced projects.
Advanced
2 Hours
Course
Advanced Guide to VBA Arrays

Advanced Guide to VBA Arrays

A comprehensive course on mastering advanced techniques and applications of VBA arrays.
Intermediate
1 Hours
Course
Python Beyond Excel

Python Beyond Excel

Advance your analytics capabilities: Transition from basic spreadsheets to Python and explore powerful data analysis techniques with our expert-led course.
Beginner
1 Hours
Course
Integrate ChatGPT into Excel using Macros and APIs

Integrate ChatGPT into Excel using Macros and APIs

Boost your Excel skills with ChatGPT integration! Learn how to use macros and APIs to seamlessly blend ChatGPT into Excel, enhancing both your productivity and learning experience.
Beginner
1 Hours

Virtual

Events
9 assets
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
Developing Data Models In The Real World

Developing Data Models In The Real World

Discover the foundations of Data Modelling in Power BI and Power Query
00:46:19 Hours
Virtual Event
Combining AI, Excel, Power BI, and Python - How To Learn Them All

Combining AI, Excel, Power BI, and Python - How To Learn Them All

Start on a holistic learning journey that integrates AI, Excel, Power BI, and Python. This event is designed to provide a unified approach to mastering these powerful tools, helping you harness their combined potential.
Intermediate
01:34:05 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
Power Query Route To M(astery): Challenge Yourself!

Power Query Route To M(astery): Challenge Yourself!

Illustrate key techniques in Power Query/M by working through the Challenges
01:14:41 Hours
Virtual Event
Row-Level-Security Hacks

Row-Level-Security Hacks

Implement some creative Row-Level-Security techniques effectively and learn how to dynamically anonymize data
00:37:32 Hours
Virtual Event
Data Engineering w/ Dataflows

Data Engineering w/ Dataflows

Learn how to become a new-age data engineer, by simply using Power BI Dataflows
00:45:52 Hours
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
Guides
16 assets
Resource
Data Analyst vs Data Scientist: Understanding the Key Differences

Data Analyst vs Data Scientist: Understanding the Key Differences

This comparison highlights the key differences between Data Analysts and Data Scientists, focusing on their core responsibilities, tools, and career paths within the data ecosystem.
Resource
Intermediate Excel Cheat Sheet

Intermediate Excel Cheat Sheet

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
Advanced Guide to VBA Arrays

Advanced Guide to VBA Arrays

Master the use of static, dynamic, and multi-dimensional arrays to streamline your VBA projects and improve efficiency across your data-driven tasks!
Resource
Productivity in Excel with ChatGPT

Productivity in Excel with ChatGPT

Learn how to automate repetitive tasks, generate dynamic data sets, and apply intelligent error-checking within your spreadsheets!
Resource
Data Scenario CSV Generator

Data Scenario CSV Generator

Data Scenario CSV Generator is a flexible and powerful tool designed to create customizable datasets based on user-defined scenarios
Resource
Beginners Excel Cheat Sheet

Beginners Excel Cheat Sheet

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
100 Things You Can Do With Data Mentor

100 Things You Can Do With Data Mentor

Unlock your data analysis potential with '100 Things You Can Do With Data Mentor', a guide showcasing the multifaceted capabilities of the Data Mentor tool.
Resource
Advanced Data Analysis (ADA) with ChatGPT

Advanced Data Analysis (ADA) with ChatGPT

Learn to harness ADA's powerful analytics to generate, manipulate, and visualize data effectively, making your data tasks more efficient and insightful!