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 ...

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 ...

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 ...

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 ...

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, ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 / ...

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 ...

HOW TO TYPE CENTS SYMBOL [ ¢ ] IN EXCEL?

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

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

PRINT A SHEET IN EXCEL

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

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 ...

OPEN A FILE IN EXCEL

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

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

FIND CURRENT TIME IN EXCEL

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

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...