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

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

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

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

Excel 365 Fundamentals – Getting Started and Core Skills

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

О курсе

This course features Coursera Coach! A smarter way to learn with interactive, real-time conversations that help you test your knowledge, challenge assumptions, and deepen your understanding as you progress through the course. Learn the core skills needed to navigate and master Microsoft Excel 365 in this comprehensive beginner course. From basic navigation to more advanced formula creation and data analysis, this course is designed to provide you with a solid foundation for using Excel effectively in various contexts. Throughout the course, you'll engage in hands-on exercises that will reinforce the concepts and techniques covered in the lessons. You'll explore how to navigate the Excel interface, customize your workspace, and efficiently create and manage spreadsheets, followed by mastering essential formulas and formatting features. The course journey starts with an introduction to Excel 365 and its online portal, providing you with a user-friendly guide to start working. It then takes you step-by-step through critical tasks like creating spreadsheets, applying functions and formulas, and organizing your data with tables and lists. You'll also learn how to present your findings with charts and apply advanced formatting techniques to enhance the appearance and usability of your worksheets. This course is perfect for beginners with little to no experience in Excel. It is designed for individuals who want to develop their foundational skills in spreadsheet creation, data organization, and basic data analysis. There are no prerequisites, making it ideal for anyone looking to improve their Excel skills from scratch. By the end of the course, you will be able to confidently navigate Excel 365, create spreadsheets, apply formulas, format data, analyze information, and collaborate in real-time with others.

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

Microsoft ExcelSpreadsheet SoftwareExcel FormulasData SharingCollaborative SoftwareMicrosoft TeamsOrganizational SkillsPresentationsData VisualizationMicrosoft 365Data Management

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

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

01Microsoft Excel 365 Beginner – Course Introduction5 материалов

Microsoft Excel 365 Beginner – Course Introduction

Introduction to the SpecializationВидеоIntroduction to the Course 'Excel 365 Fundamentals: Getting Started & Core Skills'ЧтениеFull Specialization ResourcesЧтениеExcel 365 Online PortalВидео

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

Packt - Course Instructors

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

Excel 365 Fundamentals – Getting Started and Core Skills
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 21.1 ч

19 модулей

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

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

Часть программы вашего университета
Microsoft Excel 365 Beginner – Course Introduction ExerciseВидео
02Get Started in Excel 3658 материалов

Get Started in Excel 365

Launch ExcelВидеоExplore the InterfaceВидеоWork with Contextual Menus, Ribbons, and PanesВидеоCustomize the Quick Access ToolbarВидеоKeyboard ShortcutsВидеоGet Started in Excel 365 ExerciseВидеоCustomizing the Excel Interface and Quick Access ToolbarDIALOGUEGet Started in Excel 365 - AssessmentЗадание
03Create an Excel Spreadsheet8 материалов

Create an Excel Spreadsheet

Excel TemplatesВидеоWork with Workbooks and WorksheetsВидеоSave Workbooks to OneDriveВидеоEnter Text, Numbers, and DatesВидеоCustom ListsВидеоCreate an Excel Spreadsheet ExerciseВидеоEfficient Workbook and Worksheet Management in ExcelDIALOGUECreate an Excel Spreadsheet - AssessmentЗадание
04Introduction to Excel Formulas9 материалов

Introduction to Excel Formulas

The Order of Operations (BODMAS Rule)ВидеоA Simple FormulaВидеоThe 'Big 6' FunctionsВидеоAbsolute vs Relative ReferencingВидеоQuick Calculations with AutosumВидеоAuto-Fill and Flash FillВидеоIntroduction to Excel Formulas ExerciseВидеоMastering Excel Formulas: Basics, SUM, and ReferencesDIALOGUEIntroduction to Excel Formulas - AssessmentЗадание
05Use Named Ranges6 материалов

Use Named Ranges

What Are Named Ranges?ВидеоCreate Named RangesВидеоUse Named Ranges in FormulasВидеоUse Named Ranges ExerciseВидеоCreating and Using Named Ranges in ExcelDIALOGUEUse Named Ranges - AssessmentЗадание
06Format Numbers and Cells9 материалов

Format Numbers and Cells

Apply Number FormatsВидеоFormat Cells, Rows, and Columns ManuallyВидеоAutoFormat DataВидеоFind and Replace FormattingВидеоCopy Formatting: Format PainterВидеоClear CellsВидеоFormat Numbers and Cells ExerciseВидеоFormatting Worksheets for Clarity and ReadabilityDIALOGUEFormat Numbers and Cells - AssessmentЗадание
07Excel Tables6 материалов

Excel Tables

Excel Tables ExplainedВидеоFormat Data as an Excel TableВидеоTable References in FormulasВидеоExcel Tables ExerciseВидеоMastering Excel Tables: Converting Data and Using Table ReferencesDIALOGUEExcel Tables - AssessmentЗадание
08Format Worksheets7 материалов

Format Worksheets

Work with Rows and ColumnsВидеоAlign Text and NumbersВидеоMerge Cells vs Center Across SelectionВидеоApply and Modify ThemesВидеоFormat Worksheets ExerciseВидеоFormatting Rows and Columns in Excel: Best PracticesDIALOGUEFormat Worksheets - AssessmentЗадание
09Excel Lists10 материалов

