MICROSOFT EXCEL – TRICKS AND SOLUTIONS

“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 TYPE CENTS SYMBOL [ ¢ ] IN EXCEL?

Table of Contents INTRODUCTION WHAT IS CENT SYMBOL [ ¢ ] ? ADD A CENT SYMBOL IN EXCEL 1. COPY ...
Read More

HOW TO INSERT THE CURRENT DAY AND CURRENT MONTH IN EXCEL ?

Table of Contents INTRODUCTION PURPOSE OF DISPLAYING CURRENT DAY OR MONTH IN EXCEL DISPLAY THE CURRENT MONTH AND CURRENT DAY ...
Read More

HOW TO TYPE EXCELLENT EMOJI [ 👌 ] IN EXCEL?

Table of Contents INTRODUCTION WHAT IS EXCELLENT EMOJI? DIFFERENT WAYS TO INSERT EXCELLENT EMOJI IN EXCEL? DELIVERY DESK- COPY PASTE ...
Read More

WHAT IS A PEOPLE’S GRAPH? HOW TO CREATE IN EXCEL ?

Table of Contents INTRODUCTION WHAT IS A PEOPLE CHART? WHEN DO WE USE PEOPLE GRAPHS ? WHERE IS BUTTON LOCATION ...
Read More

HOW TO HIGHLIGHT THE CURRENT DAY OF THE WEEK USING CONDITIONAL FORMATTING IN EXCEL?

Table of Contents INTRODUCTION WHY DO WE NEED HIGHLIGHTING THE DAY OF A WEEK? CONCEPT BEHIND HIGHLIGHTING THE CURRENT DAY ...
Read More

HOW TO TYPE BITCOIN [₿] SYMBOL IN MICROSOFT EXCEL?

Table of Contents INTRODUCTION WHAT IS A BITCOIN? ADDING A BITCOIN SYMBOL SIGN IN EXCEL 1. READY TO USE BITCOIN ...
Read More

HOW TO ADD SQUARE ROOT [√] SYMBOL IN EXCEL ?

Table of Contents INTRODUCTION ADD A SQUARE ROOT SYMBOL IN EXCEL DIFFERENT METHODS OF ADDING A SQUARE ROOT SYMBOL 1.DELIVERY ...
Read More

HOW TO SHOW FORMULA USED IN EXCEL ?

Table of Contents INTRODUCTION WHY TO SHOW THE FORMULAS USED IN EXCEL ? WHERE TO FIND THE OPTION TO SHOW ...
Read More

HOW TO CONVERT DEGREES TO RADIANS IN EXCEL ?

Table of Contents INTRODUCTION WHAT IS A RADIAN ? WHAT IS A DEGREE ? WHY TO CONVERT DEGREES TO RADIANS ...
Read More

HOW TO CONVERT RADIANS TO DEGREES IN EXCEL?

Table of Contents INTRODUCTION WHAT IS A RADIAN ? WHAT IS A DEGREE ? WHY TO CONVERT RADIANS TO DEGREES ...
Read More

HOW TO PREDICT THE FUTURE VALUES IN EXCEL USING FORECAST FUNCTION ?

Table of Contents INTRODUCTION PURPOSE OF FORECAST/FORECAST.LINEAR FUNCTION IN EXCEL PREREQUISITES TO LEARN FORECAST.LINEAR SYNTAX: FORECAST/FORECAST.LINEAR FUNCTION EXAMPLE 1: PREDICT ...
Read More

FIND LAST FILLED CELL IN EXCEL

Table of Contents INTRODUCTION FINDING LAST FILLED CELL IN A ROW SOLUTION: FIND LAST CELL IN A ROW USING LOOKUP ...
Read More

WHICH IS BETTER – XLOOKUP OR VLOOKUP ?

INTRODUCTION EXCEL is the best spreadsheet tool as of now with great functionalities and it is getting better with every ...
Read More

HOW TO INSERT CHECKBOX IN EXCEL ?

Table of Contents INTRODUCTION WHY TO USE CHECKBOX IN EXCEL? BUTTON LOCATION FOR INSERTION OF CHECK BOX IN EXCEL HOW ...
Read More

HOW TO HIGHLIGHT THE DUPLICATE ENTRIES IN EXCEL

Table of Contents INTRODUCTION WHEN TO HIGHLIGHT THE DUPLICATES IN MICROSOFT EXCEL? STEPS TO HIGHLIGHT THE DUPLICATES IN EXCEL STEPS ...
Read More

