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

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

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

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

Excel Fundamentals for Data Analysis

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

О курсе

As data becomes the modern currency, so the ability to analyse the data quickly and accurately has become of paramount importance. Excel with its extraordinarily broad range of features and capabilities is one of the most widely used programs for doing this. In the first course of our Excel Skills for Data Analysis and Visualization Specialization, you will learn the fundamentals of Excel for data analysis. When you have completed the course, you will be able to use a range of Excel tools and functions to clean and prepare data for analysis; automate data analysis with the help of Named Ranges and Tables; and use logical and lookup functions to transform, link and categorise data. This course will enable you to build a strong foundation in the fundamentals, helping you to be more efficient in your day-to-day and developing the necessary skills to work with the more advanced techniques used in later courses. To make the content easy to relate to and to personalize the learning experience, we are going to follow Zara's journey through the course. Who is Zara? Well, she is no-one and everyone. You will find that Zara's trials and tribulations sound familiar, and together with Zara, you will develop your Excel skills along the way — and, importantly, have some fun doing it. The Excel Skills for Data Analytics and Visualization courses are the sequel to one of most successful specializations on Coursera, Excel Skills for Business, which has attracted hundreds of thousands of learners and top ratings. Transform your skills, your confidence, and your opportunities by adding this new set of skills to your repertoire.

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

Microsoft ExcelExcel FormulasData ManipulationData CleansingData TransformationData AnalysisSpreadsheet SoftwareAutomationBusiness RequirementsData PreprocessingData Wrangling

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

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

01Introduction, Cleaning and manipulating text21 материалов

About the course

Course IntroductionВидеоWelcome to Excel Fundamentals for Data AnalysisЧтениеCourse goals and weekly learning objectivesЧтениеImportant information about versions and regionsЧтение

Scenario: Cleaning and manipulating text

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

Nicky Bull

Lecturer and Lead Content Designer

Assoc Prof Prashan S. M. Karunaratne

Associate Professor - Teaching & Leadership | SFHEA

Excel Fundamentals for Data Analysis
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 15.1 ч

6 модулей

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

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

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

Practice Videos and Challenges

Read me before you start: Quizzes and NavigationЧтениеDownload the Week 1 WorkbooksЧтениеExcel Functions for Combining Text ValuesВидеоExcel Functions for Combining Text ValuesЗаданиеFunctions that split text dataВидеоFunctions that split text data ЗаданиеCombining text functionsВидеоCombining text functions ЗаданиеCleaning data and changing caseВидеоCleaning data and changing case ЗаданиеRemoving and replacing text charactersВидеоRemoving and replacing text characters ЗаданиеWeek 1 Practice ChallengeЧтениеStrategic Text Data Cleaning: Choosing the Right FunctionsDIALOGUE

Toolbox

Week 1 ToolboxЧтение

Assessment

Cleaning and manipulating text: Test your skillsЗадание
02Working with numbers and dates15 материалов

Scenario: Working with numbers and dates

Week 2 IntroductionВидео

Practice Videos and Challenges

Download the Week 2 WorkbooksЧтениеConverting Data with VALUE and TEXTВидеоConverting Data with VALUE and TEXTЗаданиеUnderstanding dates and basic date functionsВидеоUnderstanding dates and basic date functionsЗаданиеGenerating Valid Dates using the DATE functionВидеоGenerating Valid Dates using the DATE functionЗаданиеCalculations with Dates and using DAYS, NETWORKDAYS and WORKDAYВидеоCalculations with Dates and using DAYS, NETWORKDAYS and WORKDAYЗаданиеMore sophisticated date calculations with EOMONTH and EDATEВидеоMore sophisticated date calculations with EOMONTH and EDATEЗаданиеWeek 2 Practice ChallengeЧтение

Toolbox

Week 2 ToolboxЧтение

Assessment

Working with numbers and dates: Test your skillsЗадание
03Defined Names for working more effectively with data15 материалов

Scenario: Defined Names for working more effectively with data

Week 3 IntroductionВидео

Practice Videos and Challenges

Download the Week 3 WorkbooksЧтениеCell Referencing and NamingВидеоCell Referencing and NamingЗаданиеDefined Names and Create from SelectionВидеоDefined Names and Create from SelectionЗаданиеManaging NamesВидеоManaging NamesЗаданиеCalculations with Named RangesВидеоCalculations with Named RangesЗаданиеAutomating Data Validation with Named RangesВидеоAutomating Data Validation with Named RangesЗаданиеWeek 3 Practice ChallengeЧтение

Toolbox

Week 3 ToolboxЧтение

Assessment

Defined Names for working more effectively with data: Test your skillsЗадание
04Tables for automating data manipulation15 материалов

Scenario: Tables for automating data manipulation

Week 4 IntroductionВидео

Practice Videos and Challenges

Download the Week 4 WorkbooksЧтениеIntroduction to TablesВидеоIntroduction to TablesЗаданиеCustomising TablesВидеоCustomising TablesЗаданиеSorting and Filtering TablesВидеоSorting and Filtering TablesЗаданиеTable Calculations and Structured ReferencesВидеоTable Calculations and Structured ReferencesЗаданиеAutomation with TablesВидеоAutomation with TablesЗаданиеWeek 4 Practice ChallengeЧтение

Toolbox

Week 4 ToolboxЧтение

Assessment

Tables for automating data manipulation: Test your skillsЗадание
05Logical and lookup functions15 материалов

Scenario: Logical and lookup functions

Week 5 IntroductionВидео

Practice Videos and Challenges

Download the Week 5 WorkbooksЧтениеApply logical operations to data using IFВидеоApply logical operations to data using IFЗаданиеNested IF, AND and ORВидеоNested IF, AND and ORЗаданиеCategorising data with VLOOKUPВидеоCategorising data with VLOOKUPЗаданиеMatching data with VLOOKUP and XLOOKUPВидеоMatching data with VLOOKUP and XLOOKUPЗаданиеPower Lookups with INDEX and MATCHВидеоPower Lookups with INDEX and MATCHЗаданиеWeek 5 Practice ChallengeЧтение

Toolbox

Week 5 ToolboxЧтение

Assessment

Logical and lookup functions: Test your skillsЗадание
06Final assessment1 материалов

Final assessment

Final AssessmentЗадание