MS Excel by

Course Discontinued

This course is no longer available and has been discontinued

Topic Name	Faculty	Topic Length
SECTION 1: The Macro Recorder Course Overview Defining Macros Application of Macros Recording a Macro Edit the recorded Macro and Shortcut key Saving a macro file Macro Security settings Running Macros Storage Location	Yoda Learning	43 mins
SECTION 2:VBA fundamentals What is Programming VBA Fundamentals Enable Developer Tab VBE Writing a small VBA code	Yoda Learning	40 mins
SECTION 3: Building Procedures How to create a sub procedure Adding Comments Types of procedures Calling Procedure Passing Arguments to the procedure	Yoda Learning	16 mins
SECTION 4: Working With Excel VBA Functions How to create functions How to use conditions in functions Using conditions If...Then....Else User Defined Functions	Yoda Learning	25 mins
SECTION 5: Basics of VBA coding Assigning a variable Different ways of assigning variables DataTypes Constants Operators	Yoda Learning	41 mins
SECTION 6: Working with the dialog boxes MsgBox Adding arguments to the msg box Input Box usage	Yoda Learning	9 mins
SECTION 7: Working with the objects Object Reference Model Range Cell objects Range Properties and Methods Range Count Property Mergecell & range Range Select Selection of Rows and Columns Difference between Dim and Set Understanding Worksheet Object Worksheet properties and methods Understanding workbook object How to Delete a workbook Application Objects Object Browser	Yoda Learning	45 mins
SECTION 8: Manipulating Excel Objects Offset Application of Offset Offset property in VBA	Yoda Learning	16 mins
SECTION 9: Loops Loops For-next loop Do while-loop Do-loop while Assignment For Each…Next	Yoda Learning	37 mins
SECTION 10: Events - Triggering code with Events Creating Events(Open Event) Close Events Workbook Activate Sheet Events Workbook Activate Events Worksheet ActivateDec Events Application Events	Yoda Learning	20 mins
SECTION 11: Creating Excel Add-ins How to create Excel Add-ins	Yoda Learning	5 mins
SECTION 12: Debugging And Error Handling Error Handling Debugging Speeding Up The VBA Tips	Yoda Learning	28 mins
SECTION 13: Working with the Arrays in VBA Array Function Dynamic and Fixed Arrays Size of Array	Yoda Learning	19 mins
SECTION 14: Working with the Userforms Selecting a Range with The Input Box An Introduction To UserForms Step by step process of creating a userform How to create a userform canvas Adding controls to the userform How to set the properties to userform controls Adding codes to the form controls Allowing The User To Highlight A Range using VBA Allowing The User To Highlight a Range using Userform How to create scrollbars and spinbutons in the userfom Adding images to the Userform How to add an Image in the Userform using a list box Adding Option Buttons In a Frame Multiple Tabs On A UserForm Controlling Tab Order and Aligning Controls	Yoda Learning	68 mins
SECTION 15: Working on a Live project Data mining with Advanced Filters Split Data to Multiple Worksheets Method 1 Split Data to Multiple Worksheets Method 2 How to split the Filtered Data onto Multiple Workbooks How to combine Multiple Worksheets to one single Worksheet in Excel? Merging Data from Multiple Workbooks into a Summary Workbook Using VBA to create Pivot tables Assignment Using VBA to create Charts Concept of Binding Automating Word Using Excel VBA Export charts to Powerpoint using Excel VBA Export the data to Powerpoint Outlook Mails Sending Outlook Mails with Attachment	Yoda Learning	50 mins
SECTION 16: Case Study Password Protection Creating Hyperlinks to all the Worksheets	Yoda Learning	16 mins
SECTION 17: Conclusion	Yoda Learning	3 mins

Meet Your Instructor

Yoda Learning

Yoda Learning is a team of 12+ industry professionals focused on developing Project-based" training videos. Its co-founders' diverse industry experience in the field of Finance and Accounting, helps target areas of practical application in context of the online training programs. Co-Founders:
- Rishabh Pugalia (CA) has worked with KPMG, Futures First & J.P. Morgan
- Rishabh Bhandari (MBA) has worked with Kaizen Private Equity (Education Focussed Fund)
The firm also develops eLearning programs in the domains of Web Development, Mobile App Development, Data Analytics and Design.