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 APPLY FORMULA TO ENTIRE COLUMN IN EXCEL?

Table of Contents INTRODUCTION WHAT WE MEAN BY APPLYING FORMULA TO ENTIRE COLUMN? WAYS TO APPLY FORMULA TO ENTIRE COLUMN ...
Read More

HOW TO CONVERT ROW TO COLUMN IN EXCEL?

Excel helps us in consolidating data very easily which ultimately results in better results with lesser effort and in lesser ...
Read More

HOW TO SUBTRACT A PERCENTAGE IN EXCEL?

Table of Contents INTRODUCTION WHAT IS A PERCENTAGE? HOW TO CALCULATE PERCENTAGE IN EXCEL? IMPORTANT TERMS IN SUBTRACTION WHAT IS ...
Read More

HOW TO SORT DATA PIVOT TABLES IN EXCEL?

Table of Contents INTRODUCTION EXAMPLE: PIVOT TABLE CREATING A PIVOT TABLE IN EXCEL HOW TO SORT PIVOT TABLE IN EXCEL ...
Read More

HOW TO CREATE A TOOLTIP IN EXCEL?

Table of Contents INTRODUCTION WHAT IS A TOOLTIP? CREATING A TOOLTIP IN EXCEL RESULT: INTRODUCTION If your Excel is open, ...
Read More

HOW TO STRIKETHROUGH IN EXCEL USING CONDITIONAL FORMATTING?

Table of Contents INTRODUCTION WHERE DO YOU FIND CONDITIONAL FORMATTING OPTION IN EXCEL? EXAMPLE 1:STRIKETHROUGH THE NUMBERS LESS THAN A ...
Read More

HOW TO COUNT DUPLICATE VALUES IN EXCEL?

Table of Contents INTRODUCTION WHAT ARE DUPLICATE ITEMS? EXAMPLE 1: COUNT DUPLICATE VALUES IN EXCEL CHECKING THE RESULTS: INTRODUCTION EXCEL ...
Read More

COUNT FUNCTION VS COUNTA FUNCTION IN EXCEL

Table of Contents INTRODUCTION DIFFERENCES BETWEEN COUNT AND COUNTA FUNCTION INTRODUCTION Both of the functions COUNT FUNCTION as well as ...
Read More

HOW TO COUNT BLANK OR EMPTY CELLS IN EXCEL?

Table of Contents INTRODUCTION PURPOSE EXAMPLE 1: COUNT THE BLANK CELLS IN A COLUMN OF EXCEL EXAMPLE 2: COUNT THE ...
Read More

HOW TO COUNT THE CELLS CONTAINING SPECIFIC TEXT IN EXCEL?

Table of Contents INTRODUCTION PURPOSE EXAMPLE 1: COUNT THE NUMBER OF CELLS WHICH CONTAIN THE TEXT “THE” [EXACT ] IN ...
Read More

HOW TO COUNT THE DISTINCT VALUES IN EXCEL?

Table of Contents INTRODUCTION HOW TEXT IS HANDLED IN EXCEL? WHAT ARE DISTINCT VALUES? FIND DISTINCT VALUES IN EXCEL FIND ...
Read More

HOW TO USE CONDITIONAL FORMATTING WITH DATES IN EXCEL?

Table of Contents INTRODUCTION HOW DATE IS HANDLED IN EXCEL? WHAT IS CONDITIONAL FORMATTING BASED ON DATES? EXAMPLES SHOWING CONDITIONAL ...
Read More

HOW TO TYPE LONG DIVISION SYMBOL [ ⟌ ] IN EXCEL?

Table of Contents INTRODUCTION WHAT IS DIVISION OR DIVIDING? DIFFERENT DIVISION SIGNS DIFFERENT WAYS TO INSERT A LONG DIVISION / ...
Read More

AVOID ENTERING DUPLICATE VALUES IN A COMPLETE COLUMN OF EXCEL

Table of Contents INTRODUCTION WHAT IS DATA VALIDATION? HOW TO ALLOW ONLY UNIQUE VALUES IN A COLUMN? STEP 1: SELECT ...
Read More

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 INTO DEGREES IN EXCEL?

