This is a hands-on, project-based course designed to help you leverage Copilot in Microsoft Excel to solve real-world data analytics problems.

We’ll start by reviewing Microsoft Copilot’s basic features and limitations, compare strengths and weaknesses against Generative AI tools like ChatGPT, and get you up and running with Copilot for Microsoft 365 on your machine.

From there, we’ll dive into each of Copilot’s core use cases for data management and analysis. You’ll practice using Copilot to add new formula columns using natural language, apply conditional formatting rules to highlight key data points, and analyze data to find insights using pivot tables and charts.

Last but not least, we’ll showcase how to use Copilot’s generative AI engine for more advanced use cases, including writing dynamic array formulas and generating Python code within Excel.

Throughout the course, you’ll play the role of an HR Admin at ACME Corporation, a manufacturing company that makes outlandish products based on classic cartoons. Using Copilot in Excel – and the skills you learn throughout the course – you’ll manipulate employee data, monitor performance metrics, and make data-driven recommendations to your HR supervisor.

COURSE OUTLINE:

• Introducing Copilot

  • Enable Copilot for Excel 365, introduce its basic features and limitations, and compare it with ChatGPT

• Adding Formula Columns

  • Create calculated columns with Copilot’s formula suggestions, including conditional, text, date & lookup functions

• Sorting, Filtering & Highlighting

  • Manipulate tables by sorting & filtering using natural language and apply conditional formatting rules to highlight key data points

• Analyzing Data

  • Find insights by asking Copilot to analyze your data and generate pivot tables, charts & graphs, and data-driven recommendations

• BONUS: Ask for Support

  • Leverage Copilot’s generative AI engine to get Excel pro tips and expert advice beyond its core capabilities

Ready to dive in? Join today and get immediate

Happy learning.

-Enrique Ruiz (Certified Excel Expert & Best-Selling Instructor, Maven Analytics)

Looking for our full business intelligence stack? Search for "Maven Analytics" to browse our full course library, including Excel, Power BI, MySQL, Tableau and Machine Learning courses.

See why our courses are among the TOP-RATED on Udemy:

"Some of the BEST courses I've ever taken. I've studied several programming languages, Excel, VBA and web dev, and Maven is among the very best I've seen. " Russ C.

"This is my fourth course from Maven Analytics and my fourth 5-star review, so I'm running out of things to say. I wish Maven was in my life earlier. " Tatsiana M.

"Maven Analytics should become the new standard for all courses taught on Udemy. " Jonah M.