Excel

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.

This Learning Path navigates learners through real-world scenarios to cultivate problem-solving skills using the M language in Power Query.

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.

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.

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.

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!

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.

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.

Revolutionize your Excel experience with ChatGPT! Master AI-powered techniques to streamline tasks, boost efficiency, and excel in data management.

Dive deep into Data Analytics! Gain a profound understanding of the practicality and significance of data-driven insights in today's decision-making landscape

Take your Excel skills to the next level with this intermediate course focused on Macros, VBA (Visual Basic for Applications), and automation.

Bridge the gap between GIS software and Power BI with our targeted training! Transform your mapping visuals and elevate your data storytelling skills.

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.

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.

Begin with the basics and rapidly progress to Excel mastery. This course takes you from simple spreadsheets to complex data analysis, laying a solid foundation for advanced Excel skills.

Advance your analytics capabilities: Transition from basic spreadsheets to Python and explore powerful data analysis techniques with our expert-led course.

Use Power Query/ M effectively to prepare data for analysis

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. 

Where is all your data with Oakley Turvey

Learn how to create interactive Excel charts using the Excel's new functions: Dynamic Arrays.

Know the techniques how to be strategic in your workbook development through the use of query referencing and duplicating

Analysis Planning by Brian Julius

Problem of the Week gives you real-world DAX and Power Query scenarios that will challenge your analytical skills.

Learn what it takes to develop high quality Power BI & Power Platform reports

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

This Excel formulas cheat sheet covers advanced forecasting formulas, statistical analysis, data manipulation functions, error handling, and more.

A comprehensive resource that demonstrates how to seamlessly merge tables from multiple files located within a single folder.

The Power Query M language constructs lists, which are ordered sequences of comma-delimited values enclosed in curly brackets, capable of holding any type of value, and are lazily evaluated, potentially supporting infinite elements.

In this guide, we will address a common issue when performing an Expand Column operation in Power Query. 

Designed specifically for avid Excel users, this resource unlocks the potential of combining AI with spreadsheet functions.

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.