Excel and Copilot Fundamentals

Overview

Class Central Tips

This course introduces you to the basics of Microsoft Excel and its powerful Copilot feature, equipping you with essential skills for efficient data handling and analysis. You will learn to navigate Excel’s interface, apply fundamental formulas and functions, and develop prompt engineering techniques to leverage Excel Copilot for various tasks. By the end of this course, you will have a strong foundation in Excel, enabling you to perform basic data manipulations and utilize Copilot to streamline your workflow. By the end of the course, you’ll be able to: - Activate and effectively use Excel Copilot for basic tasks and queries. - Navigate the Excel interface and utilize basic features efficiently. - Apply fundamental Excel formulas and functions to perform calculations and data manipulation. - Develop basic prompt engineering skills for Excel Copilot. Tools you’ll use: - Microsoft Excel - Copilot in Excel

Syllabus

Introduction to Copilot in Excel and activation

This module covers the activation and basic usage of Copilot in Excel, helping you understand its environments and how to effectively utilize it for various tasks.

Excel interface and basic features

This module introduces the Excel interface and its basic features. You will become familiar with the layout, essential elements, and basic functionalities to use Excel efficiently and be able to compare these functionalities to the abilities of Copilot.

Excel formulas and functions

This module focuses on Excel formulas and how to do this with Copilot as well as functions, covering essential arithmetic operations and key functions to manipulate and analyze data effectively.