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

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

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

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

Excel Essentials and Beyond

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

О курсе

Dive into "Excel Essentials and Beyond", a comprehensive exploration of Excel, the world's leading spreadsheet tool. This course is thoughtfully crafted for both newcomers to Excel and also for those aiming for mastery. We begin by introducing Excel's robust interface and foundational features, ensuring a firm grasp of data organization techniques. As you advance, you'll delve into data visualization, transforming raw data into captivating stories. The course reveals advanced data manipulation. Explore temporal data handling for data-centric analyses, and harness the power of Excel's dynamic lookup functions. Visualization takes center stage as you learn to craft compelling charts, and the intricacies of Pivot Tables and Charts are demystified, setting the stage for deep data exploration. The concluding modules focus on designing dynamic dashboards, essential for today's decision-makers. By the course's end, you'll be equipped not just to use Excel, but to leverage its vast capabilities for influential data-driven outcomes. Disclaimer: This course is an independent educational resource developed by Board Infinity and is not affiliated with, endorsed by, sponsored by, or officially associated with Microsoft Corporation or any of its subsidiaries or affiliates. This course is not an official preparation material of Microsoft Corporation. All trademarks, service marks, and company names mentioned are the property of their respective owners and are used for identification purposes only.

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

Excel FormulasData CleansingPivot Tables And ChartsInteractive Data VisualizationData ManagementData Visualization SoftwareData AnalysisData PresentationData VisualizationData-Driven Decision-MakingData StorytellingData TransformationDashboardSpreadsheet Software

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

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

01Excel Proficiency Essentials35 материалов

Introduction to Microsoft Excel

What is Microsoft ExcelВидеоWhy Excel is important for any careerВидеоUnderstanding the RibbonВидеоWhat is Worksheet and WorkbookВидеоData Types in ExcelВидео

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

Board Infinity

Instructor

Excel Essentials and Beyond
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 36.7 ч

6 модулей

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

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

Часть программы вашего университета
Further reads on Introduction to ExcelЧтение
Practice Quiz - Introduction to ExcelЗадание
Thinking in Cells: The Logic Behind Excel’s DesignDIALOGUE

Mastering Cell Formatting and Styling in Excel

Format Cells in ExcelВидеоNumber Tab in ExcelВидеоHow to change the font, Font size, Font Colour in ExcelВидеоHow to do Text Alignment and apply border in ExcelВидеоHow to apply format painter in ExcelВидеоLearn more about Mastering Cell Formatting and Styling in ExcelЧтениеPractice Quiz - Mastering Cell Formatting and Styling in ExcelЗадание

Excel Formatting and Cell Reference Techniques

Formatting Text and NumbersВидеоReferences in ExcelВидеоRelative Reference in ExcelВидеоAbsolute Reference in ExcelВидеоMixed Reference in ExcelВидеоLearn more about Excel Formatting and Cell Reference TechniquesЧтениеPractice Quiz - Excel Formatting and Cell Reference TechniquesЗаданиеExcel Proficiency EssentialsDIALOGUE

Excel Data Management and Navigation Strategies

Navigations using ExcelВидеоFlash fillВидеоSorting Data in ExcelВидеоFiltering Data in ExcelВидеоText to Columns in ExcelВидеоLearn more about Excel Data Management and Navigation StrategiesЧтениеPractice Quiz - Excel Data Management and Navigation StrategiesЗаданиеGraded Quiz - Excel Proficiency EssentialsЗаданиеTell us what you think!ЧтениеStructure to Insight: Excel’s Hidden Power in Data PreparationDIALOGUEQuick Course Check-InPLUGINHow Do You Use Excel in Your Daily Work?Обсуждение
02Excel Data Analysis and Visualization31 материалов

Excel Data Enhancement and Visualization Techniques

Remove Duplicates in ExcelВидеоData Validation in ExcelВидеоConditional Formating in ExcelВидеоAdvanced Conditional Formatting with Formulae in ExcelВидеоClear RulesВидеоFurther reads on Excel Data Enhancement and Visualization TechniquesЧтениеPractice Quiz - Data Enhancement and Visualization TechniquesЗадание

Excel Functions for Data Analysis and Calculation

Functions and Formulae in ExcelВидеоSum FunctionВидеоMin FunctionВидеоMax FunctionВидеоCount FunctionВидеоLearn more about Excel Functions for Data Analysis and CalculationЧтение

