excel

Touch-screen spread sheets

Numbers for iOS works well for creating spreadsheets and organizing data while away from your desktop, with a multitude of useful tools and a smart interface design to make your spreadsheet work easier. On the iPhone the app works admirably, but the smaller screen size makes it a bit less easy to use than the iPad version.

The app comes with a Getting Started file that walks you through everything from basic spreadsheet use to more-complicated features using an intuitive tabbed interface. As you learn the various features, the Getting Started file directs you to try them on your own … 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

Manufacture tight inventories with MRP_Excel.zip

MRP_Excel.zip from Production-Scheduling.com is a free Manufacturing Resource Planning tool in an Excel workbook. It uses no macros or VBA code and it's not locked: anyone who knows Excel can customize it to suit his or her needs.

Excel-based MRP systems have several advantages, such as the ability to use schedules and other data already entered in Excel; greater familiarity and less complexity than a full-scale MRP system; and, best of all, lower cost. MRP offers some significant features, including a Purchase Action Report that identifies schedule-critical purchase orders, a single-level Bill of Material Structure, and a … Read more

Microsoft Office for the iPad: To be or not to be

Is Microsoft cooking up a version of Office for the iPad? News site The Daily says yes, Microsoft doesn't exactly say no but claims that The Daily's story is inaccurate.

Yesterday, The Daily's Matt Hickey reported that he had seen a working prototype of Office on the iPad and that sources indicated the app would soon be sent to Apple for approval.

Microsoft quickly went into denial mode, saying The Daily's story was "based on inaccurate rumors and speculation" and that the photo displayed by The Daily is "not a real picture of … Read more

How to enter formulas in Numbers

When you purchase a new Mac it almost goes without saying that some sort of office productivity suite is required, and though, based on popularity, some might gravitate to Microsoft's Office, there are others available as well, such as OpenOffice, NeoOffice, some standalone word processors, and also Apple's iWork suite.

iWork's programs include Pages for word processing, Keynote for presentations, and a relatively unique approach to spreadsheets with its Numbers program, which if you are used to Excel, offers some similar ways to manage data, albeit with some uniquenesses.

Unlike most spreadsheet programs that offer a seemingly … Read more

A free Microsoft Office alternative that's actually good

About a week ago I featured Kingsoft Office Suite Professional 2012 in a bonus deal. Since then I've been test-driving the software on an old laptop. And you know what? I like it!

I mention this because although the Kingsoft Professional giveaway is over, you can still get Kingsoft Office Suite Free 2012 for, well, free. Update: This program is for Windows.

Until last week, I'd never heard of Kingsoft or this product. I had, however, tried all the usual freebie Microsoft Office alternatives: OpenOffice, LibreOffice, Lotus Symphony, Google Docs, and so on.

They're all OK--good enough, … Read more

Microsoft Office document editor CloudOn is back for the iPad

iPad owners searching for software to create Microsoft Office documents now have a new and free app.

The iPad app CloudOn lets you create, edit, and view Microsoft documents using online versions of Word, Excel, and PowerPoint. Your documents are stored in the cloud via your DropBox account, letting you access them whenever you're online.

Although it officially hit the App Store on January 3, CloudOn was subsequently taken down when the company bumped into technical difficulties as a result of huge demand. But CloudOn has since caught up with its service issues and is once again ripe for downloadRead more

Calculate your GPA with GPA calculators

After a long, hard semester of classes, manually calculating your GPA might be the last thing on your mind. Give your brain a rest and try some of these GPA calculators:

Web There are a lot of GPA calculators on the Web, but one of the better ones is from Koofers.com. The Koofers GPA calculator allows you to add up to eight courses and grades before tabulating your final GPA. It's also flexible enough to allow you to modify the GPA scale. If your school uses a unique scale, you can change it to match the one your … Read more

U.K. student crowned Excel world champion

Rebecca Rickwood, a 15-year-old student from Cambridge, has been crowned the Microsoft Excel world champion, the BBC reports.

Spreadsheet whiz Rebecca beat 78 rival students in the final round in a competition that saw 228,000 hopefuls from 57 countries competing for the title using Excel 2007. For her troubles, she was awarded $5,000.

We didn't know competitive spreadsheet construction was a thing, but we were fools--the brain-melting challenge involves performing timed challenges, demonstrating that contestants possess the Excel skills to pay the bills, presumably without using Clippy.

Read more of "UK student is Excel world champion" at Crave UK. … Read more

Rental receipts and more

Any time you're dealing with amounts of money that reach into the hundreds--or thousands - of dollars, receipts are a good idea for everyone involved. Receipt Templates for Excel gives users an easy way to create receipts for rental payments and other types of cash transactions. It's a simple template, but it can give your receipts a neat, professional appearance.

The download comes with two templates, one for cash transactions and one for rental transactions. The templates come with three receipts to a page, making it easy to create multiple receipts if necessary and then cut them out … Read more