Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
2 Hour(s) 26 Minute(s)
Language
English
Taught by
Maven Analytics • 1,500,000 Learners, Enrique Ruiz
Rating
1 views
Course Overview
Accelerate your Excel skills with Microsoft Copilot: Generative AI for formulas, data analysis, visualization & more!
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 and Python in Excel to perform advanced analyses and solve complex problems.
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 using Python in Excel
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, LIFETIME access to the following:
2 hours of high-quality video
4 quizzes
Copilot for Microsoft Excel ebook (35 pages)
Downloadable demo files
Expert support and Q&A forum
30-day Udemy satisfaction guarantee
If you’re a casual Excel user looking to level up your skills and productivity with Generative AI, or a data professional looking to stay on top of Microsoft's newest features, this is the course for you.
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.
Course Content
- 7 section(s)
- 35 lecture(s)
- Section 1 Getting Started
- Section 2 Introducing Copilot
- Section 3 Adding Formula Columns
- Section 4 Sorting, Filtering & Highlighting
- Section 5 Analyzing Data
- Section 6 Supporting Advanced Use Cases
- Section 7 Wrapping Up
What You’ll Learn
- Enable Copilot Pro for Microsoft 365 and learn about its strengths and limitations
- Create calculated columns using natural language and leverage Copilot's formula suggestions
- Apply basic and advanced conditional formatting rules to highlight key data using Copilot
- Find insights by asking Copilot to analyze your data and generate pivot tables, charts, and data-driven recommendations
- Use Copilot's generative AI engine to solve more custom or advanced use cases by writing Python code directly in Excel
Skills covered in this course
Reviews
-
MMahesh Sharma
Overall a good course, but still believe if more complex practical scenarios must be part of the course.
-
LLisa Martin
So far I still can't tell if I even have the right version of Copilot to be able to take the course.
-
DDee Bo
Pretty detailed and helpful. Looks at the functionalities from multiple angles.
-
RRudy Gupta
The course gives foundational knowledge on how to optimize Copilot on Excel. It seems Microsoft updated Copilot so the user interface is different from what is shown in the course. While the features are there, the discrepancy presents a bit of a challenge of following the course. Another challenge is that Copilot may provide a different solution to a prompt that what is shown in the course. This is not the courses fault, but it felt a bit of a hindrance in learning the course. Despite that, I found this course to be helpful in getting some basic understanding of Copilot in Excel. I feel more confident using Copilot in Excel. However, since there currently seems to be limited use of Copilot in Excel (which the course addresses well), it feels more like a surface level learning experience.
