PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

EXCEL TRICKS excel solutions

EXCEL TRICKS

    1. INDEX -MATCH USAGE
    2. CREATE A PROGRESS CHART IN EXCEL
    3. CREATE A THERMOMETER CHART IN EXCEL
    4. CREATE A DROP DOWN LIST IN EXCEL
    5. CREATE DEPENDENT DROP DOWN LIST IN EXCEL
    6. CREATE A DYNAMIC DROP DOWN LIST IN EXCEL
    7. FIND LAST USED CELL IN EXCEL
    8. ADD LEADING ZERO TO NUMBER
    9. INSERT A COPYRIGHT SYMBOL
    10. INSERT A CHECK MARK IN EXCEL
    11. HOW TO COUNT THE NUMBER OF OCCURRENCES IN A COLUMN
    12. HOW TO ROTATE TABLE IN EXCEL
    13. INSERT PI SYMBOL IN EXCEL
    14. INSERT EURO SYMBOL IN EXCEL
    15. FORMAT CELLS TO SHOW EURO SYMBOL IN EXCEL
    16. INSERT DEGREE SYMBOL IN EXCEL
    17. INSERT A LAMBDA SYMBOL IN EXCEL
    18. INSERT A DIVISION SYMBOL IN EXCEL

EXCEL – DATE AND TIME TRICKS

  1. MANIPULATING DATES AND TIME IN EXCEL-PART I
  2. MANIPULATING DATES AND TIME IN EXCEL- PART II
  3. MANIPULATING TEXT IN EXCEL -PART I
  4. MANIPULATING TEXT IN EXCEL-PART II
  5. CHECK IF A CELL CONTAINS TEXT IN UPPER CASE OR LOWER CASE
  6. HOW TO INSERT CURRENT DATE AND TIME IN EXCEL
  7. HOW TO CALCULATE DATE AFTER N DAYS IN EXCEL
  8. HOW TO CALCULATE DATE N DAYS AGO IN EXCEL
  9. HOW TO COMBINE DATE AND TIME IN EXCEL
  10. HOW TO SEPARATE DATE AND TIME IN EXCEL
  11. HOW TO INSERT DATE IN EXCEL
  12. HOW TO GET MILITARY TIME IN EXCEL
  13. HOW TO CREATE TIME SLOTS IN EXCEL
  14. HOW TO CALCULATE TIME AFTER GIVEN HOURS, MINUTES AND SECONDS IN EXCEL
  15. HOW TO CONVERT TEXT TO TIME IN EXCEL
  16. HOW TO GET CURRENT TIME IN EXCEL
  17. HOW TO CONVERT TIME INTO DECIMAL NUMBER IN EXCEL
  18. HOW TO SUBTRACT TIME IN EXCEL
  19. HOW TO ADD TIME IN EXCEL
  20. HOW TO FIND THE STARTING AND ENDING DATE OF CURRENT WEEK
  21. HOW TO CALCULATE NUMBER OF DAYS, MONTHS OR YEARS BETWEEN TWO DATES IN EXCEL
  22. HOW TO DISPLAY THE CURRENT MONTH OR CURRENT DAY IN WORDS IN EXCEL
  23.  HOW TO GET THE SERIAL NUMBER OF DATE IN EXCEL
 

LEARN

  • EXCEL
  • HTML
  • JAVASCRIPT
  • MORE TO COME…

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

[email protected]

KINDLY SPEND FEW SECONDS HERE....

-We might be compensated for the visits or purchases you make by clicking the ads on this website .  They help us to keep bringing excellent quality articles for you.
-Click on the pictures if you can’t read. All of them are High Resolution .
-If you can’t find what you were looking for, kindly message in the chat box.
*CLICK ANYWHERE ELSE TO CLOSE THIS WINDOW