Circular Reference? Excel’s most popular (!#?%) error message explained
Millions of people using Excel don’t get why they see the “circular reference” error message right after they’ve entered a formula.
Refine results
Product
Audience
Publish date
-
-
Generate invoice numbers in Excel
If you need a way to create invoices in Excel, you can use one of the many invoice templates on Office.
-
Tracking small projects in Excel
It goes without saying that Microsoft Project is THE program to use if you need to manage large projects.
-
The Excel part of mail merge
Hey, the holidays are fast approaching, which means you’ve got to get your cards signed, sealed, and delivered! This post goes out to those of you who keep your address list in Excel and need to figure out how to use it to create mailing labels in Word.
-
Two tips for faster worksheet navigation
If your workbook contains a ton of worksheets, it can be a hassle to navigate to just the right sheet.
-
Speed up data-entry tasks by using End Mode
The other day, I was filling out a huge Excel table, and I found myself needing to enter the exact same information in multiple cells.
-
Line or scatter chart?
Ah, the great questions of life: Paper or plastic? Line chart or scatter chart? Choosing the wrong chart type for your data can easily happen when it comes to line and scatter charts.
-
Making sense of dollar signs in Excel
We’ve noticed some of you searching for help using “$” — a dollar sign.
-
How to do percentages in Excel
Calculating a percentage in Excel is an easy two-step process—first you format the cells and then you build the formula. -
Free gradebook template for Excel 2010
Earlier in the year I worked with Beth Melton, an Excel MVP, to create a super easy and visual gradebook template in Excel 2010.
-
Create Convincing Visualizations by Adding Reference Lines to Your Excel Charts
Have you ever wanted to add a horizontal or vertical line to your chart to indicate a key value, sales threshold, important date, or the average of your data? Are you looking to impress managers and convince clients with your superb charts? Reference Lines (see the dotted black line on the chart below) can be powerful tools in effectively communicating important points in your data.
-
Staying on budget might be easier than you think
Ask most of your friends how they’re doing, and they’ll probably tell you how hectic their lives are.