;%20}%20%3c/style%3e%3clinearGradient%20id='linear-gradient'%20x1='2.99'%20y1='29.35'%20x2='127.75'%20y2='101.39'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20offset='0'%20stop-color='%23f2b347'%20/%3e%3cstop%20offset='.5'%20stop-color='%23ca5a8b'%20/%3e%3cstop%20offset='1'%20stop-color='%236654f5'%20/%3e%3c/linearGradient%3e%3c/defs%3e%3cg%20id='Layer_1-2'%20data-name='Layer%201'%3e%3cpath%20class='cls-1'%20d='M83.56,0H47.18C21.12,0,0,21.12,0,47.18v36.38c0,26.06,21.12,47.18,47.18,47.18h36.38c26.06,0,47.18-21.12,47.18-47.18V47.18C130.74,21.12,109.62,0,83.56,0ZM20.62,48.64c2.84-2.84,6.59-4.23,10.32-4.17,3.82,.07,7.55-1.1,10.25-3.8l.56-.56c2.7-2.7,3.86-6.43,3.8-10.25-.07-3.73,1.32-7.47,4.17-10.32,6.18-6.18,16.66-5.48,21.88,2.11,3.18,4.62,3.27,10.96,.19,15.64-3.02,4.6-7.92,6.78-12.72,6.54-3.51-.17-6.95,.99-9.43,3.48l-1.24,1.24c-2.48,2.48-3.65,5.92-3.48,9.43,.24,4.8-1.94,9.7-6.54,12.72-4.68,3.08-11.03,2.99-15.64-.19-7.6-5.23-8.29-15.7-2.11-21.88Zm33.7,34.25c-2.7,2.7-3.86,6.43-3.8,10.25,.07,3.73-1.32,7.47-4.17,10.32-6.18,6.18-16.66,5.48-21.88-2.11-3.18-4.62-3.27-10.96-.19-15.64,3.02-4.6,7.92-6.78,12.72-6.54,3.51,.17,6.94-.99,9.43-3.48l1.24-1.24c2.48-2.48,3.65-5.92,3.48-9.43-.24-4.8,1.94-9.7,6.54-12.72,4.68-3.08,11.03-2.99,15.64,.19,7.6,5.23,8.3,15.7,2.11,21.88-2.84,2.84-6.59,4.23-10.32,4.17-3.82-.07-7.55,1.1-10.25,3.8l-.56,.56Zm55.8-2.93c-2.96,2.96-6.91,4.35-10.79,4.15-3.51-.17-6.96,.99-9.44,3.48l-1.23,1.23c-2.49,2.49-3.65,5.93-3.48,9.44,.19,3.88-1.19,7.82-4.15,10.79-6.18,6.18-16.66,5.48-21.88-2.11-3.18-4.62-3.27-10.96-.19-15.64,3.02-4.6,7.92-6.78,12.72-6.54,3.51,.17,6.95-.99,9.43-3.48l1.24-1.24c2.48-2.48,3.65-5.92,3.48-9.43-.24-4.8,1.94-9.69,6.54-12.72,4.68-3.08,11.03-2.99,15.64,.19,7.6,5.23,8.3,15.7,2.11,21.88Z'%20/%3e%3c/g%3e%3c/svg%3e)
Enterprise DNA Tools
Excel
Expand your ability to organize, analyze, and visualize data in various formats.
Start Learning for Free
New to Excel?
Start here.
Paid Course
Foundations of Data Analytics
Dive deep into Data Analytics! Gain a profound understanding of the practicality and significance of data-driven insights in today's decision-making landscape
Learning
Paths
Path
Introduction to Power Automate for Workflow Automation
Delve into built-in connectors, mastering basic flows to advanced error handling for seamless workflow efficiency.
Advanced
12 Hours
Path
Financial Analysis and Reporting in Power BI
Explore advanced data modeling techniques in Power BI and Enterprise DNA tools, mastering dynamic grouping formulas and automated financial reporting for comprehensive analysis.
Intermediate
10 Hours
Path
Mastering 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
Path
Geospatial Insights in Power BI
Discover advanced data visualization techniques in Power BI, from environmental storytelling to dynamic flight data representation, for compelling insights.
Intermediate
8 Hours
Path
ChatGPT for Advanced Excel Data Analysis
Discover innovative techniques for leveraging ChatGPT alongside Excel's advanced data analysis functionalities.
Beginner
4 Hours
Path
Integrating Power BI with Excel and SharePoint
Seamlessly integrate Power BI with Excel and SharePoint to unlock the full potential of Office 365 for powerful data analysis and visualization capabilities across platforms.
Intermediate
13 Hours
Path
Advanced Excel: Mastering Pivot Tables and Data Analysis
Master advanced Pivot Table techniques, automate formulas, and wield tools like Power Query for dynamic data analysis and visualization in Excel.
Intermediate
7 Hours
Path
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
14 Hours
Learning
Center
Course
Foundations of Data Analytics
Dive deep into Data Analytics! Gain a profound understanding of the practicality and significance of data-driven insights in today's decision-making landscape
Beginner
2 Hours
Course
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: Forecasting and Trend Analysis
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
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
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
Course
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
2 Hours
Course
GIS Meets Power BI: Advanced Geospatial Visualization
Bridge the gap between GIS software and Power BI with our targeted training! Transform your mapping visuals and elevate your data storytelling skills.
Advanced
3 Hours
Course
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
Virtual
Events
Virtual Event
Practical Power Query Solutions - Nested Structured Values (Part 1)
Explore structured columns containing Lists, Records or Tables
01:12:34 Hours
Virtual Event
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
Practical Power Query Solutions
Let’s practice some Power Query/M. It’s a Date!
00:58:47 Hours
Virtual Event
Financial Modelling In Power BI
In just a few short years, Power BI has come from nowhere to become the business intelligence software of choice. This brief overview addresses the way forward for financial modeling.
00:54:04 Hours
Virtual Event
Practical RPA For Shared Services Using Power Automate
Create efficiency in your business processes through the specific components of Power Automate Flows
00:47:56 Hours
Virtual Event
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
Correlation and Regression in Excel
Explore the relationship between correlation and causation
00:33:45 Hours
Virtual Event
Financial Modelling In The Banking Industry
Create an interactive benchmarking report comparing the financial performance of the Banks on key metrics such as Income Growth, Cost:Income Ratio and Current Ratio
01:01:32 Hours
Guides
Resource
Fundamentals In Power Query And M
Your guide in bridging the gap between data chaos and clarity, and unlocking a world of efficient data analysis.
Resource
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
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.
Resource
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
Exploring Splitter.SplitTextByWhitespace in Power Query/ M
Learn how to effectively use this function in various real-world scenarios. It also demonstrates how this function can handle different types of whitespace characters
Resource
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
Constructing records in the Power Query M language
This resource provides comprehensive instructions on how to build and manipulate record data structures in Power Query M.
Resource
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.