All Microsoft Excel Versions

Convert Uppercase Text to Lowercase in Microsoft Excel 2010

In this article we will learn how we can convert uppercase into lowercase text in Microsoft Excel 2010. If you want to change the text from upperca...

How to highlight only text containing cells

In this article we will learn how to apply conditional formatting in cell. To apply Conditional formatting based on text, we use the Conditional Fo...

Filling a Range with a Series of Dates in Microsoft Excel 2010

In this article we will learn about to fill  a range with a series of Dates in Microsoft Excel 2010. To filling a range with a series of dates you...

Seeing Calculation Results Immediately

If you are interested in seeing the calculation of numbers quickly without using formulas, you can see the results in status bar. To see calculations ...

Retrieving the Column Header that Corresponds with a Matched Value

If you want to retrieve the column header that corresponds with a matched value,you can use a combination of INDEX, MAX, SUMPRODUCT & COLUMN func...

Retrieving a Specific Cell from Multiple Sheets in Excel 2010

While preparing a report, if we want to copy the contents of a specific cell from all the sheets in a specific row then we can use a combination of IN...

Multiplying Matrices in Microsoft Excel

To calculate the payment based on the worked hours & rate, we have to multiply each time value by its matching numerical rate. Let us take an exa...

Adding special symbols to the number format in Microsoft Excel 2010

In this article we will learn about how to add special symbols to the number format in Microsoft Excel 2010. We can create so many symbols in excel li...

PivotTable report - Grouping the Date Field by Week Number in Excel 2010

In a pivot table, in order to group the dates, number and text fields or group dates by year and month. We can manually select the items in a pivot ta...

Summing Stock Lists

In order to calculate sum of stock lists we will multiply the quantity with price of stock, we will use SUM & SUMPRODUCT function to get the outpu...

Page 19 of 105« First...10...1718192021...304050...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