All Microsoft Excel Versions

Get the value of the last non blank cell in a column in Microsoft Excel

In this article, we will learn how to get the value to the last non-blank cell in a column. To get the last non-blank value we will use COUNTA  func...

Find the most commonly repeated string in a column in Microsoft Excel 2010

In this article, we will learn how to find the most commonly repeated string in a column. We use the COUNTIF, INDIRECT, ADDRESS, MATCH, MAX ,COLUMN an...

Moving Between Open Workbooks in Microsoft Excel

In this article, you will learn how we can move between open workbooks by using the shortcut keys in Microsoft Excel. You will learn 3 options to move...

Finding the Maximal/ Minimal String, Based on Alphabetic Order in Microsoft Excel 2010

In this article, we will learn how to find the maximal or minimal string, based on alphabetic order to retrieve the minimal or maximal values from a f...

Extracting data from Text without Using Formulas in Microsoft Excel 2010

In this article, we will learn how to extract characters from text without using formulas. We use the “Text to Column” wizard to extract character...

Creating Charts with F11 in Microsoft Excel 2010

If you want to create one touch excel charts then you can use F11 in excel. In this article, we will learn how we can create charts by pressing the ke...

Changing an absolute cell reference to a relative reference in Microsoft Excel

Cell references in Excel are very important. In this article we will learn difference between absolute cell reference & relative cell reference i...

Convert Julian Date to a Calendar Date in Microsoft Excel

In this article you’ll learn, how to convert a Julian date to a calendar date. What is Julian date? Julian date calendar was introduced by Jul...

Defining a Range Name in Microsoft Excel

In this article, we will learn how we can define a range name in Microsoft Excel 2010 and 2013. There are two techniques to define a range name. ...

Count the number of cells in a range containing all types of Errors in Microsoft Excel

In this article, we will learn counting the number of cells in a range containing all types of errors in Microsoft Excel. We will use ISERROR  functi...

Page 10 of 105« First...89101112...203040...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