Excel

Technology

Excel Text Transformation Tricks

By David H. Ringstrom, CPAData arrives on your desk from multiple sources, and in many cases it's not quite in the format that you need. For instance, a user may have left the CAPS LOCK on while typing in a series of addresses. Or you've exported data from a program that pads fields with spaces at the beginning or end. Fortunately, there's no need to retype the list. Excel offers four easy-to-use functions that can quickly transform data into just the format that you need.
Technology

Excel 2007: Five Ways to Streamline Excel’s User Interface

By David H. Ringstrom, CPAIt's easy to get caught up in the day-to-day use of Excel 2007 and overlook minor tweaks that can make a significant difference in your use of Excel. In this article I'll review five of my favorite Excel 2007 tricks. Most involve customizing the user interface so that I can speed through my work without hitting unnecessary bumps:1. Extend your recently used file listBy default Excel shows the 17 most recent files that you've opened, but as shown in Figure 1, you can expand this to a maximum of 50: 
Technology

Excel 2003: Six Ways to Streamline Excel's User Interface

By David H. Ringstrom, CPAIt's easy to get caught up in the day-to-day use of Excel 2003 and overlook minor tweaks that can make a significant difference in your use of Excel. In this article I'll review five of my favorite Excel 2003 tricks. Most involve customizing the user interface so that I can speed through my work without hitting unnecessary bumps or screen prompts. These tricks will work equally well in Excel 2002, but only some apply to Excel 97 and 2000:1. Extend your recently used file list
Technology

The far side of Excel - Fireside treats for long winter nights

As you sit by your roaring log fire, idly fondling the shiny new notebook computer that Santa bought you, here are some suggestions for trying out a few lesser known features that lurk in the depths of the Microsoft Office applications, courtesy of our sister site, AccountingWEB.co.uk.Microsoft Word - Excel in disguiseFor most accountants the real problem with Word is that it isn't Excel.
Technology

AccountingWEB Webinar: Creating error proof spreadsheets

In today's fast-paced business world, spreadsheet users don't always have the luxury of double-checking every element of their work, particularly in complex spreadsheets. Fortunately there are some simple practices you can adopt to help minimize the risk of errors in your spreadsheets. You can also learn how to track down errors in spreadsheets built by others. Take an hour tomorrow and get up to speed during our live Creating Error Proof Spreadsheets Webinar.
Technology

Excel Tip: Hide an Excel Worksheet in Plain Sight

By David Ringstrom, CPAAs you’re probably aware, it’s simple to hide a worksheet in Excel 2007: right-click on the worksheet tab, and then choose Hide. To unhide the worksheet, right-click on any worksheet tab, choose Unhide, and then select the sheet you wish to make visible. It’s a little more effort in earlier versions of Excel: choose Format, Sheet, and then Hide or Unhide to change the visible status of a worksheet.
Technology

Excel Tip: Add visuals to your headers and footers

Since Excel XP it has been possible to insert a picture into a custom header or footer. Our sister site, AccountingWEB.co.uk investigated some potential uses for this facility.Excel's View-Header/Footer menu option will take you to the Header/Footer section of the Page Setup screen. Clicking on the Custom Header or Custom Footer button presents you with three sections: Left, Center and Right.
Technology

Excel 2007: Use these three techniques to turbo charge filtering

By David Ringstrom, CPADid you know Excel 2007 has a hidden command that enables you to filter a list with just one mouse click? And that there are two ways to sum just the visible rows in your filtered list? Read on to discover these time saving techniques.Not sure how to filter? Read Excel Filtering 101. 
Technology

Excel 2003: Use These Three Techniques to Turbocharge Filtering

By David Ringstrom, CPADid you know that you can streamline the AutoFilter feature in Excel 2003 and earlier versions? And that there are two ways to sum only the visible rows in your filtered list? Read on to discover these time saving techniques.Not sure how to filter? Read Excel Filtering 101.
Technology

Excel Filtering 101

By David Ringstrom, CPAFiltering is a powerful, but often overlooked feature in Excel that enables you to hide unneeded data within a list. In Excel 2003 and earlier, this feature is known as AutoFilter, while Excel 2007 refers to it as simply Filter. In this article I'll provide a quick overview of how to use this helpful feature.Filtering BasicsFiltering enables you to collapse a spreadsheet down to display only relevant rows.1. Copy the data from Table 1 into a blank worksheet, starting at cell A1. 
Technology

Excel Chart Advisor Prototype Simplifies Graphs

By David RingstromExcel 2007 users have a new tool in their arsenal: the Chart Advisor from the Microsoft Office Labs — a new proving ground for potential new Office features. Although this tool is a prototype, you may find it helpful in your daily work. This add-in for Excel utilizes an advanced rules engine to analyze your data, and then rank chart suggestions based on their respective score. Remember, this tool only works with U.S. English version of Excel 2007.
Technology

Excel guru posts 'ultimate list of Excel RSS feeds'

John Walkenbach is a legend in the world of Excel.
Technology

Microsoft announces millionth customer sign-up milestone for Office Live Workspace

Microsoft Corp. has announced that only six months after public availability, the beta release of Microsoft Office Live Workspace has reached the 1-million-customer sign-up milestone. Office Live Workspace beta is the free, Web-based extension of Microsoft Office that lets people access their documents online and share their work with others. The Workspace beta was among the first entries in the new wave of online services that embody Microsoft's software-plus-services vision previewed last fall.
Technology

New undelete program retrieves spreadsheets and other valuable files

Accidents happen. Files get deleted by mistake. Valuable information is lost. Forever? Maybe not.Diskeeper Corporation has announced the release of a new version of its program, Undelete, designed to intercept deleted files. Here's what the company has to say about its product:Think of all the valuable data on your computer: Financial records, work and school reports, digital photos you'll never be able to take again... what if those files were deleted and you couldn't get them back? Accidental file loss happens more often than you think.
Technology

Microsoft slams window on sales of XP software

Microsoft Corporation has officially pulled the XP operating system from its product line. The move came 18 months after the company launched the Vista operating system.Although Microsoft will not sell the XP program any longer, they will still generate revenue from providing support for the software since the support will no longer be free.
Technology

Microsoft launches new software subscription service

Microsoft will begin selling its Office programs as a subscription service starting in mid-July.Called Equipt (formerly code-named Albany), the package combines Microsoft Office Home and Student Edition, Windows Live OneCare, the security and PC management service, and other free services for $70 a year, which covers three PCs. Microsoft Equipt will be sold in nearly 700 Circuit City stores in the U.S. starting July 15.The annual subscription covers updates, and will save consumers money, analysts say.
Technology

Excel Tip: Using the Excel camera feature

Our sister site, AccountingWEB.co.uk, provides us with an interesting technique for setting the print area on an Excel worksheet to include several individual, distinct areas. This is relatively easy to accomplish by holding down the Control key while selecting additional areas.
Technology

New tool links online files to Excel applications

Web spreadsheet EditGrid has introduced a new feature that works as an Excel Add-in linking online files to Excel applications running on your computer. With EditGrid, you can pull information directly from the Internet into your spreadsheets.
Technology

Multiple monitors: "The quickest and cheapest way to drive up productivity"

You may think this is a thinly disguised ad designed to sell computer monitors, but it isn't. More and more accountants are adopting the practice of using dual monitors … some are even using three or four. The results? They are seeing green, in more ways than one. First, there is much less need to print, therefore less wasted paper and ink. For many, that's the original idea. Then there is the other green... increased productivity, which translates to a greener bottom line. People who swear by multiple monitors say it is the path to ultimate multi-tasking.
Technology

Microsoft introduces two new training and certification programs

Despite the current air of global economic uncertainty, demand for trained and certified IT professionals is expected to continue apace over the next several years. Research firm IDC forecasts that demand for technology training and education programs will increase by 5.4 percent between 2007 and 2012, with the Americas leading the way with 6.6 percent growth over the forecast period.

Pages


Already a member? log in here.