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

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

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

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

Master Microsoft Excel with Copilot

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

О курсе

Excel Skills Are Expected. But AI-Powered Excel Skills Make You Irreplaceable. Still spending hours writing formulas and fixing spreadsheet errors? In today’s AI-driven workplace, basic Excel knowledge is no longer enough. This Microsoft Excel with Copilot Course helps you master Excel fundamentals and elevate your skills using Microsoft 365 Copilot to automate data analysis, generate insights instantly, and build AI-powered workflows. Inside this course, you will: • Master formulas, logical & lookup functions • Clean and structure messy datasets • Build pivot tables and business-ready reports • Automate repetitive tasks with Excel • Apply prompt engineering for smarter Copilot outputs Unlike traditional Microsoft Excel courses that stop at formulas, this course teaches you how to strategically combine Excel expertise with AI to save hours every week, reduce manual errors, and boost productivity. Designed for students and professionals who want a future-ready, high-demand skill set. By the end, you’ll confidently analyze data, automate workflows, and stand out in a data-driven world. Enroll today and gain the AI-powered Excel advantage. Note: Learners need to have Microsoft 365 Copilot license.

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

Microsoft ExcelExcel FormulasMicrosoft CopilotData ValidationPrompt EngineeringPivot Tables And ChartsData CleansingData EntryBudgetingBusiness ReportingAdvanced AnalyticsWorkflow ManagementData VisualizationData TransformationDecision MakingData AnalysisData QualityData PresentationAI WorkflowsSpreadsheet Software

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

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

01Getting Started with Copilot & Core Data Operations in Excel29 материалов

Introduction to Copilot in Excel and Activation

Course Introduction: Start Your Journey!ВидеоIntroduction to Microsoft Copilot: Activation & Setup GuideВидеоMastering Basic Data Analysis with CopilotВидеоHow to Use Copilot for Data Q&AВидео

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

LearnKartS

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

Tanmoy Kumar Das

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

Master Microsoft Excel with Copilot
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 16.3 ч

3 модулей

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

Субтитры: Арабский, Французский, Итальянский, Бразильский португальский, Корейский, Немецкий, Испанский, Японский

Часть программы вашего университета
Exploring the Basics of Data Analysis in ExcelЧтение
Filtering Data with Copilot: Part 1Видео
Checkpoint QuizЗадание
Filtering Data with Copilot: Part 2Видео
Formatting Your Data for Clarity and InsightsВидео
Best Practices for Data Formatting and CleaningЧтение
Organizing Your Data: Sorting with CopilotВидео
Correcting Missing Data Using CopilotВидео
Creating Synthetic Data for Analysis with CopilotВидео
Checkpoint QuizЗадание
Proficiency QuizЗадание

Adding Formula Columns

Using Formula Columns for Dynamic DataВидеоText Functions in Excel: Working with StringsВидеоMastering Date Calculations in ExcelВидеоUsing Conditional Statements for Smarter Excel ModelsВидеоCheckpoint QuizЗаданиеProficiency QuizЗадание

Sorting, Filtering & Highlighting

Formatting Cells with Formulas for Enhanced AnalysisВидеоVisualizing Data with Color Scales & Data BarsВидеоBest Practices for Editing Excel SpreadsheetsВидеоProfiling Data to Identify Trends and InsightsВидеоCheckpoint QuizЗаданиеProficiency QuizЗаданиеAI-Powered Business Reporting with Excel Copilot SimulationDIALOGUESummaryЧтение
02Excel Fundamentals: Interface, Functions & Copilot Applications31 материалов

Apply Excel Functions

Using the Sum Function with CopilotВидеоCalculating Averages in Excel with CopilotВидеоUsing Min & Max Functions with CopilotВидеоHow to Add Formulas in Excel with CopilotВидеоWorking with Excel Functions and FormulasЧтениеSummarizing Data: Using Subtotals with CopilotВидеоCheckpoint QuizЗаданиеProficiency QuizЗадание

Different Uses Cases of Copilot in Excel

