Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Skillshare

(2022) Microsoft Office- Learn Excel from very basics-NEW

via Skillshare

This course may be unavailable.

Overview

Welcome to the course on Excel VBA - Learn from very basics of Macros Course!

This class is completely targeted towards basics of VBA Programming.

I have designed in a way it is easy to understand each topic with shorter videos.

Learning VBA programming enables you to create an user friendly interface with your system to automate your daily tasks and this course is always in HUGE demand in the market.

This course does not require any programming knowledge of macros.

Only Requirement:

MS Excel (2007 - 2016)

This Course is for:

  • All Excel Users who want to improve their productivity
  • All Employees who wish to gain knowledge on macros
  • All Users of Excel with basic knowledge in Excel

So let's begin our Learning Journey!!

Syllabus

  • Introduction
  • VBA Developer tab and User interface
  • Create a MsgBox
  • Record macro tool
  • VBA Objects, Properties and Methods
  • Range Object
  • Working on Worksheets
  • Working on Workbooks
  • VBA Basic Variables
  • VBA Basic Data Type Variables
  • VBA Range Object Variables
  • Using WithStatement
  • Loops using For Loop 1
  • Loops using For Loop 2
  • For each loop
  • If and Else If Statement

Taught by

Sai K

Reviews

Start your review of (2022) Microsoft Office- Learn Excel from very basics-NEW

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.