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
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
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
Microsoft Excel dominates the spreadsheet software market, and for a long time it was practically mandatory if you wanted to be able to share data with colleagues, classmates, or anyone else. Fortunately for our wallets, free alternatives have developed that emulate Excel, providing most, if not all, of the same features without the cash outlay that Microsoft Office requires. Kingsoft Spreadsheets is a great free alternative to Excel, and we recommend it if you're looking for a powerful spreadsheet program that won't break the bank.
If you're at all familiar with Excel 2003, you'll quickly adapt … Read more
Accel Spreadsheet is part of SSuite Office, a freeware alternative to Microsoft Office. Accel is to SSuite as Excel is to Office, functioning equally well in both standalone and integrated mode. Accel can save files in Excel format as well as text, CSV, and native formats, making it widely compatible not only with Excel but also other spreadsheets and financial tools. While we could open and edit most of the Excel formatted files we created with Accel, the free tool couldn't access Excel files created in Office 2010. However, the capability to create files Excel can open is more … Read more
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.
Google Docs users can now upload and work with files and documents as large as 10 gigabytes.
However, the increased file size will mainly benefit users with paid accounts.
People who use Google Docs for free are still limited to 1 GB of storage space in total for uploaded files, though documents created directly online don't count toward that quota. But users with paid accounts that range anywhere from $5 a year … Read more
Later this month I'll be canceling my subscription to a leading security suite that runs on two of my home-office PCs. I'll replace it with Microsoft's free Security Essentials, which I've been using on my notebook since I bought it two years ago. I realized several months ago that I simply no longer needed to spend money for the convenience of an all-in-one security app.
Office 365, announced today, gives professionals and small businesses a subscription service that lets them work from anywhere using familiar-feeling Web-enabled applications. Combined with hosted versions of Exchange, SharePoint, and Lync, Office 365 is designed to enable users to share, collaborate, and communicate in the cloud. In our testing during the beta, we found that the tools worked well across the board (with some hiccups), and expect that many people who use Office on desktop Macs and PCs will appreciate the familiar look and feel, which should help them get up and running quickly.
Obviously, Office 365 is going to … Read more
You have one more great reason to chuck your laptop in favor of an iPad when embarking on your next road trip. With only a few extra clicks you can edit Word and Excel files in the Safari browser on your iPad. The trick is to convert the files to the native Google Docs formats to make them available for editing on the iPad.
The easiest way to ensure the current version of your Word and Excel files are editable on your iPad is to use the free Google Cloud Connect toolbar for Microsoft Office, which I described in a … Read more