Table of Contents INTRODUCTION WHAT IS A RADIAN ? WHAT IS A DEGREE ? WHY TO CONVERT RADIANS INTO 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 ?

Table of Contents INTRODUCTION WHAT IS VLOOKUP FUNCTION ? WHAT IS XLOOKUP FUNCTION? BENEFITS OF VLOOKUP FUNCTION IN EXCEL LIMITATIONS ...
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

EASY METHOD TO APPLY CONDITIONAL FORMATTING BASED ON TEXT IN EXCEL?

Table of Contents INTRODUCTION HOW TEXT IS HANDLED IN EXCEL? WHAT IS CONDITIONAL FORMATTING BASED ON TEXT IN EXCEL? EXAMPLE ...
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 USE XLOOKUP IN EXCEL 2016,2013,2007,2019 OR ANY OTHER VERSION WHAT IS GKXLOOKUP ? WHEN TO USE ...
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 EXCEL COUNTIF TEXT CRITERIA

Table of Contents INTRODUCTION HOW TEXT IS HANDLED IN EXCEL? BASICS OF EXCEL COUNTIF TEXT CRITERIA EXAMPLE 1: COUNTING THE ...
Read More

HOW TO FIND UNIQUE VALUES, UNIQUE TEXT VALUES OR UNIQUE NUMBERS IN EXCEL

Table of Contents INTRODUCTION HOW TEXT IS HANDLED IN EXCEL? WHAT ARE UNIQUE VALUES? FIND AND COUNT UNIQUE TEXT VALUES ...
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 IN EXCEL ?[UPDATED]

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 HOW TO PUT TIME IN SLOTS [ ROUNDING THE TIME] STEPS TO CONVERT THE TIME INTO ...
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

Table of Contents INTRODUCTION INSERT CURRENT DATE AND TIME IN EXCEL STEPS TO INSERT CURRENT DATE IN EXCEL. STEPS TO ...
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 IN EXCEL [λ or Λ] ?

Table of Contents INTRODUCTION WHAT IS A LAMBDA SYMBOL? DIFFERENT CASES WHERE LAMBDA SYMBOL IS USED INSERT LAMBDA SYMBOL IN ...
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

6 WAYS TO INSERT PI SYMBOL IN EXCEL

Table of Contents INTRODUCTION WHAT IS A PI SYMBOL ? WHAT IS ACTUAL MEANING OF PI SYMBOL INSERT A PI ...
Read More

ROTATE A TABLE IN EXCEL

Table of Contents INTRODUCTION WHAT IS MEANT BY ROTATING A TABLE? ROTATING A TABLE IN EXCEL 1. USING RIGHT CLICK ...
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 NUMBER OF OCCURRENCES OF A ...
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 1. DELIVERY ...
Read More

ADDING COPYRIGHT SYMBOL © IN EXCEL

Table of Contents INTRODUCTION ADD A COPYRIGHT SYMBOL IN EXCEL 1. DELIVERY DESK-COPY PASTE COPYRIGHT SYMBOL IN EXCEL 2.INSERT COPYRIGHT ...
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?

Table of Contents INTRODUCTION UNDERSTANDING THE CONCEPT OF DEPENDENT DROP DOWN LIST EXAMPLE CASE DISCUSSION CREATING SIMPLE LIST FOR CONTINENTS ...
Read More

HOW TO CREATE A DROP DOWN LIST IN EXCEL?

Table of Contents INTRODUCTION BUTTON LOCATION FOR DATA VALIDATION IN EXCEL STEPS TO CREATE A DROP DOWN LIST IN EXCEL ...
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 IN EXCEL? STEPS ...
Read More

CREATE A PROGRESS CHART IN EXCEL

Table of Contents INTRODUCTION PREREQUISITE KNOWLEDGE NEEDED TO CREATE A PROGRESS CHART WHAT IS A PROGRESS CHART? STEPS TO CREATE ...
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