Learn Excel from beginner to advance with Example

 Learn Excel from beginner to advance with Example

Learn Excel from 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.

You are going to learn : –

1. Email shooting by using VBA from excel to specific users

2. Codes used in VBA

3. Data Validation – Drop Down List creation

4. IF, Nested if, if(And) command

5. Use of Conditional Formatting with Example

6. Remove Duplicates value in Excel

7. Linking from excel to mail (You can shoot mail by clicking button from excel directly)

8. Bar Chart, Pie Chart Creation – Dashboard

9. Understanding of VLOOKUP

10. Index – Match equation

11. Data Filter – Analyse data

12. Password Protected Mail shooting directly from excel



No comments:

Powered by Blogger.