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

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

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

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

Work Smarter with Microsoft Excel

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

О курсе

This course is intended for learners with some experience using Microsoft Windows, who are seeking to build presentation skills with Microsoft Excel. To be successful in this course you should have an understanding of the basics of using a Windows-based computer. Experience with printing and using a web browser are an asset, but not required. Knowing how to use Microsoft Office products is essential in any professional setting. Whether you want to expand your expertise to apply for a new role, start your own business, or simply develop a new personal skill this course is for you. This course will introduce you to Microsoft’s powerful and easy-to-use spreadsheet program, which provides you with an extensive set of tools to organize, analyze, present, and store data. If you are familiar with Excel’s basic features you can take your skills to the next level. If you are a beginner you will get the opportunity to develop basic Excel skills. In this course, you will become comfortable with creating a new spreadsheet, working with basic formulas and functions, making your spreadsheets look professional and presentable, and saving and printing a spreadsheet. By the end of this course, you will be comfortable creating advanced formulas, analyzing data with functions, analyzing data using functions and PivotTables, working with tables, visualizing data with charts, working with graphical objects, and enhancing workbooks. This course will help you prepare for Exam MO-200: Microsoft Excel (Excel and Excel 2019). You will get opportunities to demonstrate the ability to create and edit a workbook with multiple sheets and use a graphic element to represent data visually. You will also show that you can apply the correct application of the principal features of Excel and complete tasks independently.

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

Microsoft ExcelExcel FormulasData ManagementData Import/ExportSales PresentationSpreadsheet SoftwareExcel MacrosMicrosoft Office

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

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

01Getting started with Excel39 материалов

Welcome to the Course

Introduction to Work Smarter with ExcelВидеоNavigating this courseВидеоCourse syllabus - Work Smarter with ExcelЧтениеHow to be successful in this courseЧтение

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

Microsoft

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

Work Smarter with Microsoft Excel
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 21.8 ч

5 модулей

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

Субтитры: Арабский, Французский, Бенгальский, Узбекский, Украинский, Китайский (Китай), Греческий, Итальянский, Бразильский португальский, Вьетнамский, Нидерландский, Корейский, Немецкий, Пушту, Урду, Русский, Тайский, Индонезийский, Шведский, Турецкий, Азербайджанский, Испанский, Дари, Хинди, Японский, Казахский, Венгерский, Польский

Часть программы вашего университета
How to use the video settings on CourseraЧтение
Share your experience and objectivesОбсуждение

Entry-level: Get started with Excel

Get to know ExcelВидеоCreate a workbookВидеоExcel in your WorldDIALOGUEExercise: Creating workbooksЧтениеSave and share a workbookВидеоGet help in Microsoft ExcelВидеоExercise: Getting help in ExcelЧтениеKnowledge check: Get started with Excel ЗаданиеAdditional resourcesЧтение

Entry-level: Get started with data

Work with dataВидеоExercise: Working with dataЧтениеWork with rows and columnsВидеоExercise: Working with rows and columnsЧтениеKnowledge check: Get started with data Задание

Entry-level: Modifying a worksheet

Format textВидеоExercise: Formatting textЧтениеFormat cellsВидеоRegional number formattingЧтениеExercise: Formatting cellsЧтениеAlign cell contentВидеоExercise: Aligning cell contentЧтениеSearch for and replace dataВидеоExercise: Searching for and replacing dataЧтениеSpell check a worksheetВидеоExercise: Spell checking a worksheetЧтениеKnowledge check: Modifying a worksheet Задание

Entry-level: Printing workbook content

Define the basic page layout for a workbookВидеоExercise: Previewing a workbook before printingЧтениеRefine the page layout and apply print optionsВидеоExercise: Refining the page layout and applying print optionsЧтениеKnowledge check: Printing workbook contentЗаданиеModule summary - Getting started with ExcelВидеоModule quiz: Getting started with ExcelЗадание
02Working with functions31 материалов

Working with formulas and functions

Module introduction - Working with functionsВидеоA closer look at formulas and functionsВидеоExercise: Getting started with formulasЧтениеUsing formulas and functionsВидеоExercise: Using formulas and functionsЧтениеKnowledge check: Working with formulas and functionsЗадание

Sorting and filtering data

Sort and filter DataВидеоExercise: Sort and filter dataЧтениеKnowledge check: Sorting and filtering data Задание

