
PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES
Menu
EXCEL TRICKS excel solutions
EXCEL TRICKS
- INDEX -MATCH USAGE
- CREATE A PROGRESS CHART IN EXCEL
- CREATE A THERMOMETER CHART IN EXCEL
- CREATE A DROP DOWN LIST IN EXCEL
- CREATE DEPENDENT DROP DOWN LIST IN EXCEL
- CREATE A DYNAMIC DROP DOWN LIST IN EXCEL
- FIND LAST USED CELL IN EXCEL
- ADD LEADING ZERO TO NUMBER
- INSERT A COPYRIGHT SYMBOL
- INSERT A CHECK MARK IN EXCEL
- HOW TO COUNT THE NUMBER OF OCCURRENCES IN A COLUMN
- HOW TO ROTATE TABLE IN EXCEL
- INSERT PI SYMBOL IN EXCEL
- INSERT EURO SYMBOL IN EXCEL
- FORMAT CELLS TO SHOW EURO SYMBOL IN EXCEL
- INSERT DEGREE SYMBOL IN EXCEL
- INSERT A LAMBDA SYMBOL IN EXCEL
- INSERT A DIVISION SYMBOL IN EXCEL
EXCEL – DATE AND TIME TRICKS
- MANIPULATING DATES AND TIME IN EXCEL-PART I
- MANIPULATING DATES AND TIME IN EXCEL- PART II
- MANIPULATING TEXT IN EXCEL -PART I
- MANIPULATING TEXT IN EXCEL-PART II
- CHECK IF A CELL CONTAINS TEXT IN UPPER CASE OR LOWER CASE
- HOW TO INSERT CURRENT DATE AND TIME IN EXCEL
- HOW TO CALCULATE DATE AFTER N DAYS IN EXCEL
- HOW TO CALCULATE DATE N DAYS AGO IN EXCEL
- HOW TO COMBINE DATE AND TIME IN EXCEL
- HOW TO SEPARATE DATE AND TIME IN EXCEL
- HOW TO INSERT DATE IN EXCEL
- HOW TO GET MILITARY TIME IN EXCEL
- HOW TO CREATE TIME SLOTS IN EXCEL
- HOW TO CALCULATE TIME AFTER GIVEN HOURS, MINUTES AND SECONDS IN EXCEL
- HOW TO CONVERT TEXT TO TIME IN EXCEL
- HOW TO GET CURRENT TIME IN EXCEL
- HOW TO CONVERT TIME INTO DECIMAL NUMBER IN EXCEL
- HOW TO SUBTRACT TIME IN EXCEL
- HOW TO ADD TIME IN EXCEL
- HOW TO FIND THE STARTING AND ENDING DATE OF CURRENT WEEK
- HOW TO CALCULATE NUMBER OF DAYS, MONTHS OR YEARS BETWEEN TWO DATES IN EXCEL
- HOW TO DISPLAY THE CURRENT MONTH OR CURRENT DAY IN WORDS IN EXCEL
- HOW TO GET THE SERIAL NUMBER OF DATE IN EXCEL
EXCEL SOLUTIONS
- HOW TO CUSTOMIZE QUICK ACCESS TOOLBAR
- HOW TO CUSTOMIZE RIBBON IN EXCEL
- HOW TO ADD A WATERMARK IN EXCEL SHEET
- HOW TO PRINT BACKGROUND IMAGE IN EXCEL
EXCEL – TEXT TRICKS
- HOW TO COMPARE TWO TEXT STRINGS IN EXCEL
- HOW TO COMBINE TEXT IN EXCEL
- HOW TO SEPARATE/SPLIT TEXT IN EXCEL
- HOW TO USE IF STATEMENT WITH TEXT IN EXCEL
- HOW TO ROTATE TEXT IN EXCEL
- HOW TO EXTRACT TEXT FROM CELL IN EXCEL
- HOW TO CHECK IF CELL CONTAINS NUMBER OR TEXT
- HOW TO COUNT CELLS WITH SPECIFIC TEXT IN EXCEL
- HOW TO SOLVE NUMBER STORED AS TEXT PROBLEM IN EXCEL
- HOW TO TRUNCATE TEXT IN EXCEL
- HOW TO CREATE VERTICAL TEXT IN EXCEL
- HOW TO CROSS OUT TEXT IN EXCEL
- HOW TO APPEND TEXT IN EXCEL
- HOW TO COUNT UNIQUE TEXT VALUES IN EXCEL
- HOW TO USE COUNTIF FUNCTION WITH TEXT IN EXCEL
- HOW TO STRIKETHROUGH TEXT IN EXCEL
- HOW TO SUPERSCRIPT IN EXCEL?
- HOW TO SUBSCRIPT IN EXCEL?
- HOW TO LINK A TEXT BOX TO A CELL IN EXCEL?
EXCEL FUNCTION-TRICKS
EXCEL CONDITIONAL FORMATTING – TRICKS
- HOW TO USE CONDITIONAL FORMATTING BASED ON ANOTHER CELL
- HOW TO USE CONDITIONAL FORMATTING BASED ON TEXT
- HOW TO COPY CONDITIONAL FORMATTING IN EXCEL ?
- HOW TO HIGHLIGHT DUPLICATE VALUES IN EXCEL?
EXCEL FORM CONTROLS
LEARN
- EXCEL
- HTML
- JAVASCRIPT
- MORE TO COME…
If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at