Technology news April 2009

Technology

Announcing a new community for accounting professionals

AccountingWEB, AccountingJobsToday, and GoHAGit Consulting are pleased to introduce a new community designed to connect accounting and finance professionals.
Technology

Introducing the AccountingWEBinar Series

AccountingWEB is pleased to announce a series of live webinars aimed squarely at the needs of CPAs in public and private practice. This wide-ranging series will cover the following topics:Microsoft ExcelMicrosoft OutlookMicrosoft WordMicrosoft AccessIntuit QuickBooksSage Peachtree AccountingXML/XBRLEach webinar will involve a 50 minute presentation by AccountingWEB staff writer David H. Ringstrom, CPA.
Technology

Three Excel Menus You May Have Overlooked

By David H. Ringstrom, CPASheet NavigationEveryone is familiar with using the arrow buttons in the lower left-hand corner of the Excel screen to push worksheet tabs back and forth across the screen. However, try right-clicking on these buttons instead, and you'll see a menu similar to Figure 1. Simply click on a sheet name to instantly activate that worksheet. 
Technology

Managing Excel Add-Ins

By David H. Ringstrom, CPAAdd-ins are programs that plug-in into Microsoft Excel to add additional functionality. Some add-ins expand Excel's core functionality, while others allow third-party products to add features to Excel's environment. In this article I'll discuss how to enable some of Excel's hidden features, as well as give you some pointers on what to do when third-party add-ins vanish from Excel.Hidden FeaturesExcel ships with several add-ins that you can manually enable. Some of these include: 
Technology

Buried Gold: Excel's Form Command

By David H. Ringstrom, CPAMany users are not aware that Excel has long had a feature that enables you to browse through a table of data one record at a time. As shown in Figure 1, the Form command provides an easy way to navigate through a table of data. This command is easy to access in Excel 2003 and earlier versions, but is deeply buried in Excel 2007. In this article I'll show you how to use the Form command to make quick work of reviewing a list of records. 
Technology

Tricks for Opening and Closing Multiple Excel Files

By David H. Ringstrom, CPA
Technology

Tricks for Hiding and Unhiding Excel Rows and Columns

Hiding and unhiding rows and columns are mundane tasks that many users take for granted. However, sometimes simple tasks can trip up Excel users, like unhiding just one row or column within a hidden set.
Technology

Automating expense control delivers huge returns

by Bill VergantinoIf you are like most small-to-midsized business executives, your primary focus is on growing revenue and controlling company spending. To that end, you leverage technology to eliminate inefficient processes in your company, such as a CRM system to manage revenue and an accounting or ERP solution as your back-end financial system of record.
A&A

Change your IT strategy to work smarter in the recession

By Jennie LeopardThe recession is pushing every organization, regardless of size, to find ways to work smarter. Companies both large and small need to reduce operating costs at the same time they continue to increase productivity, efficiency, retain a competitive edge, and stop that bottom line from shrinking.How can you adapt your IT strategy in this economic downturn?1. Sweating existing IT assets harder
A&A

Getting your feet wet with marketing online

By James Pennington, consultant at the National B2B Centre (NB2BC)Plan your Web siteMany people sit down and start working on their Web site but then stop and never get started again because they haven't thought about what they are trying to achieve. Remember, that your Web site is another sales medium. Understand your proposition and unique selling point and have a strategy for using the Web. The following resources can help: 
A&A

Running a business: From rural life to Second Life

SciArt Media, a Temple, NH based Web design and publishing company, opened a new office and more on President's Day, February 18th. What is unusual is the location of the new office: It is nowhere in the real world – it is entirely virtual – located in the realm of Second Life.
A&A

Increase your sales by improving your Web site design

Design and usability matter a lot when creating a company Web site, and getting it right could be the difference between business success and business failure. Chris Barling, chief executive of ecommerce software provider Actinic, offers best practice advice.