HOW TO COPY CONDITIONAL FORMATTING IN EXCEL?

Table of Contents INTRODUCTION PREREQUISITES DIFFERENT WAYS TO COPY CONDITIONAL FORMATTING IN EXCEL EXAMPLE: COPY CONDITIONAL FORMATTING IN EXCEL APPLYING ...
Read More

HOW TO USE CONDITIONAL FORMATTING BASED ON TEXT IN EXCEL?

Table of Contents INTRODUCTION HOW TEXT IS HANDLED IN EXCEL? WHAT IS CONDITIONAL FORMATTING BASED ON TEXT ? EXAMPLE 1: ...
Read More

HOW TO USE CONDITIONAL FORMATTING BASED ON ANOTHER CELL IN EXCEL?

Table of Contents INTRODUCTION WHEN WE NEED TO USE CONDITIONAL FORMATTING BASED ON OTHER CELL EXAMPLE 1:HIGHLIGHT THE NUMBERS DIVISIBLE ...
Read More

USE XLOOKUP IN EXCEL 2007, 2010, 2013, 2016, 2019

Table of Contents INTRODUCTION WHAT IS GKXLOOKUP ? WHEN TO USE GKXLOOKUP ? DOWNLOAD THE ADDIN INSTALLING THE XLOOKUP ADDIN ...
Read More

HOW TO LINK TEXT BOX WITH CELL IN EXCEL ?

Table of Contents INTRODUCTION WHEN WE NEED TO LINK TEXT BOX WITH A CELL? STEPS TO LINK CELL TO TEXT ...
Read More

HOW TO SUBSCRIPT TEXT IN EXCEL

INTRODUCTION You must have seen the subscripted text or a number such as Log represented with a base or the ...
Read More

HOW TO SUPERSCRIPT TEXT IN EXCEL

INTRODUCTION Have you ever tried to insert a copyright symbol in Excel ?? or Ever tried to insert a RAISE ...
Read More

HOW TO STRIKETHROUGH TEXT IN EXCEL

Table of Contents INTRODUCTION WHEN IS STRIKE THROUGH USED IN EXCEL ? WAYS TO STRIKETHROUGH TEXT IN EXCEL STRIKETHROUGH TEXT ...
Read More

HOW TO USE COUNTIF WITH TEXT IN EXCEL

INTRODUCTION Whenever we prepare any report in excel, we have two constituents in any report. The Text portion and the ...
Read More

HOW TO FIND UNIQUE TEXT VALUES IN EXCEL

INTRODUCTION Whenever we prepare any report in excel, we have two constituents in any report. The Text portion and the ...
Read More

HOW TO APPEND TEXT IN EXCEL

Table of Contents INTRODUCTION HOW TEXT IS HANDLED IN EXCEL? APPEND TEXT IN EXCEL 1.USING & OPERATOR: 2. USING CONCATENATE ...
Read More

HOW TO CROSS OUT TEXT IN EXCEL

Table of Contents INTRODUCTION WHAT IS CROSSING OUT OR STRIKE THROUGH TEXT IN EXCEL? WHEN IS CROSS OUT USED IN ...
Read More

HOW TO CREATE VERTICAL TEXT IN EXCEL

INTRODUCTION Whenever we prepare any report in excel, we have two constituents in any report. The Text portion and the ...
Read More

HOW TO TRUNCATE TEXT IN EXCEL ?

Table of Contents INTRODUCTION HOW TEXT IS HANDLED IN EXCEL? TRUNCATE TEXT IN EXCEL EXAMPLE 1: TRUNCATE THE TEXT AFTER ...
Read More

HOW TO SOLVE NUMBER STORED AS TEXT PROBLEM

Table of Contents INTRODUCTION HOW TEXT IS HANDLED IN EXCEL? NUMBER STORED AS TEXT PROBLEM IN EXCEL CONCEPT: HOW TO ...
Read More

HOW TO COUNT CELLS WITH SPECIFIC TEXT

INTRODUCTION Whenever we prepare any report in excel, we have two constituents in any report. The Text portion and the ...
Read More

HOW TO CHECK IF A CELL CONTAINS TEXT OR NUMBER ?

Table of Contents INTRODUCTION HOW TEXT IS HANDLED IN EXCEL? CONDITIONS WHEN WE NEED TO CHECK THE PRESENCE OF NUMBER ...
Read More

