Basic to Advance – including Equation, Dashboard creation, VBA, Data validation, Shortcuts, Charts. Zero to Hero guide
-
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
GET ON UDEMY