Learn how to use VLOOKUP function in Excel. This step-by-step tutorial contains several VLOOKUP examples. We have also discussed common errors like #N/A, #REF, #VALUE and #NAME? errors.
Setting print area in MS-Excel can save printing paper and your time. You can specify a particular area / range instead of printing the entire worksheet.
Learn how to use line break in a Microsoft Excel formula. You would need to use CHAR function and word wrap feature to get to your goal.
New MS Excel users often wonder how they can combine values to two cells in a third cell. Learn how to use concatenate function and ampersand (&) operator to join/combine contents of two or more cells in MS-Excel.