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

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

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

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

Excel Skills for Business: Intermediate II

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

О курсе

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 this third course of our Excel specialization Excel Skills for Business you will delve deeper into some of the most powerful features Excel has to offer. When you have successfully completed the course you will be able to Check for and prevent errors in spreadsheets; Create powerful automation in spreadsheets; Apply advanced formulas and conditional logic to help make informed business decisions; and Create spreadsheets that help forecast and model data. Once again, we have brought together a great teaching team that will be with you every step of the way. Nicky, Prashan and myself will guide you through each week. As we are exploring these more advanced topics, we are following Alex who is an Excel consultant called in by businesses that experience issues with their spreadsheets.

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

Data ValidationExcel FormulasExcel MacrosMicrosoft ExcelData ModelingVisual Basic (Programming Language)Financial ForecastingData SecurityPredictive ModelingAutomationData IntegrityBusiness ModelingFinancial ModelingSpreadsheet Software

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

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

01Data Validation23 материалов

Let's get started

Welcome to Excel Skills for Business: Intermediate IIЧтениеCourse goals and weekly learning objectivesЧтение

Scenario

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

Practice Videos, Quizzes, and Challenges

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

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

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 29 ч

7 модулей

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

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

Часть программы вашего университета
Read me before you start: Quizzes and navigationЧтение
Read me before you start: Versions and regionsЧтение
Download the Week 1 workbooksЧтение
Assessing Your Excel Foundation for Advanced Business ApplicationsDIALOGUE
Practice Video: Data ValidationВидео
Data ValidationЗадание
Practice Video: Creating Drop-down ListsВидео
Creating Drop-down ListsЗадание
Practice Video: Using Formulas in Data ValidationВидео
Using Formulas in Data ValidationЗадание
Practice Video: Working with Data ValidationВидео
Working with Data ValidationЗадание
Practice Video: Advanced Conditional FormattingВидео
Advanced Conditional FormattingЗадание
Week 1 Wrap-UpВидео
Week 1 Practice ChallengeЗадание

Toolbox

Keyboard Shortcuts, Excel Terminology, and Ninja TipsЧтениеHealthcare Data Integrity CrisisDIALOGUE

Assessment

Week 1 Final AssignmentЗадание
02Conditional Logic17 материалов

Scenario

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

Practice Videos, Quizzes, and Challenges

Download the Week 2 workbooksЧтениеPractice Video: Logical Functions I: IFВидеоLogical Functions I: IFЗаданиеPractice Video: Logical Functions II: AND, ORВидеоLogical Functions II: AND, ORЗаданиеPractice Video: Combining Logical Functions I: IF, AND, ORВидеоCombining Logical Functions I: IF, AND, ORЗаданиеPractice Video: Combining Logical Functions II: Nested IFsВидеоCombining Logical Functions II: Nested IFsЗаданиеPractice Video: Handling Errors: IFERROR, IFNAВидеоHandling Errors: IFERROR, IFNAЗаданиеWeek 2 Wrap-UpВидеоWeek 2 Practice ChallengeЗадание

Toolbox

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

Assessment

Week 2 Final AssignmentЗадание
03Automating Lookups17 материалов

Scenario

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

Practice Videos, Quizzes, and Challenges

Download the Week 3 workbooksЧтениеPractice Video: Introduction to Lookups: CHOOSEВидеоIntroduction to Lookups: CHOOSEЗаданиеPractice Video: Approximate Matches: Range VLOOKUPВидеоApproximate Matches: Range VLOOKUPЗаданиеPractice Video: Exact Matches: Exact Match VLOOKUPВидеоExact Matches: Exact Match VLOOKUPЗаданиеPractice Video: Finding a Position: MATCHВидеоFinding a Position: MATCHЗаданиеPractice Video: Dynamic Lookups: INDEX, MATCHВидеоDynamic Lookups: INDEX, MATCHЗаданиеWeek 3 Wrap-UpВидеоWeek 3 Practice ChallengeЗадание

Toolbox

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

Assessment

Week 3 Final AssignmentЗадание
04Formula Auditing and Protection18 материалов

Scenario

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

Practice Videos, Quizzes, and Challenges

Download the Week 4 workbooksЧтениеPractice Video: Error CheckingВидеоError CheckingЗаданиеPractice Video: Formula Calculation OptionsВидеоFormula Calculation OptionsЗаданиеPractice Video: Trace Precedents and DependentsВидеоTracing Precedents and DependentsЗаданиеPractice Video: Evaluate Formula, Watch WindowВидеоEvaluate Formula, Watch WindowЗаданиеPractice Video: Protecting Workbooks and WorksheetsВидеоProtecting Workbooks and WorksheetsЗаданиеWeek 4 Wrap-UpВидеоFind the remaining errorsОбсуждениеWeek 4 Practice ChallengeЗадание

Toolbox

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

Assessment

Week 4 Final AssignmentЗадание
05Data Modelling17 материалов

Scenario

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

Practice Videos, Quizzes, and Challenges

Download the Week 5 workbooksЧтениеPractice Video: Modelling Functions: SUMPRODUCTВидеоModelling Functions (SUMPRODUCT)ЗаданиеPractice Video: Data TablesВидеоData TablesЗаданиеPractice Video: Goal SeekВидеоGoal SeekЗаданиеPractice Video: Scenario ManagerВидеоScenario ManagerЗаданиеPractice Video: SolverВидеоSolverЗаданиеWeek 5 Wrap-UpВидеоWeek 5 Practice ChallengeЗадание

Toolbox

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

Assessment

Week 5 Final AssignmentЗадание
06Recording Macros17 материалов

Scenario

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

Practice Videos, Quizzes, and Challenges

Download the Week 6 workbooksЧтениеPractice Video: Record a MacroВидеоRecord a MacroЗаданиеPractice Video: Run a MacroВидеоRun your MacroЗаданиеPractice Video: Edit a MacroВидеоEdit a MacroЗаданиеPractice Video: Working with MacrosВидеоWorking with MacrosЗаданиеPractice Video: Relative Reference MacrosВидеоRelative Reference MacrosЗаданиеWeek 6 Wrap-UpВидеоWeek 6 Practice ChallengeЗадание

Toolbox

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

Assessment

Week 6 Final AssignmentЗадание
07Final Assessment1 материалов

Final Assessment

Final AssessmentЗадание