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鈥檒l start by reviewing Microsoft Copilot鈥檚 basic features and limitations, compare strengths and weaknesses against GenAI tools like ChatGPT, and get you up and running with Copilot for Microsoft 365 on your machine. From there, we鈥檒l dive into each of Copilot鈥檚 core use cases for data management and analysis. You鈥檒l practice adding new formula columns using natural language, applying conditional formatting rules to highlight key data points, and analyzing data to find insights using pivot tables and charts. Last but not least, we鈥檒l showcase how to use Copilot鈥檚 generative AI engine for more advanced use cases, including writing dynamic array formulas and generating Python code within Excel. Throughout the course, you鈥檒l play the role of an HR Admin at ACME Corporation, a global manufacturing company. Using the skills you learn throughout the course, you鈥檒l manipulate employee data, monitor performance metrics, and make data-driven recommendations to your HR supervisor. If you're an Excel user looking to add Copilot to your data analytics workflow, this is the course for you!
