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

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

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

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

Spreadsheet Macros and VBA Automation

Курс от EDUCBA
Уровень не указан≈ 13.5 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

Master Excel VBA and Macros to automate repetitive tasks and boost productivity. Learn how to transform manual Excel work into efficient, automated workflows. This course takes you from recording your first macro to writing powerful VBA code for real-world applications. You will explore the VBA object model, learn how to work with ranges, variables, and loops, and apply conditional logic to build dynamic solutions. Through hands-on exercises and practical projects, you will develop the skills to automate data processing, improve reporting efficiency, and create interactive Excel tools using MsgBox and InputBox. Designed for beginners and professionals alike, this course simplifies complex programming concepts into easy-to-follow steps, enabling you to confidently apply VBA in real-world scenarios. By the end of the course, you will be able to automate Excel tasks, write structured VBA code, and significantly enhance your productivity and career opportunities.

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

Excel MacrosVisual Basic (Programming Language)AutomationData StoreScriptingSpreadsheet SoftwareData ProcessingScripting LanguagesData StructuresComputational LogicBusiness Process AutomationFollow ThroughMicrosoft ExcelProgramming PrinciplesDesignBuild ToolsDevelopment EnvironmentComputer Programming ToolsReal Time DataProductivity

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

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

01Getting Started with Macros12 материалов

Introduction to Macros

Overview - MacroВидеоRecording First MacroВидеоIntroduction to MacrosЗадание

Macro Recording Techniques

Special Selection MacroВидео

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

EDUCBA

Преподаватель курса

Spreadsheet Macros and VBA Automation
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 13.5 ч

5 модулей

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

Часть программы вашего университета
Absolute and Relative Cell ReferenceВидео
Macro Recording TechniquesЗадание

Running and Managing Macros

Copy Data Recording a MacroВидеоVarious Ways of Running MacroВидеоRunning and Managing MacrosЗаданиеDesigning and Executing Efficient Excel Macros for Task AutomationDIALOGUEGetting Started with MacrosЗаданиеAutomating Daily Excel Tasks Using Macro Recording and ExecutionDIALOGUE
02Understanding VBA Basics11 материалов

VBA Environment and Model

Understanding VBA ModelВидеоColor Differences and Keyboard shortcutsВидеоVBA Environment and ModelЗадание

Working with Cells and Ranges

How to Refer to Range and Write to Cell in VBAВидеоWriting to Cells in VBAВидеоWorking with Cells and RangesЗадание

Properties and Methods in VBA

Most used Range PropertiesВидеоMost useful Properties and MethodsВидеоMost useful Properties and Methods ContinuedВидеоProperties and Methods in VBAЗаданиеUnderstanding VBA BasicsЗадание
03Advanced Referencing and Data Handling11 материалов

Copying Data and Range Operations

Copy and Pasting Various MethodsВидеоDifferent Ways to Reference WorksheetВидеоCopying Data and Range OperationsЗадание

Worksheet Referencing in Practice

Referencing Worksheets ProjectВидеоReferencing Worksheets Project ContinuedВидеоWorksheet Referencing in PracticeЗадание

Variables and Data Storage

Understanding VariablesВидеоVariables DeclarationВидеоArray DeclarationВидеоVariables and Data StorageЗаданиеAdvanced Referencing and Data HandlingЗадание
04Control Structures and Automation Logic13 материалов

Working with Objects and Scope

Set StatementВидеоVariable ScopeВидеоWorking with Objects and ScopeЗадание

Collections and Looping

Understanding Collections and with end withВидеоWith - End With ExampleВидеоFor Each Loop CollectionsВидеоCollections and LoopingЗадание

Conditional Logic and Flow Control

Protecting Sheet with PasswordВидеоIf Then StatementВидеоSelect Case StatementВидеоGo to StatementВидеоConditional Logic and Flow ControlЗаданиеControl Structures and Automation LogicЗадание
05Practical Applications and VBA Functions12 материалов

Practice and Assignments

Sample ActivityВидеоAssignment 2ВидеоPractice and AssignmentsЗадание

VBA Functions Overview

Basic VBA FunctionsВидеоVBA FunctionsВидеоVBA Functions OverviewЗадание

User Interaction in VBA

MsgBox FunctionВидеоInput Box FunctionВидеоInput Box ExcelВидеоUser Interaction in VBAЗаданиеPractical Applications and VBA FunctionsЗаданиеAutomating Excel Reporting Using Macros and VBADIALOGUE