Introduction to Business Data Analysis with Excel Copilot AI

If you want to learn how to analyze your data using nothing more than plain English, this course is the one you're looking for. Microsoft Excel Copilot puts an AI data analyst right inside the spreadsheet you already use, and this course shows you exactly how to put it to work. Recorded in high definition video, it teaches you practical skills you can apply in your work environment immediately. Just take a look at the recent comments and reviews!

COURSE CONTENT AND OUTCOMES

This course teaches you how to use Excel Copilot to turn your data into new insight and intelligence, simply by asking questions of it.

The ability to ask questions of your data is a powerful competitive advantage, resulting in new income streams, better decision making and improved productivity. Copilot removes the barrier between you and your answers. Instead of building analysis by hand, you describe what you want to know and Copilot does the heavy lifting, generating the tables, charts and summaries for you in seconds.

During the course you will learn how to write effective Copilot prompts, how to interpret what Copilot gives you back, and how to check its results so you can trust the insight you share. You will understand why each form of analysis matters and see it produced live using Copilot.

Using Excel Copilot, you will learn to produce:

• Key Metrics

• Comparison Analysis

• Trend Analysis

• Ranking Analysis

• Interactive Dashboards

• Contribution Analysis

• Variance Analysis

• Pareto Analysis

• Frequency Analysis

• Correlations

For each one you will learn the plain-English prompts that get Copilot to do the work, so you can reproduce the same analysis on your own data straight away.

TWO COURSES IN ONE

As well as the new Excel Copilot material, this course includes the original PivotTables course as a second part. There you will see how to create the very same types of analysis using PivotTables, the traditional way. This gives you the best of both worlds. You learn the fast, prompt-driven Copilot approach, and you also understand what is happening underneath so you can work confidently whether or not Copilot is available to you.

This course is designed for all business professionals who want to take their ability to turn data into information to the next level. If you are an Excel user then you will want to learn the easy, prompt-driven techniques that are taught in this course.

WHAT YOU NEED TO FOLLOW ALONG

The Copilot part of the course requires a Microsoft 365 subscription with Copilot enabled on your account, and it is presented using Excel Copilot in Microsoft 365. The PivotTables part of the course uses techniques that also work in earlier versions of Excel, including:

• Excel 2013

• Excel 2016

• Excel 2019

Please note that this course does not require any complicated formulas, VBA or macros. In the Copilot part you get Copilot to create the majority of the different data analysis techniques for you simply by asking, and in the PivotTables part you use straightforward drag and drop techniques.