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

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

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

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

Business Data Analytics with Excel

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

О курсе

Business Data Analytics with Excel introduces learners to the practical skills needed to organize, analyze, and interpret business data using Microsoft Excel. Through hands-on exercises and realistic business scenarios, learners develop the foundational analytical skills needed to transform raw data into meaningful insights that support informed decision-making. Throughout the course, learners practice organizing and preparing datasets, applying essential Excel formulas and functions, creating charts and visualizations, and using pivot tables to uncover trends and summarize information. They then apply these skills to real-world business scenarios across industries, including customer segmentation for marketing, healthcare trend analysis, retail inventory management, and financial forecasting and risk assessment, gaining experience solving the kinds of analytical challenges organizations face every day. By the end of the course, learners will be prepared to use Excel confidently to analyze business data, uncover actionable insights, and communicate findings that help organizations make smarter, data-driven decisions.

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

Data AnalysisExcel FormulasAnalysisBusiness AnalyticsTrend AnalysisInventory ManagementData VisualizationData CleansingStatisticsDecision MakingData StorytellingData LiteracyRetail Store OperationsProductivityInventory and WarehousingMicrosoft ExcelData PresentationBusiness IntelligenceCustomer AnalysisProblem Solving

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

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

01Data analysis with Excel97 материалов

Welcome to data analysis with Excel

Welcome to data analysis with ExcelЧтениеOverviewЧтениеGet ready to analyze data with ExcelЧтениеScenario: Reflecting on your Excel skillsDIALOGUE

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

Barry Finder

VP of Operations

Business Data Analytics with Excel
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 16.5 ч

2 модулей

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

Часть программы вашего университета
Pause and reflect: Data analysis with Excel DIALOGUE
Excel foundationsЧтение

Organizing data with Excel

Organizing data with ExcelЧтениеKey termsЧтениеData organization and formatting in ExcelЧтениеBenefits of well-structured dataЧтениеOrganizing data in ExcelЧтениеWatch and learnЧтениеKnowledge check: Organizing dataЗаданиеData organization: Format, filter and sortЧтениеSteps for data organization: Format, filter, and sortЧтениеNow you try: Steps for organizing data in ExcelDIALOGUEKey takeawaysЧтение

Practice: Organizing data

Practice: Organizing dataЧтениеReminder: Steps for data organizationЧтениеWalkthrough with an expertЧтениеNow you tryЧтениеDebrief your activity​: Organizing data in ExcelDIALOGUEKey takeawaysЧтение

Essential Excel functions for analysis

Essential Excel functions for analysisЧтениеKey termsЧтениеFormulas versus functions in ExcelЧтениеEssential Excel functions​ЧтениеKey Excel function formulasЧтениеWatch and learnЧтениеKnowledge check: Essential Excel functionsЗаданиеNow you try: Excel function practiceDIALOGUEKey takeawaysЧтение

Practice: Using Excel functions

Practice: Using Excel functionsЧтениеReminder: How key Excel functions workЧтениеWalkthrough with an expertЧтениеNow you tryЧтениеDebrief your activity​: Practicing Excel functionsDIALOGUEKey takeawaysЧтение

Data visualization in Excel

Data visualization in ExcelЧтениеKey termsЧтениеData visualization in ExcelЧтениеUnderstanding chart elements: Axes and legendsЧтениеWatch and learnЧтениеKnowledge check: Excel chart typesЗаданиеCreate and customize charts in ExcelЧтениеCreating and customizing a visualization in ExcelЧтениеNow you try: Selecting and customizing charts in ExcelDIALOGUEKey takeawaysЧтение

Practice: Creating visuals with Excel

Practice: Creating visuals with ExcelЧтениеReminder: Creating and customizing a visualization in ExcelЧтениеWalkthrough with an expertЧтениеNow you tryЧтениеDebrief your activity​: Visualizing monthly sales with Excel chartsDIALOGUEKey takeawaysЧтение

Using conditional formatting for insights

Using conditional formatting for insightsЧтениеKey termsЧтениеIntroducing conditional formattingЧтениеConditional formatting for insightsЧтениеKey features of conditional formattingЧтениеWatch and learnЧтениеKnowledge check: Conditional formatting insightsЗаданиеHow to use conditional formattingЧтениеSteps to use conditional formatting in ExcelЧтениеNow you try: Identifying where to use conditional formattingDIALOGUEKey takeawaysЧтение

Practice: Applying conditional formatting

Practice: Applying conditional formattingЧтениеReminder: Key features of conditional formattingЧтениеWalkthrough with an expertЧтениеReminder: Steps to use conditional formatting in Excel​ЧтениеNow you tryЧтениеDebrief your activity​: Applying conditional formatting in ExcelDIALOGUEKey takeawaysЧтение

