Hygia LMS
Course Content
Topic outline
General
1. How To Use Clipboard To Copy & Paste Several Items
2. Using Paste Special To Copy Format, Formula, Values & its Shortcut Keys
3. Copy Conditional Format, Column Width, Number Format By Paste Special
4. Using Paste Special To Transpose Data And To Add or Subtract Values
5. How To Use Data Validation Option For Whole Numbers & Error Alert?
6. How To Create Data Validation For Decimal Numbers & Other Data Options
7. How To Create Drop Down Menu & Set Character Limit By Data Validation?
8. How to Set Limit for Date & Time Using Data Validation Option?
9. Preventing Duplicate Entries & Allow Text / Numbers Only
10. How To Add Data Of Multiple Sheets & Workbook By Consolidate Option
11. Learn To Insert & Delete Image From Background of Data
12. How to Navigate Between Sheets of a Workbook using go to option
13. How To Use Print Option For Printing Worksheet & Setting Orientation/Margins
14. How to print title or heading on every page by print titles option
15. How to use the LOOKUP Function
16. How To Use Vlookup Formula To Find Particular Data In Same/Different Workbooks
17. How To Check Column & Row Number Of A Cell By Column & Row Formula
18. How to Check Number of Columns or Rows in a Table Using Columns & Rows Formula
19. How To Get Multiple Results by Using Vlookup Formula For Single Time
20. Use Of Hlookup Formula To Find Data From Database In Same/Different Workbooks
21. How To Freeze & Unfreeze Multiple Rows And Columns
22. Generate Random Numbers Using Rand And Rand between Formula
23. Learn To Calculate EMI Using PMT Formula
24. Use of goal seek formula to know estimated down payment amount
25. How To Insert Chart & Change Its Color, Style Etc.
26. How to calculate interest & Principal amount of loan using IPMT & PPMT function
27. How to use Averageif & Averageifs in MS Excel to calculate average based on different conditions
27. How to use Averageif & Averageifs in MS Excel to calculate average based on different conditions
28. How to create template in MS Excel with font style, font size, alignment etc. of your choice
29. How to use COUNT, COUNT A, COUNT BLANK, COUNT IF, COUNT IFS formula
30. How to remove different types of formula errors
31. How to use concatenate formula and “&” sign to combine data of 2 or more cells
32. How to change case (upper, lower, proper) and concatenate text at same time
33. How to use FV formula to calculate future value of an investment
34. How to protect a complete worksheet or a part of worksheet with password
35. How to use clean formula in MS Excel for removing non-printable characters from data
36. How to calculate running total using Sum Formula
37. How to split full name to first and last name
38. How to use Dsum in MS Excel to add numbers of particular column based on a condition
39. How to use Dget in Excel to search a record from a database according to a condition
40. How to use Daverage in MS Excel to find average of a data of a column based on condition