Name of The Video

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
    i. On Error Resume Next
    ii. On Error Goto Label
    iii. On Error Resume Again
    iv. 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
    v. ADODB
    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

query button