formula News and Other Resources

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

Blog Post

Determine the remaining number of days in the same year

March 18, 2013 8:20am PDT

Susan Harkins explains two ways to calculate in Excel the remaining number of days from a specific date to the end of the same year.

7 Latest comment by lee_dimambro@...

Blog Post

Highlight Excel list values when they change

February 4, 2013 11:04am PST

If your Excel lists repeats values and you need help finding changes, try this easy conditional format.

23 Latest comment by ssharkins@...

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

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

DIY: Add formulas to LibreOffice documents with LibreOffice Math

April 13, 2012 5:15pm PDT

Jack Wallen explains how to add user-friendly formulas in your LibreOffice documents by installing and using LibreOffice Math.

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.

23 Latest comment by EleanorSugden

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

A quick tip for entering names into an expression

January 25, 2012 12:27pm PST

Show users this quick tip for entering range names into formulas and functions. It's easy to use and reduces errors from typos.

9 Latest comment by sanjmeh

Blog Post

Use conditional formatting in Excel to highlight important dates

November 30, 2011 7:08am PST

If you don't want events slipping up on you, or past you, use Excel's conditional formatting as an alert system.

4 Latest comment by Robiisan

Blog Post

10 ways to improve Excel performance

November 18, 2011 6:51am PST

You don't have to live with sluggish workbooks. Try these tricks for a noticeable boost in performance.

23 Latest comment by Rob-dawg!

Blog Post

Troubleshoot VLOOKUP() formula gotchas

September 28, 2011 12:18pm PDT

Excel's VLOOKUP() function is notorious for returning wrong results, but it's not the function, it's the way you're using it!

7 Latest comment by Marshwiggle

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

Office challenge: Why aren't my formulas calculating correctly?

September 14, 2011 7:50am PDT

This week, test your Excel skills against a workbook that suddenly stops calculating correctly.

16 Latest comment by mrsmithatraytheon

Blog Post

Five tips for troubleshooting formulas in Excel

September 2, 2011 2:33pm PDT

If you're worksheet-challenged (or even if you aren't), finding and fixing formula problems can be a big headache. These tips will help ease the pain.

5 Latest comment by Jody Gilbert

Blog Post

Use Excel's table nomenclature to quickly create dynamic formulas

July 22, 2011 10:17am PDT

In Excel, defining a data range as a table opens the door to a number of efficient behaviors. Susan Harkins explains how to use nomenclature to create and use dynamic formulas.

5 Latest comment by LonMcClure