HOW TO EXTRACT TEXT FROM A CELL IN EXCEL

Table of Contents INTRODUCTION WHEN THE EXTRACTION IS NEEDED EXTRACT TEXT FROM A CELL CONCEPT: EXAMPLES GENERALIZED STEPS TO EXTRACT ...
Read More

HOW TO ROTATE TEXT IN EXCEL

INTRODUCTION Whenever we prepare any report in excel, we have two constituents in any report. The Text portion and the ...
Read More

HOW TO USE TEXT WITH IF STATEMENT IN EXCEL

INTRODUCTION Whenever we prepare any report in excel, we have two constituents in any report. The Text portion and the ...
Read More

HOW TO SPLIT CELLS IN EXCEL

Table of Contents INTRODUCTION HOW TEXT IS HANDLED IN EXCEL? SPLIT CELLS IN EXCEL TEXT TO COLUMN: USING FLASHFILL: SPLIT ...
Read More

HOW TO COMPARE TWO TEXT STRINGS IN EXCEL

INTRODUCTION Whenever we prepare any report in excel, we have two constituents in any report. The Text portion and the ...
Read More

HOW TO COMBINE TEXT IN EXCEL

INTRODUCTION Whenever we prepare any report in excel, we have two constituents in any report. The Text portion and the ...
Read More

HOW TO PRINT BACKGROUND IN EXCEL SHEET

INTRODUCTION Background image is the visual, which is visible in the background of the cells in Excel. There can be ...
Read More

HOW TO ADD WATERMARK IN EXCEL SHEET

INTRODUCTION WATERMARK is a picture in the background of the data which can be a logo or a copyrighted image ...
Read More

HOW TO CUSTOMIZE RIBBON IN MICROSOFT EXCEL

INTRODUCTION RIBBON is the name given to the new layout of controls which was introduced in MICROSOFT OFFICE 2007. Since ...
Read More

HOW TO CUSTOMIZE QUICK ACCESS TOOLBAR

INTRODUCTION QUICK ACCESS TOOLBAR is a small toolbar situated at the top in the left upper corner of the EXCEL ...
Read More

HOW TO PRINT PAGE NUMBER ALL THE PAGES IN EXCEL

INTRODUCTION Printing in Excel is a fun if we know the techniques to use them properly.When we are dealing with ...
Read More

HOW TO PRINT HEADER ON ALL THE PAGES IN EXCEL

INTRODUCTION When we are printing the reports in Excel, there may arise a need to print some headings on all ...
Read More

HOW TO PRINT TOP ROW ON TOP OF EVERY PAGE IN EXCEL ?

INTRODUCTION When we are dealing with very lengthy reports, the final resort of any report is to get finalized and ...
Read More

HOW TO PRINT A SHEET ON ONE PAGE IN EXCEL

INTRODUCTION After we have created a report in Excel by using the different formats, borders, functions, formulas etc. , the ...
Read More

PRINT A SHEET IN EXCEL

INTRODUCTION After we have created a report in Excel by using the different formats, borders, functions, formulas etc. , the ...
Read More

SAVE A FILE IN EXCEL

INTRODUCTION Think of a situation! Suppose we are creating a pot and somehow it falls on the floor. Its gone ...
Read More

OPEN A FILE IN EXCEL

INTRODUCTION The new learning is always very exciting. Either, it is an activity , or some game or learning any ...
Read More

CAN’T COPY FORMULA IN EXCEL

INTRODUCTION Sometimes our software can malfunction or we may press any button or key combination by mistake which can create ...
Read More

HOW TO GET THE DATE SERIAL NUMBER OF ANY DATE IN EXCEL

INTRODUCTION DATES and TIME , if you are new to Excel and you have already tried using those format, I ...
Read More

HOW TO DISPLAY THE CURRENT MONTH AND CURRENT DAY IN WORDS IN EXCEL

Table of Contents INTRODUCTION DISPLAY THE CURRENT MONTH AND CURRENT DAY IN WORDS IN EXCEL STEPS TO DISPLAY CURRENT DAY ...
Read More

HOW TO CALCULATE AGE OR NUMBER OF DAYS BETWEEN TWO DATES

INTRODUCTION DATES and TIME , if you are new to Excel and you have already tried using those format, I ...
Read More

