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

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

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

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
Microsoft Excel for Office 365 (Desktop or Online): Part 1 · LearnSpace
Назад в каталог
courseraБизнес

Microsoft Excel for Office 365 (Desktop or Online): Part 1

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

О курсе

Organizations the world over rely on information to make sound decisions regarding all manner of affairs. But with the amount of available data growing on a daily basis, the ability to make sense of all of that data is becoming more and more challenging. Fortunately, this is where the power of Microsoft® Excel® can help. Excel can help you organize, calculate, analyze, revise, update, and present your data in ways that will help the decision makers in your organization steer you in the right direction. It will also make these tasks much easier for you to accomplish, and in much less time, than if you used traditional pen-and-paper methods or non-specialized software. This course aims to provide you with a foundation for Excel knowledge and skills, which you can build upon to eventually become an expert in data manipulation. Note: Most Office users perform the majority of their daily tasks using the desktop version of the Office software, so that is the focus of this training. The course material will also enable you to access and effectively utilize many web-based resources provided with your Microsoft 365 subscription. This includes brief coverage of key skills for using Excel for the Web and OneDrive. Helpful notes throughout the material alert you to cases where the online version of the application may function differently from the primary, desktop version. This course may be a useful component in your preparation for the Microsoft Excel (Microsoft 365 Apps): Exam MO-210 and Microsoft Excel Expert (Microsoft 365 Apps): Exam MO-211 certification exams. This course is intended for students who wish to gain the foundational understanding of Excel that is necessary to create and work with electronic spreadsheets. In this course, you will: familiarize yourself with Excel's layout, its various parts, its commands, and its terminology; outline Excel's abilities to quickly, efficiently, and accurately calculate data; update worksheets without throwing away all of the valuable work you've already done; format a worksheet and organize your data; print workbooks; and manage the overall structure of your workbooks. This course requires that you have Microsoft Excel installed on a Windows PC. The course setup instructions provided in the first module of the course go into more detail about the hardware and software requirements.

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

Excel FormulasMicrosoft ExcelOrganizational SkillsDocument ManagementProductivity SoftwareSpreadsheet SoftwareData EntryEditingFile ManagementAnalysisMicrosoft 365User Interface (UI)Data LiteracyData ManagementData CleansingData Maintenance

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

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

01Getting Started with Excel26 материалов
Data Files and Setup for This CoursePLUGINCourse InformationPLUGINLesson IntroductionPLUGINTopic A: Navigate the Excel User InterfacePLUGIN

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

Bill Rosenthal

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

Microsoft Excel for Office 365 (Desktop or Online): Part 1
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 12.9 ч

7 модулей

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

Часть программы вашего университета
1A-1: ReadingPLUGIN
1A-2: ActivityPLUGIN
Topic 1B: Use Excel CommandsPLUGIN
1B-1: ReadingPLUGIN
1B-2: ActivityPLUGIN
1B-3: ReadingPLUGIN
1B-4: ActivityPLUGIN
Topic C: Create and Save a Basic WorkbookPLUGIN
1C-1: ReadingPLUGIN
1C-2: GuidelinesPLUGIN
1C-3: ReadingPLUGIN
1C-4: ActivityPLUGIN
1C-5: ReadingPLUGIN
1C-6: ActivityPLUGIN
Topic D: Navigate in Excel for the WebPLUGIN
1D-1: ReadingPLUGIN
1D-2: ActivityPLUGIN
1D-3: ActivityPLUGIN
Topic E: Enter Cell DataPLUGIN
1E-1: ReadingPLUGIN
1E-2: ActivityPLUGIN
Lesson SummaryPLUGIN
02Performing Calculations12 материалов
Lesson IntroductionPLUGINTopic A: Create Worksheet FormulasPLUGIN2A-1: ReadingPLUGIN2A-2: ActivityPLUGINTopic B: Insert FunctionsPLUGIN2B-1: ReadingPLUGIN2B-2: ActivityPLUGINTopic C: Reuse Formulas and FunctionsPLUGIN2C-1: ReadingPLUGIN2C-2: ActivityPLUGINMastery Builder: Creating and Reusing Formulas and FunctionsPLUGINLesson SummaryPLUGIN
03Modifying a Worksheet14 материалов
Lesson IntroductionPLUGINTopic A: Adjust Cells, Columns, and RowsPLUGIN3A-1: ReadingPLUGIN3A-2: ActivityPLUGINTopic B: Search for and Replace DataPLUGIN3B-1: ReadingPLUGIN3B-2: ActivityPLUGINTopic C: Use Proofing and Research ToolsPLUGIN3C-1: ReadingPLUGIN3C-2: GuidelinesPLUGIN3C-3: ActivityPLUGIN3C-4: ActivityPLUGINMastery Builder: Modifying a WorksheetPLUGINLesson SummaryPLUGIN
04Formatting a Worksheet19 материалов
Lesson IntroductionPLUGINTopic A: Apply Text FormatsPLUGIN4A-1: ReadingPLUGIN4A-2: ActivityPLUGINTopic B: Apply Number FormatsPLUGIN4B-1: ReadingPLUGIN4B-2: ActivityPLUGINTopic C: Align Cell ContentsPLUGIN4C-1: ReadingPLUGIN4C-2: ActivityPLUGINTopic D: Apply Colors, Borders, and StylesPLUGIN4D-1: ReadingPLUGIN4D-2: ActivityPLUGIN4D-3: ActivityPLUGINTopic E: Apply Basic Conditional FormattingPLUGIN4E-1: ReadingPLUGIN4E-2: ActivityPLUGINMastery Builder: Formatting a WorksheetPLUGINLesson SummaryPLUGIN
05Printing Workbooks12 материалов
Lesson IntroductionPLUGINTopic A: Preview and Print a WorkbookPLUGIN5A-1: ReadingPLUGIN5A-2: ActivityPLUGINTopic B: Set Up the Page LayoutPLUGIN5B-1: ReadingPLUGIN5B-2: ActivityPLUGINTopic C: Configure Headers and FootersPLUGIN5C-1: ReadingPLUGIN5C-2: ActivityPLUGINMastery Builder: Printing WorkbooksPLUGINLesson SummaryPLUGIN
06Managing Workbooks12 материалов
Lesson IntroductionPLUGINTopic A: Manage WorksheetsPLUGIN6A-1: ReadingPLUGIN6A-2: ActivityPLUGINTopic B: Manage Workbook and Worksheet ViewsPLUGIN6B-1: ReadingPLUGIN6B-2: ActivityPLUGINTopic C: Manage Workbook PropertiesPLUGIN6C-1: ReadingPLUGIN6C-2: ActivityPLUGINMastery Builder: Managing WorkbooksPLUGINLesson SummaryPLUGIN
07Completing the Course7 материалов
Course SummaryPLUGINAppendix A: Mapping Course Content to Excel (Microsoft 365 Apps): Exam MO-210PLUGINAppendix B: Mapping Course Content to Excel Expert (Microsoft 365 Apps): Exam MO-211PLUGINAppendix C: Microsoft® Excel® Common Keyboard ShortcutsPLUGINAppendix D: Adding Themes and Backgrounds to WorksheetsPLUGINAppendix E: Basic Excel CustomizationPLUGINCourse AssessmentЗадание