Latest VLookup trick to search with more than one criteria in Excel
VLookup is an important function located in Lookup and reference category. You can use given VLookup trick to search with more than one criteria in Excel.
Microsoft-Office
2 Methods to insert more than one columns and rows in Excel
Excel is an important application software which is widely used by the users. Now you can quickly insert more than one columns and rows.
Highlight Cells Containing Specific Text with Conditional Formatting
Conditional formatting feature in Microsoft Excel allows you to easily highlight one or more cells which have specific text in active worksheet.
How to copy or fill a formula into adjacent cells in Excel
Excel allows you to easily copy or fill a formula into adjacent cells in Excel using several methods.
How to replace across multiple worksheets or entire workbook
Find and replace is an important command of Excel. Now you can replace across multiple worksheets or entire workbook in Excel.
How to Extract few Numbers using Excel Functions
Excel allows you to insert different types of data format in cell of active worksheet. You can extract few numbers using Excel Functions.
How to use Flash Fill or Auto Fill command in Excel
You can use Flash Fill or Auto Fill command in Excel. It allows you to automatically fill matched data when it senses a pattern in cell.
How to use Microsoft Excel LEN function to know length of text string
LEN is an important text function in Excel. Excel LEN function helps you to know the length of any given text string including spaces.
How to Create and Run a Macro in Excel
Macro is an important utility of which allows you to start recording of more than one sequentially commands. You can create and run a Macro.
How to Copy Formatting only using Fill Handle in Excel
Fill handle is an important tool of Excel which allows you to copy or generate series. You can also copy formatting only using Fill Handle.