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

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

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

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

Excel Skills for Business: Advanced

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

О курсе

This advanced Excel course is designed for business professionals, data analysts, and financial analysts seeking to master complex spreadsheet software for data-driven decision-making. Building on foundational Excel skills, this program will transform you into a power user, enhancing your employability and positioning you ahead in a rapidly evolving digital job market. (Source: World Economic Forum 2023 Future of Jobs Report). By the end of this course, you will be able to: - Master advanced Excel formulas and lookup functions for efficient data handling. - Clean and prepare complex data for robust analysis using Microsoft Excel. - Apply financial functions and date formulas for business calculations and reporting. - Design and build professional, interactive dashboards in Excel for business intelligence. To be successful, you should have completed the Excel Skills for Business: Essentials, Intermediate I, and Intermediate II courses, or possess equivalent intermediate Microsoft Excel proficiency.

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

Microsoft ExcelExcel FormulasData PreprocessingFinancial AnalysisExcel MacrosData Analysis SoftwareSpreadsheet SoftwareAnalytical SkillsAdvanced AnalyticsDashboard CreationBusiness MathematicsData WranglingBusiness AnalyticsInteractive Data VisualizationDashboardData ManipulationData ProcessingData Presentation

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

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

01Spreadsheet Design and Documentation20 материалов

Let's get started

WelcomeЧтениеCourse Structure & AssessmentsЧтениеCourse goals and weekly learning objectivesЧтение

Scenario

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

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 25.2 ч

7 модулей

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

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

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

Practice Videos, Quizzes & Challenges

Read me before you start: Quizzes and navigationЧтениеRead me before you start: Versions and regionsЧтениеDownload the Week 1 workbooksЧтениеPractice Video: Spreadsheet Design PrinciplesВидеоSpreadsheet Design PrinciplesЗаданиеPractice Video: CalculationsВидеоCalculationsЗаданиеPractice Video: FormattingВидеоFormattingЗаданиеPractice Video: DocumentationВидеоDocumentationЗаданиеPractice Video: Interface and NavigationВидео

Toolbox

Keyboard Shortcuts, Terminology, and Ninja TipsЧтениеDesigning Professional Spreadsheets: Integrating Best PracticesDIALOGUE

Assessment

Week 1 Final AssignmentЗадание
02Advanced Formula Techniques14 материалов

Scenario

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

Practice Videos, Quizzes & Challenges

Download the Week 2 workbooksЧтениеPractice Video: Tables and Structured ReferencingВидеоTables and Structured ReferencingЗаданиеPractice Video: Using Functions to Sort DataВидеоUsing Functions to Sort DataЗаданиеPractice Video: Introduction to Array FormulasВидеоIntroduction to Array FormulasЗаданиеPractice Video: Working with an Array Function (TRANSPOSE)ВидеоPractice Video: Solving Problems with Array FormulasВидеоWeek 2 Practice ChallengeЗадание

Toolbox

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

Assessment

Week 2 Final AssignmentЗадание
03Data Cleaning and Preparation16 материалов

Scenario

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

Practice Videos, Quizzes & Challenges

Download the Week 3 workbooksЧтениеPractice Video: Replace blanks with repeating valuesВидеоReplace blanks with repeating valuesЗаданиеPractice Video: Fix Dates (DATE, MONTH, YEAR, DAY, TEXT)ВидеоFix Dates (DATE, MONTH, YEAR, DAY, TEXT)ЗаданиеPractice Video: Remove Unwanted Spaces (TRIM, CLEAN)ВидеоRemove Unwanted Spaces (TRIM, CLEAN)ЗаданиеPractice Video: Diagnostic Tools (ISNUMBER, LEN, CODE)ВидеоDiagnostic Tools (ISNUMBER, LEN, CODE)ЗаданиеPractice Video: Remove Unwanted Characters (SUBSTITUTE, CHAR, VALUE)ВидеоRemove Unwanted Characters (SUBSTITUTE, CHAR, VALUE)ЗаданиеWeek 3 Practice ChallengeЗадание

Toolbox

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

Assessment

Week 3 Final AssignmentЗадание
04Financial Functions and Working with Dates15 материалов

Scenario

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

Practice Videos, Quizzes & Challenges

Download the Week 4 workbooksЧтениеPractice Video: Working with Dates (EOMONTH, EDATE, WORKDAY.INTL)ВидеоWorking with Dates (EOMONTH, EDATE, WORKDAY.INTL)ЗаданиеPractice Video: Financial Functions (FV, PV, PMT)ВидеоFinancial Functions (FV, PV, PMT)ЗаданиеPractice Video: Loan Schedule (PMT, EDATE)ВидеоLoan Schedule (PMT, EDATE)ЗаданиеPractice Video: Net Present Value and Internal Rate of Return (NPV, IRR)ВидеоNet Present Value and Internal Rate of Return (NPV, IRR)ЗаданиеPractice Video: Depreciation Functions (SLN, SYD, DDB)ВидеоDepreciation Functions (SLN, SYD, DDB)Задание

Toolbox

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

Assessment

Week 4 Final AssignmentЗадание
05Advanced Lookup Functions12 материалов

Scenario

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

Practice Videos, Quizzes & Challenges

Download the Week 5 workbooksЧтениеPractice Video: INDIRECTВидеоINDIRECTЗаданиеPractice Video: ADDRESSВидеоADDRESSЗаданиеPractice Video: Introduction to OFFSETВидеоIntroduction to OFFSETЗаданиеPractice Video: Solving Problems with OFFSETВидео

Toolbox

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

Assessment

Week 5 Final AssignmentЗадание
06Building Professional Dashboards10 материалов

Scenario

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

Practice Videos, Quizzes & Challenges

Download the Week 6 workbooksЧтениеPractice Video: Dashboard DesignВидеоDashboard DesignЗаданиеPractice Video: Prepare DataВидеоPractice Video: Construct DashboardВидеоPractice Video: Creative ChartingВидеоPractice Video: Interactive DashboardВидео

Toolbox

Keyboard Shortcuts, Excel Terminology, and Ninja TipsЧтение
07Advanced Excel Final Assessment1 материалов

Final Assessment

Final AssessmentЗадание