Microsoft Excel 2013

Extract Student Summary Data from Another Sheet Based on Various Status in Microsoft Excel

In this article, you will learn how to get summary status of student from Source sheet to Summary sheet based on multiple checks. Question:- I h...

Data Validation in Excel

Original Question:- How to stop user from entering space before or after string? I do not want user to make any mistake i.e. there should be no ...

250 Excel Keyboard Shortcuts

Microsoft Excel having so many unbelievable capabilities that are not instantly perceived. Excel Shortcut keys are most useful and usa...

Find Duplicates Items in Combine Columns in Microsoft Excel

In this article we will learn how to find the duplicate items in combined columns. To find duplicate items we use the “COUNTIF” and “IF” form...

Add One Zero Digit in the Front of Number in Microsoft Excel

To change the cell formatting we have 2 options: first is Excel Format Cells option and second is Excel Text formula. Excel Text function is used ...

DAYS function

DAYS function is introduced in Excel 2013 and it is very useful function to calculate the number of days between two dates. Syntax:- = DAYS(end_...

COMBINA function

In Excel we have lots of functions, in which COMBINA function is one of the Math & trig function. This function has been introduced with Excel 201...

SHEETS function

SHEETS function With Excel 2013, Microsoft has introduced a new function viz. SHEETS This function returns the total number of sheets in referen...

ISFORMULA

Do you ever faced a situation where you need to check if a cell has a formula or not? Here is the good news.. Now we have ISFORMULA function which i...

MUNIT function

MUNIT function Munit function has been introduced with Excel 2013.  It returns the unit matrix for the specifid dimension. For example, you can ...

Page 5 of 8« First...34567...Last »
Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube