Microsoft Excel - Beginner to Advance with Example
Basic to Advance - including Equation, Dashboard creation, VBA, Data validation, Shortcuts, Charts. Zero to Hero guide
What you'll learn
- 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
*** Hidden text: cannot be quoted. ***