Email:      Pass:    Pass?
Featured Excel Content

Excel Tip
How to use the Vlookup function to return a result that falls within a range of numbers, such as a weight or quantity or even tests or grades. This allows you to, for example, return the letter A for a score of 90 - 100 on a test. Here, it is assumed that you are at least partly familiar with the Vlookup function.  If you want to learn more about i ...
Added: Nov 25, 2015
Excel Tip
How to make Excel automatically add row shading to every other row when you add data to the spreadsheet. This does NOT use the Table feature in Excel.  This tutorial will show you how to use a formatting method to achieve automatically alternating row colors. Steps to Automatically Shade Alternating Rows When Data is Added to a Spreadsheet Select t ...
Added: Nov 24, 2015
Excel Tip
How to print the comments in a worksheet when you print from Excel. This includes how to print the comments within the worksheet and how to print them at the end of the worksheet all in one place. Steps to Print Comments Go to the Page Layout tab and click the little button in the bottom right corner of the Page Setup section. In the window that op ...
Added: Nov 23, 2015
Excel Tip
How to shade every other row in Excel quickly without using the Table feature. This method is for when you simply want to shade the rows and nothing more; when you do not want to convert your data to a Table type in Excel. Sections: Steps to Shade Every Other Row in Excel Quickly Remove Background Shading Remove Lines From Between the Cells Notes S ...
Added: Nov 20, 2015
Excel Tip
Make a macro run when you click a button in the worksheet in Excel. This allows you to create a button and put it anywhere in the spreadsheet and then to have a macro run when that button is clicked. Steps to Have a Macro Run When a Button is Clicked Create the button.  Go to the Insert tab and click the Shapes button and select the desired button ...
Added: Nov 19, 2015
Excel Tip
How to increment a value, number, percent, etc. every so many rows in Excel. This tutorial teaches you how to build the formula needed to increment a value or, really, do anything every so many rows in Excel. Section: The Formula That Knows in Which Row You are in Excel How to Increment a Value Based on Which Row You are in Excel Data Set Not on Ro ...
Added: Nov 18, 2015
Excel Tip
How to calculate the number of periods required for an investment in order to get the desired return.  The number of periods required for the investment tells you how long the investment must last.  This is based on a constant interest rate, a present value, and an optional future value. Syntax =NPER(rate, pmt, pv, [fv], [type]) Argument Descriptio ...
Added: Nov 17, 2015
Excel Tip
Quickly find all rows in Excel that contain a certain value and then delete those rows. This is a simple technique for quickly searching an entire worksheet to locate specific rows that you can then delete without having to individually search a data set and delete each row. Steps to Delete All Rows that Contain a Specific Value Go to the workshee ...
Added: Nov 16, 2015
Excel Tip
I'll show you the top keyboard shortcuts for Excel that are sure to increase your productivity. These shortcuts are easy to learn and are ones that I use almost every day. Move Between Worksheets Ctrl + Page Down Move to the next worksheet to the right. Ctrl + Page Up Move to the next worksheet to the left Move Up, Down, Left, or Right After Enteri ...
Added: Nov 13, 2015
Excel Tip
How to split text from one cell into multiple cells quickly and easily in Excel.  This includes how to split names, part numbers, really anything you want.  You can split the text based on spaces in the text, commas, periods, or anything you specify. We will use the Text to Columns feature to do this. Desired Result: Steps to Split Text into Multip ...
Added: Nov 12, 2015
Subscribe for Free Excel tips & more!