worksheet posts on CNET

worksheet

PDF to Excel Converter makes the job easy

You have many options for converting PDF files into Excel documents, depending on what software you already have, what the PDF contains, and what you expect as a finished product: everything from free Web-based tools to expensive pro tools and enterprise-level packages. Blue Label Software's PDF to Excel Converter falls somewhere in the middle, offering lots of speed and convenience, but at a significant cost, compared to the freeware.

PDF to Excel Converter's user interface is a nicely rendered variation on a common layout for tools of this type, with a tree view in a sidebar to the … Read more

Translean brings lean processes to Excel

Leanmap's Excel worksheets help busy people apply lean management techniques to nearly any business. Translean is a set of free worksheets for reducing waste and costs in a wide range of business processes, including transportation, labor, inventory, defects, and production. While most of its worksheets are free, it also includes a couple of try-only tools from the Pro version. We tried it in Office 2010.

Clicking any of Translean's worksheets opens Excel directly, but be sure to extract the zipped download to a familiar directory so you'll be able to browse quickly to it from inside Excel. … Read more

DiffEngineX finds Excel data differences fast

So important is Microsoft Excel to the world's data that the smallest difference between datasets can have consequences that ripple outward like a stone thrown in a calm pond. DiffEngineX is a powerful tool that identifies the differences between two Excel workbooks or individual worksheets, even thousands at a time. But unlike standard difference analysis, it takes into account any new or blank rows, cells, and columns. It's not something you can just fire up and run, but the payoff for a little prep is accurate identification of actual differences in huge amounts of data in minutes or … Read more

Manage your budget with Household Budget Worksheet

There are all kinds of tools out there for budgeting, from Web sites that connect to your bank account to the old-fashioned envelope method. Household Budget Worksheet falls somewhere in the middle, bringing some useful features to the familiar format of a spreadsheet. We think this is a great choice for anyone who needs a simple way to keep track of their spending.

Household Budget Worksheet is simply an Excel spreadsheet, and it opened in Excel with no problems. The spreadsheet had a professional-looking format with helpful built-in instructions. We really liked it that the spreadsheet lets users enter both … Read more

Easy Excellence

The power and features that make Microsoft's Excel spreadsheet the business world's standard can be daunting to new and infrequent users. EZ-Format for Excel makes Excel easy by separating data formatting, maintenance, and analysis tasks. It automates the task of formatting worksheets, enables improved, modifiable totaling, and simplifies common tasks such as splitting worksheets and applying row color. The program bundles the maker's EZ-Subtotal and EZ-Split add-ins as well, and it includes the functionality of the EZ-Stat statistical analysis software.

EZ-Format for Excel integrates seamlessly with Excel, appearing in the Add-Ins Ribbon on the Toolbar. An extensive … Read more

Reading worksheet generator

Teachers can test their reading and writing students' skills with Edit Prep. The program creates worksheets that students can proofread for correct punctuation and grammar usage, or read for contextual clues to test their reading comprehension skills.

We tried each of Edit Prep's three sections: Proofreading, Comprehension, and CLOZE Worksheet, which deals with finding contextual clues in passages of text. The program has a selection of sample text from well-known works of literature from which you can generate worksheets, or users can import passages from sources outside the program. We think teachers will enjoy this option, because they can … Read more

Intuitive worksheet maker

AlgeWorksheets is a quick and intuitive way for teachers and parents to create algebra worksheets and tests. The program combines many useful features in an easy-to-use layout.

The program's interface is plain, but all of its features are straightforward and easy to use. Users select from among 20 algebraic topics, specify any other needed settings (difficulty level, type of problem, etc.), and then click Add New Sum. The program generates a problem and inserts it into the worksheet. Users can specify whether they want to include answer blanks and can give each problem up to 15 lines of working … Read more

Your options for placing Excel data in Word

Whenever you move data from Microsoft Excel to its Office mate Word, it seems there's always a compromise involved: If the formatting makes the transition intact, then changing the data either causes problems or simply can't be done. If you can alter the data, either the formatting is a mess, or the resulting Word document is huge. Here are the advantages and disadvantages of the various ways to add Excel data to a Word document, starting with the simplest.

Copy the cells and paste them as a Word table: If your Excel worksheet is formatted simply, and you … Read more

Five easy Excel formatting tricks

I've never trained an elephant, but I imagine the process is similar to that of getting your Microsoft Excel worksheet to look just right. Here are five of my favorite Excel formatting tricks.

Double-click to fit columns and rows When you enter or paste text and numbers into Excel, the cells don't expand to fit their contents. The fast way to autofit columns and rows is to hover your mouse over the header border between the column and its neighbor to the right, or between two rows at the far left of the worksheet. When the resize icon … Read more