“Microsoft excel or excel is the name given to the spreadsheet software provided by microsoft” which comes bundled with the microsoft office suite. Excel is one of the most important component of the office suite.
We have already discussed the standard options and functions available in Excel to accomplish many activities while using the Excel. But there are a number of activities which needs the execution of different functions or options to fulfill a particular requirement which we call as a trick.
For example,
there is no direct option in Excel to put a watermark in the background of your sheet, but it is possible to do it with the help of some other available options.
In this segment, we are going to learn a number of tricks which are described with the help of pictures , animations and theory for concept building.
Choose any of the categories shown below.
CHOOSE THE TRICK
HOW TO APPLY FORMULA TO ENTIRE COLUMN IN EXCEL?
Read More
HOW TO CONVERT ROW TO COLUMN IN EXCEL?
Read More
HOW TO SUBTRACT A PERCENTAGE IN EXCEL?
Read More
HOW TO SORT DATA PIVOT TABLES IN EXCEL?
Read More
HOW TO CREATE A TOOLTIP IN EXCEL?
Read More
HOW TO STRIKETHROUGH IN EXCEL USING CONDITIONAL FORMATTING?
Read More
HOW TO COUNT DUPLICATE VALUES IN EXCEL?
Read More
COUNT FUNCTION VS COUNTA FUNCTION IN EXCEL
Read More
HOW TO COUNT BLANK OR EMPTY CELLS IN EXCEL?
Read More
HOW TO COUNT THE CELLS CONTAINING SPECIFIC TEXT IN EXCEL?
Read More
HOW TO COUNT THE DISTINCT VALUES IN EXCEL?
Read More
HOW TO USE CONDITIONAL FORMATTING WITH DATES IN EXCEL?
Read More
HOW TO TYPE LONG DIVISION SYMBOL [ ⟌ ] IN EXCEL?
Read More
AVOID ENTERING DUPLICATE VALUES IN A COMPLETE COLUMN OF EXCEL
Read More
HOW TO TYPE CENTS SYMBOL [ ¢ ] IN EXCEL?
Read More
HOW TO INSERT THE CURRENT DAY AND CURRENT MONTH IN EXCEL ?
Read More
HOW TO TYPE EXCELLENT EMOJI [ 👌 ] IN EXCEL?
Read More
WHAT IS A PEOPLE’S GRAPH? HOW TO CREATE IN EXCEL ?
Read More
HOW TO HIGHLIGHT THE CURRENT DAY OF THE WEEK USING CONDITIONAL FORMATTING IN EXCEL?
Read More
HOW TO TYPE BITCOIN [₿] SYMBOL IN MICROSOFT EXCEL?
Read More
HOW TO ADD SQUARE ROOT [√] SYMBOL IN EXCEL ?
Read More
HOW TO SHOW FORMULA USED IN EXCEL ?
Read More
HOW TO CONVERT DEGREES TO RADIANS IN EXCEL ?
Read More
HOW TO CONVERT RADIANS INTO DEGREES IN EXCEL?
Read More
HOW TO PREDICT THE FUTURE VALUES IN EXCEL USING FORECAST FUNCTION ?
Read More
FIND LAST FILLED CELL IN EXCEL
Read More
WHICH IS BETTER – XLOOKUP OR VLOOKUP ?
Read More
HOW TO INSERT CHECKBOX IN EXCEL ?
Read More
HOW TO HIGHLIGHT THE DUPLICATE ENTRIES IN EXCEL
Read More
HOW TO COPY CONDITIONAL FORMATTING IN EXCEL?
Read More
EASY METHOD TO APPLY CONDITIONAL FORMATTING BASED ON TEXT IN EXCEL?
Read More
HOW TO USE CONDITIONAL FORMATTING BASED ON ANOTHER CELL IN EXCEL?
Read More
USE XLOOKUP IN EXCEL 2007, 2010, 2013, 2016, 2019
Read More
HOW TO LINK TEXT BOX WITH CELL IN EXCEL ?
Read More
HOW TO SUBSCRIPT TEXT IN EXCEL
Read More
HOW TO SUPERSCRIPT TEXT IN EXCEL
Read More
HOW TO STRIKETHROUGH TEXT IN EXCEL
Read More
HOW TO USE EXCEL COUNTIF TEXT CRITERIA
Read More
HOW TO FIND UNIQUE VALUES, UNIQUE TEXT VALUES OR UNIQUE NUMBERS IN EXCEL
Read More
HOW TO APPEND TEXT IN EXCEL
Read More
HOW TO CROSS OUT TEXT IN EXCEL
Read More
HOW TO CREATE VERTICAL TEXT IN EXCEL
Read More
HOW TO TRUNCATE TEXT IN EXCEL ?
Read More
HOW TO SOLVE NUMBER STORED AS TEXT PROBLEM
Read More
HOW TO COUNT CELLS WITH SPECIFIC TEXT
Read More
HOW TO CHECK IF A CELL CONTAINS TEXT OR NUMBER IN EXCEL ?[UPDATED]
Read More
HOW TO EXTRACT TEXT FROM A CELL IN EXCEL
Read More
HOW TO ROTATE TEXT IN EXCEL
Read More
HOW TO USE TEXT WITH IF STATEMENT IN EXCEL
Read More
HOW TO SPLIT CELLS IN EXCEL
Read More
HOW TO COMPARE TWO TEXT STRINGS IN EXCEL
Read More
HOW TO COMBINE TEXT IN EXCEL
Read More
HOW TO PRINT BACKGROUND IN EXCEL SHEET
Read More
HOW TO ADD WATERMARK IN EXCEL SHEET
Read More
HOW TO CUSTOMIZE RIBBON IN MICROSOFT EXCEL
Read More
HOW TO CUSTOMIZE QUICK ACCESS TOOLBAR
Read More
HOW TO PRINT PAGE NUMBER ALL THE PAGES IN EXCEL
Read More
HOW TO PRINT HEADER ON ALL THE PAGES IN EXCEL
Read More
HOW TO PRINT TOP ROW ON TOP OF EVERY PAGE IN EXCEL ?
Read More
HOW TO PRINT A SHEET ON ONE PAGE IN EXCEL
Read More
PRINT A SHEET IN EXCEL
Read More
SAVE A FILE IN EXCEL
Read More
OPEN A FILE IN EXCEL
Read More
CAN’T COPY FORMULA IN EXCEL
Read More
HOW TO GET THE DATE SERIAL NUMBER OF ANY DATE IN EXCEL
Read More
HOW TO DISPLAY THE CURRENT MONTH AND CURRENT DAY IN WORDS IN EXCEL
Read More
HOW TO CALCULATE AGE OR NUMBER OF DAYS BETWEEN TWO DATES
Read More
HOW TO FIND OUT THE STARTING AND ENDING DATE OF THE CURRENT WEEK
Read More
HOW TO ADD TIME IN EXCEL
Read More
HOW TO SUBTRACT TIME IN EXCEL
Read More
HOW TO CONVERT THE TIME TO DECIMAL
Read More
FIND CURRENT TIME IN EXCEL
Read More
HOW TO INSERT THE TIME FROM TEXT IN EXCEL
Read More
HOW TO FIND TIME AFTER CERTAIN HOURS , MINUTES OR SECONDS IN EXCEL
Read More
HOW TO CREATE TIME SLOTS IN EXCEL
Read More
HOW TO GET MILITARY TIME IN EXCEL
Read More
HOW TO INSERT A DATE IN EXCEL TO AVOID PROBLEMS
Read More
HOW TO SEPARATE DATE AND TIME IN EXCEL
Read More
COMBINE DATE AND TIME IN EXCEL
Read More
HOW TO FIND THE DATE 30/60/90/120 OR N DAYS AGO
Read More
HOW TO FIND THE DATE AFTER N DAYS IN EXCEL
Read More
HOW TO INSERT CURRENT DATE AND TIME IN EXCEL
Read More
CHECK IF THE TEXT HAS UPPER CASE OR LOWER
Read More
MANIPULATING TEXT IN EXCEL PART-II
Read More
MANIPULATING TEXT IN EXCEL PART-I
Read More
MANIPULATING DATES AND TIME IN EXCEL-PART II
Read More
MANIPULATING DATES AND TIME IN EXCEL
Read More
HOW TO REVERSE SORT OR UNSORT DATA IN EXCEL
Read More
HOW TO INSERT DIVISION / DIVIDE BY [÷] SYMBOL IN EXCEL
Read More
HOW TO INSERT LAMBDA SYMBOL IN EXCEL [λ or Λ] ?
Read More
HOW TO ADD DEGREE SYMBOL IN EXCEL [ °C ] ?
Read More
HOW TO FORMAT CELLS TO SHOW EURO SYMBOL WITH NUMBERS
Read More
HOW TO ADD EURO SYMBOL [CURRENCY €] IN EXCEL
Read More
6 WAYS TO INSERT PI SYMBOL IN EXCEL
Read More
ROTATE A TABLE IN EXCEL
Read More
HOW TO COUNT THE NUMBER OF OCCURRENCES IN A COLUMN IN EXCEL?
Read More
INSERT CHECK MARK OR TICK MARK SYMBOL IN EXCEL 🗸🗸🗸
Read More
ADDING COPYRIGHT SYMBOL © IN EXCEL
Read More
ADD LEADING ZERO IN EXCEL
Read More
FIND LAST FILLED CELL VALUE IN EXCEL
Read More
HOW TO CREATE A DYNAMIC DROP DOWN LIST IN EXCEL?
Read More
HOW TO CREATE A DEPENDENT DROP DOWN LIST IN EXCEL?
Read More
HOW TO CREATE A DROP DOWN LIST IN EXCEL?
Read More
CREATE A THERMOMETER CHART IN EXCEL
Read More
CREATE A PROGRESS CHART IN EXCEL
Read More
EXCEL TRICKS-USING INDEX-MATCH
Read More