Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Meditation Personal Transformation Life Purpose Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Google Analytics
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Office Productivity Microsoft Excel VBA

Ultimate Excel VBA Macros Training Course

The ultimate excel course to learn VBA as quickly and efficiently as possible
Rating: 4.4 out of 54.4 (48 ratings)
10,546 students
Created by Commerce Curve
Last updated 12/2020
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Students will learn how to optimize their time usage of Excel to automate their manual processes and gain time in their daily workflow.
  • Basic programming

Requirements

  • Basic-Intermediate knowledge of Excel

Description

This course is designed for the non-programming Excel user, to help them learn how to use the VBA portion of Excel. Learning how to write VBA code will allow Excel users to automate many tasks in Excel, saving them time in the long run. This course provides the information necessary for someone who has no knowledge of programming to learn the basics of programming while at the same time learning how to create useful macros with VBA in Excel.

Who this course is for:

  • Basic - Intermediate level Excel users looking to improve their skills with Excel

Course content

9 sections • 74 lectures • 4h 22m total length

  • Preview09:58
  • Preview09:11
  • Preview13:34
  • Preview09:22
  • Preview12:11
  • Offset Formula And Its Importance To Navigate In Excel Sheets
    15:12
  • Offset Formula Interaction With Sumif And Counta
    10:28

  • Understand VBA Modules, Procedures, Functions And Sub-Procedures
    08:35
  • Preview06:26
  • Creating Sub Procedures For Common Tasks 1
    07:27
  • Creating Sub Procedures For Common Tasks 2
    13:52
  • VBA Object Explorer
    02:45
  • Preview02:34
  • Understanding Variables and Data Types
    04:16
  • Preview03:30
  • Navigate Through VBA Objects Available With Excel
    04:03
  • Understand Objects, Methods, Properties, And Events
    02:45

  • Assigning Macro To A Shape In Excel For Easy Navigation Between VBA Codes
    03:41
  • Preview01:20
  • Understanding The Limitations Of Record Macro Technique In Comparison With VBA
    04:03
  • Overview of VBA Statements
    02:34

  • Dynamic Formula Editing to Automate Processes
    03:07
  • Preview02:30
  • Dim and Range
    05:35
  • Preview02:45
  • What Are Variables? Including Multinational Arrays And Storing Variable Values
    04:51
  • Expression In VBA Statements
    01:12
  • Preview05:48
  • Preview02:12
  • Statement To Refer Current Workbook And Navigate Through Sheets
    02:48
  • Statement To Open All Workbooks
    02:58
  • Statement To Refer To A Worksheet In Same Workbook Or In Other Workbook
    01:21
  • Defining Variables And Their Syntax
    02:22
  • Using For/Next Statements
    03:18
  • Preview02:52

  • Workbook Objects And Related Sub Categories
    02:07
  • Worksheet Objects And Related Sub Categories
    02:25
  • Active Cell, Column, Rows Or String Selection Objects
    02:20
  • Active Window Command And Related Sub Categories
    01:11
  • Active Sheet Command And Related Sub Categories
    01:29
  • Cell Entire Row And Columns Properties And Commands
    01:22
  • Explanation Of Boolean Term In VBA
    01:43
  • This Workbook Command And Related Sub Categories
    01:35
  • VBA Error Handling And Debugging
    02:20
  • Preview03:20
  • If Worksheet Function Command
    01:36
  • On Error Command
    02:04
  • Preview03:40
  • Next And Last Command
    03:32
  • Application Command To Open Microsoft Apps
    02:05
  • Offset Command Or Range Command In VBA, Uses, Limitations And Errors
    02:53
  • VBA Message Box Function With Dynamic Parameters
    01:39
  • Preview02:15

  • Overview Of Form, Form Controls And Activex Controls
    02:22
  • Preview01:53
  • User Forms And Link With Developer Form Control And Active X Controls
    01:37
  • Create A Sample Userform For Purchase Invoice
    01:47

  • How To Create Custom Sub Procedures In Excel
    02:26
  • Convert Dynamic Range into String Data
    01:53
  • Preview01:24
  • Add Values In All Worksheet In One Single Master Sheet
    01:33
  • Find And Replace Accented Alphabets and Foreign Text Characters
    01:24

  • How To Create Custom Functions In Excel
    01:41
  • Adding Comments To Functions And Limitation Of Functions At Sheet Level
    01:28
  • Preview01:03
  • Accounting Functions 2 : Present Value And NPV Customization
    01:16
  • Commission Calculation
    00:56

  • Find and Replace Function For Multiple Strings
    01:20
  • Rename All Worksheets With Single Command Based On Pre Defined Values
    01:02
  • Preview01:18
  • Print Settings Including Page Margins, Specific Triggers, And Custom Pages
    01:11
  • Chart Object Command As A Sub Command Of Active Worksheets
    00:53
  • Programming Charts
    00:50
  • Generating Dynamic Results With Pivot Table Objects
    02:04

Instructor

Commerce Curve
Accelerate Your Career - Hands-on Finance/Accounting Courses
Commerce Curve
  • 4.4 Instructor Rating
  • 1,351 Reviews
  • 67,325 Students
  • 9 Courses

Commerce Curve is a finance educational channel for accounting and finance professionals, students, and entrepreneurs.

We post content to help you accelerate your career by teaching you the practical, hands-on skills which you don't learn in school.

Our courses include topics on accounting, finance, financial modeling, Excel and more.

Reach us at commercecurve@gmail.com

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.