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

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

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

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

Excel for Business with AI: Essentials

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

О курсе

Excel is one of the most in-demand tools in business — and this course gives you everything you need to use it with confidence, from your very first spreadsheet to professional dashboards and data visualisations. Across six structured modules, you'll build skills step by step. You'll start by navigating the Excel interface and creating your own spreadsheets, then move through professional formatting, essential calculations, and data management. You'll learn to sort and filter data, work with Excel tables, and use Microsoft Copilot to generate data insights. The course closes with conditional formatting, chart creation — including column, bar, pie, line, map, and treemap charts — and building visual dashboards that communicate your data clearly. AI is integrated throughout the course in a dedicated "AI Corner" in select modules, giving you practical guidance on using tools like Microsoft Copilot to write formulas faster, solve problems, and uncover insights more efficiently. Each module follows a consistent structure: a fireside discussion video to introduce key concepts, hands-on practice videos, quick quizzes, a practice challenge, and a graded assessment. Quick reference guides and AI challenge activities support every module. Who this is for: Complete beginners, business professionals, and students who want to build practical Excel skills from the ground up, with no prior spreadsheet experience needed. Join over 1 million professionals who have advanced their careers with our highly-rated courses. Whether you're aiming to boost your employability, enhance your current role, or elevate your Excel skills, this industry-endorsed program provides the knowledge and tools to help you excel in a competitive job market. Enrol now and start your journey to Excel mastery with the power of AI.

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

Microsoft ExcelExcel FormulasDashboardSpreadsheet SoftwareData ManagementMicrosoft CopilotProductivity Softwaredigital literacyMicrosoft 365Interactive Data VisualizationAnalysisPivot Tables And ChartsGenerative AIData AnalysisBusiness Analytics

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

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

01 Taking Charge of Excel30 материалов

Getting Started

Welcome to Excel for Business with AIВидеоGetting the most out of your courseВидеоCourse Overview & Learning Journey Чтение

Skills Checklist

Skills Checklist Чтение

Taking Charge of Excel

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

Nicky Bull

Lecturer and Lead Content Designer

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

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 28 ч

6 модулей

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

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

Часть программы вашего университета
Introduction: Taking Charge of ExcelВидео
Discussion Video Видео
Taking Charge WorkbookЧтение
Practise Video: Taking Charge of ExcelВидео
Taking Charge of ExcelЗадание

Navigating and Selecting

Navigating and Selecting WorkbookЧтениеPractise Video: Navigating and Selecting DataВидеоNavigating and Selecting Задание

Creating a Spreadsheet

Practise Video: Creating a SpreadsheetВидеоCreating a SpreadsheetЗадание

Entering and Editing data

Entering and Editing Data WorkbookЧтениеPractise Video: Entering and Editing DataВидеоEntering and Editing DataЗадание

Using the Fill Handle

Using the Fill Handle WorkbookЧтениеPractise Video: Using the Fill HandleВидеоUsing the Fill HandleЗадание

Managing Rows and Columns

Columns and Rows WorkbookЧтение Columns and Rows Workbook Solution ЧтениеPractise Video: Managing Rows and Columns ВидеоManaging Rows and ColumnsЗадание

Practise Challenge

Practise Challenge VideoВидеоPractise Challenge WorkbookЧтениеPractise Challenge Workbook Solution Чтение

Assessment

Assessment WorkbookЧтениеTaking Charge of Excel AssessmentЗадание

Toolbox

Quick Reference GuideЧтение
02Formatting a Spreadsheet 27 материалов

Skills Check List

Formatting a Spreadsheet Skills Checklist Чтение

Introduction Video: Formatting Spreadsheet

Introduction Video Formatting a SpreadsheetВидеоDiscussion VideoВидео

Fonts and Colours

Fonts and Colours WorkbookЧтениеPractise Video: Fonts and ColoursВидеоFonts and Colours PracticeЗадание

Borders and Styles

Borders and Styles WorkbookЧтениеPractise Video: Borders and StylesВидеоBorders and Styles Задание

Alignment Tools

Alignment Tools WorkbookЧтениеPractise Video Alignment ToolsВидеоAlignment ToolsЗадание

Number Formats

Number Formats WorkbookЧтениеPractise Video Number FormatsВидеоNumber FormatsЗадание

Copy & Paste

Cut, Copy & Paste WorkbookЧтениеPractise Video Copy & PasteВидеоCut, Copy and PasteЗадание

Themes & Images

Themes and Images WorkbookЧтениеPractise Video Themes & ImagesВидеоThemes & Images Задание

Practise Challenge

Practise Challenge VideoВидеоPractise Challenge WorkbookЧтениеPractise Challenge Workbook SolutionЧтение

Assessment

Assessment WorkbookЧтениеFormatting a SpreadsheetЗадание

Toolbox

Quick Reference GuideЧтение
03Calculations32 материалов

Skills Checklist

Skills Checklist Чтение

Introduction Video: Calculations

Calculations Introduction VideoВидеоDiscussion VideoВидео

Simple Calculations

Simple Calculations WorkbookЧтениеPractise Video: Simple CalculationsВидеоSimple Calculations QuizЗадание

Absolute Cell References

Absolute Cell References WorkbookЧтениеPractise Video: Absolute Cell ReferencesВидеоPractise Quiz Absolute Cell ReferencesЗадание

SUM and Autosum

SUM and Autosum WorkbookЧтениеPractise Video: SUM and Autosum ВидеоSUM and Autosum Задание

AVERAGE, MAX and MIN

AVERAGE, MAX and MIN ЧтениеPractise Video: AVERAGE, MAX and MIN ВидеоAVERAGE, MAX and MIN Задание

