• Quick tip: Pin your most-used Office documents for easy access

    Posted July 31, 2013 - 1:29 pm

    Save time in Word, Excel, etc. by pinning your most frequently used documents
  • 10 awesome new features in Excel 2013

    Posted February 2, 2013 - 8:15 am

    Microsoft's updated spreadsheet tool isn't getting a lot of new, whiz-bang features, but it is becoming more functional. That's something both new and experienced users will enjoy--especially a new approach to an old problem that used to require a cumbersome workaround. Complex tasks become easier to perform, thanks to tools such as Recommended Charts and Recommended PivotTables tools. Other changes place choices closer to your data, and use big-business brawn to crunch data right into Excel.
  • 13 useful add-ons for Microsoft Excel and Word 2013

    Posted February 1, 2013 - 9:00 am

    Here are the most useful browser add-ons for the latest versions of Excel and Word.
  • 10 great tips/shortcuts for Office

    Posted December 14, 2012 - 1:19 pm

    Improve your Office productivity with some quick tips and shortcuts.
  • Grid, spreadsheet rework for tablets, goes beta

    Posted August 9, 2012 - 11:29 am

    Binary Thumb releases GRID beta for tablets and smartphones, including new Maestro gesture tool.
  • Microsoft dumps Office Starter from PC maker choices

    Posted June 24, 2012 - 7:08 am

    Microsoft is dumping its Office Starter edition as Windows 8 and the next edition of the suite, dubbed Office 2013, near completion and release later this year and early next
  • How to create advanced Microsoft Excel spreadsheets

    Posted June 2, 2012 - 7:12 am

    Looking to become an Excel power user? Excel has a number of features that will make it easier for you and your colleagues to enter data into your spreadsheets. If you're developing a spreadsheet that you'll use over and over again, inserting a spin button or scrollbar will allow you to choose from a predefined range of values using your mouse, instead of typing numbers in with the keyboard. Or, if you wish to limit a spreadsheet user to selecting from a few preset choices, a set of option buttons will do.
  • How to edit office documents on your smartphone

    Posted May 10, 2012 - 7:50 am

    Although office suites have been available on mobile phones for more than a decade, touch interfaces have made them much simpler and more efficient than before. Now, iPhone and Android users wanting to work with office documents while on the go have at least three great options each, and two of them in common. This guide will walk you through the process of choosing an editor and getting started in editing documents on your smartphone.
  • Even with spreadsheet use fading, it's still an Excel world

    Posted March 26, 2012 - 9:22 pm

    As California-based manufacturer GoPro prepares to go public later this year, it has high hopes of expanding its reach among the surfers, mountain climbers and other so-called adventure photographers to whom GoPro wants to sell its novel 3D video devices and gear-mounted cameras.
  • Five Excel nightmares (and how to fix them)

    Posted June 7, 2011 - 10:19 am

    Have you ever wondered if Microsoft Excel was invented by a sadist?
  • The problem of Chromebook and backward compatibility

    Posted May 16, 2011 - 8:00 am

    Google is betting big there are enterprise-ready cloud apps for Chromebook users, but their own Google Docs currently falls short in one big area. Will virtualization be enough to solve the issue, or will it just cause more headaches?
  • Review

    Supercharge Excel with ASAP Utilities

    Posted January 18, 2011 - 11:51 am

    Excel add-in ASAP Utilities piles so many features onto Excel, it can make you dizzy. You can convert text to uppercase, lowercase, or proper case (first word capitalized), merge and import multiple files, and copy a selection to the clipboard as HTML. Jobs that you could already do get grouped logically into one place. For instance, the Vision Control dialog box lets you hide and unhide gridlines, page breaks, tabs, and scroll bars. You can easily reverse the order of selected cells, fill a range with random numbers, and change hyperlinks to hyperlink() formulas.
  • Excel vulnerabilities revealed on 'slower' Patch Tuesday

    Posted March 9, 2010 - 10:13 pm

    Coming off a record-making Patch Tuesday in February, Microsoft announces a lighter load of bulletins and advisories targeting client operating systems, Microsoft Office and Internet Explorer.
  • How To Master Excel Spreadsheet Printing

    Posted January 28, 2010 - 1:48 pm

    You slave over cell after cell after cell in your spreadsheet until it's perfect. When it comes time to print out that perfection, you get blank pages, missing sections, and weird formatting. You can blame your printer, but the problem is almost always in Excel. Jen Darr of PC Helps sent the details for this lesson.
  • Unix How to: Thinking in Unix Time

    Posted January 6, 2010 - 1:27 pm

    The new year rolled in at 1262304000, Unix time that is. It's a little hard to imagine that Unix is now more than 1.2 billion seconds old. Seems only yesterday that I was trying my first pipes and grep commands while thinking "Wow, this is groovy". OK, maybe not quite "groovy", but close!
  • 10 Ways Excel Drives More Value From Your SAP Investment

    Posted December 17, 2009 - 3:07 pm

    The effective use of Microsoft Excel as a front-end to create new master and transactional data in SAP leads to tremendous business efficiencies.
  • How to share web databases

    Posted September 14, 2009 - 7:11 am

    There are a number of Web services that allow you to collaborate on tabular or database data using nothing other than your browser. You can even upload your desktop spreadsheet to get started. I look at four such services.
  • 5 Reasons To Use SharePoint Instead Of Emailing Excel Files

    Posted August 6, 2009 - 6:37 pm

    SharePoint acts as a basic replacement for shared folders on file servers.
  • IBM, Microsoft quibble over Office 2007's new ODF support

    Posted May 6, 2009 - 8:50 pm

    In the latest sniping in the long-running feud over document format standards, IBM this week claimed that Microsoft Corp.'s Excel 2007 corrupted formulas and data in spreadsheets created in the OpenDocument Format.
  • Analyzing Twitter with Excel, Part 4

    Posted April 24, 2009 - 9:41 am

    Over the last three weeks I've been trying to figure out how to analyze Twitter messages using Excel 2003, something I thought would be fairly easy but it turns out there are a number of "gotchas."
  • Analyzing Twitter with Excel, Part 3

    Posted April 18, 2009 - 8:26 pm

    For the last two weeks I've been considering how to analyze Twitter messages using Excel 2003. Having been thwarted by the deficiencies of Excel and Twitter (turns out that Twitter Search returns malformed HTML and Excel won't tolerate that) I have a new plan: Let's use cURL to retrieve the raw XML returned by Twitter search and then haul that data into Excel for the analysis.
  • Analyzing Twitter with Excel, Part 2

    Posted April 10, 2009 - 11:13 am

    So, last week I set myself a problem: Use Microsoft Excel to capture Twitter messages that mention the word "rovio", pretending that I worked for the company that makes the Rovio Wi-Fi-controlled camera and I wanted to see what people were saying about it. After finishing last week's column I had to drop the project for a couple of days while I put out other fires. When I returned to it I discovered that things weren't working as I had expected.
  • After attacks, Excel update due from Microsoft

    Posted April 9, 2009 - 2:40 pm

    Microsoft will release eight security updates next week, including one for Excel, while Oracle is readying patches, too.
  • Analyzing Twitter with Excel, Part 1

    Posted April 3, 2009 - 12:26 pm

    Excel's XML maps are a powerful tool if you can figure out how they work so this week we're going to do exactly that. Or at least, something like that.
  • Excel Bug Will Be Ignored on Patch Tuesday

    Posted March 9, 2009 - 11:28 am

    Microsoft will release three Windows security updates, including one rated "critical," but won't deliver a fix for an Excel flaw that attackers are now exploiting.

Join today!

See more content
Ask a Question