Microsoft Excel - Beginner to Advance with Example

In this course you are going to learn, daily excel equations which are widely used in daily life with short cut. No prior knowledge is required. We have taken example to teach easily so one can learn from basic with example.

Example here taken to send email to the specific person directly from excel by using one button and navigating to the outlook in easy way. You are going to learn1. Basic excel equations widely used in2.

Hands on experience to the excel with understanding of basic and widely use shortcuts3. Analytical dashboard creation - Pie chart, Bar chart4. Data filtration, Border, Sr No.

, Format Painter5. Email shooting by using VBA from excel to specific users from outlook using single button6. Codes used in VBA7.

Data Validation - Drop Down List creation8. IF, Nested if, if(And) command as a equation9. Use of Conditional Formatting with Example10.

Remove Duplicates value in Excel11. Linking from excel to mail (You can shoot mail by clicking button from excel directly)12. Bar Chart, Pie Chart Creation - Dashboard13.

Understanding of VLOOKUP14. Index - Match equation for arranging and fetching right data15. Data Filter - Analyze data16.

Password Protected Mail shooting directly from excel17.