Today's Fresh Blogs...

• Excel Tip: Reference Cell Ranges by Label

  Published: August 23, 2007, 9:00 am

  Tags: Excel, Excel Tip, Microsoft Office, Spreadsheets

  you're writing formulas in Excel, you can refer to cell ranges not only by hard-to-read row and column numbers and letters but by label. So instead of totaling a column using =SUM(B2:B5), you can write the formula =SUM('Widgets Cranked'). After I mentioned this is a nice feature in Apple's new spreadsheet application Numbers '08, reader Dustin

  Comments (0)   Blog link Rating: 0

• Excel Tip: Slice and Dice Your Data with AutoFilter

  Published: September 21, 2007, 8:30 am

  Tags: Excel, Excel Tip, Microsoft Excel, Spreadsheets

  with helpful screenshots. Excel AutoFilter Filter Excel Spreadsheets [Productivity Portfolio]

  Comments (0)   Blog link Rating: 0

• Avoid Excel Division by Zero Errors [Excel Tip]

  Published: January 17, 2008, 3:00 pm

  Tags: Excel, Excel Tip, Microsoft Excel, Microsoft Office

  When your Excel formula results turn out to be that ugly divide by zero error #DIV/0!, customize the way they are displayed using the IF function. The Producitivity Portfolio blog explains how to test to see if your divisor is 0, and if so, display a blank value using something like =IF(D2=0,'',C2/D2). If you're an Excel nerd who loves in-cell

  Comments (0)   Blog link Rating: 0

• Get Started with Pivot Tables in Excel 2007 [Tutorial]

  Published: February 19, 2008, 11:30 am

  Tags: Data, Excel, Excel Tip, Microsoft Excel, Spreadsheets, Tutorial

  convenience. For more Excel 2007 knowledge, try out PP's equally helpful guide to AutoFilter. Learn to use Pivot Tables in Excel 2007 to Organize Data [Productivity Portfolio]

  Comments (0)   Blog link Rating: 0

• Master the Excel IF Function [Excel Tip]

  Published: April 26, 2008, 1:30 pm

  Tags: Excel, Excel Tip, Spreadsheets, Top

  offer an introduction to Excel's crazy-useful IF function. In short, IF sets the contents of a spreadsheet cell conditionally, based on a test. A formula like =IF(A1>90, "A", "Less than an A") would set the cell to equal A if A1's value was greater than 90, and Less than an A if A1's value was 90 or lower. This works in all modern

  Comments (0)   Blog link Rating: 0

• Calculate the Number of Working Days Between Two Dates [Excel Tip]

  Published: August 1, 2008, 11:16 am

  Tags: Excel Tip, Excel, Microsoft Excel, Spreadsheet, Spreadsheets

  You already knew that Excel can do straight date math, but it can also take into account holidays to find the number of working days between two dates. Tech blogger Chandoo points out the =networkdays(start date, end date, list of holidays) formula, which turns out the number of days minus holidays (and vacation) between the start and end

  Comments (0)   Blog link Rating: 0