• Basic excel equations widely used in
• Email shooting by using VBA Directly from excel to specific users
• Hands on experience to the excel with understanding of shortcuts
• Analytical dashboard creation
• Data filtration, Border, Sr No., Format Painter
• Codes used in VBA
• Function today() and Equation additing
• Command Dollar {$} understanding
• Data Validation – Drop Down List creation
• IF, Nested if, if(And) command
• Use of Conditional Formatting with Example
• Remove Duplicates value in Excel
• Automate Boarder – Where data available
• Understanding of VLOOKUP
• Index – Match equation
• Data Filter – Analyse data
• Bar Chart, Pie Chart Creation – Dashboard
• VBA Form Creation
• Password Protected Mail shooting directly from excel
   

Who this course is for:

• Beginners to the excel
• College students
• To become expert in excel
• Who wants to learn excel from basic, and want to become expert
• Want to understand the real life corporate situation and solve from the basic