HOW TO FIND OUT THE STARTING AND ENDING DATE OF THE CURRENT WEEK

INTRODUCTION DATES and TIME , if you are new to Excel and you have already tried using those format, I ...
Read More

HOW TO ADD TIME IN EXCEL

Table of Contents INTRODUCTION ADD TIME IN EXCEL STEPS TO ADD THE TIME IN EXCEL EXAMPLE 1: EXAMPLE 2: EXAMPLE ...
Read More

HOW TO SUBTRACT TIME IN EXCEL

INTRODUCTION DATES and TIME , if you are new to Excel and you have already tried using those format, I ...
Read More

HOW TO CONVERT THE TIME TO DECIMAL

INTRODUCTION DATES and TIME , if you are new to Excel and you have already tried using those format, I ...
Read More

FIND CURRENT TIME IN EXCEL

INTRODUCTION DATES and TIME , if you are new to Excel and you have already tried using those format, I ...
Read More

HOW TO INSERT THE TIME FROM TEXT IN EXCEL

INTRODUCTION DATES and TIME , if you are new to Excel and you have already tried using those format, I ...
Read More

HOW TO FIND TIME AFTER CERTAIN HOURS , MINUTES OR SECONDS IN EXCEL

INTRODUCTION DATES and TIME , if you are new to Excel and you have already tried using those format, I ...
Read More

HOW TO CREATE TIME SLOTS IN EXCEL

Table of Contents INTRODUCTION PUTTING THE TIME IN SLOTS [ ROUNDING THE TIME] STEPS TO CONVERT THE TIME INTO SLOTS ...
Read More

HOW TO GET MILITARY TIME IN EXCEL

Table of Contents INTRODUCTION WHAT IS MILITARY TIME MILITARY TIME IN EXCEL STEPS TO CONVERT STANDARD TIME TO MILITARY TIME ...
Read More

HOW TO INSERT A DATE IN EXCEL TO AVOID PROBLEMS

INTRODUCTION DATES and TIME , if you are new to Excel and you have already tried using those format, I ...
Read More

HOW TO SEPARATE DATE AND TIME IN EXCEL

INTRODUCTION DATES and TIME , if you are new to Excel and you have already tried using those format, I ...
Read More

COMBINE DATE AND TIME IN EXCEL

INTRODUCTION DATES and TIME , if you are new to Excel and you have already tried using those format, I ...
Read More

HOW TO FIND THE DATE 30/60/90/120 OR N DAYS AGO

Table of Contents INTRODUCTION FIND THE DATE N [30/60/90/120] DAYS AGO CONCEPT: STEPS TO FIND THE DATE N DAYS AGO ...
Read More

HOW TO FIND THE DATE AFTER N DAYS IN EXCEL

INTRODUCTION DATES and TIME , if you are new to Excel and you have already tried using those format, I ...
Read More

HOW TO INSERT CURRENT DATE AND TIME IN EXCEL

INTRODUCTION DATES and TIME , if you are new to Excel and you have already tried using those format, I ...
Read More

CHECK IF THE TEXT HAS UPPER CASE OR LOWER

INTRODUCTION Think of a report where we are putting grades against a value say Marks of the students. Although the ...
Read More

MANIPULATING TEXT IN EXCEL PART-II

INTRODUCTION Whenever we prepare any report in excel, we have two constituents in any report. The Text portion and the ...
Read More

MANIPULATING TEXT IN EXCEL PART-I

INTRODUCTION Whenever we prepare any report in excel, we have two constituents in any report. The Text portion and the ...
Read More

MANIPULATING DATES AND TIME IN EXCEL-PART II

INTRODUCTION DATES and TIME , if you are new to Excel and you have already tried using those format, I ...
Read More

MANIPULATING DATES AND TIME IN EXCEL

INTRODUCTION DATES and TIME , if you are new to Excel and you have already tried using those format, I ...
Read More

HOW TO REVERSE SORT OR UNSORT DATA IN EXCEL

INTRODUCTION Sorting is putting up a number of things in a particular fashion as per the selected criteria. Sorting in ...
Read More

HOW TO INSERT DIVISION / DIVIDE BY [÷] SYMBOL IN EXCEL

Table of Contents INTRODUCTION WHAT IS DIVISION OR DIVIDING? DIFFERENT WAYS TO INSERT A DIVISION / DIVIDE SYMBOL IN EXCEL ...
Read More

