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

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

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

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

Excel Skills for Business: Intermediate I

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

О курсе

Spreadsheet software remains one of the most ubiquitous pieces of software used in workplaces across the world. Learning to confidently operate this software means adding a highly valuable asset to your employability portfolio. In the United States alone, millions of job advertisements requiring Excel skills are posted every day. Research by Burning Glass Technologies and Capital One shows that digitals skills lead to higher income and better employment opportunities at a time when digital skills job are growing much faster than non-digital jobs. In this second course of our Excel specialization Excel Skills for Business you will build on the strong foundations of the Essentials course. Intermediate Skills I will expand your Excel knowledge to new horizons. You are going to discover a whole range of skills and techniques that will become a standard component of your everyday use of Excel. In this course, you will build a solid layer of more advanced skills so you can manage large datasets and create meaningful reports. These key techniques and tools will allow you to add a sophisticated layer of automation and efficiency to your everyday tasks in Excel. Once again, we have brought together a great teaching team that will be with you every step of the way. Prashan and Nicky will guide you through each week (and I am even going to make a guest appearance in Week 5 to help you learn about my favourite tool in Excel - shh, no spoilers!). Work through each new challenge step-by-step and in no time you will surprise yourself by how far you have come. This time around, we are going to follow Uma's trials and tribulations as she is trying to find her feet in a new position in the fictitious company PushPin. For those of you who have done the Essentials course, you will already be familiar with the company. Working through her challenges which are all too common ones that we encounter everyday, will help you to more easily relate to the skills and techniques learned in each week and apply them to familiar and new contexts.

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

Microsoft ExcelExcel FormulasDashboardData ManagementBusiness ReportingAutomationConsolidationSpreadsheet Software

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

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

01Working with Multiple Worksheets & Workbooks23 материалов

Welcome and Critical Information

Welcome to Excel Skills for Business: Intermediate IЧтениеCourse Goals and Weekly Learning ObjectivesЧтениеWhat Happens When Your Data Lives in Different PlacesDIALOGUE

Scenario: Multiple Worksheets and Workbooks

Week 1 IntroductionВидео

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

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: Intermediate I
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 28 ч

7 модулей

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

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

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

Practice Videos and Challenges

Read me before you start: Quizzes and NavigationЧтениеDownload the Week 1 workbooksЧтениеRead me before you start: Versions and regionsЧтениеPractice Video: Multiple WorksheetsВидеоMultiple WorksheetsЗаданиеPractice Video: 3D FormulasВидео3D FormulasЗаданиеPractice Video: Linking WorkbooksВидеоLinking WorkbooksЗаданиеPractice Video: Consolidating by PositionВидеоConsolidating by PositionЗаданиеPractice Video: Consolidating by Category (Reference)ВидеоConsolidating by Category (Reference)ЗаданиеWeek 1 Wrap-UpВидеоWeek 1: Practice ChallengeЧтениеWeek 1: Advanced Practice ChallengeЧтение

Toolbox

Keyboard Shortcuts, Excel Terminology and Ninja TipsЧтение

Assessment

Test your Skills: Working with Multiple Worksheets & WorkbooksЗадание
02Text and Date Functions18 материалов

Scenario

Week 2 IntroductionВидеоWeek 2 DiscussionВидеоExcel - how, when, where, whyОбсуждение

Practice Videos and Challenges

Download the Week 2 workbooksЧтениеPractice Video: Combining Text (CONCAT, &)ВидеоCombining Text (CONCAT, &)ЗаданиеPractice Video: Changing Text Case (UPPER, LOWER, PROPER)ВидеоChanging Text Case (UPPER, LOWER, PROPER)ЗаданиеPractice Video: Extracting Text (LEFT, MID, RIGHT)ВидеоExtracting Text (LEFT, MID, RIGHT)ЗаданиеPractice Video: Finding Text (FIND)ВидеоFinding Text (FIND)ЗаданиеPractice Video: Date Calculations (NOW, TODAY, YEARFRAC)ВидеоDate Calculations (NOW, TODAY, YEARFRAC)ЗаданиеWeek 2 Wrap-UpВидеоWeek 2: Practice ChallengeЧтение

