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.
Excel
Transform data into insightful spreadsheets to help you analyze trends and visualize information.
Refine results
Product
Audience
Publish date
-
-
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.
-
Excel table or PivotTable?
In Excel there are tables and PivotTables.
-
Add a table of contents to your workbook – it’s easy, I promise!
Sometimes workbooks can be very large and hard to navigate. -
Can’t find the Chart Wizard? No worries
Going, going, gone! Yes, it’s true that the Chart Wizard was removed from the product when we shipped Excel 2007, and we didn’t bring it back in Excel 2010.
-
Create a bulleted list in a cell
Today’s blog post is brought to you by Gary Willoughby.