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 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

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 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.

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 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.

This Learning Path guides you through mastering SharePoint, emphasizing its collaborative essence and diverse versions, all while seamlessly integrating with the Office 365 ecosystem.

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.

Join us on this journey from cells to scripts, and unlock a new realm of possibilities for your data projects.

Unlocking Advanced Insights with ChatGPT's Advanced Data Analysis (ADA)

Bridging the gap between GIS software and Power BI mapping visuals

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

Mastering Data Analysis: Transitioning from Spreadsheets to Scripts

Boost your Excel productivity with our ChatGPT course designed to enhance your skills!

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.

Integrate ChatGPT into Excel using Macros and APIs to enhance your learning experience and maximize productivity.

Boost your productivity and magnify the power of your existing applications w/ Power Automate Desktop

Learn how to become a new-age data engineer, by simply using Power BI Dataflows

This lesson will show the easy and quick ways to get things done with Excel. Bob will show you a potpourri of tips & tricks not widely known.

View Replays of the August 2022 Business Intelligence Summit Event for Analysts, Excel Users, Database Professionals, Data Enthusiasts and more...

Build a comprehensive and compelling Power BI report within an hour from scratch!

Prepare, profile and analyze data in Excel workbooks

The session include function Let and how to declare and using parameters in Power Query and DAX

Use Power Query/ M effectively to prepare data for analysis

Your guide in bridging the gap between data chaos and clarity, and unlocking a world of efficient data analysis.

Here you’ll find a quick fix and an overview of all other functions in these groups.

In this guide, we will address a common issue when performing an Expand Column operation 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.

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

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

A the comprehensive reference guide that presents a variety of techniques and functions for creating and manipulating tables in Power Query/M