Financial Management Theory Marathon
Taxation
Strategic Financial Management-Fast track
Price Rs. 3,990.00
Offer Price 1990.00
(Inclusive
of Registration and Tax)
- Video Duration: 8 Hours
- Language: English
- Enroll with Pendrive
(INR 1000 will be added) - E-Certificate (On completion of course : issued by CAclubindia)
What is Excel VBA Tutorial?
VBA which stands for Visual Basic for Applications is the programming language of Excel. Computers and technical devices have their own language to understand the data processing. Although it is like us who need a language, i.e. a medium to talk to and converse.
VBA is the language which Excel understands and talks in. VBA is known and can be used as the Programming language for other Office programs i.e. (Excel, Word, PowerPoint, Outlook, Access) as well. We always worry about learning new things thinking that it might be very difficult or we might get stuck somewhere. It is the same thing with learning a new language.
Course Curriculum:
- Module 1: WARM UP – 10 MIN
- With this Module, you’ll learn the Beginner level of tricks required to make any Presentation. You’ll get a proper Guidance on how to select and play right with the Colors and Pictures in a Presentation.
- ✔ Quick Tour for Beginners
✔ Slide Background (Color & Picture)
✔ Slide Header N Footer
✔ QAT and Alt Key tricks
- Module 2: RECORD AND RUN MACROS – 20 MINS
- With this Module, you’ll learn what you gain if you run record your own Excel Macros i.e. vba tutorial. You even get to learn how to Record and Run Macros.
- ✔ Macros – Record & Run
✔ Macros – Viewing the code
✔ Macro-free vs. Macro-enabled Workbook
✔ Visual Basic Editor (VBE)
✔ Personal Macro WB
✔ Ways to Run a Macros
- Module 3: GOOGLE YOUR VBA CODES – 19 MINS
- Module 4: OBJECTS, PROPERTIES, METHODS – 4 MINS
- With this Module, you’ll learn about Objects and their Properties. Most of the programming languages today are Object-Based and these are mainly Object-Oriented Programming Languages. You’ll learn how these are used coupled with methods of Excel.
- Objects, Properties, Values, Methods and Parameters 1
Objects, Properties, Values, Methods and Parameters 2
- Module 5: WORKSPACE INTERFACE – 13 MINS
- With this Module, you’ll learn that a workspace factory object can be a lot useful in creating new Workspace. Learn about the various editing methods to edit tools bars in Excel VBA.
- Code Color & Activating Edit Toolbar w. Comments
Edit Toolbar – Indent, Bookmark
Code writing shortcuts incl. Intellisense
Testing the Code
Immediate Window 01
- Module 6: RANGE & CELLS OBJECT – 26 MINS
- With this Module, you’ll learn How to use the Cell Property to select a Range. And that making use of Cells is actually useful when you wish to loop through ranges. You’ll learn about the different Range and Cell objects.
- Range Selection – Method 1
Range Selection – Method 2 & 3
Advantage of Range Selection – Method 2 & 3
Range Selection (Rows & Columns) – Method 4
Assigning values to selected range of cells
Exercise 1 – Assigning values to selected range of cells
Exercise 2- Assigning values to selected range of cells
Multiple Range Selection – Method 5
Multiple Range Selection – Method 6
RangeSelectionWays – Others
- Module 7: ABSOLUTE VS RELATIVE REFERENCE – 5 MINS
- Module 8: RANGE NAVIGATION – 15 MINS
- With this Module, you’ll learn one of the best and common use object that is the Range object. You’ll learn about Navigation in between a Range of Cells.
- Navigating between a Range of cells – Part 1
Navigating between a Range of cells – Part 2
Navigating between a Range of cells – Part 3
Exercise – Finding Last Row No.
Exercise – Finding Last Column No.
Exercise – Finding Next Row No.
- Module 9: VARIABLE DECLARATION – 20 MINS
- Module 10: LOOPS – 52 MINS
- With this Module, you’ll learn about loops in VBA. Looping is known as one of the most Powerful Technique of Programming.
- “For…Next”
“If…Else…End If” nested within “For…Next”
“Do…While”
“Do…Until”
“For Each…Next”
“If…End If” nested within “For Each…Next”
Exercise – “Do While” and Loop Counter”
With…End With” – Example 1
“With…End With” – Example 2
“Select…Case” – Demonstration
“Select…Case” – Explanation
- Module 11: OPTIMIZING CODE EFFICIENCY – 8 MINS
- Module 12: EVENT TRACKING – 37 MINS
- With this Module, you’ll learn about tracking all the events in VBA. For example, if a user ever changes the selection. Also, tracking the Worksheet changes of event.in Excel VBA.
- Introduction
Events – Workbook_Open and Worksheet_Activate
Exercise 1 – Tracking Workbook Opens
Exercise 2 – Tracking Workbook Save
Event – Worksheet_BeforeDoubleClick
Event – Worksheet_Change
Event – Worksheet_Calculate
Pivot Table – Refresh – WorkSheetActivate
- Module 13: INPUT BOX – 23 MINS
- Module 14: MSG BOX – 16 MINS
- Module 15: ACTIVEX CONTROLS – 8 MINS
- Module 16: USER DEFINED FUNCTIONS – 17 MINS
- With this Module, you’ll learn to make your own Functions. These Functions are called User Defined Functions. These are the Customize Excel Functions. These Codes allow you to take code from VBA and Rewrite it.
- UDF Intro 001
UDF Example 1 – Score Result with IF END IF
UDF Example 2 – CellComments
UDF Samples – Series A
UDF Samples – Series B
- Module 17: USER FORMS – 74 MINS
- With this Module, you’ll learn to create USER FORMS, this is helpful in making the User’s Data Entry Controllable. User Form helps the users to use data Easily.
- Introduction
User Form – Basics
Exercise – Part 1 of 4
Exercise – Part 2 of 4
Exercise – Part 3 of 4
Exercise – Part 4 of 4
Exercise – Part 4 of 4
Exercise – Part 4 of 4
Option Button – 1
Option Button – 2
Multi-Page – Introduction
Multi-Page – 1
Multi-Page – 2
Multi-Page – 3
Check Box 001
Combo Box – Method 1
Combo Box – Method 2
- Module 18: MIS PROJECTS – 40 MINS
- Module 19: REAL LIFE PROJECT – 91 MINS
About the Training Instructor:
Rishabh Pugalia, Founder, Yoda Learning Solutions/Excel Next has trained more than 9,000 professionals on Advanced Excel Ninja across 15+ cities since 2010.
Terms and Conditions:
- Total Length of Videos: 8 Hrs (129+ Videos)
- Expiry: 6.0 months (Unlimited viewing) from the date of registration
- Videos are meant for web viewing only and cannot be downloaded. Videos are available in Full Screen viewing
- Course/Subject purchased once cannot be cancelled
Buy now
CAclubindia