Excel Advanced Data Analysis and Conditional Logic

Count A FunctionВидеоAverage FunctionВидеоConditionals in ExcelВидеоIf Conditions in ExcelВидеоIf with Or Conditions in ExcelВидеоLearn more about Excel Advanced Data Analysis and Conditional LogicЧтение

Excel Conditional Logic and Specialized Functions

If with And Conditions in ExcelВидеоIFS vs Nested IFВидеоA simple Nested if Conditions in ExcelВидеоIfError Condition in ExcelВидеоSumIF Condition in ExcelВидеоSumIFs Condition in ExcelВидео
03Excel Advanced Functions and Temporal Functions34 материалов

Advanced Excel Functions and Conditional Calculations

CountIF Condition in ExcelВидеоCountIFs Condition in ExcelВидеоAverage IF Condition in ExcelВидеоAverage IFS Condition in ExcelВидеоDate and Time Functions in ExcelВидеоFurther Reads on Advanced Excel Functions and Conditional CalculationsЧтениеPractice Quiz - Advanced Excel Functions and Conditional CalculationsЗаданиеBefore Module 3: Ready to Go Beyond the Basics?Обсуждение

Excel Date and Time Manipulation Techniques

Date FunctionВидеоToday FunctionВидеоNow FunctionВидеоDate Value FunctionВидеоDay FunctionВидеоLearn More About Excel Date and Time Manipulation TechniquesЧтениеPractice Quiz - Excel Date and Time Manipulation Techniques

Excel Date and Time Analysis Toolbox

Month FunctionВидеоYear FunctionВидеоEOMonth FunctionВидеоWeekday Function in ExcelВидеоDatedIF FunctionВидеоLearn More About Excel Date and Time Analysis ToolboxЧтениеExcel Date and Time Analysis Toolbox practice quiz

Advanced Date and Workday Functions in Excel

EDATE FunctionВидеоWorkday FunctionВидеоWorkday.INTL FunctionВидеоNetworkDays FunctionВидеоNetworkDays.INTL FunctionsВидеоLearn more about Advanced Date and Workday Functions in ExcelЧтение

Text Functions

TEXTSPLIT, TEXTBEFORE and TEXTAFTERВидеоTEXTSPLIT (Advanced)ВидеоTEXTBEFORE and TEXTAFTER (Advanced)ВидеоLET & LAMBDAВидео
04Excel Data Manipulation and Advanced Lookups37 материалов

Excel Lookup Techniques and Advanced Data Retrieval

Lookup Functions in ExcelВидеоVlookup in ExcelВидеоHlookup in ExcelВидеоIndex and Match Function in ExcelВидеоIndex FunctionsВидеоFurther reads on Excel Lookup Techniques and Advanced Data RetrievalЧтениеPractice Quiz - Excel Lookup Techniques and Advanced Data RetrievalЗадание

Excel Advanced Lookup Techniques and Dynamic Retrieval

Match FunctionsВидеоIndex and Match FunctionВидеоTwo way LookupВидеоCase Sensitive LookupВидеоLeft LookupВидеоLearn more about Excel Advanced Lookup Techniques and Dynamic RetrievalЧтение

Excel Data Manipulation and Text Techniques

Two Column LookupВидеоClosest MatchВидеоText Functions in ExcelВидеоConcatenate FunctionВидеоLeft FunctionВидеоLearn More About Excel Data Manipulation and Text TechniquesЧтение

Excel Text Manipulation and Cleaning Techniques

Right FunctionВидеоMID FunctionВидеоTRIM FunctionВидеоReplace FunctionВидеоLEN FunctionВидеоLearn More About Excel Text Manipulation and Cleaning TechniquesЧтениеPractice Quiz - Excel Text Manipulation and Cleaning Techniques

Modern Lookups - XLOOKUP

XLOOKUP vs VLOOKUPВидеоXLOOKUP – Match ModeВидеоXLOOKUP vs INDEX/MATCHВидеоXLOOKUP – Dynamic Range ReturnВидеоXLOOKUP – Error HandlingВидео

Dynamic Arrays

UNIQUEВидеоSORT & SORTBYВидеоFILTERВидео
05Excel Data Analysis, Visualization, and Presentation31 материалов

Mastering Excel Data Analysis and Presentation

