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

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

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

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

Excel Skills for Business: Essentials

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

О курсе

In this first course of the specialization, 'Excel Skills for Business: Essentials', you will master the fundamental capabilities of Microsoft Excel. Over six weeks, you will gain the confidence to expertly navigate the Excel user interface, perform essential calculations using formulas and functions, professionally format spreadsheets, and create impactful data visualizations with charts and graphs. This course is designed for aspiring business professionals, students, and anyone looking to enhance their digital skills. Whether you are new to Excel or self-taught and aiming to solidify your foundational knowledge for greater efficiency and productivity, this program provides a robust starting point. You will solve a variety of practical business problems, applying learned Excel skills and techniques through downloadable workbooks and real-world data sets. To succeed in this course, no prior Excel experience is required. You will develop highly valuable spreadsheet software skills, positioning yourself for success in today's rapidly evolving digital job market.

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

Microsoft ExcelExcel FormulasProductivity SoftwareSpreadsheet SoftwareBusiness AnalyticsData Analysis SoftwareAnalytical Skills

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

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

01Critical Core of Excel27 материалов

Welcome and Critical Information

Welcome to Excel Skills for Business: EssentialsЧтениеCourse goals and weekly learning objectivesЧтениеImportant information about versions and regionsЧтениеAre essential skills too basic for me?Задание

Scenario: Taking Charge of Excel

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

Nicky Bull

Lecturer and Lead Content Designer

Professor Yvonne Breyer

Deputy Dean, Education and Employability

Assoc Prof Prashan S. M. Karunaratne

Associate Professor - Teaching & Leadership | SFHEA

Excel Skills for Business: Essentials
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 26.1 ч

7 модулей

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

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

Часть программы вашего университета
Week 1 IntroductionВидео
Week 1 DiscussionВидео

Practice Videos and Challenges

Read me before you start: Quizzes and NavigationЧтениеDownload the Week 1 workbooksЧтениеPractice Video: Taking Charge of ExcelВидеоTaking Charge of ExcelЗаданиеPractice Video: Navigating and SelectingВидеоNavigating and SelectingЗаданиеPractice Video: View OptionsВидеоView OptionsЗаданиеPractice Video: Data Entry, Data Types, Editing and DeletingВидеоData EntryЗаданиеPractice Video: Fill HandleВидеоFill handleЗаданиеWeek 1 Wrap-upВидеоWeek 1: Practice ChallengeЧтение

Toolbox

Week 1: Keyboard Shortcuts, Terminology, and Ninja TipsЧтениеCopy and PasteВидеоTemplatesВидеоExcel Foundations Check-In: Integrating Your Complete ToolkitDIALOGUE

Assessment

Taking Charge of Excel: Test your skills, Part 1ЗаданиеTaking Charge of Excel: Test your skills, Part 2Задание

Optional Materials

Week 1: Excellent Tips and ResourcesЧтение
02Excel Calculations23 материалов

Scenario: Performing Calculations

Week 2 IntroductionВидеоWeek 2 DiscussionВидео

Practice Videos and Challenges

Download the Week 2 workbooksЧтениеPractice Video: FormulasВидеоFormulasЗаданиеPractice Video: Formulas in ContextВидеоFormulas in ContextЗаданиеPractice Video: Functions I: SUM and AUTOSUMВидеоFunctions IЗаданиеPractice Video: Functions II: AVERAGE, MIN and MAXВидеоFunctions IIЗаданиеDiscussion: Absolute Cell ReferencesВидеоPractice Video: Absolute Cell ReferencesВидеоAbsolute Cell ReferencesЗаданиеPractice Video: Calculations across sheetsВидеоCalculations across SheetsЗаданиеWeek 2 Wrap-upВидеоWeek 2: Practice ChallengesЧтениеWord Search Puzzle: Master rangesЧтение

Toolbox

Week 2: Keyboard Shortcuts, Terminology, and Ninja TipsЧтениеExcel OptionsВидео

Assessment

Performing Calculations: Test your skillsЗадание

Optional Materials

