К содержимому
learnspaceYOUR NEXT CHAPTER
ПРОСТРАНСТВО ОБУЧЕНИЯ
ГлавнаяКаталог курсовМоё обучениеCoursera

Знания без границ

Учитесь у лучших университетов и компаний мира.

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
Excel and Copilot Fundamentals · LearnSpace
Назад в каталог
courseraАнализ данных

Excel and Copilot Fundamentals

Курс от Microsoft
Начальный≈ 21.9 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

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 Required Course Materials: A Copilot license is required to complete this course. If you don’t have a Microsoft 365 Personal or Family license, you can start a free 30-day trial using the link provided in the course.

Навыки, которые вы освоите

Excel FormulasMicrosoft ExcelData EntryData Analysis SoftwarePrompt EngineeringMicrosoft CopilotData ManipulationMicrosoft OfficeData AnalysisUser Interface (UI)Spreadsheet SoftwareData Visualization

Программа курса

5 модулей · 114 учебных материалов

01Introduction to Copilot in Excel and activation27 материалов

Getting started

Welcome to Excel and Copilot fundamentalsЧтениеIntroduction to the Coursera CommunityЧтение

Introduction to Copilot in Excel

Getting started with Copilot in Excel ЧтениеHow to Get Started with Microsoft CopilotЧтение

Учитесь у экспертов

Microsoft

Преподаватель курса

Excel and Copilot Fundamentals
В каталоге вашей программы

Инвестируйте в себя

Новые знания — в удобное для вас время.

Начать на Coursera

Обучение откроется на Coursera
в новой вкладке

Обучение на Coursera

≈ 21.9 ч

5 модулей

Язык: Английский

Субтитры: Арабский, Французский, Узбекский, Итальянский, Бразильский португальский, Корейский, Немецкий, Пушту, Азербайджанский, Испанский, Дари, Японский, Казахский, Венгерский

Часть программы вашего университета
Activating Excel CopilotВидео
Performing basic tasks with CopilotВидео
Guide to performing basic tasks using Copilot in ExcelЧтение
Hands-on activity: Activating CopilotЧтение
Hands-on activity debrief: Activating CopilotВидео
Hands-on activity: Create a travel budgetЧтение
Hands-on activity debrief: Create a travel budgetВидео
Quiz: Performing basic tasks using Copilot in ExcelЗадание

Optimising workflows through Copilot in Excel

Optimizing workflows with Excel Copilot Part 1 of 2ВидеоOptimizing workflows with Excel Copilot Part 2 of 2ВидеоUsing Excel add-ins to extend functionalityЧтениеUsing conditional formatting with CopilotВидеоEnhancing data presentation with Excel CopilotВидеоHands-on activity: Optimize workflows with Copilot ЧтениеHands-on activity debrief: Optimize workflows with CopilotВидеоQuiz: Optimizing workflows with CopilotЗадание

Evaluating Copilot performance

Evaluating Copilot performanceВидеоCopilot performance metricsЧтениеImproving Copilot performance through customizationВидеоHands-on activity: Evaluating Copilot performanceЧтениеHands-on activity debrief: Evaluating Copilot performanceВидеоQuiz: Copilot performance ЗаданиеQuiz: Introduction to Copilot in Excel and activationЗадание
02Excel interface and basic features23 материалов

Exploring the Excel interface

Introduction to Excel: Basic navigationВидеоIntroduction to Excel: Backstage view and shortcutsВидеоBasic features in ExcelЧтениеCreating and managing Excel workbooksВидеоUsing Excel templates for efficiencyЧтениеHands-on activity: Navigating and using basic featuresЧтениеHands-on activity debrief: Navigating and using basic featuresВидеоQuiz: Excel interface customizationЗадание

Understanding data types

Introduction to data typesВидеоConverting data typesВидеоMastering data types in Excel: Tips and tricks for effective data managementЧтениеWorking with data typesВидеоHands-on activity: Understanding data types ЧтениеHands-on activity debrief: Understanding data types Видео

Creating lists and tables

