Excel

Explore a new frontier in data analysis! Unleash the fusion of Excel's robust power with ChatGPT's AI capabilities, transforming your approach to complex data tasks with unparalleled efficiency and automation. Discover innovative techniques for leveraging ChatGPT alongside Excel's advanced data analysis functionalities.

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 SharePoint's collaborative features for enhanced productivity and teamwork.

Elevate Task Automation! Delve into built-in connectors, mastering basic flows to advanced error handling for seamless workflow efficiency. Empower your team and optimize efficiency with Introduction To Power Automate, the ultimate solution for effortless workflow automation and business process optimization.

Ignite Geospatial Intelligence! Discover advanced data visualization techniques in Power BI, from environmental storytelling to dynamic flight data representation, for compelling insights. Gain expertise in harnessing location intelligence to drive business success with Power BI.

Transform Your Reporting Approach! Explore Power BI's strategic deployment, planning, and governance for enterprise-level reporting, driving a sustainable data culture with actionable insights. Delve into advanced techniques for managing large-scale datasets ensuring robust and scalable reporting solutions tailored to enterprise needs.

Excel at Excel from the start! Delve into IF statements, text functions, and data cleaning strategies, while grasping the essentials of functions and formulas. Begin your data analysis journey with confidence and competence!

Power BI Visualization: Master the art of creating visually appealing and insightful dashboards and reports using Power BI, leveraging its wide range of visualization options and features. Harness the power of M code in Power Query! Navigate real-world scenarios and cultivate problem-solving skills for efficient data manipulation.

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

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.

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

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

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.

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

Discover the power of Time Series Analysis! Learn to forecast and identify trends, gaining valuable insights into the patterns of temporal data.

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

Check the Replays of the Feb 2022 Analytics Summit Event for Analysts, Excel Users, Database Professionals, Data Enthusiasts and more.

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. 

In this session, we will look at the online tools available inside Office 365 to automate our Excel processes.

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.

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

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

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

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

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

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

 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. 

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

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. 

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

Unlock the ‘Each’ expression in Power Query/M

This is focused on one of the key functionalities of Power Query M – the 'Group By' or 'Table Group' operation.