Apply range in Excel

Add range namesВидеоUse range names in formulasВидеоExercise: Using range names in formulasЧтениеKnowledge check: Apply range in ExcelЗадание

Specialized functions

Function categories and syntaxВидеоUsing specialized functionsВидеоExercise: Using specialized functionsЧтениеKnowledge check: Specialized functionsЗаданиеAdditional resourcesЧтение

Text functions

Manage text with functionsВидеоTrim and case text functionsВидеоJoin and transpose text functionsВидеоExercise: Analyzing data using text functionsЧтениеKnowledge check: Text functionsЗаданиеAdditional resourcesЧтение

Logical functions

Logical functions and operatorsВидеоUsing logical functions with conditionsВидеоExercise: Analyzing data using logical functionsЧтениеKnowledge check: Logical functions ЗаданиеModule summary - Working with functionsВидеоModule quiz: Working with functionsЗадание
03Organizing and visualizing data36 материалов

Create and modify tables

Module introduction - Organizing and visualizing dataВидеоCreate tablesВидеоFormat tablesВидеоExercise: Creating and modifying a tableЧтениеModifying tablesВидеоExercise: Modifying tablesЧтениеSubtotal function argumentsЧтениеKnowledge check: Create and modify tables Задание

Table references

Name tables and use structured referencesВидеоDatabase functions and convert to rangeВидеоList of database functionsЧтениеExercise: Using table referencesЧтениеKnowledge check: Table referencesЗадание

Managing large workbooks

Format worksheet tabsВидеоExercise: Formatting worksheet tabsЧтениеManage worksheetsВидеоExercise: Managing worksheetsЧтениеManage the view of worksheets and workbooksВидеоExercise: Managing the view of worksheets and workbooksЧтение

Visualizing data with basic charts

Create chartsВидеоExercise: Creating chartsЧтениеModify and format chartsВидеоExercise: Modifying and formatting chartsЧтениеAdvanced chart elementsВидеоExercise: Create a trendlineЧтениеKnowledge check: Visualizing data with basic charts

Analyzing data

Create a PivotTableВидеоSummarize data in a PivotTableВидеоSummary of DAX categories of functions ЧтениеExercise: Creating PivotTablesЧтениеFiltering data using slicersВидеоExercise: Filtering data using slicersЧтение
04Advanced Excel features28 материалов

Customize the Excel Environment

Customizing formula optionsВидеоExercise: Customizing formula optionsЧтениеCustomize proofing and save optionsВидеоCustomizing proofing and save optionsЧтениеCustomize the ribbon and Quick Access ToolbarВидеоExercise: Customizing the Quick Access ToolbarЧтениеKnowledge check: Customize the Excel environmentЗадание

Customize formula, proofing, and saving options

Conditional formattingВидеоConditional formatting rulesВидеоExercise: Apply conditional formattingЧтениеKnowledge check: Conditional formatting ЗаданиеWhy use conditional formatting?Обсуждение

Enhancing workbooks and manage workbook properties

Customize workbooksВидеоExercise: Customizing workbooksЧтениеManage workbook propertiesВидеоExercise: Managing workbook propertiesЧтениеKnowledge check: Enhancing and managing workbooks Задание

Exporting and sourcing data

Export dataВидеоExercise: Exporting worksheet dataЧтениеUse data sourcesВидеоExercise: Using data sourcesЧтениеKnowledge check: Exporting and sourcing dataЗаданиеModule summary - Advanced Excel featuresВидео

Course wrap-up

Course wrap up - Work Smarter with Microsoft ExcelВидеоCourse quiz: Work Smarter with Microsoft ExcelЗаданиеReflect on learningОбсуждениеNext stepsЧтение
05Hands-on practice using Microsoft Excel4 материалов

Analyze and present data with Excel

The benefits of using Microsoft ExcelОбсуждениеProject introductionВидеоTask 1: Analyze and present data with ExcelВзаимная проверкаHow to submit assignment linkЧтение
Additional resourcesЧтение
Knowledge check: Managing large workbooksЗадание
Задание
Knowledge check: Analyzing data Задание
Module summary - Organizing and visualizing dataВидео
Module quiz: Organizing and visualizing dataЗадание
Module quiz: Advanced Excel featuresЗадание