DVD Purchase


001. First Topic Macro 00:07:18
002. Recording Macro 00:14:07
003 Recoding Macro R1C1 Style 00:11:32
004. Data type-OK 00:05:30
005. Variable - Local Static Global 00:06:38
006. Implicit  - Explicit Declaration-OK 00:05:59
007. Object Model-Property-Event-Method 00:07:31
008. SubRoutine Vs Function 00:06:10
009. Basic Concept (Refer Sheet) 00:07:27
010. Basic Concept (Refer Sheet)-Part2 00:13:45
011. Basic Concept (Refer Sheet)-Part3 00:05:02
012. Workbook and Window 00:05:36
013. Workbook and Window-2 00:03:52
014. Cells - Range - Row - Columns 00:12:53
015. With Statement 00:05:21
016. Currunt Region Used Range 00:05:53
017. Special Cells 00:06:53
018. Filter Concept with Criterias 00:08:33
019. IF Statement  00:10:46
020. IF with Msgbox Concept 00:09:19
021. Multiple Elseif 00:05:23
022. Multiple IF Conditions 00:06:21
023. String Function + conversion Function 00:15:21
024. Offset Function 00:10:56
025. Offset +Resizing 00:04:08
026. While Loop 00:06:58
027. While Loop Part -2 00:04:58
028. While Loop Part -3 00:04:33
029. Simple For Loop 00:08:11
030. Simple For Loop Part-2 00:06:37
031. Nested For Loop Part-3 00:10:50
032. Nested For Loop Part-4 00:14:56
033. For Each Loop Part-1 00:10:29
034. For Each Loop Part-2 00:07:45
035. For Each Loop Part-3 00:10:34
036. Nested For Each Loop 00:05:27
037. Filter Resize - Copy filtered Data-Delete filtered Data 00:08:59
038. Function Procedure (User Defined Function) 00:08:26
039. Function Procedure (Sum of Digits) 00:03:17
040. Function Procedure (Char Count+Sumof Coloured Cell) 00:08:21
041. Event Handling (Intersaction) 00:12:15
042. Select Case Statement 00:09:04
043. Select Case with Function Procedure 00:10:38
044. Create Charts in VBA 00:10:08
045. USerform - Combobox 00:14:53
046. USerform - Listbox -Label - Selection 00:14:30
047. USerform - PropertyWindow 00:07:46
048. USerform - OptionButton-Checkbox-Listbox-Multipage-EventHandling 00:22:39
049. USerform - Validate User Inputs 00:16:55
05.5 Applying Formula Externaly 00:09:44
050. USerform - Full in Size 00:08:10
051. USerform - Application Visible 00:05:33
052. Array Concept - One Dimension Fixed Size 00:13:52
053. Array Concept - One Dimension LBound and Ubound+Redim 00:08:08
054. Array Concept - Multi Dimension 00:13:25
055. Error Handling Techniques (on Error resume next + Goto Label) 00:07:11
056. Error Handling Techniques (On Error Resume Again) 00:06:58
057. Calling Function in Procedure 00:20:11
058. Connectivity with MS Access-EarlyBinding 00:18:49
059. Connectivity with MS Access-LateBinding 00:09:32
060. Connectivity with MS Access-SQL Queries by VBA 00:17:40
061. Connectivity with Power-Point 00:11:54
062. Connectivity with Power-Point - Copy  Excel Data to PowerPoint 00:12:12
063. Connectivity with Power-Point - Copy  Charts PowerPoint 00:12:43
064.  Connectivity with MS Word with VBA 00:08:06
065. Pull Up Data from Website - Webscrapping-ID 00:19:28
066. Pull Up Data from Website - Webscrapping - Class 00:18:37
067. Pull Up Data from Website - Webscrapping - By Anchor Tag 00:09:05
067. Send Basic Email Part 1 00:08:43
068. Send Basic Email Part 2 00:13:57
069. Send Basic Email Part 3 00:05:26
070. Send Basic Email Part 4 00:09:09
071. Exporting as pdf 00:02:47
072. Live Project Work 00:25:17
  • Course Content
  • FAQ
  • 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?
i. Type
ii. Scope
iii. Assign
iv. Value transfer
v. Declaration (Implicit / Explicit)
vi. Local, Static, Global

5. Object Model
i. Hierarchy
ii. Property/Event/Method
6. Difference Between Subroutine and Function with example

7. Worksheet Concept
i. Different way to refer the Sheet (By Name, By Index)
ii. Visibility
iii. Renaming
iv. Deletion (Single/Multiple)
v. Insertion (Single/Multiple)
vi. Referring multiple sheets
vii. Copy
viii. Moving

8. Workbook and Windows Concept
i. Opening
ii. Activation
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
i. Comments
ii. Formula
iii. Visible
iv. Constant
v. Last Row
vi. Blank

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
iv. Msgbox
v. If else with Msgbox integration
vi. Multiple Elseif
vii. Nested if

15. String and Conversion Functions
i. Concatenation
ii. Split
iii. Ucase
iv. Lcase
v. Instr
vi. Validation
vii. Len
viii. Cint
ix. Val

16. Offset Statement
i. Current region
ii. Resize Range
iii. Set

17. While Loop
i. With Conditions
ii. Play with variable
iii. Inputbox
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
i. Intersection

25. Select Case Statement
i. Difference between if and select case
ii. Select case with Function Procedure
iii. Calling Procedure

26. Charts Concept
Advance Topic

27. Array
i. Option Base
ii. Fixed Size
iii. One Dimensional
iv. Dynamic array
v. LBound, UBound
vi. Redim
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
vi. Recordset
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
iii. Slide
iv. Layout Slide
v. Textframe
vi. Add Multiple Slides
vii. Copy data from Excel and paste in PowerPoint
viii. Copy Chart from Excel and paste in PowerPoint Slides
ix. Positioning
x. Size

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)

35. Userform
i. Label
ii. Combobox
iii. Listbox
iv. OptionButton
v. Checkbox
vi. Image
vii. Frame
viii. ToggleButton
ix. Scrollbar
x. SpinBar
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


Learning Through DVD VS Offline

How does this work?

query button