HOW TO INSERT LAMBDA SYMBOL [λ or Λ] OR WAVELENGTH SYMBOL IN EXCEL

Table of Contents INTRODUCTION WHAT IS A LAMBDA SYMBOL? OTHER PROBLEMS THIS ARTICLE ANSWERS INSERT LAMBDA SYMBOL / WAVELENGTH SYMBOL ...
Read More

HOW TO ADD DEGREE SYMBOL IN EXCEL [ °C ] ?

Table of Contents INTRODUCTION WHAT IS A DEGREE ? ADD A DEGREE SYMBOL IN EXCEL DIFFERENT METHODS OF ADDING A ...
Read More

HOW TO FORMAT CELLS TO SHOW EURO SYMBOL WITH NUMBERS

INTRODUCTION So , we have discussed the different ways to INSERT EURO SYMBOL IN GOOGLE SHEETS. But what about the ...
Read More

HOW TO ADD EURO SYMBOL [CURRENCY €] IN EXCEL

Table of Contents INTRODUCTION ADD A EURO SYMBOL IN EXCEL 1. READY TO USE EURO SYMBOL 2.INSERT EURO SYMBOL IN ...
Read More

HOW TO INSERT PI [π] SYMBOL IN EXCEL ?

Table of Contents INTRODUCTION WHAT IS A PI SYMBOL ? MEANING OF PI SYMBOL ADD A PI SYMBOL IN EXCEL ...
Read More

ROTATE A TABLE IN EXCEL

Table of Contents INTRODUCTION ROTATING A TABLE USING SPECIAL PASTE MENU ROTATE TABLE USING TRANSPOSE FUNCTION IN EXCEL STEPS TO ...
Read More

HOW TO COUNT THE NUMBER OF OCCURRENCES IN A COLUMN IN EXCEL?

Table of Contents INTRODUCTION NUMBER OF OCCURRENCES IN A COLUMN WHEN THE DATA IS NUMBER USING FREQUENCY FUNCTION PLANNING THE ...
Read More

INSERT CHECK MARK OR TICK MARK SYMBOL IN EXCEL 🗸🗸🗸

Table of Contents INTRODUCTION WHAT IS A CHECK MARK SYMBOL ? ADD A CHECK MARK SYMBOL IN EXCEL DIFFERENT METHODS ...
Read More

ADDING COPYRIGHT SYMBOL IN EXCEL

Table of Contents INTRODUCTION ADD A COPYRIGHT SYMBOL IN EXCEL DIFFERENT METHODS OF ADDING A COPYRIGHT SYMBOL 1.DELIVERY DESK 2.INSERT ...
Read More

ADD LEADING ZERO IN EXCEL

INTRODUCTION EXCEL provides us with a vast variety of options to do almost whatever we wish to do concerned with ...
Read More

FIND LAST FILLED CELL VALUE IN EXCEL

Table of Contents INTRODUCTION FINDING LAST FILLED CELL IN A ROW SOLUTION 1-FIND LAST CELL IN A ROW USING LOOKUP ...
Read More

HOW TO CREATE A DYNAMIC DROP DOWN LIST IN EXCEL?

INTRODUCTION Data validation means to check the data before entry. It gives us the power to condition the values which ...
Read More

HOW TO CREATE A DEPENDENT DROP DOWN LIST IN EXCEL?

INTRODUCTION Data validation means to check the data before entry. It gives us the power to condition the values which ...
Read More

HOW TO CREATE A DROP DOWN LIST IN EXCEL?

INTRODUCTION Data validation means to check the data before entry. It gives us the power to condition the values which ...
Read More

CREATE A THERMOMETER CHART IN EXCEL

Table of Contents INTRODUCTION PREREQUISITE KNOWLEDGE NEEDED TO CREATE A THERMOMETER CHART WHAT IS A THERMOMETER CHART? STEPS TO CREATE ...
Read More

CREATE A PROGRESS CHART IN EXCEL

INTRODUCTION As we are already acquainted ourselves with the charts which are one of the very important part of data ...
Read More

EXCEL TRICKS-USING INDEX-MATCH

Table of Contents INTRODUCTION COMBINING INDEX AND MATCH PURPOSE OF INDEX-MATCH IN EXCEL SYNTAX: INDEX-MATCH EXAMPLE 1:INDEX MATCH SIMPLE LOOKUP ...
Read More