Week 2: Excellent Tips and ResourcesЧтение
03Excel Formatting Essentials21 материалов

Scenario: Formatting Spreadsheets

Week 3 IntroductionВидеоWeek 3 DiscussionВидео

Practice Videos and Challenges

Download the Week 3 workbooksЧтениеPractice Video: FormattingВидеоFormattingЗаданиеPractice Video: BordersВидеоBordersЗаданиеPractice Video: Alignment ToolsВидеоAlignment ToolsЗаданиеPractice Video: Format PainterВидеоFormat PainterЗаданиеPractice Video: Number FormatsВидеоNumber FormatsЗаданиеPractice Video: Styles and ThemesВидеоStyles and ThemesЗаданиеWeek 3 Wrap-upВидеоWeek 3: Practice ChallengeЧтение

Toolbox

Week 3: Keyboard Shortcuts and Ninja TipsЧтениеGraphicsВидео

Assessment

Formatting: Test your skillsЗадание

Optional Materials

Week 3: Excellent Tips and ResourcesЧтение
04Excel Data Management18 материалов

Scenario: Working with Data

Week 4 IntroductionВидеоWeek 4 DiscussionВидео

Practice Videos and Challenges

Download the Week 4 workbooksЧтениеPractice Video: Managing Rows and ColumnsВидеоManaging Rows and ColumnsЗаданиеPractice Video: Find and ReplaceВидеоFind and ReplaceЗаданиеPractice Video: FilteringВидеоFilteringЗаданиеPractice Video: SortingВидеоSortingЗаданиеPractice Video: Conditional FormattingВидеоConditional FormattingЗаданиеWeek 4 Wrap-upВидеоWeek 4: Practice ChallengeЧтение

Toolbox

Week 4: Keyboard Shortcuts, Terminology, and Ninja TipsЧтениеAccessibilityВидео

Assessment

Working with Data: Test your skillsЗадание
05Printing Excel Spreadsheets20 материалов

Scenario: Printing Spreadsheets

Week 5 IntroductionВидеоWeek 5 DiscussionВидео

Practice Videos and Challenges

Print to PDF - Setup TipsЧтениеDownload the Week 5 workbooksЧтениеPractice Video: Print PreviewВидеоPrint PreviewЗаданиеPractice Video: Orientation, Margins and ScaleВидеоOrientation, Margins and ScaleЗаданиеPractice Video: Page BreaksВидеоPage BreaksЗаданиеPractice Video: Print TitlesВидеоPrint TitlesЗаданиеPractice Video: Headers and FootersВидеоHeaders and FootersЗаданиеWeek 5 Wrap-upВидеоWeek 5: Practice ChallengeЧтение

Toolbox

Week 5: Keyboard Shortcuts, Terminology, and Ninja TipsЧтениеSave OptionsВидео

Assessment

Printing: Test your skillsЗадание

Optional Materials

Week 5: Excellent Tips and ResourcesЧтение
06Excel Data Charts17 материалов

Scenario: Creating Charts and Graphs

Week 6 IntroductionВидеоWeek 6 DiscussionВидео

Practice Videos and Challenges

Download the Week 6 workbooksЧтениеPractice Video: Basic Chart Types: Pie, Column and Line ChartsВидеоBasic Chart TypesЗаданиеPractice Video: Move and Resize ChartsВидеоMove and Resize ChartsЗаданиеPractice Video: Change Chart Style & TypeВидеоChange Chart Style & TypeЗаданиеPractice Video: Modify Chart ElementsВидеоModify Chart ElementsЗаданиеWeek 6 Wrap-upВидеоWeek 6: Practice ChallengeЧтение

Toolbox

Week 6: Keyboard Shortcuts, Terminology, and Ninja TipsЧтениеSharing ChartsВидео

Assessment

Charts: Test your skillsЗадание

Optional Materials

Week 6: Excellent Tips and ResourcesЧтение
07Final Assessment1 материалов

Course 1: Final Assessment

Final Assessment - Excel Skills for Business: EssentialsЗадание