Excel

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

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.

Master the art of centralized data management. Streamline reporting processes and drive efficiency across your organization, maximizing the impact of your insights.

Discover innovative techniques for leveraging ChatGPT alongside Excel's advanced data analysis functionalities.

Delve into IF statements, text functions, and data cleaning strategies, while grasping the essentials of functions and formulas.

Explore advanced data modeling techniques in Power BI and Enterprise DNA tools, mastering dynamic grouping formulas and automated financial reporting for comprehensive analysis.

Master advanced Pivot Table techniques, automate formulas, and wield tools like Power Query for dynamic data analysis and visualization in Excel.

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!

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

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

Bridge the gap between GIS software and Power BI with our targeted training! Transform your mapping visuals and elevate your data storytelling 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.

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

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

EXPERIMENTAL: This course teaches valuable Microsoft VBA automation techniques that optimize business processes, leading to increased productivity and efficiency.

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.

Power Query Tricks beyond the User Interface with Chandeep Chhabra

Using in-built standard Excel tools, we will explore how to reduce uncertainty in decision-making with sensitivity and scenario analysis

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

Analysis Planning by Brian Julius

Discover how to visualize, debug, validate and solve complex DAX problems using Excel

Explore the relationship between correlation and causation

On this session, Cristiano Galvao MVP will cover the impact of recent changes in Excel that unleash the power of formulas. 

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

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

 This resource illustrates how users can manipulate data structures at a granular level, offering insights into how tables can be deconstructed for detailed analysis or data-cleaning purposes. 

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

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

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

This offers techniques to retrieve and manipulate data based on specific row indexes or key matches, enhancing the flexibility and precision of data analysis.

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.

A comprehensive resource that provides essential guidelines for effectively commenting and documenting M code in Power Query.