Transform data into insightful spreadsheets to help you analyze trends and visualize information.
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.
Earlier in the year I worked with Beth Melton, an Excel MVP, to create a super easy and visual gradebook template in Excel 2010.
We’ve noticed some of you searching for help using “$” — a dollar sign.
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.
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.
If your workbook contains a ton of worksheets, it can be a hassle to navigate to just the right sheet.
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.
It goes without saying that Microsoft Project is THE program to use if you need to manage large projects.
If you need a way to create invoices in Excel, you can use one of the many invoice templates on Office.
Millions of people using Excel don’t get why they see the “circular reference” error message right after they’ve entered a formula.
If you’re collaborating or creating sensitive material in Excel, you probably need either a DRAFT or CONFIDENTIAL watermark.
