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

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

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

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

Excel Foundations: Worksheets, Formatting, and Printing

Курс от John Wiley & Sons
Начальный≈ 17.3 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

Strong spreadsheet skills are essential in today’s data-driven workplace, and Excel remains one of the most widely used productivity tools. This course introduces the core skills required to build, format, and manage professional worksheets, helping you work more efficiently and present data clearly in business and technical environments. Throughout the course, you will learn how to navigate the Excel interface, customize the workspace, and create structured worksheets for organizing data. You will also explore essential formatting techniques that enhance readability and visual clarity, along with editing and proofing tools that help maintain accuracy and consistency. What sets this course apart is its balanced focus on both practical workflows and foundational Excel concepts. By combining step-by-step demonstrations with real-world examples, the course helps you develop the confidence to manage worksheets and prepare them for professional sharing and printing. This course is ideal for beginners, students, and professionals who want to build a solid foundation in Microsoft Excel. No prior Excel experience is required, although basic computer skills will help you get started quickly. This course is part one of a three-course Specialization designed to provide a comprehensive learning pathway in this subject area. While it delivers standalone value and practical skills, learners seeking a more integrated and in-depth progression may benefit from completing the full Specialization. Copyright © 2022 by John Wiley & Sons, Inc., Hoboken, New Jersey. Published simultaneously in Canada. Used by arrangement with John Wiley & Sons, Inc.

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

Microsoft ExcelData EntryProofreadingEditingSpreadsheet SoftwareProductivity SoftwareData ValidationData ManagementExcel FormulasConsolidationData Presentation

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

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

01Excel: The 50-Cent Tour12 материалов

Lesson 1

Excel: The 50-Cent Tour - Overview VideoВидеоIntroductionЧтениеGetting Comfy with the Excel User InterfaceЧтениеSizing Up Other File Menu CommandsЧтение

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

Wiley Skills Network

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

Excel Foundations: Worksheets, Formatting, and Printing
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 17.3 ч

7 модулей

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

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

Часть программы вашего университета
Ripping through the RibbonЧтение
Selecting with Mouse and KeyboardЧтение
Fooling Around with the Formula BarЧтение
Tips on Using the Scroll BarsЧтение
Surfing the Sheets in a WorkbookЧтение
Getting Help from the Help Tab on the RibbonЧтение
Starting Excel from the Windows Metro View in Tablet ModeЧтение
Excel Essentials OverviewЗадание
02Customizing Excel13 материалов

Lesson 1

Customizing Excel - Overview VideoВидеоIntroductionЧтениеExercising Your OptionsЧтениеThe Privacy Settings GroupЧтениеDigging the Options on the Data TabЧтениеSave AutoRecover Information Every MinuteЧтениеChanging the Office Language PreferencesЧтениеWorking the Worksheet Editing OptionsЧтениеCaring About the Formulas Calculating and General OptionsЧтениеAdding Custom Tabs to the RibbonЧтениеUsing Office Add-insЧтениеUsing Excel's Own Add-insЧтениеExcel Customization and Advanced SettingsЗадание
03Building Worksheets22 материалов

Lesson 1

Building Worksheets - Overview VideoВидеоIntroductionЧтениеSaving Changes to Your Customized TemplatesЧтениеPlanning Your WorkbookЧтениеGetting to Know Excel's Data TypesЧтениеWhat's the ValueЧтениеInputting Dates and Times Using Recognized FormatsЧтениеData Entry 101ЧтениеDoing Data Entry with the Touch KeyboardЧтениеYou AutoComplete MeЧтениеConstraining Data Entry to a Cell RangeЧтениеYou AutoFill MeЧтениеAutoFill via the Fill Button on the RibbonЧтениеCreating Custom AutoFill ListsЧтениеFlash Fill to the RescueЧтениеLimiting Data Entry with Data ValidationЧтениеLinking to Other DocumentsЧтениеFollow that linkЧтениеSaving the DataЧтениеSaving Workbooks in Other Commonly Used File FormatsЧтениеSaving a New Workbook in the Old File FormatЧтениеMastering Excel Worksheet TechniquesЗадание
04Formatting Worksheets21 материалов

Lesson 1

Formatting Worksheets - Overview VideoВидеоIntroductionЧтениеSelecting Cells with the MouseЧтениеSelecting Cells with the KeyboardЧтениеSelecting Cells with Go ToЧтениеAdjusting Columns and RowsЧтениеSetting a New Standard WidthЧтениеFormatting Tables from the RibbonЧтениеFormatting Tables with the Quick Analysis ToolЧтениеFormatting Cell Ranges with the Mini-ToolbarЧтениеUsing One of the Predefined Number FormatsЧтениеDesigning Your Own Number FormatsЧтениеAltering the AlignmentЧтениеReorienting Your EntriesЧтениеBasic Borders, Fills, and PatternsЧтениеHiring Out the Format PainterЧтениеDefining a Custom Cell Style by ExampleЧтениеData BarsЧтениеIdentifying Particular Values or Text Entries in a Cell RangeЧтениеHighlighting Duplicate Values in a Cell RangeЧтениеMastering Excel Formatting ToolsЗадание
05Editing and Proofing Worksheets16 материалов

Lesson 1

Editing and Proofing Worksheets - Overview VideoВидеоIntroductionЧтениеOpening More Than One Workbook At A TimeЧтениеChanging Your Mind with Undo and RedoЧтениеClearing CellsЧтениеInserting CellsЧтениеFreezing Window PanesЧтениеSaving Custom ViewsЧтениеCopying and and Moving with Drag and DropЧтениеCopying and Moving with Copy, Cut, and PasteЧтениеTaking it out of the Clipboard Task PaneЧтениеFinding and Replacing Worksheet DataЧтениеFinding and Replacing DataЧтениеGetting It Right Spell Checking Your WorksheetsЧтениеAdding Words to the Custom DictionaryЧтениеMastering Worksheet Editing ToolsЗадание
06Managing Worksheets10 материалов

Lesson 1

Managing Worksheets - Overview VideoВидеоIntroductionЧтениеOutlining WorksheetsЧтениеOutline ButtonsЧтениеManually Adjusting the Outline LevelsЧтениеCreating Different Custom Views of the OutlineЧтениеComparing Worksheet Windows Side by SideЧтениеWindow ArrangementsЧтениеConsolidating by PositionЧтениеMastering Excel Worksheet ManipulationЗадание
07Printing Worksheets9 материалов

Lesson 1

Printing Worksheets - Overview VideoВидеоIntroductionЧтениеSelecting the Printer to UseЧтениеPreviewing the Pages of the ReportЧтениеUsing the Buttons in the Page Setup GroupЧтениеPutting out the print titlesЧтениеUsing the Print Options on the Sheet Tab of the Page Setup Dialog BoxЧтениеCreating Unique First-Page Headers and FootersЧтениеMastering Worksheet Printing TechniquesЗадание