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

Документы и презентации в LaTeX (Introduction to LaTeX)
Higher School of Economics via Coursera
Excel Avanzado
Miríadax
Excel aplicado a los negocios (Nivel Avanzado)
Universidad Austral via Coursera
Excel Skills for Business: Intermediate II
Macquarie University via Coursera
Diseño de sistemas de información gerencial para intranet con Microsoft Access
Universidad del Rosario via edX