Excel VBA: How to Write Macros Like a Professional
5.0 /5- Offered byUDEMY
Excel VBA: How to Write Macros Like a Professional at UDEMY Overview
Duration | 5 hours |
Total fee | ₹649 |
Mode of learning | Online |
Credential | Certificate |
Excel VBA: How to Write Macros Like a Professional at UDEMY Highlights
- Earn a certificate of completion from Udemy
- Learn from 9 downloadable resources & 1 article
- Get full lifetime access of the course material
- Comes with 30 days money back guarantee
Excel VBA: How to Write Macros Like a Professional at UDEMY Course details
- For Accountants/Auditors/Financial planners
- For Business/Financial Analysts
- For Managers/Project Managers/Project Planners
- For Anyone who wants to learn how to write VBA in a professional environment
- For Anyone who wants to exponentially increase their productivity at work
- For Anyone who wants an introduction to programming with a straightforward langauge
- For Anyone who wants to increase their value to their current or potential employer
- For Any user of Excel who wants to dramatically increase their abiltiy
- Learn little-known techniques used by the top professionals
- Over 70 example Macros for you to use in your own projects
- Discover the best method to access a worksheet and the ones you should avoid
- Learn how to use Intellisense to help you write your code
- Learn how to supercharge your Excel experience using Loops
- How to resolve errors quickly and painlessly
- Learn programming techniques you can use in any programming language
- Learn When to use "If" and when to use "Select"
- Learn how to build an entire Excel VBA application from start to finish
- In this brand new section you will see techniques not taught in any other Excel VBA course
- This new section(number 15) contains proven principles and little-known techniques that will help you build an application in a fraction of the time it would normally take you
- You will also learn tips and tricks that will reduce your errors, make your code more organised, and make your applications easier to maintain and update
- This is the only Excel VBA course that shows you first hand, a professional developer creating a VBA application from scratch
Excel VBA: How to Write Macros Like a Professional at UDEMY Curriculum
Introduction
Setting yourself up to win
Getting Started
A Quick Environment Check
Your First Macro
How to Create Modules
The Immediate Window - How to easily test your output
Using Intellisense - Let VBA help you write code
Workbooks and Worksheets
Using Range to manipulate cells
How to get any Workbook
When to use each Workbook method
Making your code easy to read - Use a Workbook variable
How to get any Worksheet
Putting it all together - A sample Macro
VBA's best kept secret - the worksheet codename
The Sample Macro - How the code name improves it
Summary of Worksheets and Workbooks
Using Variables
An introduction to Variables
How to do almost anything with a string
Using variables to write and read from Cells
Ranges, Cells and Offsets
Using Range to manipulate cells
Using Cells - How to choose cells at run time part 1
Using Offset - How to choose cells at run time part 2
Sample Macro - Writing to months using Offset
Sample Macro - Writing to months using Cells
Formatting Ranges - Making you work look good
Mini Project - Fruit Sales
Introduction to Mini Project
Formatting the Cells
Write the Totals
Make it flexible with Offset
Excel VBA: How to Write Macros Like a Professional at UDEMY Faculty details
Excel VBA: How to Write Macros Like a Professional at UDEMY Entry Requirements
- Prerequisite: Knowledge of Microsoft Excel
- Not mentioned
Other courses offered by UDEMY
Excel VBA: How to Write Macros Like a Professional at UDEMY Students Ratings & Reviews
1 Rating- 4-51
Student Forum
Anything you would want to ask experts?