Excel Lists

How to Structure a ListВидеоSort a List: Single-Level SortВидеоSort a List: Multi-Level SortВидеоSort a List: Sort with Custom ListsВидеоFilter a List - Numbers and TextВидеоFilter and Sort by ColorВидеоAdd Subtotals to a ListВидеоExcel Lists ExerciseВидеоMastering Excel Lists: Sorting and Filtering FundamentalsDIALOGUEExcel Lists - AssessmentЗадание
10Move and Link to Data9 материалов

Move and Link to Data

Cut, Copy, and PasteВидеоPaste OptionsВидеоPaste From ClipboardВидеоMove and Copy WorksheetsВидео3D ReferencingВидеоInsert Hyperlinks to WorksheetsВидеоMove and Link to Data ExerciseВидеоEssential Excel: Moving, Copying, and Linking Data Across WorksheetsDIALOGUEMove and Link to Data - AssessmentЗадание
11Introduction to Intermediate Formulas8 материалов

Introduction to Intermediate Formulas

Lookup Functions: VLOOKUP ExplainedВидеоLookup Functions: XLOOKUP ExplainedВидеоLogical Functions: IF, AND, ORВидеоText Functions: PROPER, TRIM, CLEANВидеоTime and Date Functions: TODAY, NOW, WORKDAYВидеоIntroduction to Intermediate Formulas ExerciseВидеоMastering Excel Lookup, Logical, Text, and Date/Time FunctionsDIALOGUEIntroduction to Intermediate Formulas - AssessmentЗадание
12Analyze Data9 материалов

Analyze Data

Quick Analysis ButtonВидеоChoose the Right Chart TypeВидеоPresent Data with ChartsВидеоFormat a ChartВидеоIn-Cell Charts: SparklinesВидеоIn-Cell Charts: The REPT FunctionВидеоAnalyze Data ExerciseВидеоUsing Excel's Quick Analysis and Chart Tools for Data VisualizationDIALOGUEAnalyze Data - AssessmentЗадание
13Conditional Formatting7 материалов

Conditional Formatting

Highlight Cell ValuesВидеоData BarsВидеоColor ScalesВидеоIcon SetsВидеоConditional Formatting ExerciseВидеоMastering Conditional Formatting Visuals in SpreadsheetsDIALOGUEConditional Formatting - AssessmentЗадание
14Insert Pictures and Other Graphics8 материалов

Insert Pictures and Other Graphics

Add Interest with Pictures and IconsВидеоInsert Shapes and Text BoxesВидеоCreate Diagrams Using SmartArtВидеоInsert Screenshots and ClipsВидеоInsert and Respond to Threaded CommentsВидеоInsert Pictures and Other Graphics ExerciseВидеоEnhancing Excel Spreadsheets with Visual Elements and CollaborationDIALOGUEInsert Pictures and Other Graphics - AssessmentЗадание
15Work with Views6 материалов

Work with Views

Workbook Views and ZoomВидеоArrange Workbooks and WorksheetsВидеоFreeze PanesВидеоWork with Views ExerciseВидеоExploring Excel Workbook Views and Window ManagementDIALOGUEWork with Views - AssessmentЗадание
16Prepare for Printing9 материалов

Prepare for Printing

Set Margins and OrientationВидеоSet and Clear the Print AreaВидеоInsert Page BreaksВидеоSet Print Titles and a BackgroundВидеоInsert Headers and FootersВидеоPrint a WorkbookВидеоPrepare for Printing ExerciseВидеоPreparing an Excel Workbook for PrintingDIALOGUEPrepare for Printing - AssessmentЗадание
17Finalizing the Spreadsheet6 материалов

Finalizing the Spreadsheet

Protect Cells, Worksheets, and WorkbooksВидеоInspect the Workbook for IssuesВидеоSave the Workbook in Different FormatsВидеоFinalizing the Spreadsheet ExerciseВидеоProtecting, Inspecting, and Saving Excel WorkbooksDIALOGUEFinalizing the Spreadsheet - AssessmentЗадание
18Excel 365 Online8 материалов

Excel 365 Online

Work with Files in Excel OnlineВидеоShare Workbooks with OthersВидеоCo-Author Workbooks in Real-TimeВидеоAdd an Excel Workbook to Microsoft TeamsВидеоExcel Live: Share a Workbook in a Teams MeetingВидеоExcel 365 Online ExerciseВидеоCollaborating and Sharing Workbooks in Excel OnlineDIALOGUEExcel 365 Online - AssessmentЗадание
19Microsoft Excel 365 Beginner – Conclusion6 материалов

Microsoft Excel 365 Beginner – Conclusion

Microsoft Excel 365 Beginner ConclusionВидеоExcel 365 Skills RecapDIALOGUEConclusion to the Course 'Excel 365 Fundamentals: Getting Started & Core Skills'ЧтениеMicrosoft Excel 365 Beginner – Conclusion - AssessmentЗаданиеFull Course Practice AssessmentЗаданиеFull Course AssessmentЗадание