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

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

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

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

Visualizing Data in Excel

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

О курсе

Raw data buried in rows and columns forces your audience to do mental work before they can act. When numbers sit in plain cells with no visual emphasis, hierarchy, or context, the most important insights get lost in the noise. In this course, you'll move from raw data to polished, decision-ready visuals using only Microsoft Excel. You'll format numbers for immediate impact, build and customize pivot tables and charts, work with text boxes, icons, and images as visual objects, assemble a multi-chart dashboard, set up end-user filtering, and export the finished result to PowerPoint. By the end of this course, you'll be able to produce professional data visualizations in Excel that reduce the mental effort your audience needs to find the insight, draw their attention to what matters most, and present your data in any format from a live spreadsheet to a board-ready PowerPoint slide.

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

Microsoft ExcelData PresentationPivot Tables And ChartsDashboardMicrosoft PowerPointPresentationsData TransformationConsolidationSpreadsheet SoftwareDesign Elements And PrinciplesDashboard CreationData Visualization SoftwareInteractive Data VisualizationData Visualization

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

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

01Recognizing the Value of Data Visualization3 материалов

Why Excel Is a Powerful Data Visualization Tool

Why Excel Is a Powerful Data Visualization ToolВидео

The Three Business Benefits of Visualizing Data

The Three Business Benefits of Visualizing DataВидеоMaking the Case for Visualization in ExcelЗадание
02Formatting Numbers for Visual Impact11 материалов

Putting Data in a Sentence with CONCATENATE

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

Madecraft

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

Visualizing Data in Excel
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 7 ч

6 модулей

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

Часть программы вашего университета
Putting Data in a Sentence with CONCATENATEВидео
Your Number Means Nothing Without a Sentence Around ItЧтение

Making Big Numbers Stand Out

Making Big Numbers Stand OutВидеоThe Number Is There. No One Is Seeing It.DIALOGUE

Using Text Boxes to Support Your Data

Using Text Boxes to Support Your DataВидеоWhen Your Data Needs a Note That Isn't in a CellЧтение

Using Wingdings to Add Visual Symbols

Using Wingdings to Add Visual SymbolsВидеоA Triangle Can Say More Than a NumberЧтение

Enhancing Tables with Conditional Formatting

Enhancing Tables with Conditional FormattingВидеоOne Table, One Chance to Make It Readable.DIALOGUEPutting Numbers to Work on the PageЗадание
03Building Pivot Tables and Charts10 материалов

Building Pivot Tables and Pivot Charts

Building Pivot Tables and Pivot ChartsВидеоRaw Data Is Never Ready to VisualizeЧтениеBuilding and Reading Pivot DataЗадание

Selecting the Right Chart Type

Selecting the Right Chart TypeВидеоThe Data Has a Shape. Does Your Chart Match It?DIALOGUE

Customizing Charts to Match Business Standards

Customizing Charts to Match Business StandardsВидеоYour Chart Does Not Know Your Brand. You Have to Tell It.Чтение

Applying Time-Saving Chart Tricks

Applying Time-Saving Chart TricksВидеоSix Charts, Forty Minutes, and a Meeting That Won't WaitDIALOGUEFrom Raw Data to a Business-Ready ChartЗадание
04Enhancing Spreadsheets with Visual Objects7 материалов

Displaying Key Numbers with Text Boxes

Displaying Key Numbers with Text BoxesВидеоThe Grid Is Optional: Why KPI Cards Belong in Shapes, Not CellsЧтение

Adding Images and Icons to Tell Your Story

Adding Images and Icons to Tell Your StoryВидеоWhen a Logo Replaces a LabelDIALOGUE

Layering Text, Icons, and Charts for Impact

Layering Text, Icons, and Charts for ImpactВидеоEverything Is on the Sheet. Nothing Is Aligned.DIALOGUEBreaking Free from the GridЗадание
05Assembling and Publishing a Data Dashboard10 материалов

Combining Charts onto a Single Dashboard Sheet

Combining Charts onto a Single Dashboard SheetВидеоWhy Scattered Charts Are a Liability, Not a StrategyЧтение

Aligning Charts with Snap to Grid

Aligning Charts with Snap to GridВидеоClose Enough Is Never Good Enough Before a PresentationDIALOGUE

Setting Up End User Filtering

Setting Up End User FilteringВидеоA Filter Is an Invitation, Not a ControlЧтениеLetting Users Explore Your DashboardЗадание

Exporting Your Dashboard to PowerPoint

Exporting Your Dashboard to PowerPointВидеоThe Presentation Is Tomorrow. The Dashboard Doesn't Fit in the Deck.DIALOGUEFrom Charts on Separate Sheets to a Presentation-Ready DashboardЗадание
06Conclusion3 материалов

Applying Your Visualization Skills and Going Further

Applying Your Visualization Skills and Going FurtherВидеоWhat Changes on Monday?DIALOGUEReading the Story Your Data TellsЗадание