Excel

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

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!

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

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 navigates learners through real-world scenarios to cultivate problem-solving skills using the M language in Power Query.

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

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

Build a strong foundation on your MS Excel skills as you progress to advanced level

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

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

Bridging the gap between GIS software and Power BI mapping visuals

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

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

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.

Boost your productivity and performance by mastering Microsoft’s latest technology updates

In this session, Celia will reveal her top list of Excel skills and features needed to automate the most common Excel reporting procedures.

In this session, Ken will show you how he can build a complex Excel BI model leveraging Power Query and Power Pivot very quickly. 

Learn how can Python augment and automate Excel

Use Power Query/ M effectively to prepare data for analysis

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!

Explore the relationship between correlation and causation

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.

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

A detailed resource that provides robust solutions to deal with missing fields in datasets when using Power Query/M. 

Unlock the ‘Each’ expression in Power Query/M

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. 

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

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