Wenn Sie sich für diesen Kurs anmelden, werden Sie auch für diese Spezialisierung angemeldet.
Lernen Sie neue Konzepte von Branchenexperten
Gewinnen Sie ein Grundverständnis bestimmter Themen oder Tools
Erwerben Sie berufsrelevante Kompetenzen durch praktische Projekte
Erwerben Sie ein Berufszertifikat zur Vorlage
In diesem Kurs gibt es 5 Module
This course focuses on data cleaning and processing using Copilot in Excel. It empowers you to identify and correct data errors, handle missing values and duplicates, and standardize data types. You will explore advanced text manipulation, column operations, and external data integration, leveraging Copilot for efficient data transformation. Additionally, you will design structured data workflows by developing effective prompts for Copilot, enabling you to pose clear questions that guide your analysis. Through practical modules, you’ll develop skills in data organization, error identification, and cleaning strategies. By the end of this course, you will enhance data accuracy and reliability, ensuring your datasets are analysis-ready. Elevate your data processing capabilities and gain a competitive edge in data-driven decision-making.
By the end of the course, you’ll be able to:
- Identify and address common data errors using Copilot in Excel.
- Apply comprehensive data cleaning techniques to prepare datasets for analysis.
- Manipulate and transform data efficiently with Copilot.
- Implement data organization strategies for improved analysis readiness.
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.
This module introduces basic data preparation techniques and error identification methods using Copilot in Excel. You will learn to identify and address common data errors and transform data for analysis.
Das ist alles enthalten
13 Videos13 Lektüren5 Aufgaben
Infos zu Modulinhalt anzeigen
13 Videos•Insgesamt 82 Minuten
Introduction to data cleaning and processing with Copilot in Excel •4 Minuten
Hands-on activity debrief: Data error correction with Copilot in Excel•6 Minuten
Hands-on activity debrief: Identifying errors in datasets•6 Minuten
Using Copilot to address data errors•7 Minuten
Hands-on activity debrief: Correcting data errors•6 Minuten
Transpose data for trends analysis•6 Minuten
Date-time formatting techniques•6 Minuten
Advanced data transformation techniques•7 Minuten
Hands-on activity debrief: Transforming data for analysis•7 Minuten
13 Lektüren•Insgesamt 189 Minuten
Hands-on activity: Data error correction with Copilot in Excel•15 Minuten
Introduction to data cleaning & processing with Copilot in Excel•5 Minuten
Introduction to the Coursera Community•10 Minuten
Getting started with Copilot in Excel •2 Minuten
How to Get Started with Microsoft Copilot•10 Minuten
Guide to performing basic tasks using Copilot in Excel•10 Minuten
Hands-on activity: Activating Copilot•20 Minuten
Common data errors and solutions•7 Minuten
Hands-on activity: Identifying errors in datasets•30 Minuten
Case studies on common data errors•10 Minuten
Hands-on activity: Correcting data errors•30 Minuten
Best practices for data error correction•10 Minuten
Hands-on activity: Transforming data for analysis•30 Minuten
5 Aufgaben•Insgesamt 57 Minuten
Quiz: Performing basic tasks using Copilot in Excel•12 Minuten
Quiz: Common data errors•6 Minuten
Quiz: Data error correction •3 Minuten
Quiz: Data transformation•6 Minuten
Quiz: Data preparation and error identification•30 Minuten
Handling missing values and duplicates
Modul 2•3 Stunden abzuschließen
Moduldetails
In this module, you’ll develop essential skills in data preparation using Copilot in Excel. You’ll focus on identifying and addressing missing values, removing duplicates, and applying both manual and automated imputation techniques. Through videos, readings, hands-on activities, and quizzes, you’ll gain practical experience in ensuring data integrity and readiness for analysis. By the end of the module, you’ll be proficient in transforming raw data into reliable datasets ready for meaningful analysis.
Das ist alles enthalten
6 Videos5 Lektüren4 Aufgaben
Infos zu Modulinhalt anzeigen
6 Videos•Insgesamt 44 Minuten
Handling missing values: An overview•7 Minuten
Hands-on activity debrief: Handling missing values in datasets •8 Minuten
Techniques for removing dataset duplicates•7 Minuten
Hands-on activity debrief: Removing duplicates in datasets•7 Minuten
Quiz: Handling missing values and duplicates•30 Minuten
Data type conversion and standardization
Modul 3•3 Stunden abzuschließen
Moduldetails
This module focuses on converting and standardizing data types using Copilot in Excel, ensuring consistency and accuracy in datasets. You will learn to convert data to the desired formats and standardize data for analysis.
Das ist alles enthalten
6 Videos5 Lektüren4 Aufgaben
Infos zu Modulinhalt anzeigen
6 Videos•Insgesamt 42 Minuten
Data type conversion techniques•7 Minuten
Hands-on activity debrief: Practicing data type conversion •8 Minuten
Standardizing data in Excel•7 Minuten
Hands-on activity debrief: Standardizing data practice•7 Minuten
Data normalization techniques•7 Minuten
Hands-on activity debrief: Data normalization practice•6 Minuten
5 Lektüren•Insgesamt 110 Minuten
Advanced data conversion techniques•10 Minuten
Hands-on activity: Practicing data type conversion•30 Minuten
Hands-on activity: Standardizing data practice•30 Minuten
Normalization methods in Excel•10 Minuten
Hands-on activity: Data normalization practice•30 Minuten
4 Aufgaben•Insgesamt 39 Minuten
Quiz: Data type conversion•3 Minuten
Quiz: Data standardization•3 Minuten
Quiz: Data normalization•3 Minuten
Quiz: Data type conversion and standardization •30 Minuten
Text manipulation and column operations
Modul 4•3 Stunden abzuschließen
Moduldetails
This module covers techniques for manipulating text data and performing column operations using Copilot in Excel, ensuring efficient data organization and improved readability.
Das ist alles enthalten
8 Videos4 Lektüren4 Aufgaben
Infos zu Modulinhalt anzeigen
8 Videos•Insgesamt 49 Minuten
Text manipulation in Excel•5 Minuten
Text manipulation in large datasets•6 Minuten
Hands-on activity debrief: Practicing text manipulation•8 Minuten
Hands-on activity: Advanced text manipulation practice•30 Minuten
4 Aufgaben•Insgesamt 48 Minuten
Quiz: Text manipulation•9 Minuten
Quiz: Column operations•6 Minuten
Quiz: Advanced text manipulation•3 Minuten
Quiz: Text manipulation and column operations•30 Minuten
Prompt development for data analysis workflow
Modul 5•4 Stunden abzuschließen
Moduldetails
This module focuses on designing structured and logical data analysis workflows by developing effective prompts for Copilot in Excel. You will learn to pose clear and precise questions to Copilot to guide their data analysis processes.
Das ist alles enthalten
5 Videos6 Lektüren3 Aufgaben1 peer review
Infos zu Modulinhalt anzeigen
5 Videos•Insgesamt 40 Minuten
Data workflows in action •7 Minuten
Hands-on activity debrief: Structuring workflows with prompts•9 Minuten
Optimizing prompts for improved data workflows •7 Minuten
Hands-on activity debrief: Optimizing data analysis workflows•8 Minuten
Cumulative project debrief: Data processing•10 Minuten
6 Lektüren•Insgesamt 93 Minuten
Understanding data workflows•7 Minuten
Hands-on activity: Structuring workflows with prompts•30 Minuten
Discussion: Optimizing data workflows with prompts•10 Minuten
Mastering prompting: Best practices for efficient data workflows using Copilot in Excel•6 Minuten
Hands-on activity: Optimizing data analysis workflows•30 Minuten
Cumulative project: Discussion•10 Minuten
3 Aufgaben•Insgesamt 42 Minuten
Quiz: Structuring data analysis workflows•6 Minuten
Practice quiz: Prompt optimization for data analysis workflows•6 Minuten
Quiz: Prompt development for data analysis workflow•30 Minuten
1 peer review•Insgesamt 60 Minuten
Cumulative project: Data processing •60 Minuten
Erwerben Sie ein Karrierezertifikat.
Fügen Sie dieses Zeugnis Ihrem LinkedIn-Profil, Lebenslauf oder CV hinzu. Teilen Sie sie in Social Media und in Ihrer Leistungsbeurteilung.
Our goal at Microsoft is to empower every individual and organization on the planet to achieve more.
In this next revolution of digital transformation, growth is being driven by technology. Our integrated cloud approach creates an unmatched platform for digital transformation. We address the real-world needs of customers by seamlessly integrating Microsoft 365, Dynamics 365, LinkedIn, GitHub, Microsoft Power Platform, and Azure to unlock business value for every organization—from large enterprises to family-run businesses. The backbone and foundation of this is Azure.
Do I need prior Excel or data analysis experience for this course?
No prior experience is required. The course is designed for beginners and introduces data cleaning and processing concepts step-by-step using Excel and Copilot.
What tools will I use in this course?
You’ll use Microsoft Excel and Copilot in Excel to clean, organize, transform, and prepare datasets for analysis.
What will I be able to do after completing this course?
You’ll be able to identify data errors, clean and organize datasets, transform data efficiently, and prepare analysis-ready data using Copilot-assisted workflows.
When will I have access to the lectures and assignments?
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I subscribe to this Specialization?
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.
Is financial aid available?
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.
Finanzielle Unterstützung verfügbar, weitere Informationen
¹ Einige Aufgaben in diesem Kurs werden mit AI bewertet. Für diese Aufgaben werden Ihre Daten in Übereinstimmung mit Datenschutzhinweis von Courseraverwendet.