YoVDO

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

Offered By: Skillshare

Tags

Microsoft Excel Courses Programming Courses User Interface Design Courses Macros Courses Excel VBA Courses

Course Description

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

Related Courses

مقدمة إلى برنامج أدوبي إكس دي
Coursera Project Network via Coursera
Access SQLite in an Android Studio Project
Coursera Project Network via Coursera
Make an Action Bar in Unity Part 1 - Modular Action System
Coursera Project Network via Coursera
Align Design Teams with SCAMPER Brainstorming in Miro
Coursera Project Network via Coursera
Amazon Honeycode Essentials
Amazon Web Services via AWS Skill Builder