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

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

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

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

Master Excel Fundamentals for Data Analysis

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

О курсе

By the end of this course, learners will be able to navigate Microsoft Excel 2019 confidently, apply professional formatting, perform accurate calculations, and analyze data using logical and conditional tools. This Excel 2019 – Beginners Training course is designed for absolute beginners who want to build strong, practical spreadsheet skills from the ground up. Learners start by understanding the Excel interface, worksheets, and file management before progressing to formatting data for clarity and professionalism. The course then introduces mathematical operations, logical functions like IF, and essential number formatting to ensure calculations are accurate and meaningful. Finally, learners develop data analysis skills using functions such as COUNTIF, SUM, AVERAGE, MAX, MINIFS, and visual tools like conditional formatting. What makes this course unique is its step-by-step, concept-first approach, reinforced with practice quizzes and graded assessments that ensure real skill development rather than memorization. Each lesson is aligned with clear learning objectives and real-world use cases, making it ideal for students, professionals, and anyone looking to use Excel effectively for data-driven tasks.

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

Data PresentationData Analysis

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

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

01Getting Comfortable with Excel16 материалов

First Steps into Excel

Accessing MS ExcelВидеоMS Excel Startup ScreenВидеоUnderstanding the RibbonВидеоFirst Steps into ExcelЗадание

Working with Worksheets and Files

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

EDUCBA

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

Master Excel Fundamentals for Data Analysis
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 8.3 ч

3 модулей

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

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

Часть программы вашего университета
Cells in ExcelВидео
Worksheet EssentialsВидео
Saving the FileВидео
Working with Worksheets and FilesЗадание

Making Data Look Professional

Formatting Cells Part 1ВидеоFormatting Cells Part 2ВидеоCustom Cell StylesВидеоCustom Number Formatting in ExcelВидеоMaking Data Look ProfessionalЗаданиеNavigating and Preparing Your First Excel WorkbookDIALOGUEGetting Comfortable with ExcelЗаданиеSet Up a Clean, Professional Excel Workbook for a Team UpdateDIALOGUE
02Calculations and Smart Logic14 материалов

Mastering Numbers and Formats

More on Custom Number FormattingВидеоCustom Formats of Data Part 1ВидеоCustom Formats of Data Part 2ВидеоThe BEDMAS Order of Mathematical OperationsВидеоMastering Numbers and FormatsЗадание

Doing Calculations Without Functions

Mathematical Operations without FunctionsВидеоMathematical Operations without Functions ContinuedВидеоIF FunctionВидеоMore on IF FunctionВидеоDoing Calculations Without FunctionsЗадание

Bringing Data into Excel

Importing Data and CalculationsВидеоWorking with the Count FunctionВидеоBringing Data into ExcelЗаданиеCalculations and Smart LogicЗадание
03Data Analysis Made Easy15 материалов

Conditional Calculations

Conditional Counts - Count IF FunctionВидеоWorking with the Sum Function Part 1ВидеоWorking with the Sum Function Part 2ВидеоConditional CalculationsЗадание

Understanding Averages and Extremes

Finding the AverageВидеоConditional Average - Average IFS FunctionВидеоFinding the Maximum Value Using the MAX FunctionВидеоUnderstanding Averages and ExtremesЗадание

Visual Insights and Smart Formatting

Finding the Maximum Value Using the MINFS FunctionВидеоDetermining Proportions and Updating a CalculationВидеоConditional FormattingВидеоMore on Conditional FormattingВидеоVisual Insights and Smart FormattingЗаданиеData Analysis Made EasyЗадание
Analyze, Format, and Present Data Using Excel 2019DIALOGUE