ajay parmar
I am here to make you awesome in Excel VBA. Let us take a deep dive into VBA and learn it from the beginning.
We are starting with Macro recorder introduction. How to record steps and play it later using VBA.
How to Edit the existing macros if your boss want you to change few lines.
How to Run macros or delete macros or give shortcut keys. There are different ways to execute your program or macro. Know all of them.
How to find out last row and how to select the data. We have discussed Static and Dynamic , both approaches and their advantages ,disadvantages over each other. Everything is discussed in full detail. Great for freshers who do not know anything about programming.
How to correct Macros if they are recorded with wrong steps.
How to run macro step by step which we need it for debugging.
How to move from one sheet to another. What errors we can expect if sheet name changes and how to sort out your issues.
Introduction to Variables. What are variables and why do we need them. How to declare them.
Data types of Variables and their significance in your project. Strings. Integer, Single, byte, Double , Variants – we have covered all.
Instructor Details
Courses : 8
Specification: Excel VBA Introduction- Data Analytics Series1
|
2 reviews for Excel VBA Introduction- Data Analytics Series1
Add a review
| Price | $14.99 |
|---|---|
| Provider | |
| Duration | 6 hours |
| Year | 2019 |
| Level | All |
| Language | English |
| Certificate | Yes |
| Quizzes | No |
$14.99
Dipak Bohara –
This series is very good for beginners. The tutorial is very clearly explained that there is no any confusion left behind. I am very happy to choose Ajay Sir as my Trainer.
Kevin Starr –
I’m enjoying the course. The instructor is very detailed and careful but moves at a good pace and keeps the material interesting.