HYPERLINK function

Description HYPERLINK function Creates a shortcut or jump that opens a document stored on the Internet. When you click the cell that […]

Excel VBA: Change Calculation Mode To Manual

Sub WorkbookCalculationManual() With Application 'Workbook calculation settings .Calculation = xlCalculationManual 'Change calculation mode to manual '.CalculateBeforeSave = True 'Recalculate workbook before saving, […]
How To Count Unique Values In Excel Using Formula

How To Count Unique Values In Excel Using Formula

Sometimes you may want to count unique values exist in a range that contains duplicate values. You can count the number of […]
How To Find The First Number In A Text String Use Excel Formula

How To Find The First Number In A Text String Use Excel Formula

Sometimes you may want to find the first number in a text string, and deal with the numbers. In this Case, we […]
How To Select Cells In Excel

How To Select Cells In Excel

You may want to select multiple cells, ranges, rows, or columns in a worksheet in order to format the data in the selection, or to […]

Complete List of Excel 2010 Keyboard Shortcuts

Note: The complete list of Excel 2010 keyboard shortcuts are for U.S. keyboard layout and Windows Operation system. Click Here to download […]

How To Get Last Value in a Column Use Excel Formula

Sometimes you may want to get last value of a Column or a Row with Excel Formula, Here is an example for […]
How To Use Excel Solver

How To Use Excel Solver

What is Excel Solver Excel Solver is a what-if analysis tool for optimization in Microsoft Office Excel. It is an add-in with […]