PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES HOME CATEGORIES MS EXCEL HINDI EXCEL JAVASCRIPT HTML VBA EXCEL TRICKS AND SOLUTIONS POWER BI GOOGLE SHEETS VIDEOS CONTACT US SUBSCRIBE DISCLAIMER Menu HOME CATEGORIES MS EXCEL HINDI EXCEL JAVASCRIPT HTML VBA EXCEL TRICKS AND SOLUTIONS POWER BI GOOGLE SHEETS VIDEOS CONTACT US SUBSCRIBE DISCLAIMER Search for: EXCEL TRICKS excel solutions EXCEL TRICKSINDEX -MATCH USAGECREATE A PROGRESS CHART IN EXCELCREATE A THERMOMETER CHART IN EXCELCREATE A DROP DOWN LIST IN EXCELCREATE DEPENDENT DROP DOWN LIST IN EXCELCREATE A DYNAMIC DROP DOWN LIST IN EXCELFIND LAST USED CELL IN EXCELADD LEADING ZERO TO NUMBERINSERT A COPYRIGHT SYMBOLINSERT A CHECK MARK IN EXCELHOW TO COUNT THE NUMBER OF OCCURRENCES IN A COLUMNHOW TO ROTATE TABLE IN EXCELINSERT PI SYMBOL IN EXCELINSERT EURO SYMBOL IN EXCELFORMAT CELLS TO SHOW EURO SYMBOL IN EXCELINSERT DEGREE SYMBOL IN EXCELINSERT A LAMBDA SYMBOL IN EXCELINSERT A DIVISION SYMBOL IN EXCELHOW TO UNSORT OR REVERSE SORT DATA IN EXCELEXCEL – DATE AND TIME TRICKSMANIPULATING DATES AND TIME IN EXCEL-PART IMANIPULATING DATES AND TIME IN EXCEL- PART IIMANIPULATING TEXT IN EXCEL -PART IMANIPULATING TEXT IN EXCEL-PART IICHECK IF A CELL CONTAINS TEXT IN UPPER CASE OR LOWER CASEHOW TO INSERT CURRENT DATE AND TIME IN EXCELHOW TO CALCULATE DATE AFTER N DAYS IN EXCELHOW TO CALCULATE DATE N DAYS AGO IN EXCELHOW TO COMBINE DATE AND TIME IN EXCELHOW TO SEPARATE DATE AND TIME IN EXCELHOW TO INSERT DATE IN EXCELHOW TO GET MILITARY TIME IN EXCELHOW TO CREATE TIME SLOTS IN EXCELHOW TO CALCULATE TIME AFTER GIVEN HOURS, MINUTES AND SECONDS IN EXCELHOW TO CONVERT TEXT TO TIME IN EXCELHOW TO GET CURRENT TIME IN EXCELHOW TO CONVERT TIME INTO DECIMAL NUMBER IN EXCELHOW TO SUBTRACT TIME IN EXCELHOW TO ADD TIME IN EXCELHOW TO FIND THE STARTING AND ENDING DATE OF CURRENT WEEKHOW TO CALCULATE NUMBER OF DAYS, MONTHS OR YEARS BETWEEN TWO DATES IN EXCELHOW TO DISPLAY THE CURRENT MONTH OR CURRENT DAY IN WORDS IN EXCEL HOW TO GET THE SERIAL NUMBER OF DATE IN EXCEL EXCEL SOLUTIONSMY DRAG HANDLE IS MISSINGHOW TO OPEN A FILE IN EXCELHOW TO SAVE A FILE IN EXCELHOW TO PRINT A SHEET IN EXCELHOW TO PRINT A SHEET IN ONE PAGEHOW TO PRINT TOP ROW ON EVERY PAGEHOW TO PRINT HEADER ON EVERY PAGEHOW TO PRINT PAGE NUMBER ON EVERY PAGEHOW TO CUSTOMIZE QUICK ACCESS TOOLBARHOW TO CUSTOMIZE RIBBON IN EXCELHOW TO ADD A WATERMARK IN EXCEL SHEETHOW TO PRINT BACKGROUND IMAGE IN EXCELEXCEL – TEXT TRICKSHOW TO COMPARE TWO TEXT STRINGS IN EXCELHOW TO COMBINE TEXT IN EXCELHOW TO SEPARATE/SPLIT TEXT IN EXCELHOW TO USE IF STATEMENT WITH TEXT IN EXCELHOW TO ROTATE TEXT IN EXCELHOW TO EXTRACT TEXT FROM CELL IN EXCELHOW TO CHECK IF CELL CONTAINS NUMBER OR TEXTHOW TO COUNT CELLS WITH SPECIFIC TEXT IN EXCELHOW TO SOLVE NUMBER STORED AS TEXT PROBLEM IN EXCELHOW TO TRUNCATE TEXT IN EXCELHOW TO CREATE VERTICAL TEXT IN EXCELHOW TO CROSS OUT TEXT IN EXCELHOW TO APPEND TEXT IN EXCELHOW TO COUNT UNIQUE TEXT VALUES IN EXCELHOW TO USE COUNTIF FUNCTION WITH TEXT IN EXCELHOW TO STRIKETHROUGH TEXT IN EXCELHOW TO SUPERSCRIPT IN EXCEL?HOW TO SUBSCRIPT IN EXCEL?HOW TO LINK A TEXT BOX TO A CELL IN EXCEL? EXCEL FUNCTION-TRICKSUSE XLOOKUP IN EXCEL 20016 ,2013, 2010, 2007.EXCEL CONDITIONAL FORMATTING – TRICKSHOW TO USE CONDITIONAL FORMATTING BASED ON ANOTHER CELLHOW TO USE CONDITIONAL FORMATTING BASED ON TEXTHOW TO COPY CONDITIONAL FORMATTING IN EXCEL ?HOW TO HIGHLIGHT DUPLICATE VALUES IN EXCEL?EXCEL FORM CONTROLSHOW TO INSERT A CHECKBOX IN EXCEL ? LEARNEXCELHTMLJAVASCRIPTMORE 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]