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

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

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

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

Microsoft Excel: Data Analysis with Power Pivot

Курс от Logical Operations
Уровень не указан≈ 5.4 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

We are now living in the age of big data. Data is being collected all the time and for increasingly detailed transactions. This can lead to an overwhelming amount of data, which brings about a need for people who can analyze large amounts of data quickly. Fortunately, Microsoft® Excel® provides Power Pivot to help you organize, manipulate, and report on your data in the best way possible. Since a tool is only as good as the person using it, it is important to gain a solid understanding of Power Pivot to maximize your effectiveness when analyzing data. This material will benefit users of any current Office version. The course environment setup is based on Excel for Office 365. Students taking this course are experienced Excel users who are seeking to advance their data-analysis capabilities by using Power Pivot. In this course, you will: get started with Power Pivot, visualize Power Pivot data, and work with advanced functionality in Power Pivot. This course requires that you have Microsoft Excel installed on a Windows PC. The course setup instructions provided in the first module of the course go into more detail about the hardware and software requirements.

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

Key Performance Indicators (KPIs)Data Analysis Expressions (DAX)Microsoft ExcelData PresentationPerformance ReportingData Visualization SoftwarePivot Tables And ChartsData AnalysisData ManipulationCloud-Based IntegrationTrend AnalysisSpreadsheet SoftwarePerformance MeasurementTime Series Analysis and ForecastingData IntegrationMicrosoft 365Productivity SoftwareData Modeling

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

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

01Getting Started with Power Pivot6 материалов
Getting Started with This CoursePLUGINLesson IntroductionPLUGINEnable and Navigate Power PivotPLUGINManage Data RelationshipsPLUGIN

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

Bill Rosenthal

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

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

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 5.4 ч

4 модулей

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

Часть программы вашего университета
Mastery Builder: Getting Started with Power PivotPLUGIN
Lesson SummaryPLUGIN
02Visualizing Power Pivot Data5 материалов
Lesson IntroductionPLUGINCreate a Power Pivot ReportPLUGINCreate Calculations in Power PivotPLUGINMastery Builder: Visualizing Power Pivot DataPLUGINLesson SummaryPLUGIN
03Working with Advanced Functionality in Power Pivot5 материалов
Lesson IntroductionPLUGINCreate a KPIPLUGINWork with Dates and Time in Power PivotPLUGINMastery Builder: Working with Advanced Functionality in Power PivotPLUGINLesson SummaryPLUGIN
04Completing the Course3 материалов
AppendicesPLUGINCourse SummaryPLUGINCourse AssessmentЗадание