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

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

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

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

Excel Sales Dashboard and Pivot Table

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

О курсе

Learn how to build interactive Excel sales dashboards that transform raw business data into clear visual insights and professional reports. Master Pivot Tables, Pivot Charts, slicers, and dashboard design techniques used for real-world business analysis. This course provides a practical, step-by-step approach to creating professional sales dashboards in Microsoft Excel. You’ll learn how to prepare and structure datasets, analyze sales performance using Pivot Tables, and create visually engaging Pivot Charts that help businesses track KPIs and make informed decisions. As you progress, you’ll build a complete Excel Sales Dashboard from scratch while learning essential dashboard design principles and visualization best practices. The course also demonstrates how to enhance reports using labels, formatting techniques, and interactive slicers that allow users to filter and explore data dynamically. What makes this course unique is its hands-on learning approach using realistic business data and practical reporting scenarios. Instead of focusing only on Excel features, learners develop job-ready skills for creating dashboards used in sales reporting, business performance tracking, and strategic analysis. By the end of the course, you’ll be able to confidently analyze sales data, design interactive dashboards, create impactful visual reports, and deliver actionable business insights using Excel.

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

Excel MacrosAutomationDashboardMicrosoft ExcelPerformance AnalysisStatistical ModelingFinancial AnalysisStatistical AnalysisTrend AnalysisPerformance MetricPredictive ModelingSpreadsheet SoftwareBusiness AnalyticsPresentationsSalesSimulation and Simulation Software

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

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

01Foundations of Advanced Sales Dashboarding19 материалов

Getting Started with Advanced Dashboard Concepts

Introduction to Sales Productivity Dashboard AdvancedВидеоData IntroductionВидеоAdding Formula Data BaseВидеоGetting Started with Advanced Dashboard ConceptsЗадание

Setting Targets and Performance Metrics

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

EDUCBA

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

Excel Sales Dashboard and Pivot Table
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 15.9 ч

6 модулей

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

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

Часть программы вашего университета
Quarter Target and Percentage AchievementВидео
Target YTDВидео
CTC DefinitionВидео
Setting Targets and Performance MetricsЗадание

Data Cleaning and Structuring for Analysis

Remove PartВидеоCTC TaggingВидеоWorking With Core RevenueВидеоData Cleaning and Structuring for AnalysisЗадание

Enhancing Data with Revenue Insights

Adding Core Revenue to Each FactorВидеоConditional FormattingВидеоIndividual Employee ViewВидеоEnhancing Data with Revenue InsightsЗаданиеStructuring Sales Data and Applying Performance Metrics in ExcelDIALOGUEGraded - Foundations of Advanced Sales DashboardingЗаданиеStructuring Sales Data and Building Foundational Dashboard InsightsDIALOGUE
02Building Multi-Dimensional Views17 материалов

Employee-Level Dashboard Design

Individual Employee View ContinuesВидеоDepartment Grid ViewВидеоSales Employee ProfileВидеоEmployee-Level Dashboard DesignЗадание

Regional and Zone-Level Analysis

Zone Grid ViewВидеоData Break MacroВидеоData Break Macro ContinuesВидеоRegional and Zone-Level AnalysisЗадание

Automating Data Management

Delete Sheets MacroВидеоPerformance LinkageВидеоSigma AnalysisВидеоAutomating Data ManagementЗадание

Advanced Performance Evaluation

More on Sigma AnalysisВидеоCore Rev Sigma AnalysisВидеоCTC wise AnalysisВидеоAdvanced Performance EvaluationЗаданиеBuilding Multi-Dimensional ViewsЗадание
03Financial and Pivot-Based Analysis16 материалов

Revenue and Cost-Based Analysis

Core Rev CTC AnalysisВидеоBudgetВидеоBudget ContinuesВидеоRevenue and Cost-Based AnalysisЗадание

Mastering Pivot Tables and Charts

Pivot TableВидеоPivot Table ContinuesВидеоPivot ChartsВидеоMastering Pivot Tables and ChartsЗадание

Data Consolidation and Trend Insights

ConsolidationВидеоTrend AnalysisВидеоMore on Trend AnalysisВидеоData Consolidation and Trend InsightsЗадание

Scenario Analysis with Goal Seek

Goal SeekВидеоObjectives and Distribution of Montecarlo SimulationВидеоScenario Analysis with Goal SeekЗаданиеGraded - Financial and Pivot-Based AnalysisЗадание
04Monte Carlo Simulation & Advanced Modeling13 материалов

Introduction to Simulation Techniques

Advantages of Montecarlo SimulationВидеоNormal Distribution for Montecarlo SimulationВидеоIntroduction to Simulation TechniquesЗадание

Iteration and Simulation Logic

Iteration in Montecarlo SimulationВидеоIteration in Montecarlo SimulationВидеоIteration and Simulation LogicЗадание

Advanced Distribution Modeling

Trigular Distribution in Montecarlo SimulationВидеоTrigular Distribution in Montecarlo Simulation ContinueВидеоAdvanced Distribution ModelingЗадание

Data Structuring for Analysis

Create a Data Analysis with Null MatrixВидеоYear to Year Data AnalysisВидеоData Structuring for AnalysisЗаданиеGraded - Monte Carlo Simulation & Advanced ModelingЗадание
05Business Insights & Statistical Analysis13 материалов

Data Formatting and Ranking Insights

Formatting a Data PieceВидеоTop Ranked Exits AnalysisВидеоData Formatting and Ranking InsightsЗадание

Comparative Business Analysis

Year on Year Exit AnalysisВидеоActive Visavis Inactive AnalysisВидеоComparative Business AnalysisЗадание

Advanced Comparative Insights

Active Visavis Inactive Analysis ContinuesВидеоHistogram AnalysisВидеоAdvanced Comparative InsightsЗадание

Statistical Modeling Techniques

Histogram Analysis ContinuesВидеоRegression AnalysisВидеоStatistical Modeling TechniquesЗаданиеGraded - Business Insights & Statistical AnalysisЗадание
06Dashboard Automation & Presentation14 материалов

Statistical Summaries and Ranking

Rank and PercentileВидеоDescriptive StatisticsВидеоStatistical Summaries and RankingЗадание

Automating Dashboard Outputs

Create Presentation View MacroВидеоDashboard to PPTВидеоAutomating Dashboard OutputsЗадание

Navigation and User Experience

Using Hyper Link in IndexВидеоUsing Hyper Link in Index ContinuesВидеоNavigation and User ExperienceЗадание

Final Dashboard Enhancements

Adding Header to Sales Productivity DashboardВидеоConclusionВидеоFinal Dashboard EnhancementsЗаданиеGraded - Dashboard Automation & PresentationЗаданиеDesigning and Presenting an Advanced Sales Productivity DashboardDIALOGUE