# formula

(59 results)

Select:
Content Type:

### 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

### 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@...

### 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@...

### 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.

### 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

### 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.

### 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

### 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@...

### 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

### 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

### 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!

### 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

### 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

### 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

### 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

### 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

### Quick Tip: Use this mouse trick to edit Excel formulas

May 4, 2011 8:29am PDT

Instead of manually typing pieces of a cell reference, use this quick mouse trick to extend the reference when modifying a formula.

11 Latest comment by Mark.Mathews

### Use Excel tables for quick formula auto-fill

April 1, 2011 10:44am PDT

Excel 2007's new table feature eliminates the need to copy formulas; once you define a data range as a table, Excel will do it for you!

7 Latest comment by DBlayney

### 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

### Document Excel formulas with embedded comments

February 2, 2011 12:01pm PST

Need to share information about a formula with other users or developers? Drop them a note, right into the formula.

8 Latest comment by stapleb