Creating lists ВидеоCreating tablesВидеоGuide to Excel tables and best practiceЧтениеHands-on activity: Creating lists and tablesЧтениеHands-on activity debrief: Creating lists and tablesВидеоDiscussion: Customizing the Excel interfaceЧтение
03Excel formulas and functions23 материалов

Combining arithmetic operations in Excel with Copilot

Using basic arithmetic in ExcelВидеоApplying BODMASЧтениеApplying mathematical functions in ExcelВидеоUnderstanding cell references (relative, absolute, and mixed)ЧтениеHands-on activity: Practicing arithmetic functionsЧтениеHands-on activity debrief: Practicing arithmetic functionsВидеоQuiz: Arithmetic functions Задание

Using logical and LOOKUP functions

Applying logical functions in ExcelВидеоUsing LOOKUP functions overviewЧтениеCombining logical and LOOKUP functions for advanced data analysisВидеоCreating and managing named rangesЧтениеHands-on activity: Practicing logical and LOOKUP functionsЧтениеHands-on activity debrief: Practicing logical and LOOKUP functionsВидео

Using conditional, date, and time functions with Copilot

Using conditional, date, and time functions with CopilotВидеоApplying the date and time functions overviewЧтениеUsing nested functions for complex calculations in ExcelВидеоUnderstanding Excel's error messages and troubleshooting techniquesЧтениеHands-on activity: Practicing conditional, date, and time functions ЧтениеHands-on activity debrief: Practicing conditional, date, and time functions Видео
04Basic data entry and formatting with Copilot18 материалов

Efficient data entry

Data entry techniquesВидеоOverview of shortcutsЧтениеUsing data validation for accurate data entryВидеоHands-on activity: Practicing data entry techniquesЧтениеHands-on activity debrief: Practicing data entry techniquesВидеоQuiz: Data entry techniques Задание

Formatting data with Copilot

Formatting data in ExcelВидеоFormatting best practicesЧтениеCreating custom styles and templates in ExcelВидеоHands-on activity: Formatting techniques practice ЧтениеHands-on activity debrief: Formatting techniques practice ВидеоQuiz: Formatting techniques Задание

Enhancing data presentation by leveraging Copilot

Enhancing data presentationВидеоCreating basic pivots in ExcelВидеоHands-on activity: Advanced formatting practice ЧтениеHands-on activity debrief: Advanced formatting practice ВидеоQuiz: Advanced formatting ЗаданиеQuiz: Basic data entry and formatting with CopilotЗадание
05Introduction to prompt engineering for Copilot in Excel23 материалов

Basics of prompt engineering

Engineering prompts for Excel CopilotВидеоList of Copilot tasks available and starter promptsЧтениеAdvanced prompt engineering techniquesВидеоUnderstanding natural language processing (NLP) basicsЧтениеHands-on activity: Writing basic promptsЧтениеHands-on activity debrief: Writing basic promptsВидеоQuiz: Prompt engineering basics Задание

Developing effective prompts

Writing effective promptsВидеоTechniques for effective promptsЧтениеImproving your prompts ВидеоHands-on activity: Practicing effective promptsЧтениеHands-on activity debrief: Practicing effective promptsВидеоQuiz: Effective prompts Задание

Evaluating prompt performance

Evaluating prompt performanceВидеоMetrics for prompt performanceЧтениеOptimizing prompts for better resultsВидеоHands-on activity: Developing effective promptsЧтениеHands-on activity debrief: Evaluating prompt performanceВидеоQuiz: Prompt performance Задание
Quiz: Data types Задание
Quiz: Lists and tables Задание
Quiz: Excel interface and basic featuresЗадание
Quiz: Logical and LOOKUP functionsЗадание
Discussion: Optimizing patient data analysis with ExcelЧтение
Quiz: Conditional, date, and time functions Задание
Quiz: Excel formulas and functionsЗадание
Quiz: Introduction to prompt engineering for Excel CopilotЗадание
Cumulative project: DiscussionЧтение
Cumulative project: Attendance tracker Взаимная проверка
Cumulative project debrief: Attendance tracker Видео