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
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
What is Excel Solver Excel Solver is a what-if analysis tool for optimization in Microsoft Office Excel. It is an add-in with...
IF function
Description IF function returns one value if a condition you specify evaluates to TRUE, and another value if that condition evaluates to...
Create a Backup of a Workbook with Current Date
We all know that making backups of your work is important. Now you can have a macro do it for you. This simple...
Prevent the Workbook Closing If a Cell is Empty
Sometimes you may not want a user closing out a workbook without entering a specific piece of data. In these situations, you...