Using Copilot to Create a Travel BudgetВидеоOptimizing Excel Workflows with Copilot: Part 1ВидеоOptimizing Excel Workflows with Copilot: Part 2ВидеоOptimizing Your Workflow with Excel FunctionsЧтениеApplying Conditional Formatting with CopilotВидеоMaking Your Data Stand Out with CopilotВидео

Excel Interface and basic features

Navigating Excel: Getting Started with the InterfaceВидеоUnderstanding Data Types in ExcelВидеоHow to Convert Data Types in ExcelВидеоEffective Techniques for Working with Data TypesВидеоMastering Data Types for Better AnalysisВидеоCheckpoint QuizЗадание
03Excel Productivity: Formulas, Data Preparation & Copilot Prompting47 материалов

Excel Formulas and functions

Mastering Basic Arithmetic Functions in ExcelВидеоApplying Mathematical Functions for Complex CalculationsВидеоMastering Logical Functions in ExcelВидеоMastering Logical & Lookup Functions for Complex AnalysisЧтениеCheckpoint QuizЗаданиеAdvanced Data Analysis with Logical & Lookup FunctionsВидеоLeveraging Conditional & Time Functions for Smarter Excel ModelsВидеоMastering Nested Functions for Complex CalculationsВидеоCheckpoint QuizЗаданиеProficiency QuizЗадание

Basic Data Entry and formatting with Copilot

Mastering Data Entry Techniques in ExcelВидеоHow to Use Data Validation for Error-Free Data EntryВидеоHands-on Activity: Practicing Data Entry TechniquesВидеоEffective Techniques for Accurate Data EntryЧтениеMastering Data Formatting in ExcelВидеоCheckpoint QuizЗадание

Introduction to prompt engineering for Copilot in Excel

Crafting Effective Prompts for Excel CopilotВидеоAdvanced Prompt Engineering for Maximum Copilot EfficiencyВидеоHands-on: Writing Basic Prompts for CopilotВидеоCrafting Effective Prompts to Enhance Copilot PerformanceВидеоCheckpoint QuizЗаданиеHow to Evaluate Prompt Performance with CopilotВидео

Data preparation and error identification

Cleaning and Processing Data with Copilot in ExcelВидеоCorrecting Data Errors with CopilotВидеоIdentifying Common Data Errors in ExcelВидеоData Error Identification and Troubleshooting in ExcelЧтениеHow to Detect and Correct Errors in DatasetsВидеоCheckpoint QuizЗадание
Checkpoint QuizЗадание
Streamlining Workflows with CopilotВидео
How to Evaluate Copilot's PerformanceВидео
Enhancing Copilot Performance Through CustomizationВидео
Measuring Copilot’s Performance and ImprovementsВидео
Checkpoint QuizЗадание
Proficiency QuizЗадание
Optimizing Excel with Copilot: Smart Calculations, Workflow Automation, and Performance EvaluationDIALOGUE
Proficiency QuizЗадание
AI-Optimized Financial Planning & Workflow Automation SimulationDIALOGUE
SummaryЧтение
Activity: Enhancing Formatting TechniquesВидео
Enhancing Data Presentation for Clear InsightsВидео
Creating Basic Pivot Tables in ExcelВидео
Activity: Advanced Formatting Techniques in ExcelВидео
Checkpoint QuizЗадание
Proficiency QuizЗадание
Optimizing Prompts for Better Results with CopilotВидео
Activity: Evaluating and Improving Prompt Performance with CopilotВидео
Checkpoint QuizЗадание
Proficiency QuizЗадание
Using Copilot to Address Data ErrorsВидео
Correcting Data ErrorsВидео
Transposing Data for Trend AnalysisВидео
Date-time Formatting Techniques for Accurate AnalysisВидео
Checkpoint QuizЗадание
Advanced Excel with Copilot: Functions, Prompt Engineering, and Intelligent Data ProcessingDIALOGUE
Proficiency QuizЗадание
End-to-End AI-Powered Data Analysis & Reporting SimulationDIALOGUE
Congratulations on Completing the Course!Видео