Calculations Across Sheets

Calculations across Sheets ЧтениеPractise Video: Calculations across Sheets ВидеоCalculations across Sheets Задание

Getting Help from AI

Getting Help from AI WorkbookЧтениеGetting Help from AI Workbook SolutionЧтениеPractise Video: Getting Help from AI ВидеоGetting Help from AI ЗаданиеPractice: Design a Multi-Sheet Report in ExcelDIALOGUE

Calculations Practise Challenge

Practise Challenge VideoВидеоPractise Challenge: Calculations WorkbookЧтениеPractise Challenge: Calculations Workbook SolutionЧтение

Assessment - Calculations

Assessment WorkbookЧтениеAssessment Workbook SolutionЧтениеCalculations Assessment Задание

Toolbox

Quick Reference GuideЧтение

AI Corner

AI as your thinking PartnerЧтениеAI Challenge: Use AI to help with Excel calculationsЧтение
04Managing Data 31 материалов

Skills Checklist

Skills ChecklistЧтение

Introduction Video: Managing Data

Managing Data Introduction VideoВидеоDiscussion VideoВидео

Working with Sheets

Working with Sheets WorkbookЧтениеPractise Video: Working with Sheets ВидеоPractise Quiz: Working with Sheets Задание

Creating a Table

Creating a Table WorkbookЧтениеPractise Video: Creating a Table ВидеоPractise Quiz: Creating a Table Задание

Working with Tables

Working with Tables WorkbookЧтениеPractise Video: Working with Tables ВидеоPractise Quiz Working with Tables ЗаданиеPractice: Structuring Data with Excel TablesDIALOGUE

Sorting Data

Sorting Data WorkbookЧтениеPractise Video Sorting Data ВидеоPractise Quiz Sorting Data Задание

Filters & Slicers

Filters & Slicers WorkbookЧтениеPractise Video: Filters & Slicers ВидеоPractise Quiz Filters & Slicers Задание

Data Insights with Copilot

Data Insights with Copilot WorkbookЧтениеData Insights with Copilot Workbook Solution ЧтениеPractise Video: Data Insights with Copilot Видео Data Insights with Copilot Задание

Practice Challenge: Managing Data

Practise Challenge WorkbookЧтениеPractise Challenge Workbook SolutionЧтениеPractise Challenge Video: Managing DataВидео

Assessment: Managing Data

Assessment WorkbookЧтениеManaging Data AssessmentЗадание

Toolbox

Quick Reference GuideЧтение

AI Corner

AI as your thinking PartnerЧтениеAI Challenge: Use CoPilot to help generate insightsЧтение
05Sharing & Printing 27 материалов

Skills Checklist

Skills ChecklistЧтение

Introduction Video: Sharing & Printing

Sharing & Printing Introduction VideoВидеоDiscussion VideoВидео

Print Preview

Print Preview WorkbookЧтениеPractise Video: Print Preview ВидеоPrint Preview Задание

Page Layout Options

Page Layout Options WorkbookЧтениеPractise Video: Page Layout Options ВидеоPage Layout Options Задание

Headers and Footers

Headers and Footers WorkbookЧтениеPractise Video: Headers and Footers ВидеоHeaders and Footers Задание

Print Titles & Print Areas

Print Titles & Print Areas WorkbookЧтениеPractise Video: Print Titles & Print Areas ВидеоPrint Titles & Print Areas Задание

Page Breaks

Page Breaks WorkbookЧтениеPractise Video: Page BreaksВидеоPage BreaksЗадание

Save & Share Options

Save & Share Options WorkbookЧтениеPractise Video: Save & Share Options ВидеоSave & Share Options Задание

Practise Challenge: Sharing & Printing

Practise Challenge Video: Sharing & PrintingВидеоPractise Challenge Workbook ЧтениеPractise Challenge Workbook SolutionЧтение

Assessment: Sharing & Printing

Assessment WorkbookЧтениеSharing & Printing Assessment Задание

Toolbox

Quick Reference GuideЧтение
06Visualising Data32 материалов

Skills Checklist

Skills ChecklistЧтение

Introduction Video: Visualising Data

Visualising Data Introduction VideoВидеоDiscussion VideoВидео

Quick Conditional Formats

Quick Conditional Formats WorkbookЧтениеPractice Video: Quick Conditional FormatsВидеоQuick Conditional Formats Задание

Column & Bar Charts

Column & Bar Charts WorkbookЧтениеPractise Video: Column & Bar Charts ВидеоColumn & Bar Charts Задание

Pie and Donut Charts

Pie and Donut Charts WorkbookЧтениеPractise Video: Pie and Donut Charts ВидеоPie and Donut Charts Задание

Line and Area Charts

Line and Area Charts WorkbookЧтениеPractise Video: Line and Area Charts ВидеоPractice: Choose the Right Visualisation ToolDIALOGUELine and Area Charts Задание

Map and Treemap Charts

Map and Treemap Charts WorkbookЧтениеPractise Video: Map and Treemap Charts ВидеоMap and Treemap Charts Задание

Simple Dashboards

Simple Dashboards WorkbookЧтениеPractise Video: Simple Dashboards ВидеоSimple Dashboards Задание

Practise Challenge: Visualising Data

Practise Challenge Video: Visualising DataВидеоPractise Challenge Workbook ЧтениеPractise Challenge Workbook SolutionЧтение

Assessment: Visualising Data

Assessment WorkbookЧтениеVisualising Data Assessment Задание

Toolbox

Quick Reference GuideЧтение

AI Corner

AI as your thinking PartnerЧтениеAI ChallengeЧтение

Final Assessment and Summary

Final Assessment ЗаданиеConcluding VideoВидео