Excel

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.
Technology

Excel goes pop: Guess the songs that appear in spreadsheet charts

Microsoft's Excel spreadsheet has provided a platform for the web's latest sensation - graphical charts that summarize the concepts set out in pop song lyrics.
Technology

Excel charts tutorial: How to manipulate the pop charts

The tech team at our sister site, Accounting.co.uk, put their heads together and came up with this response to the recent net phenomenon where abstract graphs and diagrams are used to illustrate pop lyrics such as "Never Gonna Give You Up." This tutorial applies some of the more obscure charting options to your data.Some challenges are hard to ignore.
Technology

It’s for real: Microsoft offers software at 91 percent discount

Listen up college students! Or the parents of college students! Or anyone who knows a college student! Microsoft's The Ultimate Steal promotion, which AccountingWEB reported on last month, has been extended through May 16, giving eligible students a few more days to snap up Office Ultimate 2007 software at an unbelievable 91 percent discount – only $59.95 instead of the full retail cost of $679.
Technology

Lotus Symphony Office Suite available for free from IBM

Internet users may now access IBM's Lotus Symphony office suite for free from IBM's Web site. The program, which permits the user to create documents, spreadsheets and presentations from software stored on IBM's servers, is available for both Microsoft Windows and Linux operating systems, with support for the Apple Mac OS platform planned for the future.
Technology

New tool available to edit Excel pivot tables

Excel4U.Net Solutions is offering a way to eliminate one of the frustrations of using Microsoft Excel—the inability to make changes directly in the data area of a pivot table.Pivot tables sort, count and total the data stored in one table or spreadsheet and create a second table showing the summary. They are often used to extract statistical information from raw data. The pivot table is linked to the source data and the cells of the table can be read, but not changed.Installing Pivot4U allows users to click on the "add-ins" table of Excel, then select Pivot4U.
Technology

Gartner IT analysts opine that Windows is collapsing under its own weight

Windows is too "monolithic," claimed Gartner IT analysts Michael Silver and Neil Macdonald last week.
Technology

Are you spending too much time with Excel?

Access Accounting managing director John Beech argues that Excel is a part of the daily life of the accountancy profession, but poses significant risks if it's not integrated with the business and accounting system. This article from our sister site, AccountingWEB.co.uk, sets out a base line for how spreadsheets should work with accounting systems.There's no denying that Microsoft Excel has worked its way into the heart of modern business practice.
Technology

Gadget Zone: Computer gadgets can save power from 'energy vampires'

Consumer electronics are notorious energy vampires, sucking energy even when they're not in use. But going green in your office may be easier than you think.According to the U.S. Department of Energy, consumer electronics - 25 devices in the average American home - use as much as 25 percent of their power when in standby mode. Consider the computer, monitor and cable modem. Together, they use 11 watts of power even when powered down.

Pages