Category Archives: Spreadsheets

Information about spreadsheet software.

Excel Instant Sum

Posted on January 18, 2010 by Ron

Get instant sums using Excel’s Status bar There are a number of ways to get quick sums in a worksheet — but did you know you can sum a range of values without entering a function or formula? Have you … Continue reading →

Posted in Spreadsheets | Tagged | Comments Off on Excel Instant Sum

Excel Cheat Sheet

Posted on December 2, 2009 by Ron

10 things I can never remember how to do in Excel If your Excel skills are perennially rusty, this cheat sheet will help you knock out basic tasks without forcing you to scramble back up the learning curve. Like a … Continue reading →

Posted in Spreadsheets | Tagged | Comments Off on Excel Cheat Sheet

Excel Data Entry

Posted on February 25, 2009 by Ron

Use Excel’s built-in features to simplify data entry Entering data into a worksheet can be time-consuming, and mistakes often find their way in — but with the right tools, both speed and accuracy can be improved. Here’s a look at … Continue reading →

Posted in Spreadsheets | Tagged | Comments Off on Excel Data Entry

Printing blank data sheets

Posted on January 13, 2000 by Ron

Version 4.x, 95 – If you need to print a blank sheet between two or more worksheets that contain your data, you’ll find that Excel ordinarily declines to print a data-free worksheet. However, if you select a group of empty … Continue reading →

Posted in Spreadsheets | Comments Off on Printing blank data sheets

Make your printout the center of attention

Posted on March 10, 1998 by Ron

Here’s the situation: You’ve just finished preparing your quarterly sales-projection worksheet. It’s the result of weeks of work culling information from branch offices, running numbers through regression analysis tools (you really don’t even know what they ARE) and other forecasting … Continue reading →

Posted in Spreadsheets | Comments Off on Make your printout the center of attention

Find the missing links

Posted on March 9, 1998 by Ron

No, we’re not talking about discovering the whereabouts of the Groks, those old school chums who had so much body hair by third grade, they could get into nightclubs. We’re talking about links you’ve added to your Excel spreadsheet. Add … Continue reading →

Posted in Spreadsheets | Comments Off on Find the missing links

No more sheets

Posted on March 6, 1998 by Ron

In the last tip, we showed you how to insert a new worksheet between two existing sheets. In that tip, we mentioned that the Excel default is 16 sheets to a workbook. If a given workbook needs only one or … Continue reading →

Posted in Spreadsheets | Comments Off on No more sheets

In roman times

Posted on March 6, 1998 by Ron

Now that a better way of writing numbers has been around for a thousand years or so, wouldn’t you think people would stop using Roman numerals? They haven’t, though. You still run across them in copyright dates and other places … Continue reading →

Posted in Spreadsheets | Comments Off on In roman times

Getting in shape

Posted on March 6, 1998 by Ron

AutoShapes: If you haven’t experimented with this handy feature in Excel, now is the time to see how it works. Let’s imagine that you’ve just finished a worksheet that contains a chart. You can add labels to the chart to … Continue reading →

Posted in Spreadsheets | Comments Off on Getting in shape

Showing up the boss, a hypothetical story

Posted on March 6, 1998 by Ron

Your boss, who wouldn’t know a computer if it fell ten stories and crashed right next to him, narrowly missing killing him (you know this because you’ve tested it), is nonetheless remarkably free with his Excel advice. In fact, just … Continue reading →

Posted in Spreadsheets | Comments Off on Showing up the boss, a hypothetical story