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

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

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

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

Data for Business Analysts Using Microsoft Excel

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

О курсе

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 Business Analyst.  After completing this course, you’ll be able to:  • Identify and explain the steps involved in preparing data for analysis using Excel functions. • Use formula and functions for Data Analysis • Describe how Excel is used in business scenarios for Data Analysis • Apply Excel skills to real-world data preparation tasks.

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

Microsoft ExcelExcel FormulasPivot Tables And ChartsData CleansingSpreadsheet SoftwareData ManipulationData PresentationData AnalysisData SynthesisData Transformation

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

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

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

Welcome to Data for Business Analysts Using Microsoft Excel

Course IntroductionВидеоCourse Syllabus: Data for Business Analysts Using Microsoft ExcelЧтениеHow to be successful in this courseЧтениеPersonalize your learning trackЧтение

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

Microsoft

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

Data for Business Analysts Using Microsoft Excel
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 23.3 ч

5 модулей

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

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

Часть программы вашего университета
Discussion prompt: Meet and GreetОбсуждение
How to open an image in a new tabЧтение
How to locate your downloaded filesЧтение
Business Analysts and Microsoft ExcelВидео
Additional resources: Accessing Microsoft ExcelЧтение

Creating Workbook Content

Introduction to Microsoft ExcelВидеоEntering and formatting dataВидеоRegional variations in ExcelЧтениеWorking with rows and columnsЧтениеWorking with worksheetsЧтениеExercise: Adding data to a worksheetЧтениеSelf-Review: Adding data to a worksheetЗаданиеExemplar: Adding data to a worksheetЧтениеKnowledge Check: Creating Workbook ContentЗадание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ЧтениеSelf-Review: Sorting DataЗаданиеExemplar: 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ЗаданиеWhat features were new to you and which were most usefulОбсуждениеAdditional resources: Working with blocks of data in ExcelЧтение
02Formula 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: Standardising text-based dataЗаданиеExemplar: Standardising text-based dataЧтениеKnowledge Check: Using functions to clean or standardise 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Задание
04Working with Pivots24 материалов

Creating dynamic blocks using tables

Creating TablesВидеоNaming and Managing TablesВидеоFormatting a tableЧтениеModifying tablesВидеоFormulas in tablesЧтениеActivity: Creating and formatting a tableЗаданиеKnowledge Check: Creating dynamic blocks using tablesЗадание

Creating Pivots

What is a Pivot?ВидеоWorking with PivotTablesВидеоActivity: Creating a PivotTableЗаданиеPivoting the analysisЧтениеCustomizing resultsВидеоActivity: Conducting an analysis using a PivotTableЗаданиеKnowledge Check: Creating Pivots

Advanced Pivots

Using the "Show values as" featureВидеоSlicers and timelinesВидеоGETPIVOTDATA functionЧтениеCalculated fieldsВидеоActivity: Creating a reportЗаданиеKnowledge Check: Advanced PivotsЗаданиеModule Summary: Working with Pivots
05Final project and assessment: Preparing data for analysis with MS Excel7 материалов

Final Project and Assessment

Course Recap: Preparing data for analysis with MS ExcelВидеоAbout the final project and assessmentЧтениеFinal 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Задание

Next Steps

Reflect on LearningОбсуждение
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Чтение
Задание
Видео
Module Quiz: Working with PivotsЗадание
What features were new to you and which were most usefulОбсуждение
Additional Resources: Working with PivotsЧтение