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

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

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

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

Spreadsheet Automation Projects

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

О курсе

Master Excel VBA automation by building real-world macro projects for business productivity and reporting. Learn how to automate repetitive Excel tasks, create dashboards, and manage workflows efficiently using VBA macros. This hands-on course teaches practical Excel VBA development through business-focused projects such as login/logout trackers, file splitter automation, file merger systems, and interactive dashboards. Learners will understand how to use VBA coding, loops, variables, filters, workbook automation, and macro recording to streamline daily operations. By the end of the course, learners will be able to create automated Excel solutions that reduce manual effort, improve productivity, and support business reporting workflows. Whether you are an Excel beginner or a working professional, this course provides practical VBA automation skills that can be applied immediately in real workplace scenarios.

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

Excel MacrosSpreadsheet SoftwareAutomationDashboardMicrosoft ExcelOperations Support SystemsBusiness OperationsBusiness Process AutomationIT AutomationBusiness Workflow AnalysisOperationsProductivityBusiness SolutionsFile SystemsBusiness ReportingBusinessWorkflow ManagementManagement ReportingOperations ManagementDashboard Creation

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

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

01Getting Started with VBA Login Automation9 материалов

Introduction to VBA & Tracker Setup

Introduction to VB Macro ApplicationsВидеоCreating Login Logout TrackerВидеоIntroduction to VBA & Tracker SetupЗадание

Creating Login Interface & Understanding Code

Creating Display Button of LoginВидео

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

EDUCBA

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

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

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 8.7 ч

4 модулей

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

Часть программы вашего университета
Understand Coding PartВидео
Creating Login Interface & Understanding CodeЗадание
Building an Automated Employee Login Tracker with VBADIALOGUE
Getting Started with VBA Login AutomationЗадание
Employee Attendance Automation Setup with Excel VBADIALOGUE
02Building Login & File Splitter Macros10 материалов

Creating and Assigning Login Macros

Creating MacroВидеоAssign Macro LoginВидеоCreating and Assigning Login MacrosЗадание

Managing Login Time & Save Actions

Working on Login TimeВидеоAssign Macro SaveВидеоManaging Login Time & Save ActionsЗадание

Developing File Splitter Macros

Crate File Splitter MacroВидеоCrate File Splitter Macro ContinuesВидеоDeveloping File Splitter MacrosЗаданиеBuilding Login & File Splitter MacrosЗадание
03File Management & Merger Automation10 материалов

Working with Master Files & Filters

Activate Master FileВидеоApplying FilterВидеоWorking with Master Files & FiltersЗадание

Running Automation & Display Alerts

Application Display AlertВидеоRunning MacroВидеоRunning Automation & Display AlertsЗадание

Creating File Merger Macros

Create File Merger MacroВидеоCreate File Merger Macro ContinuesВидеоCreating File Merger MacrosЗаданиеFile Management & Merger AutomationЗадание
04Dashboard Automation with VBA12 материалов

Building Merge Sheets & File Merger

Creating Merge SheetВидеоCreating file MergerВидеоBuilding Merge Sheets & File MergerЗадание

Designing Dashboards with Macrocode

Create Dashboard Using MacrocodeВидеоDashboard Using Macrocode ContinuesВидеоDesigning Dashboards with MacrocodeЗадание

Advanced Dashboard Creation in VBA

Dashboard - Working with CodingВидеоDashboard Using Recording MacroВидеоCreate Dashboard Using VBAВидеоAdvanced Dashboard Creation in VBAЗаданиеDashboard Automation with VBAЗаданиеExcel VBA Automation Specialist SimulationDIALOGUE