(2022) Microsoft Office- Learn Excel from very basics-NEW
Offered By: Skillshare
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
Introduction to Computational Finance and Financial EconometricsUniversity of Washington via Coursera Excel 2010
Miríadax The Finance of Retirement & Pensions
Stanford Graduate School of Business via NovoEd Einführung in die Wahrscheinlichkeitstheorie
Johannes Gutenberg University Mainz via iversity Introduction to VBA/Excel Programming
Cal Poly Pomona via Open Education by Blackboard