Excel

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

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.

This Learning Path delves into Power BI development, focusing on creating effective reports and visualizations. It covers parameter management, using PowerPoint and more!

Bridging the gap between GIS software and Power BI mapping visuals

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

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

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

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

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.

Let's go beyond the thrills and glamour of Excel tricks. This session explores the dark side--the sexy features in Excel that can burn your fingers if you're not careful.

Implement some creative Row-Level-Security techniques effectively and learn how to dynamically anonymize data

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.

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

Learn how can Python augment and automate Excel

Prepare, profile and analyze data in Excel workbooks

Enterprise DNA Analytics Summit are action packed live events showcasing a variety of beginner to advanced Power BI & Power Platform tips and techniques. 

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. 

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 offers techniques to retrieve and manipulate data based on specific row indexes or key matches, enhancing the flexibility and precision of data analysis.

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.