Find FunctionВидеоRound FunctionВидеоSubtotal FunctionВидеоPivot Tables in ExcelВидеоCreating a Pivot Table and Dragging a fieldВидеоFurther reads on Mastering Excel Data Analysis and PresentationЧтениеRecommended PivotTablesВидеоPractice Quiz - Mastering Excel Data Analysis and PresentationЗадание

Excel Pivot Tables and Visual Data Exploration

Sorting & Filtering in Pivot TableВидеоChanging Summary Calculation in Pivot TableВидеоTwo Dimensionals Pivot TableВидеоSlicer in Pivot TableВидеоCharts in ExcelВидеоLearn More About Excel Pivot Tables and Visual Data ExplorationЧтение

Excel Charting and Visualization Techniques

Creating a Chart in ExcelВидеоSwitch Row/Column for charts in ExcelВидеоLegend Position for Charts in ExcelВидеоData Labels for ChartsВидеоPivot Charts in Excel and its typesВидеоLearn More About Excel Charting and Visualization TechniquesЧтение

Excel Pivot Charts and Advanced Visualizations

Creating a Pivot ChartВидеоFilter Pivot ChartВидеоLines ChartsВидеоModern Charts (Combo, Waterfall, Funnel)ВидеоScatterplotsВидеоHeat mapsВидеоLearn More About Excel Pivot Charts and Advanced Visualizations
06Excel Advanced Data Visualization and Insightful Dashboards33 материалов

Excel Advanced Visualization Techniques

HistogramsВидеоMaps in ExcelВидеоDual Axis ChartsВидеоPie ChartsВидеоBump ChartsВидеоFurther Reads On Excel Advanced Visualization TechniquesЧтениеPractice Quiz - Excel Advanced Visualization TechniquesЗадание

Excel Specialized Charts and Data Analysis

Control chartsВидеоFunnel chartsВидеоPareto chartsВидеоWaterfall chartsВидеоUsage and filtration of data with chartsВидеоLearn More About Excel Specialized Charts and Data AnalysisЧтение

Excel Dashboard Design and Practical Implementation

Dashboarding in ExcelВидеоCase by creating dashboardВидеоLearn More About Excel Dashboard Design and Practical ImplementationЧтениеPractice Quiz - Excel Dashboard Design and Practical ImplementationЗаданиеDashboard Creation Project: Enhancing Data-Driven Decision-Making Задание

Power Query

Power Query – CleanupВидеоPower Query – UnpivotВидеоPower Query – Merge TablesВидео

Data Modeling

Adding Power Pivot to ExcelВидеоRelationships in Data ModelВидеоDAX MeasuresВидеоFact, Dimension & STAR SchemaВидеоCardinality (Many-to-Many) & CROSSFILTER DAXВидео

Automation & AI — Excel Copilot

Office ScriptsВидеоDecision Loops using Office ScriptsВидеоUsing Copilot in ExcelВидеоInsights using CopilotВидео

Capstone Projects

Capstone – Sales Dashboard using CopilotВидеоWhat-If AnalysisВидео
Practice Quiz - Excel Functions for Data Analysis and CalculationЗадание
Practice Quiz - Excel Advanced Data Analysis and Conditional LogicЗадание
SWITCH vs Multiple ConditionsВидео
Learn more about Excel Conditional Logic and Specialized FunctionsЧтение
Practice Quiz - Excel Conditional Logic and Specialized FunctionsЗадание
Graded Quiz - Excel Data Analysis and VisualizationЗадание
Задание
Задание
Practice Quiz - Advanced Date and Workday Functions in ExcelЗадание
Graded Quiz - Excel Advanced Functions and Temporal FunctionsЗадание
Practice Quiz - Excel Advanced Lookup Techniques and Dynamic RetrievalЗадание
Practice quiz- Excel Data Manipulation and Text TechniquesЗадание
Задание
Graded Quiz - Excel Data Manipulation and Advanced LookupsЗадание
Practice Quiz - Excel Pivot Tables and Visual Data ExplorationЗадание
Practice Quiz - Excel Charting and Visualization TechniquesЗадание
Чтение
Practice Quiz - Excel Pivot Charts and Advanced VisualizationsЗадание
Graded Quiz - Excel Data Analysis, Visualization, and PresentationЗадание
Practice Quiz - Excel Specialized Charts and Data AnalysisЗадание