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

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

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

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

Data Analysis and Visualization with Generative AI in Excel

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

О курсе

In this course, it is necessary to have access to Microsoft 365 with Copilot enabled, although no prior experience with Copilot is needed. You'll explore how to use Copilot Pro and Microsoft 365 Copilot in Excel to work with data more efficiently. You'll learn to transform raw data into meaningful insights and eye-catching visualizations, all with the help of AI. You'll cover advanced techniques for manipulating data, generating insights, creating visualizations, and summarizing information using Copilot in Excel. By the end of the course, you'll be able to: • Manipulate and analyze datasets using Copilot in Excel. • Generate valuable insights from a provided dataset. • Create effective data visualizations using natural language prompts with Copilot in Excel. • Synthesize and summarize information into concise, actionable formats. With these skills, you'll be ready to tackle data challenges confidently and enhance your productivity using Excel and AI-powered tools. 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.

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

Microsoft CopilotMicrosoft ExcelExcel FormulasData TransformationForecastingPrompt EngineeringDashboard CreationData ManipulationInteractive Data VisualizationData SynthesisData StorytellingPredictive ModelingSpreadsheet SoftwareData Visualization SoftwareData PresentationData AnalysisData-Driven Decision-Making

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

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

01Data manipulation with Copilot in Excel33 материалов

Course introduction

Introduction to data analysis and visualization with Copilot in ExcelВидеоSetting up Microsoft 365ЧтениеMicrosoft 365 Copilot troubleshooting guideЧтениеActivate Copilot and utilize its capabilities to generate sample dataЧтение

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

Microsoft

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

Data Analysis and Visualization with Generative AI in Excel
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 24.7 ч

5 модулей

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

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

Часть программы вашего университета
Course syllabus: Data analysis and visualization with Copilot in ExcelЧтение
How to be successful in this courseЧтение
Course navigation: Enhanced image viewingЧтение
Course navigation: Locating downloaded filesЧтение
Community discussion: Data analysis and visualization with Copilot in ExcelЧтение

Data cleaning and transformation

Orientation in ExcelВидеоCopilot in Excel: An environment overviewЧтениеIntroducing data types in ExcelВидеоCleaning data in ExcelВидеоActivity: Using Copilot to identify and assign data types in ExcelЗаданиеCase study: Identifying and analyzing data types in Excel with CopilotЧтениеKnowledge check: Data cleaning and transformationЗадание

Filtering and sorting

Sorting and filtering simplified with CopilotВидеоSorting data in ExcelВидеоFiltering data in ExcelЧтениеCleaning and organizing your dataЧтениеActivity: Data cleaning and subsetting with Excel CopilotЗаданиеCase study: Applying best practices for data subsetting with Excel CopilotЧтениеKnowledge check: Filtering and sortingЗадание

Creating calculations and function formulas

Dynamic data formula and function creationВидеоDynamic formulas and conditional logicЧтениеAutomating text splits and formula columnsВидеоConfirm Copilot's outputЧтениеActivity: Implementing a formulaЗаданиеCase study: Formula application with CopilotЧтениеKnowledge check: Formula and function creationЗадание

Module Wrap-up: Data Manipulation with Copilot in Excel

Module summary: Data manipulation with Copilot in ExcelВидеоModule quiz: Data manipulation with Copilot in ExcelЗаданиеAdditional resources: Data manipulation with Copilot in ExcelЧтение
02Insight generation with Copilot31 материалов

PivotTables and data modeling

Introduction to PivotTablesВидеоCreating PivotTables with CopilotВидеоAnalyze data through use of pivot tablesЧтениеActivity: Implementing a PivotTableЗаданиеCase study: Exploring PivotTable insights with CopilotЧтениеKnowledge check: PivotTables and data modelingЗадание

Trend and pattern identification

Data cleaning and real-world pattern findingВидеоAdvanced data cleaning and data preprocessingВидеоPattern detection in sample data setВидеоAdvanced pattern and trend analysisЧтениеHandling missing data with Copilot in ExcelВидеоCommon data errorsЧтение

