Excel

Things to Learn:

1) Understanding the excel screen

2) Ribbon Customization and Shortcut for automatic startup

3) Bordering Row, and Column insertion

4) Coloring & Presentation of Excel Sheet

5) Quick shortcut for Selection using Ctrl & Shift Keys

6) Advance formatting using practical sheets

7) Auto fill & drag option

8) Sorting of Data and Filter of data along with Magic Shortcut

9) Mathematical formula - Average, Sum, Auto-sum, Total, Sub-Total

10) Date & Time Date Diff etc

11) Look up

12) Vlookup

13) All functions - Countif, Sumif, IF, IFF

14) Find and Replacein Excel and its application

15) Conditional Formatting and its application

16) Print page setup techniques

17) Various print techniques

18) Magical short cut for Time reduction

19) Protecting & Hiding in Excel

20) Using review Tab for daily work

21) Charts & Pivot Table insertion