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

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
 

EXCEL SOLUTIONS

  1. MY DRAG HANDLE IS MISSING

  2. HOW TO OPEN A FILE IN EXCEL

  3. HOW TO SAVE A FILE IN EXCEL

  4. HOW TO PRINT A SHEET IN EXCEL

  5. HOW TO PRINT A SHEET IN ONE PAGE

  6. HOW TO PRINT TOP ROW ON EVERY PAGE

  7. HOW TO PRINT HEADER ON EVERY PAGE

  8. HOW TO PRINT PAGE NUMBER ON EVERY PAGE

  9. HOW TO CUSTOMIZE QUICK ACCESS TOOLBAR
  10. HOW TO CUSTOMIZE RIBBON IN EXCEL

EXCEL – TEXT TRICKS

  1. HOW TO COMPARE TWO TEXT STRINGS IN EXCEL
  2. HOW TO COMBINE TEXT IN EXCEL
  3. HOW TO SEPARATE/SPLIT TEXT IN EXCEL
  4. HOW TO USE IF STATEMENT WITH TEXT IN EXCEL
  5. HOW TO ROTATE TEXT IN EXCEL
  6. HOW TO EXTRACT TEXT FROM CELL IN EXCEL
  7. HOW TO CHECK IF CELL CONTAINS NUMBER OR TEXT
  8. HOW TO COUNT CELLS WITH SPECIFIC TEXT IN EXCEL
  9. HOW TO SOLVE NUMBER STORED AS TEXT PROBLEM IN EXCEL
  10. HOW TO TRUNCATE TEXT IN EXCEL
  11. HOW TO CREATE VERTICAL TEXT IN EXCEL
  12. HOW TO CROSS OUT OR STRIKE THROUGH TEXT IN EXCEL
  13. HOW TO APPEND TEXT IN EXCEL
  14. HOW TO COUNT UNIQUE TEXT VALUES IN EXCEL
  15. HOW TO USE COUNTIF FUNCTION WITH TEXT IN EXCEL

EXCEL FUNCTION-TRICKS

  1. USE XLOOKUP IN EXCEL 20016 ,2013, 2010, 2007.

EXCEL CONDITIONAL FORMATTING – TRICKS

  1. HOW TO USE CONDITIONAL FORMATTING BASED ON ANOTHER CELL

LEARN

  • EXCEL
  • HTML
  • JAVASCRIPT
  • MORE TO COME…

Encourage us by following at …

Facebook Twitter Pinterest

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

[email protected]

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

  • PICTURES ARE TOO SMALL?? Don’t worry, Click them, and pinch zoom to see them properly. All pictures are in high resolution.
  • KINDLY LIKE OUR FACEBOOK PAGE BY CLICKING HERE  AND IF WE NEED TO IMPROVE, KINDLY SEND US THE FEEDBACK ON [email protected]
  • Didn’t get what you were looking for?? Just put your question in the chat box present in the Right Lower corner. Name and email id [No spamming, just for the answer of your requirement] are needed.
*CLICK ANYWHERE ELSE TO CLOSE THIS WINDOW
%d bloggers like this: