Software

Technology

The Curious Case of Strikethrough in Word and Excel

Excel expert David Ringstrom, CPA, describes a couple of ways that you can streamline access to the strikethrough feature – and pretty much any feature – in both Word and Excel.
Technology

How to Reinstall Microsoft Office When You Don't Have a Disc or Download

From time to time, you may need to reinstall Microsoft Office because you purchased a new computer or you're trying to resolve a program error. Or, in Excel 2010 and later, you may need to move between the 32-bit and 64-bit versions.
Technology

Restoring "Shrink One Page" in Word 2010 and 2013

Long-time Word users may recall a handy feature in Word 2007 and earlier called Shrink One Page. This feature may appear to have vanished from Word 2010 and 2013, but you can easily resurrect it.
Technology

Xero Raises $150 Million to Fund US Expansion

New Zealand-based online accounting software provider Xero said on October 13 it has raised $150 million to fund a major expansion in the United States.
Technology

Twenty-Five Ways to Use Excel's Name Box

It's pretty much impossible to use Excel and not notice the Name Box. Most users know this as the space in Excel where you can determine the address of the currently selected cell. A smaller subset of users relies on the Name Box as a navigation aid.
Technology

What To Do When Excel Worksheet Tabs Go Missing

In addition to restoring vanished worksheet tabs, David Ringstrom also describes a couple of techniques for navigating workbooks easier, as well as other ways to find hidden worksheets.
Technology

Creating a "Chainsaw" List of Excel Worksheet Functions

Depending on your version of Excel, you have nearly 500 different worksheet functions at your disposal. Some worksheets functions are like the chainsaw in my garage. I don't use them very often, but when I do, no other tool will suffice.
Technology

How to Maximize Excel's Recent Items Menu

Depending upon your version of Excel, the Recent list on the File menu can streamline access to both files and folders. If you work on numerous spreadsheets, this list offers marginal value in Excel 2003 and earlier.
Technology

Worlds Colliding: Convert a Digital Photo into an Excel Spreadsheet

In an unlikely mash-up, Matt Parker of Think Maths offers a free tool that converts a digital photo of your choice into an Excel spreadsheet. If you have Excel 2007 or later, you can try the technique yourself.
Technology

Microsoft Excel: How to Automate Text File Links

Some time ago, I explained how to use Excel's Text to Columns Wizard for separating text within a spreadsheet into columns. Although this approach is helpful for data that's in a spreadsheet, in other cases, you may wish to link spreadsheets to text files that change periodically.
Technology

Eliminate a Common Spreadsheet Design Flaw

Whenever column headings within a worksheet span two or more rows, a cascade of issues can occur. Fortunately, a simple technique can help you avoid frustration and save time when working in Microsoft Excel.
Technology

Improving the Integrity of Excel's SUM Function

My unscientific observation is that the SUM function is the most widely used function within Excel spreadsheets. This function makes it easy to add up multiple cells at once without laboriously adding multiple cells together individually.
Technology

Farewell, Lotus 1-2-3

IBM recently announced that Lotus 1-2-3 will no longer be available for purchase. Most readers of this article will likely have one of two reactions: "What is Lotus 1-2-3?" or "Lotus 1-2-3 was still on the market?"
Technology

The End Is Near for Windows XP

Despite three subsequent Windows releases, Windows XP remains the second most popular operating system version. Regardless, the 38 percent of computer users currently relying on Windows XP will soon need to move to a modern operating system, or risk exposure to malware.
Technology

Sticker Shock Awaits Sage 50/Peachtree Payroll Service Users

The 2014 version of Sage 50, formerly known as Peachtree Accounting, is available for purchase now. As a result, certain users who rely on the payroll subscription are going to experience sticker shock in the near future.
Technology

Creating a Series of Letters in Excel

By its very nature as a spreadsheet, it's easy to create a series of numbers in Excel. But most users don't realize that you can configure Excel to create a series of letters in a similar fashion. Excel expert David Ringstrom explains how.
Technology

Recovering Unsaved Excel Workbooks

It's every spreadsheet user's worst nightmare – you've worked on a workbook for a period of time, and then accidentally close it without saving. Or the power goes out, or Excel crashes . . . the list of spreadsheet hazards goes on and on.
Technology

How to Disable Worksheet Animation in Excel 2013

Excel 2013 has arrived, and for the most part, it's much like Excel 2007 and 2010, but with some spiffy new features, such as Recommended Charts and Pivot Tables, Flash Fill, Quick Analysis, Power View, and more.
Tax

Free Spreadsheet-Based Form 1040 Available for 2012 Tax Year

It's not just the IRS that's been madly updating forms for the 2012 filing season. Right on schedule, Glenn Reeves of Kansas has released his sixteenth spreadsheet-based version of the US Individual Tax Return, commonly known as Form 1040.
Technology

Microsoft Office 2013 Officially Released

The latest incarnation, or rather incarnations, of Microsoft's flagship productivity suite were released on January 29, 2013. The plural reference is a nod toward both the web-based Office 365 version as well as the new Office 2013 desktop versions.

Pages


Already a member? log in here.