Toolbox

Keyboard Shortcuts, Excel Terminology and Ninja TipsЧтение

Assessment

Test your Skills: Text and Date FunctionsЗадание
03Named Ranges17 материалов

Scenario

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

Practice Videos and Challenges

Download the Week 3 workbooksЧтениеPractice Video: Introducing Named RangesВидеоIntroducing Named RangesЗаданиеPractice Video: Creating Named RangesВидеоCreating Named RangesЗаданиеPractice Video: Managing Named RangesВидеоManaging Named RangesЗаданиеPractice Video: Named Ranges in FormulasВидеоNamed Ranges in FormulasЗаданиеPractice Video: Apply NamesВидеоApply NamesЗаданиеWeek 3 Wrap-UpВидеоWeek 3: Practice ChallengeЧтение

Toolbox

Keyboard Shortcuts, Terminology and Ninja TipsЧтение

Assessment

Test your Skills: Named RangesЗадание
04Summarising Data19 материалов

Scenario

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

Practice Videos and Challenges

Download the Week 4 workbooksЧтениеPractice Video: COUNT functionsВидеоCOUNT functionsЗаданиеPractice Video: Counting with Criteria (COUNTIFS)ВидеоCounting with Criteria (COUNTIFS)ЗаданиеPractice Video: Adding with Criteria (SUMIFS)ВидеоAdding with Criteria (SUMIFS)ЗаданиеPractice Video: SparklinesВидеоSparklinesЗаданиеPractice Video: Advanced ChartingВидеоAdvanced ChartingЗаданиеPractice Video: TrendlinesВидеоTrendlinesЗаданиеWeek 4 Wrap-UpВидеоWeek 4: Practice ChallengeЧтение

Toolbox

Keyboard Shortcuts, Excel Terminology and Ninja TipsЧтение

Assessment

Test your Skills: Summarising DataЗадание
05Tables17 материалов

Scenario

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

Practice Videos and Challenges

Download the Week 5 workbooksЧтениеPractice Video: Creating and Formatting TablesВидеоCreating and Formatting TablesЗаданиеPractice Video: Working with TablesВидеоWorking with TablesЗаданиеPractice Video: Sorting and Filtering in TablesВидеоSorting and Filtering in TablesЗаданиеPractice Video: Automation with TablesВидеоAutomation with TablesЗаданиеPractice Video: Converting to Range and SubtotalingВидеоConverting to Range and SubtotalingЗаданиеWeek 5 Wrap-UpВидеоWeek 5: Practice ChallengeЧтение

Toolbox

Keyboard Shortcuts, Excel Terminology and Ninja TipsЧтение

Assessment

Test your Skills: TablesЗадание
06Pivot Tables, Charts and Slicers19 материалов

Scenario

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

Practice Videos and Challenges

Download the Week 6 workbooksЧтениеPractice Video: Creating and Modifying a Pivot TableВидеоCreating and Modifying a Pivot TableЗаданиеPractice Video: Value Field SettingsВидеоValue Field SettingsЗаданиеPractice Video: Sorting and Filtering a Pivot TableВидеоSorting and Filtering a Pivot TableЗаданиеPractice Video: Reporting Filter PagesВидеоReport Filter PagesЗаданиеPractice Video: Pivoting ChartsВидеоPivoting ChartsЗаданиеPractice Video: Pivoting SlicersВидеоPivoting SlicersЗаданиеWeek 6 Wrap-UpВидеоWeek 6: Practice ChallengeЧтение

Toolbox

Keyboard Shortcuts, Excel Terminology and Ninja TipsЧтение

Assessment

Test your Skills: Pivot Tables, Charts and SlicersЗадание
07Final Assessment1 материалов

Final Assessment

Final AssessmentЗадание