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

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

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

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

Apply Microsoft Excel Fundamentals for Data Analysis

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

О курсе

By the end of this course, learners will be able to navigate the Excel 2016 interface, enter and manage data accurately, apply formulas and functions for calculations, format data for clarity, use logical tools for decision-making, and troubleshoot common Excel errors. This Microsoft Excel 2016 beginner course is designed to help learners build strong spreadsheet skills from the ground up. Starting with Excel basics such as workbooks, worksheets, and the Ribbon, the course gradually progresses into data entry, calculations, formatting, and essential formulas like SUM, AVERAGE, and IF. Learners also gain practical experience through a guided case study that reinforces real-world data handling. What makes this course unique is its structured, hands-on approach that blends concept explanation with practical application and efficiency tips. Built-in shortcuts, logic functions, and error-handling techniques ensure learners not only understand Excel but also work confidently and efficiently. Upon completion, learners will be well-equipped to use Excel for everyday tasks, business reporting, and data analysis, making this course ideal for students, professionals, and anyone looking to strengthen their Excel fundamentals.

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

Microsoft ExcelExcel FormulasData EntryData ManipulationData LiteracyDecision MakingSpreadsheet SoftwareProductivity SoftwareMicrosoft OfficeDebuggingData Presentation

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

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

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

First Steps in Excel

OverviewВидеоOpening an Excel WorksheetВидеоRibbons and Quick Access ToolbarВидеоFirst Steps in ExcelЗадание

Understanding the Excel Workspace

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

EDUCBA

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

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

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 7 ч

3 модулей

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

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

Часть программы вашего университета
Ribbons and Quick Access Toolbar continuedВидео
Case StudyВидео
Understanding the Excel WorkspaceЗадание

Entering Data Like a Pro

Data entry in excelВидеоData entry in excel continuedВидеоPopulating the Case Study in ExcelВидеоEntering Data Like a ProЗаданиеExploring the Excel Interface and Entering Data with ConfidenceDIALOGUEGraded - Getting Started with Excel FoundationsЗаданиеGuiding a New User Through Excel Basics and Data EntryDIALOGUE
02Working with Data and Formulas12 материалов

Excel Calculations Made Easy

CalculationsВидеоFormulas- SUM MAX MIN AVERAGEВидеоFormulas continuedВидеоExcel Calculations Made EasyЗадание

Formatting for Clarity

Formatting- Number FormatsВидеоFormatting Table formatsВидеоUpdating a CalculationВидеоFormatting for ClarityЗадание

Smart Formulas and Logic

Percentage and Absolute referencesВидеоConditional FormattingВидеоSmart Formulas and LogicЗаданиеGraded - Working with Data and FormulasЗадание
03Efficiency, Logic, and Troubleshooting13 материалов

Making Decisions in Excel

IF FunctionВидеоShortcuts in excelВидеоMaking Decisions in ExcelЗадание

Navigating Excel Faster

Shortcuts- NavigationВидеоShortcuts- Workbook BasicsВидеоShortcuts- SelectionВидеоNavigating Excel FasterЗадание

Power User Tips & Error Handling

Shortcuts- Working with DataВидеоShortcuts- FormulaВидеоCommon errorsВидеоPower User Tips & Error HandlingЗаданиеGraded - Efficiency, Logic, and TroubleshootingЗаданиеSupporting a Colleague to Build, Analyze, and Fix an Excel WorkbookDIALOGUE