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

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

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

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

Preparing Data for Analysis with Microsoft Excel

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

О курсе

This course forms part of the Microsoft Power BI Analyst Professional Certificate. This Professional Certificate consists of a series of courses that offers a good starting point for a career in data analysis using Microsoft Power BI. No prior skills are needed to be successful in this course. In this course, you’ll learn how to make use of Excel in business scenarios for data analysis. You’ll also learn how to utilize formulas and functions for data analysis.  Specifically, this course will help you gain knowledge and skills for preparing data for analysis using Microsoft Excel and take you one step closer to becoming a Microsoft Power BI Analyst.  After completing this course, you’ll be able to:  • Create data in Microsoft Excel and prepare it for data analysis.  • Make use of common formulas and functions in a worksheet.  • Prepare Excel data for analysis in Power BI using functions. 

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

Excel FormulasMicrosoft ExcelData AnalysisData ManagementTimelinesData ProcessingData PresentationPower BISpreadsheet SoftwareData CleansingData WranglingData Manipulation

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

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

01Excel fundamentals34 материалов

Welcome to Preparing data for analysis with Microsoft Excel

Introduction to the programВидеоCourse introduction: Preparing data for analysis with Microsoft ExcelВидеоHow to be successful in this courseЧтениеSkills measured in the Microsoft Exam PL300Чтение

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

Microsoft

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

Preparing  Data for Analysis with Microsoft Excel
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 18.6 ч

4 модулей

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

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

Часть программы вашего университета
Day in the lifeВидео
Building Your Data Analysis FoundationDIALOGUE
How to open an image in a new tabЧтение
How to locate your downloaded filesЧтение
Additional resources: Key conceptsЧтение

Introduction to Generative AI

Welcome to Generative AI for everyoneВидеоUnderstanding the Capabilities of Generative AI for Business FunctionsВидеоGenerative AI TerminologyЧтениеGenerative AI - Under the hoodВидеоThe potential pitfalls and shortcomings of GenAIВидеоGeneral Knowledge QuizЗаданиеGenerative AI in BusinessЧтение

Creating workbook content

Introduction to Microsoft ExcelВидеоEntering and formatting dataВидеоRegional variations in ExcelЧтениеWorking with rows and columnsЧтениеWorking with worksheetsЧтениеKnowledge check: Creating workbook contentЗаданиеExercise: Adding data to a worksheetЗаданиеAdditional resources: Creating workbook contentЧтение

Working with blocks of data in Excel

Reading large data blocksВидеоSorting and filtering data in ExcelВидеоExercise: Sorting DataЗаданиеExercise: Filtering dataЧтениеSelf-review: Filtering dataЗаданиеExemplar: Filtering dataЧтениеKnowledge check: Working with blocks of data in ExcelЗаданиеModule summary: Excel fundamentalsВидеоModule quiz: Excel fundamentalsЗаданиеAdditional resources: Working with blocks of data in ExcelЧтение
02Formulas and functions21 материалов

Formulas in Excel

What is a formula?ВидеоControlling calculationsВидеоOrder of precedence in calculationsЧтениеControlling calculations in actionВидеоUseful percentage calculationsЧтениеExercise: Calculating profit and marginЧтениеSelf-Review: Calculating profit and marginЗаданиеExemplar: Calculating profit and marginЧтениеKnowledge check: Formulas in ExcelЗаданиеAdditional resources: Formulas in ExcelЧтение

Getting started with functions

What is a function formula and how to write itВидеоUsing the INSERT functionВидеоThe AutoSum shortcutЧтениеExercise: Preparing a monthly sales reportЧтениеSelf-Review: Preparing a monthly sales reportЗаданиеExemplar: Preparing a monthly sales reportЧтение
03Preparing data for analysis using functions27 материалов

Using functions to clean or standardise text

How inconsistent data can affect data analysisВидеоFunctions which can be used to standardize text dataЧтениеExercise: Standardizing text-based dataЧтениеSelf-review: Standardizing text-based dataЗаданиеExemplar: Standardising text-based dataЧтениеKnowledge check: Using functions to clean or standardize textЗаданиеAdditional resources: Using functions to clean or standardize textЧтение

Date and time functions

Why understanding date calculations is importantВидеоDynamic date and time entriesВидеоOther useful date calculationsЧтениеExercise: Calculating the number of working days remaining in the yearЧтениеSelf-review: Calculating the number of working days remaining in the yearЗаданиеExemplar: Calculating the number of working days remaining in the yearЧтение

Logical functions

Using the IF functionВидеоUsing nested IF and IFS functionВидеоAND and OR functionsЧтениеIF functionsЧтениеExercise: Adding a data column using the IFS functionЧтениеSelf-Review: Adding a data column using the IFS functionЗадание
04Final project and assessment9 материалов

Final project and assessment: Preparing data for analysis with Microsoft Excel

Course recap: Preparing data for analysis with Microsoft ExcelВидеоAbout the final project and assessment: Preparing data for analysis with Microsoft ExcelЧтениеFinal course project: Creating an executive data summaryЧтениеSelf-review: Creating an executive data summaryЗаданиеExemplar: Creating an executive data summaryЧтениеCourse quiz: Preparing data for analysis with MS ExcelЗадание

Wrap-up: Preparing data for analysis with Microsoft Excel

CongratulationsВидеоReflect on learningОбсуждениеNext stepsЧтение
Knowledge check: Getting started with functionsЗадание
Module summary: Formulas and functionsВидео
Module quiz: Formulas and functionsЗадание
What features were new to you and which were most useful?Обсуждение
Additional resources: Getting started with functionsЧтение
Knowledge check: Date and time functionsЗадание
Additional resources: Date and time functionsЧтение
Exemplar: Adding a data column using the IFS functionЧтение
Knowledge check: Logical functionsЗадание
Module summary: Preparing Data for Analysis Using FunctionsВидео
Module quiz: Formulas and functionsЗадание
What features were new to you and which were most usefulОбсуждение
Additional resources: Logical functionsЧтение