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

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

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

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

Build a CRM with Spreadsheet Automation

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

О курсе

Build a complete CRM system with spreadsheet automation and VBA to manage customers, leads, dashboards, and workflows. Learn how to automate customer data, improve productivity, and create a practical CRM solution without complex software. This hands-on course teaches you how to design and develop a functional Customer Relationship Management system using spreadsheets and VBA. You will start by understanding CRM workflows, system structure, customer data management, and lead tracking before building key features step by step. The course covers VBA automation logic, reusable functions, data entry forms, interactive dashboards, customer record management, lead handling, and user interaction tracking. You will also learn advanced features such as admin modules, password management, data control, and security settings. By the end of this course, you will have a working CRM system and the practical skills to automate business processes, organize customer information, and improve decision-making. This course is ideal for beginners, business professionals, sales teams, and spreadsheet users who want job-ready CRM automation skills.

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

Customer Relationship ManagementLead GenerationData ManagementAutomationDashboardData EntryProductivityDecision MakingData MaintenanceMicrosoft ExcelBusiness ProcessCustomer Relationship Management (CRM) SoftwareSalesCustomer Data ManagementRelationship ManagementCustomer Relationship BuildingExcel MacrosDashboard CreationBusinessSpreadsheet Software

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

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

01CRM Foundations & System Overview12 материалов

Introduction to CRM Concepts

Introduction to CRM using Power PointВидеоBasic Demo of Running CRMВидеоIntroduction to CRM ConceptsЗадание

Exploring CRM Functionality

Basic Demo of CRM ContinuesВидео

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

EDUCBA

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

Build a CRM with Spreadsheet Automation
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 9.1 ч

4 модулей

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

Часть программы вашего университета
Development of CRM in VBAВидео
Exploring CRM FunctionalityЗадание

System Architecture & Workflow

Learning Process Flow DiagramВидеоClient MachineВидеоSystem Architecture & WorkflowЗаданиеDesigning CRM Workflows for Real-World Customer ManagementDIALOGUEGraded - CRM Foundations & System OverviewЗаданиеDesigning an Effective CRM Workflow Using Excel-Based SystemDIALOGUE
02VBA Development & Core Components12 материалов

VBA Coding Fundamentals

VBA Coding Explained Part 1ВидеоVBA Coding Explained Part 2ВидеоVBA Coding Explained Part 3ВидеоVBA Coding FundamentalsЗадание

Dashboard Design & Automation

DashboardВидеоDashboard CodingВидеоDashboard Design & AutomationЗадание

Core Functions & Logic Building

Generic FunctionВидеоStore ComboВидеоSelect Case StatementВидеоCore Functions & Logic BuildingЗаданиеGraded - VBA Development & Core ComponentsЗадание
03Data Handling & CRM Functionalities13 материалов

Data Loading & Interface Enhancements

Load DetailsВидеоList View AdditionsВидеоLeadsВидеоData Loading & Interface EnhancementsЗадание

Data Operations & Management

Other Loading details ExplainedВидеоEdit Data or Add a New DataВидеоMT User FormВидеоData Operations & ManagementЗадание

Data Updates & Lead Management

Updating DataВидеоUpdating Data ContinueВидеоAdd New LeadВидеоData Updates & Lead ManagementЗаданиеGraded - Data Handling & CRM FunctionalitiesЗадание
04Advanced Features, Admin & Finalization12 материалов

Data Control & Security

How to Save DataВидеоHow to Delete DataВидеоHow to Change PasswordВидеоData Control & SecurityЗадание

Admin Module & System Control

Explain Admin ModuleВидеоExplain Coding and AdminВидеоAdmin Module & System ControlЗадание

Final Review & Wrap-Up

Explain DashboardВидеоConclusionВидеоFinal Review & Wrap-UpЗаданиеGraded - Advanced Features, Admin & FinalizationЗаданиеBuilding and Managing a CRM System Using Excel & VBADIALOGUE