Microsoft Excel 2010

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

Selecting Special Cells in Excel

Selecting special cells in a sheet, for example, cells containing Constants, Formulas, blank cells, and more, enables you to copy, move, delete, color...

Summing Across Multiple Sheets

In this article, we are going to learn how to calculate the sum across the multiple sheets in Microsoft Excel. Let’s take an example and understand...

Print in Microsoft Excel

How to print Excel spreadsheet? In this article, we are going to learn how to print a page and how to change the print settings in Excel. Print ...

Auto Calculator feature in Excel

Excel 2010 has a quick Auto Calculator feature which can be found in bottom right corner of Excel window. Usage:- Suppose you need to find the ...

Page 5 of 512345
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