excel posts on CNET - Page 3


Prevent Excel from reformatting two numbers to a date and month

Topping my list of Microsoft Excel pet peeves is the program's automatic conversion of two numbers on either side of a hyphen into the date and month the numbers correspond to, such as "1-1" becoming "01-Jan."

The change occurs even when you choose any of the options available when you select Paste Special. I have looked high and low for a way to disable this setting in Excel, to no avail.

You can make the change for an entire worksheet by clicking the small box above 1 and to the left of A in the … Read more

Put CellworXs to work in Excel

Microsoft Excel is the business world's standard spreadsheet application for lots of reasons, not the least of which is the ability to expand its capabilities through add-ons. CellworXs by Softalis is a free Excel add-on that adds significant data analysis capabilities, including the ability to generate dynamic reports and offline report versions that can be shared with others. CellworXs has the potential to greatly reduce the time and expertise needed to create sophisticated analyses. Instead of requiring lots of "help calculations" and in-depth technical knowledge, CellworXs uses simple formulas to enable users to build database-specific analysis, consolidation, … Read more

Quickoffice Pro HD is a mini office suite on the go

As its name suggests, Quickoffice Pro HD is a mobile office and productivity suite for use on the go. It lets you create and edit office files, and even sync them to your favorite cloud storage service.

If you're a fan of Google Docs like I am, then you've probably noticed that editing files from your mobile device can be a bit of a pain. The Google Drive (download) app (which recently slurped up Google Docs) doesn't offer a very robust menu of formatting tools, which makes workflow more complicated than it should be (especially when dealing … Read more

Exec sings goodbye to Microsoft on YouTube

When I first saw this I thought the first line was "Long, long lines of coke."

I thought this would be a contemporary dirge to the emptiness of the corporate American dream. This was, after all, being sung to Don McLean's "American Pie."

Sadly, it seems, the first words are "long, long lines of code." For this is the resignation ditty of Karen X. Cheng, a project manager at Microsoft.

I sing a haiku to TechCrunch for explaining that she is leaving on a jet plane to work for something called Exec, a … Read more

Microsoft releases Office 2011 SP2 for OS X

Microsoft announced on its Office for Mac Blog today that it has made its Service Pack 2 for Office for Mac 2011 available for download. This update addresses a number of problems users have been having with Outlook, but also fixes some aspects of Word, Excel, and PowerPoint.

The update is available via Microsoft's included Autoupdate utility, but can also be downloaded from Microsoft's Web site. The update is about 110MB in size, and after installing the version of your Office installation will be 14.2.0.

With the release of Office 2011 Microsoft replaced its old Entourage … Read more

Office Web Apps refresh likely on Microsoft's menu

Microsoft Office users can expect to see a new version of Office Web Apps this summer, according to Windows Live enthusiast site LiveSide.net.

The cloud-based suite will reportedly be available in "preview" mode at the same time that Office 15 for the desktop is released as a beta. Users will be able to try the latest features of Office Web Apps to create or edit documents stored through SkyDrive or Hotmail, LiveSide added.

Little else is known or at least revealed about a new version of Office Web Apps. Microsoft did not immediately answer CNET's request … Read more

An early look at Microsoft Office 15

Microsoft Office 15 will come built for the desktop but offer a huge touch of the Metro flair, according to a description posted by Supersite for Windows author Paul Thurrott, who obtained a copy of an early preview version.

Accord to Thurrott, the technical preview of Office 15 kicks off like the current version, letting you choose which applications to install.

But after a full installation, you'll find your Metro start screen cluttered with a huge number of live tiles for each application. That's an inherent flaw in the Metro UI, which doesn't allow tiles to be … Read more

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