Cross-source data analysis

Accessing and transforming Word documentsВидеоExtracting data from PowerpointВидеоMulti-source amalgamationЧтениеActivity: Using Copilot to build insights from multiple sourcesЗаданиеCase study: Extracting insights across sources with CopilotЧтениеKnowledge check: Cross-source data analysisЗадание

Predictive analysis and forecasting

Preparing data for accurate forecastingВидеоForecasting in ExcelВидеоAdvanced forecasting techniques in ExcelВидеоUsing Copilot to predict trendsЧтениеActivity: Predicting future salesЗаданиеCase study: Making predictions with CopilotЧтение

Module wrap-up: Insight generation with Copilot

Module summary: Insight generation with CopilotВидеоModule quiz: Insight generation with CopilotЗаданиеAdditional resources: Insight generation with CopilotЧтение
03Data visualization with Copilot in Excel19 материалов

Basic chart creation

Selecting the appropriate chart typeВидеоCustomizing chart elements with Copilot in ExcelВидеоUpdating and refining chartsВидеоVisualization Customization and EnhancementDIALOGUEActivity: Creating a chart in ExcelЗаданиеCase study: Presenting data in ExcelЧтениеKnowledge check: Basic chart creationЗадание

Advanced visualization techniques

Creating a table with CopilotВидеоWorking with multiple tables in ExcelВидеоActivity: Working with dataЗаданиеWalk-through: Real-world multi-table analysisВидеоKnowledge check: Advanced visualization techniquesЗадание

Dashboard creation

Preparing and structuring dashboard dataВидеоSelecting dashboard display typeВидеоAdding interactivity to your dashboardЧтениеKnowledge check: Dashboard creationЗадание

Module wrap-up: Data visualization with Copilot in Excel

Module summary: Data visualization with Copilot in ExcelВидеоModule quiz: Data visualization with Copilot in ExcelЗаданиеAdditional resources: Information summarization and reportingЧтение
04Information summarization and reporting20 материалов

Data synthesis and summarization

Using Copilot to determine the variety of summarization techniquesВидеоUsing Copilot to extract data and summaries from unstructured textВидеоSynthesizing insights from Excel sheetsВидеоActivity: Data synthesis and insights with Copilot in ExcelЗаданиеCase study: Exploring data insights with Copilot in ExcelВидеоKnowledge check: Data synthesis and summarizationЗадание

Executive summary creation

Defining executive summariesВидеоCrafting executive summaries with CopilotЧтениеUsing Copilot to create and refine executive summariesВидеоActivity: Synthesizing insights and summarizing data with CopilotЗаданиеCase study: Analyzing insights with CopilotВидеоKnowledge check: Executive summary creationЗадание

Report and insight generation

An introduction into narrative insightsВидеоUsing Copilot to generate insightsЧтениеDefining report generationВидеоUsing Copilot to craft reportsЧтениеKnowledge check: Report and insight generationЗадание

Module wrap-up: Information summarization and reporting

Module summary: Information summarization and reportingВидеоModule quiz: Information summarization and reportingЗаданиеAdditional resources: Information summarization and reportingЧтение
05Final project and assessment: Data preparation and management11 материалов

Final project: Data Analysis and Visualization with Copilot in Excel

Course recap: Fundamentals of Microsoft 365 CopilotВидеоAbout the final projectЧтениеCourse project: Data analysis and visualization with Copilot in ExcelЧтениеSelf-review: Evaluating an the processed data outputЗаданиеExemplar: Data analysis and visualization with CopilotPLUGIN

Final assessment: Data Analysis and Visualization with Copilot in Excel

About the final assessmentЧтениеCourse quiz: Data analysis and visualization with Copilot in ExcelЗаданиеCoursera communityЧтение

Next Steps

CongratulationsВидеоShowcase your skillsЧтениеNext stepsЧтение
Activity: Working with applied stepsЗадание
Case study: Navigating applied steps in data transformationЧтение
Knowledge check: Trend and pattern identificationЗадание
Knowledge check: Predictive analysis and forecastingЗадание