formula News and Other Resources

Blog Post

10 cool ways to use Excel's conditional formatting feature

April 11, 2012 2:06pm PDT

Excel's conditional formatting feature can do a whole lot more than many people realize. Susan Harkins runs through 10 practical ways to put this tool to work.

22 Latest comment by EleanorSugden

Blog Post

Use EDATE() and relative addressing to create a quick date matrix in Excel

May 28, 2013 12:26am PDT

With a little planning, you can create an easy-to-implement date matrix in Microsoft Excel.

7 Latest comment by jshewsbury@...

Blog Post

Build a simple timesheet in Excel

January 26, 2010 9:43am PST

Excel makes it easy to set up a system for tracking time. Follow these steps to create your own or download our sample timesheet template and customize it to fit your needs.

38 Latest comment by raj_as

Blog Post

Use a formula to trigger Excel's Conditional Formatting feature

January 5, 2009 1:07pm PST

If you need a visual clue to hype a worksheet, use Excel's Conditional Formatting feature to help values stand out.

29 Latest comment by JNirvaha

Articles

Copy an Excel formula without changing its cell references

October 31, 2006 8:00am PST

If you copy a formula from one place to another, Excel will want to readjust the references to reflect the change. However, if you want the formulas to stay the same, Mary Ann Richardson can help...

56 Latest comment by f.quintas

Blog Post

Office solution: A few reasons why Excel formulas might not calculate as expected

September 20, 2011 8:16am PDT

This week, we learn the answer to last week's Office challenge: Why aren't my formulas calculating correctly?

1

Blog Post

Return the last item in an Excel column

October 20, 2008 12:00am PDT

Use this Excel formula to easily return the last item from any list.

8 Latest comment by wizard57m-cnet

Articles

Use this formula for the perfect cover letter

February 11, 2003 8:00am PST

Never assume that hiring managers don't look at cover letters, even when you apply for a job via e-mail. Use this outline to make sure you include the right information in your cover letter.

36 Latest comment by ofooks@...

Blog Post

10 steps to creating a simple break-even template in Excel

November 29, 2012 1:40pm PST

Determining the break-even point for your products gives you valuable insights into how business is performing. Here's how to set up a break-even profit model.

Blog Post

10 tips for troubleshooting Excel formulas and functions

March 1, 2012 9:19am PST

Finding and fixing errors in formulas and functions can be tedious and time-consuming. Here are some practical tips to help you cut to the chase.

7 Latest comment by ssharkins@...

Blog Post

Use formulas to find multi-column duplicates in Excel

May 3, 2010 10:15am PDT

Duplicates in the same column are easy to find by sorting or filtering. Duplicates that span multiple columns require a bit of setup, but the solution's not difficult to implement.

12 Latest comment by Candace.1221

Blog Post

Create an Excel function to highlight formula cells in a worksheet

April 7, 2009 3:21pm PDT

With the help of a simple function, Excel's Conditional Formatting feature can save you time and effort. Here's an easy way to flag formulas in your worksheets.

7 Latest comment by danny@...

Blog Post

An alternative Excel averaging formula that doesn't evaluate zero

June 20, 2012 11:49am PDT

Excel's AVERAGE() function evaluates zero values. If you want to exclude zeroes, use these alternatives.

2 Latest comment by jonc2011

Blog Post

Identify which cells in Excel are formula cells

March 25, 2011 1:06pm PDT

Learn how to identify formula cells the easy way using VBA, and then combine VBA and conditional formatting for more permanent identification.

5 Latest comment by JanTijssen

Blog Post

A handy shortcut that switches between relative and absolute references

August 26, 2009 12:00am PDT

You can specify relative and absolute references manually... but why not let Excel do it for you?

Blog Post

Build a simple timesheet in Excel

May 3, 2013 12:43am PDT

Excel makes it easy to set up a system for tracking time. Follow these steps to create your own or download our sample timesheet template and customize it to fit your needs.

12 Latest comment by emma0123

Articles

Create a formula for entering a series of incremental times in Excel

February 28, 2006 2:50pm PST

You can have Excel enter time increments in your worksheet automatically. Mary Ann Richardson shows us how to set up a formula for entering a series of increments in Excel.

7 Latest comment by epco2@...

Blog Post

Copy hundreds of rows of Excel formulas in three steps

December 4, 2007 12:00am PST

Excel provides a number of ways to copy formulas -- all of which work fine, unless the column extends down hundreds of rows. Follow these steps for foolproof cell copying.

10 Latest comment by balgowda