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 INSERT CHECKBOX IN EXCEL ?

INTRODUCTION A CHECKBOX is a visible element which returns a TRUE if checked and FALSE if the checkbox is unchecked ...
Read More

HOW TO HIGHLIGHT THE DUPLICATE ENTRIES IN EXCEL

INTRODUCTION While analyzing the data, we might come across the repeated data which needs to be replaced or highlighted. If ...
Read More

HOW TO COPY CONDITIONAL FORMATTING IN EXCEL?

INTRODUCTION Conditional Formatting is one of the frequently used feature of the EXCEL but the most important point about the ...
Read More

HOW TO USE CONDITIONAL FORMATTING BASED ON 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 CONDITIONAL FORMATTING BASED ON ANOTHER CELL IN EXCEL?

INTRODUCTION Conditional formatting is the formatting [ font, color, fill color , size etc. ] of data as per its ...
Read More

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

INTRODUCTION XLOOKUP is a new flavored lookup function provided in OFFICE 365.XLOOKUP is very much advanced and versatile when compared ...
Read More

HOW TO LINK TEXT BOX WITH CELL IN EXCEL ?

INTRODUCTION We already learnt about the text box in excel. [ click here for information about text box in excel ...
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

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

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

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

HOW TO GET MILITARY 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 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

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

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

INTRODUCTION This situation comes around many times when we are programming any application in VBA or we are making any ...
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