Introduction to pivot tables

Introduction to pivot tablesЧтениеKey termsЧтениеPivot tables for summarizationЧтениеHow to use pivot tables for data insightsЧтениеPivot table componentsЧтениеWatch and learnЧтениеKnowledge check: Understanding of pivot tableЗаданиеCreating a pivot tableЧтениеCreating a pivot table in ExcelЧтениеNow you try: Practicing pivot tables for data summarizationDIALOGUEKey takeawaysЧтение

Practice: Building pivot tables

Practice: Building pivot tablesЧтениеReminder: Introduction to pivot tablesЧтениеWalkthrough with an expertЧтениеReminder: Creating a pivot table in ExcelЧтениеNow you tryЧтениеDebrief your activity​: Creating a pivot table for inventory managementDIALOGUEKey takeawaysЧтение

Module summary and assessment: Data analysis with Excel

Module summary and assessment: Data analysis with ExcelЧтениеAssessment: Data analysis with ExcelЗаданиеPart 2: Coursera AIЧтениеDebrief your activity: Excel-driven healthcare data analysisDIALOGUEData analysis functions and tools in ExcelDIALOGUECongratulationsЧтениеWhat you've learned in this module​Чтение
02Applying data analytics in real-world scenarios71 материалов

Welcome to applying data analytics in real-world scenarios

Welcome to Applying data analytics in real-world scenariosЧтениеOverviewЧтениеWhat's your experience with data?​ЧтениеPause and reflect: Applying data analytics in real-world scenariosDIALOGUEData analytics in actionЧтение

Data analytics in business

Data analytics in businessЧтениеKey termsЧтениеUsing data to make better decisions at workЧтениеData analytics drives success​ЧтениеWatch and learnЧтениеKnowledge check: Data-driven business decisions​ЗаданиеCustomer segmentationЧтениеCustomer segmentation criteriaЧтениеApplying customer segmentation techniques​ЧтениеNow you try: Analyzing customer data for targeted marketing campaignsDIALOGUEKey takeawaysЧтение

Practice: Customer segmentation case study

Practice: Customer segmentation case study​ЧтениеReminder: Data analytics in business​ЧтениеWalkthrough with an expertЧтениеNow you try: Customer segmentation for targeted marketingDIALOGUEKey takeawaysЧтение

Data analytics in healthcare

Data analytics in healthcare​ЧтениеKey termsЧтениеData analytics for healthcareЧтениеHow data analytics improves healthcare outcomes​ЧтениеHow Jordan’s clinic uses data to improve patient care​ЧтениеWatch and learnЧтение

Practice: Predicting health trends

Practice: Predicting health trends​ЧтениеReminder: Data analytics for healthcare​ЧтениеWalkthrough with an expertЧтениеNow you tryЧтениеDebrief your activity: Analyzing healthcare data for patient outcomesDIALOGUEKey takeawaysЧтение

Data analytics in retail

Data analytics in retail​​ЧтениеKey termsЧтениеHow data analytics enhances retail​ЧтениеBenefits of data analytics in retail​ЧтениеWatch and learnЧтениеKnowledge check: Data analytics in retailЗаданиеSteps for data analysis for inventory management​

Practice: Inventory management analysis

Practice: Inventory management analysisЧтениеReminder: Data analytics in retail​ЧтениеReminder: Data analytics in retail​ЧтениеWalkthrough with an expertЧтениеNow you try: Using data analytics to improve retail operationsDIALOGUEKey takeawaysЧтение

Data analytics in finance

Data analytics in financeЧтениеKey termsЧтениеApplying financial data analytics in the workplaceЧтениеFinancial data analytics​ЧтениеWatch and learnЧтениеKnowledge check: Financial data analytics​ЗаданиеHow financial data analysis works​

Practice: Analyzing financial data

Practice: Analyzing financial dataЧтениеReminder: Financial data analyticsЧтениеWalkthrough with an expertЧтениеNow you tryЧтениеDebrief your activity: Financial data analysis for risk assessmentDIALOGUEKey takeawaysЧтение

Module summary and assessment: Applying data analytics in real-world scenarios

Module summary and assessment: Applying data analytics in real-world scenariosЧтениеAssessment: Applying data analytics in real-world scenariosЗаданиеPause and reflect: Applying data analytics in real-world scenariosDIALOGUECongratulationsЧтениеWhat you've learned in this module​Чтение
Knowledge check: Role of data and analytics in healthcare​Задание
Now you try: Using data analysis in a healthcare settingDIALOGUE
Key takeawaysЧтение
Чтение
Now you try: Optimizing inventory and personalizing customer experiencesDIALOGUE
Key takeawaysЧтение
Чтение
Now you try: Leveraging financial data analyticsDIALOGUE
Key takeawaysЧтение