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 PREDICT THE FUTURE VALUES IN EXCEL USING FORECAST FUNCTION ?

CONTENTS INTRODUCTION PURPOSE OF FORECAST/FORECAST.LINEAR FUNCTION IN EXCEL PREREQUISITES TO LEARN FORECAST.LINEAR SYNTAX: FORECAST/FORECAST.LINEAR FUNCTION EXAMPLE 1: PREDICT THE SALES ...
Read More

FIND LAST FILLED CELL IN EXCEL

CONTENTS INTRODUCTION FINDING LAST FILLED CELL IN A ROW SOLUTION: FIND LAST CELL IN A ROW USING LOOKUP WHICH VALUE ...
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 ?

CONTENTS INTRODUCTION WHY TO USE CHECKBOX IN EXCEL? BUTTON LOCATION FOR INSERTION OF CHECK BOX IN EXCEL HOW TO INSERT ...
Read More

HOW TO HIGHLIGHT THE DUPLICATE ENTRIES IN EXCEL

CONTENTS INTRODUCTION WHEN TO HIGHLIGHT THE DUPLICATES IN MICROSOFT EXCEL? STEPS TO HIGHLIGHT THE DUPLICATES IN EXCEL STEPS TO HIGHLIGHT ...
Read More

HOW TO COPY CONDITIONAL FORMATTING IN EXCEL?

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

(no title)

HOW TO USE CONDITIONAL FORMATTING BASED ON TEXT IN EXCEL? CONTENTS HOW TO USE CONDITIONAL FORMATTING BASED ON TEXT IN ...
Read More

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

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

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

CONTENTS INTRODUCTION WHAT IS GKXLOOKUP ? WHEN TO USE GKXLOOKUP ? DOWNLOAD THE ADDIN INSTALLING THE XLOOKUP ADDIN [GKXLOOKUP] GKXLOOKUP: ...
Read More

HOW TO LINK TEXT BOX WITH CELL IN EXCEL ?

CONTENTS INTRODUCTION WHEN WE NEED TO LINK TEXT BOX WITH A CELL? STEPS TO LINK CELL TO TEXT BOX [ ...
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

INTRODUCTION We make reports in Excel.Reports consist of text numbers and symbols. The need to strikethrough the text may arise ...
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

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

HOW TO CROSS OUT TEXT IN EXCEL

INTRODUCTION Crossingout the text is needed many times while making the reports. CROSSING OUT TEXT PLACES A HORIZONTAL LINE THROUGH ...
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

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

HOW TO SOLVE NUMBER STORED AS TEXT PROBLEM

CONTENTS INTRODUCTION HOW TEXT IS HANDLED IN EXCEL? NUMBER STORED AS TEXT PROBLEM IN EXCEL CONCEPT: HOW TO RECOGNIZE IF ...
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

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

HOW TO EXTRACT TEXT FROM A CELL IN EXCEL

CONTENTS INTRODUCTION WHEN THE EXTRACTION IS NEEDED EXTRACT TEXT FROM A CELL CONCEPT: EXAMPLES GENERALIZED STEPS TO EXTRACT TEXT FROM ...
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

INTRODUCTION Whenever we prepare any report in excel, we have two constituents in any report. The Text portion and the ...
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

INTRODUCTION DATES and TIME , if you are new to Excel and you have already tried using those format, I ...
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

INTRODUCTION DATES and TIME , if you are new to Excel and you have already tried using those format, I ...
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

CONTENTS INTRODUCTION PUTTING THE TIME IN SLOTS [ ROUNDING THE TIME] STEPS TO CONVERT THE TIME INTO SLOTS EXPLANATION OF ...
Read More

HOW TO GET MILITARY TIME IN EXCEL

CONTENTS INTRODUCTION WHAT IS MILITARY TIME MILITARY TIME IN EXCEL STEPS TO CONVERT STANDARD TIME TO MILITARY TIME. CONVERT MILITARY ...
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 N DAYS AGO

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 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 DIVIDE SYMBOL IN EXCEL

INTRODUCTION Let us start another exciting session of Excel Tricks with gyankosh.net This article will let you know how to ...
Read More

HOW TO INSERT LAMBDA SYMBOL IN EXCEL

CONTENTS INTRODUCTION THIS ARTICLE CONTAINS THE SOLUTION FOR THE FOLLOWING PROBLEMS INSERT LAMBDA SYMBOL IN EXCEL DIFFERENT METHODS OF ADDING ...
Read More

HOW TO ADD DEGREE SYMBOL IN EXCEL

INTRODUCTION Degree symbol is known to everybody as it is used commonly. Every day differs from the other in respect ...
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 IN EXCEL

INTRODUCTION Let us start another exciting session of Excel Tricks with gyankosh.net This article will let you know how to ...
Read More

HOW TO INSERT PI SYMBOL IN EXCEL

INTRODUCTION Let us start another exciting session of Excel Tricks with gyankosh.net This article will let you know how to ...
Read More

ROTATE A TABLE IN EXCEL

INTRODUCTION Suppose we have a data which needs to be rotated i.e. the rows should become the columns and vice ...
Read More

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

INTRODUCTION Knowledge is not complete unless we know how to apply it in our day to day applications. So we’ll ...
Read More

INSERT CHECK MARK SYMBOL IN EXCEL

INTRODUCTION Let us start another exciting session of Excel Tricks with gyankosh.netThis article will let you know how to insert ...
Read More

ADDING COPYRIGHT SYMBOL IN EXCEL

INTRODUCTION Let us start another exciting session of Excel Tricks with gyankosh.net This article will let you know how to ...
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

CONTENTS INTRODUCTION FINDING LAST FILLED CELL IN A ROW SOLUTION 1-FIND LAST CELL IN A ROW USING LOOKUP FINDING LAST ...
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

INTRODUCTION Have a look at the chart above; fascinating! isn’t it?? (Didn’t like?? Even if you didn’t like it, don’t ...
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

INTRODUCTION INDEX-MATCH is the combination of two great functions INDEX and MATCH who are very useful in practical usage of ...
Read More