Advance Excel Classes

Basic Trick For Excel Operating
1. Paste Special
2. Data Shifting
3. Tricks In Copy Paste And Clear Formatting
4. Short Cuts
Adv. Formulas
1. Hlookup
2. Vlookup
3. Index
4. Match
5. Picture Lookup
6. And
7. Or
8. Others
Formulas in sheets
1. Salary Sheet
2. Sale Sheet
3. Calling Sheet
4. Hospital Sheet
5. Attendance Sheet
6. Mark sheet
7. Other Sheets For Nested Formulas
Adv. Tools
1. Conditional Formatting With Formulas
2. Advance Filter
3. Data Validation (Custom)
4. Text to column (With Symbols)

Get in touch