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

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

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

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

Build Interactive Sales Dashboards in Excel

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

О курсе

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.

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

Performance AnalysisMicrosoft ExcelForecastingDashboardExcel FormulasStatistical AnalysisTrend AnalysisDashboard CreationBusiness AnalysisData VisualizationPerformance MetricAnalysisExcel MacrosPredictive ModelingBusiness ReportingBusiness ModelingProbability & Statistics

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

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

01Foundations of Sales Dashboard Creation15 материалов

Understanding Dashboard Objectives & Data Setup

Introduction to Sales Productivity Dashboard - Beginners TrainingВидеоData Base CreationВидеоUnderstanding Dashboard Objectives & Data SetupЗадание

Building and Structuring the Dataset

Data Base Creation ContinuesВидео

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

EDUCBA

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

Build Interactive Sales Dashboards in Excel
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 15.1 ч

6 модулей

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

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

Часть программы вашего университета
Analysis CTS and Over AchievementВидео
Building and Structuring the DatasetЗадание

Enhancing Data with Formatting & Navigation

Conditional FormattingВидеоCreating IndexВидеоEnhancing Data with Formatting & NavigationЗадание

Designing Interactive Index & Visual Elements

Creating Index ContinuesВидеоIndex - Addinf PictureВидеоDesigning Interactive Index & Visual ElementsЗаданиеStructuring Data & Designing an Interactive Dashboard IndexDIALOGUEFoundations of Sales Dashboard CreationЗаданиеDesigning the Foundation of a Sales Productivity DashboardDIALOGUE
02Core Business & Performance Analysis13 материалов

Business Insights & Analytical Thinking

Business AnalysisВидеоMore on Business AnalysisВидеоBusiness Insights & Analytical ThinkingЗадание

Understanding Performance Drivers

Working with Achievement FactoryВидеоWorking with CTC FactorВидеоUnderstanding Performance DriversЗадание

Location-Based Performance Analysis

Location AnalysisВидеоAnalyse Zon and StateВидеоLocation-Based Performance AnalysisЗадание

Data Consolidation Techniques

ConsolidationВидеоConsolidation ContinuesВидеоData Consolidation TechniquesЗаданиеCore Business & Performance AnalysisЗадание
03Advanced Metrics & Trend Analysis13 материалов

Multi-Level Consolidation & YTD Analysis

Consolidation of StateВидеоConsolidation - YTDВидеоMulti-Level Consolidation & YTD AnalysisЗадание

Workforce Demographics & Growth Metrics

Tenure and Age GroupВидеоCAGRВидеоWorkforce Demographics & Growth MetricsЗадание

Trend Calculations & Forecasting Basics

CAGR ContinueВидеоMoving AverageВидеоTrend Calculations & Forecasting BasicsЗадание

Advanced Trend Analysis Techniques

Moving Average ContinueВидеоMore on Moving AverageВидеоAdvanced Trend Analysis TechniquesЗаданиеAdvanced Metrics & Trend AnalysisЗадание
04Statistical Analysis & Exit Insights13 материалов

Understanding Variability with Standard Deviation

Standard DeviationВидеоStandard Deviation ContinuesВидеоUnderstanding Variability with Standard DeviationЗадание

Visualizing Statistical Insights

Standard Deviation - State and ZoneВидеоStandard Deviation - ChartВидеоVisualizing Statistical InsightsЗадание

Employee Exit Analysis

Exit AnalysisВидеоMore on Exit AnalysisВидеоEmployee Exit AnalysisЗадание

Exit Data & Growth Evaluation

EA - List of Leaving EmployeesВидеоGrowth RatiosВидеоExit Data & Growth EvaluationЗаданиеStatistical Analysis & Exit InsightsЗадание
05Scenario Building & Workforce Profiling13 материалов

Scenario Planning & Workforce Diversity

Create ScenarioВидеоGender LinkageВидеоScenario Planning & Workforce DiversityЗадание

Sales Employee Profiling

Sales Employee ProfileВидеоSales Employee Profile ContinuesВидеоSales Employee ProfilingЗадание

Compensation & Department Insights

SEP - Working with CTCВидеоDepartment ProfileВидеоCompensation & Department InsightsЗадание

Department Performance & Achievement Tracking

Department Profile ContinuesВидеоAchievement StatusВидеоDepartment Performance & Achievement TrackingЗаданиеScenario Building & Workforce ProfilingЗадание
06Predictive Analytics & Advanced Tools15 материалов

Regional Insights & Zone Performance

Zone ProfileВидеоMore on Zone ProfileВидеоRegional Insights & Zone PerformanceЗадание

Trend Prediction & Forecast Modeling

Working with Trend PredictionВидеоTrend Prediction - Working with FormulasВидеоTrend Prediction & Forecast ModelingЗадание

Generational Analysis & Trends

Generation AnalysisВидеоGeneration Analysis ContinuesВидеоGenerational Analysis & TrendsЗадание

Advanced Analysis Tools & Navigation

Generation Analysis - Month on Month AnalysisВидеоAdvanced FilterВидеоHyperlinksВидеоAdvanced Analysis Tools & NavigationЗаданиеPredictive Analytics & Advanced ToolsЗаданиеBuilding and Presenting a Sales Productivity DashboardDIALOGUE