How does this work?
- Course Content
- DVD Vs Offline
Topics Covered In a set of Two DVD
1. What is Macro?
i. VBA Editor, Project Explorer, Code Pane, and Properties Window
ii. The Object Browser
iii. Assign Macro
2. Recording Macro
i. How to record Macro
ii. Shortcut keys
iii. Limitations of Recoding
iv. How to Optimize Recorded Macro
3. Recording Macro R1C1 Style
i. Convert R1C1 Style into general
4. What is Variable?
iv. Value transfer
v. Declaration (Implicit / Explicit)
vi. Local, Static, Global
5. Object Model
6. Difference Between Subroutine and Function with example
7. Worksheet Concept
i. Different way to refer the Sheet (By Name, By Index)
iv. Deletion (Single/Multiple)
v. Insertion (Single/Multiple)
vi. Referring multiple sheets
8. Workbook and Windows Concept
iii. State (Minimize/Maximize/Resize)
iv. Active window
v. Not Operator
9. Refer Cell, Range, Columns, Row
i. Consecutive Range
ii. Split range
iii. Column Selection (Single/Multiple)
iv. Row Selection (Single/Multiple)
v. Difference between Cell and Range
10. With Statement
11. Current Region and Used Range concept
12. Special Cells
v. Last Row
13. Filter Data
i. Single Criteria
ii. Multiple Criteria
iii. AND operator
iv. OR Operator
v. Like Operator
vi. Top item
vii. Bottom item
14. IF Statement
i. Simple if
ii. If and Else
iii. Sorting example
v. If else with Msgbox integration
vi. Multiple Elseif
vii. Nested if
15. String and Conversion Functions
16. Offset Statement
i. Current region
ii. Resize Range
17. While Loop
i. With Conditions
ii. Play with variable
iv. Increment Decrement
v. Is Empty
18. For Loop (More than 10 Example)
19. Nested For Loop (Multiple Example)
20. Nested For Loop (Pyramid creation) – Multiple Example
21. For Each loop (More than 15 Practical Examples)
22. Nested For Each Loop
23. Function Procedure (More than 15 example)
i. Function through looping (for and For each)
ii. Inbuilt Function (Multiple Examples)
24. Event Handling
25. Select Case Statement
i. Difference between if and select case
ii. Select case with Function Procedure
iii. Calling Procedure
26. Charts Concept
i. Option Base
ii. Fixed Size
iii. One Dimensional
iv. Dynamic array
v. LBound, UBound
vii. Two Dimensional
28. Error Handling Techniquesi. Error Type
ii. On Error Resume Next
iii. On Error Goto Label
iv. On Error Resume Again
v. On Error Goto 0
29. Calling Function in a Procedure
i. Through File Handling Example
ii. Through Function Procedure
30. Connectivity with MS Access
i. Database Connectivity
ii. Early Binding
iii. Late Binding
iv. Reference Library
vii. Connection Testing
viii. Connection String
ix. Run SQL Query through VBA
x. Import data from MS Access or SQL Server
31. Connectivity with PowerPoint
i. New Instance Creation
ii. Initialization application
iv. Layout Slide
vi. Add Multiple Slides
vii. Copy data from Excel and paste in PowerPoint
viii. Copy Chart from Excel and paste in PowerPoint Slides
32. Connectivity with MS Word
33. Web scrapping
i. Website Navigation
ii. How to Inspect Element and their respective values
iii. Innertext; Outertext ; ReadyState ; Doevents
iv. Pull up the Data from Website
v. Pull up values from multiple Webpages
vi. Extract the Data by id
vii. Extract multiple value by Class and through multiple Webpages
viii. Extract Hyperlinks from website by Anchor Tag
34. Connectivity with Outlook
i. Invoke Outlook
ii. Mail Item; Subject; To; CC; BCC etc.
iii. Send Basic Email through VBA-Macro
iv. Send Mail to multiple recipient
v. Add Attachment
vi. Add Body Information
vii. Insert HTML Tag in Outlook Mail
viii. Send Mail to multiple recipient along with Excel data in range (Array)
xi. Property Window
xii. How to handle Event (On File opening; Click, DoubleClick; Initialization; Activate; before Entry;
before Exit etc.)xiii. Validate User input (Multiple Examples)
xiv. Form as per Application Size (Hiding Excel)
xv. Disable Application Visibility
36. Deal with PDF
i. Export data into PDF
37. Project Work
i. How to automate a report
ii. File handling
Q: What version of Excel is used in this course?
A: This course covers 2007, 2010, and 2013. The videos are recorded in Excel 2013, with features that are also applicable for 2010 and 2007. Any minor difference in versions is highlighted upfront and details on all the versions are covered.
Q: What all payment methods are accepted?
A: You can pay using debit or credit card (VISA, Master Card, Amex) via secure checkout or through PayUMoney.
Q: Can I share the Downloaded Videos and Files with friends/colleagues?
A: You are not allowed to share the videos/files with friends/colleagues and sharing the content would be a copyright violation.
Q: I am a beginner in Excel. Is it too advanced for me?
A: If you are a complete newbie in Excel, then it’s recommended to understand the concept of Excel first and there after you can opt for VBA – Macro.
Q: Are there any other hidden payments?
A: Absolutely NOT. You pay exactly what you see (Not a Penny more)
Q: The course is too pricey... Can I get it for less?
A: Excel skill is one of the most sought after skills in the world, and people with this skill always have a head-start. The price is the minimum possible price for the course at which we have made it available (considering website maintenance, operational and tax costs are to be paid as well)
Q: Will my money be refunded or money back guarantee?
A: Not, There is no procedure to return the money, however you found any defect in the product or its not working properly. We will replace the product without charging any penny.
Q: What happens to the videos I have downloaded after the membership tenure is over?
A: You have the right to keep those videos and use whenever you want. However, you are not allowed to share the videos or files with anyone at any point in time.
Look forward to having you as a student of the Excelprince!!
For more information… Please click on