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

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

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

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

Master Microsoft Excel: Apply, Analyze & Visualize Data

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

О курсе

Master Microsoft Excel: Apply, Analyze & Visualize Data is a beginner-friendly course designed to help you build practical Excel skills for organizing, analyzing, and presenting data with confidence. Whether you are a student, professional, or anyone looking to improve spreadsheet proficiency, this course provides a structured path from Excel fundamentals to advanced data analysis and visualization. You will begin by exploring the Excel interface, worksheets, cells, and file management before learning professional formatting techniques, custom styles, and advanced number formatting. As you progress, you will apply mathematical operations, build formulas using the IF function, and use essential functions such as SUM, COUNT, AVERAGE, MAX, MIN, and their conditional variants to automate calculations and support data-driven decisions. The course also covers data organization with tables, filtering, conditional formatting, freeze panes, and print layouts, followed by PivotTables, interactive charts, and troubleshooting common Excel errors to improve reporting accuracy. What makes this course unique is its practical, step-by-step learning approach that combines foundational concepts with hands-on examples and real-world scenarios. By the end of the course, you will be able to manage datasets efficiently, analyze information with confidence, create professional data visualizations, and produce reliable business reports using Microsoft Excel.

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

Microsoft ExcelExcel FormulasFile ManagementPivot Tables And ChartsBusinessInformation ManagementDebuggingBusiness ManagementInteractive Data VisualizationManagement ReportingAnalysisData ManagementBusiness ReportingDesignSpreadsheet SoftwareData VisualizationFile I/OData Analysis

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

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

01Getting Started with Excel11 материалов

Exploring the Interface

Accessing MS ExcelВидеоMS Excel Startup ScreenВидеоUnderstanding the RibbonВидеоExploring the InterfaceЗадание

Working with Worksheets

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

EDUCBA

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

Master Microsoft Excel: Apply, Analyze & Visualize Data
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 11.7 ч

4 модулей

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

Субтитры: Дари, Пушту

Часть программы вашего университета
Cells in ExcelВидео
Worksheet EssentialsВидео
Saving the FileВидео
Working with WorksheetsЗадание
Navigating Excel’s Interface and Worksheets for Productive Data WorkDIALOGUE
Graded - Getting Started with ExcelЗадание
Confidently Navigating Excel: Building Your First Structured WorkbookDIALOGUE
02Formatting & Customization8 материалов

Formatting Basics

Formatting CellsВидеоCustom Cell StylesВидеоFormatting BasicsЗадание

Advanced Formatting

Custom Number Formatting in ExcelВидеоMore on Custom Number FormattingВидеоCustom Formats of DataВидеоAdvanced FormattingЗаданиеGraded - Formatting & CustomizationЗадание
03Formulas & Functions18 материалов

Mathematical Foundations

The BEDMAS Order of Mathematical OperationsВидеоMathematical Operations without FunctionsВидеоMathematical Operations without Functions ContinuedВидеоMathematical FoundationsЗадание

Logical & Conditional Functions

IF FunctionВидеоMore on IF FunctionВидеоImporting Data and CalculationsВидеоLogical & Conditional FunctionsЗадание

Essential Functions

Working with the Count FunctionВидеоConditional Counts - Count IF FunctionВидеоWorking with the Sum FunctionВидеоFinding the AverageВидеоConditional Average - Average IFS FunctionВидеоFinding the Maximum Value Using the MAX FunctionВидео
04Data Management & Visualization22 материалов

Organizing & Managing Data

Conditional FormattingВидеоMore on Conditional FormattingВидеоWorking with TablesВидеоFormatting TableВидеоFiltering and Sorting of DataВидеоFreeze and SplitВидеоPrinting and Layouts in ExcelВидеоOrganizing & Managing DataЗадание

Pivot Tables & Charts

Pivot TablesВидеоCreating Custom TablesВидеоOrganizing Pivot TablesВидеоColumn ChartВидеоBar ChartВидеоLine ChartВидеоPie ChartВидео

Troubleshooting in Excel

Common Errors in ExcelВидеоMore on Common ErrorsВидеоTroubleshooting in ExcelЗаданиеGraded - Data Management & VisualizationЗаданиеExcel Foundations in Action: Building and Analyzing a Business ReportDIALOGUE
Finding the Minimum Value Using the MINFS FunctionВидео
Determining Proportions and Updating a CalculationВидео
Essential FunctionsЗадание
Graded - Formulas & FunctionsЗадание
Map ChartВидео
Pivot Tables & ChartsЗадание