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
    19. HOW TO UNSORT OR REVERSE SORT DATA 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
  11. HOW TO ADD A WATERMARK IN EXCEL SHEET
  12. HOW TO PRINT BACKGROUND IMAGE 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  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
  16. HOW TO STRIKETHROUGH TEXT IN EXCEL
  17. HOW TO SUPERSCRIPT IN EXCEL?
  18. HOW TO SUBSCRIPT IN EXCEL?
  19. HOW TO LINK A TEXT BOX TO A CELL 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
  2. HOW TO USE CONDITIONAL FORMATTING BASED ON TEXT
  3. HOW TO COPY CONDITIONAL FORMATTING IN EXCEL ?
  4. HOW TO HIGHLIGHT DUPLICATE VALUES IN EXCEL?

EXCEL FORM CONTROLS

  1. HOW TO INSERT A CHECKBOX IN EXCEL ?

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]