Excel

Technology

Dell promises to restate fudged accounts

Texas-based PC manufacturer Dell has been forced to restate accounts going back to 2003 due to accounting errors and irregularities identified by an internal investigation. The accounting errors and irregularities that will be corrected are significant because of the combination of the number of issues identified, the qualitative nature of many of the issues, and in some cases, the dollar amounts involved.The problems came to light in 2005, when the SEC's Division of Enforcement launched an investigation into the company's accounting and financial reporting practices.
Technology

Kittens could save us from spam

Kevin Larson, a researcher at Microsoft, has come up with a unique idea for combating e-mail spam – kittens! Typically, would-be spammers use free e-mail services like Hotmail and Yahoo mail for sending their spam messages. These mail services attempt to prevent automated signups for new mailboxes by using a protocol referred to as HIPS – Human Interactive Proofs. You've seen them. A box appears containing slightly distorted letters or numbers and you are asked to type what you see.
Technology

Lights! Camera! Online video is revolutionizing how companies recruit

New Yorkers braved the heat one day last week to take advantage of the opportunity to record free online video resumes, when the world's first career TV-website, CareerTV.com, launched big in Times Square."It felt a bit weird doing it.
Practice

Corporate world welcomes wikis

Almost everyone who owns a computer knows about Wikipedia, the huge, do-it-yourself online encyclopedia. The software that makes Wikipedia possible is becoming increasingly easy to use, and corporate America is starting to embrace wikis as a tool for simple and swift collaboration.In fact, Wikipedia founder Jimmy Wales told Newsweek that the wikis are becoming mainstream, not just for "tech geeks." And in corporate settings, wikis break down barriers.
Technology

Apple unleashes Numbers spreadsheet with new iMac

Californian computer maker Apple has launched one of its cheekiest attacks yet on the might of Microsoft with a new software bundle designed to challenge the might of Office.The iWork '08 suite introduced alongside the latest slimline iMac computers includes the Pages word processor, a presentation package called Keynote and Numbers, a rival to Microsoft Excel.This being Apple, Numbers is not being presented as just another spreadsheet, but a new approach that in the words of chief executive Steve Jobs i
Technology

Managing complexity still top security challenge, survey says

Managing the complexity of security continues to be the number one challenge for organizations around the globe, followed closely by preventing security breaches, enforcing security policies and spreading user awareness. These challenges have prompted plans for a significant increase in security spending in the coming year, according to a 2007 survey by Accenture and CMP Technology's InformationWeek.The tenth annual survey of nearly 3,000 IT professionals from the U.S.
Technology

Microsoft to offer Works for free

Microsoft Corp. has announced plans to offer Microsoft Works, its diluted version of the Office product, to customers for free next year. Works version 9 SE will be loaded on a limited number of new computers. The catch? The program will come with advertising already installed.Display ads will appear in the lower corners of the screen when users turn on the program. The ads will update and change automatically in the background, while the user is online.
Technology

The Spacebar: Your Excel nemesis

The spacebar can be your enemy in Excel. While pressing the spacebar might seem like a simple method for clearing data from a cell, the results of such an action can be devastating. And spaces take up space, and that can cause other problems with your spreadsheet.Pressing the spacebar leaves not a blank but a space in a spreadsheet cell, and a space is a character, just like a letter or a number.
AccountingWEB Life

How do I waste time at the office? Let me count the ways....

With the line between work and the rest of your life becoming blurrier every day, technology seems to make workers both more and less productive at the same time.Computer tools can make quick work of once-tedious accounting tasks, for example, but they also make it easier to buy a paperback, chat with friends by instant message or balance your personal checkbook while at the office.
Technology

IRS extends deadline for E-filers to register their websites

Notice: The IRS has extended its deadline from August 9 to September 10 for e-file providers to register their websites. The information contained below is still applicable, but you now have until September 10 to prepare and send a spreadsheet to the IRS containing URL information.The IRS has provided AccountingWEB with additional information, including a sample spreadsheet (pictured below) for e-file providers who are required to register their web sites.
Technology

Illinois CPA Society prepares for 2007 Business & Technology Solutions Show

On August 21-22, the Illinois CPA Society will host its 27th annual Business & Technology Solutions Show at the Donald E. Stephens Convention Center in Rosemont, IL. The Show will take a closer look at the hottest issues facing accounting and finance professionals and showcase the latest business technologies to help stay ahead of the competition. The event will provide innovative solutions from approximately 120 industry-leading exhibitors.
Technology

Brush up your PowerPoint skills for college applications

Launching what might become a national trend, the University of Chicago's Graduate School of Business is now requiring new applicants to submit a PowerPoint presentation in addition to the traditional application, transcripts, and test scores.The reason for requiring the PowerPoint slides goes beyond the fact that Microsoft's presentation program is a software standard in boardrooms across America. U of C Associate Dean Rose Martinelli explains that the slide presentation is designed to give students an opportunity to show their creative side to the admissions committee.
Technology

Excel 2min Tip: How to remove error messages such as #DIV/0!

When you use a formula to calculate a new column of numbers, Excel will sometimes display error messages such as #DIV/0! if a number has been divided by zero.Use the ISERROR function to eliminate error messages and keep the column of data tidyWorked example: Start up Excel. Open a blank worksheet.In cells A1 to A6, type: 10, 20, 30, 40, 50, 60 (no commas)In cells B1 to B6 type: 1, 2, 3, 4, 5, 6Now in B2 and B4, replace the 2 and the 4 with 0 (zero).In C1, divide B1 into A1 with the formula = A1/B1.
Technology

Excel Tip: Moving around the worksheet

There are several techniques for moving from one place to another on an Excel worksheet. Here are some of the most common techniques:Using the mouse:Use the mouse to click in any visible cell.
Technology

Urgent: New IRS rule for e-file providers

The IRS has established new e-file rules to enable it to more quickly identify fraud schemes including phishing. These new IRS e-file rules apply to all Authorized IRS e-file Providers, including Online Providers, Intermediate Service Providers, and Electronic Return Originators (EROs) that obtain taxpayer information via the Internet directly or through third parties in order to e-file federal returns.Providers must submit to the IRS by August 9, 2007 an Excel spreadsheet that has been encrypted using WINZIP 9 with password protection.
Technology

IASC Foundation seeks candidates for XBRL Advisory Council

The Trustees of the International Accounting Standards Committee (IASC) Foundation are today inviting applications for membership of its XBRL Advisory Council (XAC) and its XBRL Quality Review Team (XQRT).The XAC will provide strategic advice to the Trustees and the Foundation's London-based XBRL team on the future development and adoption of the XBRL Taxonomy for International Financial Reporting Standards (IFRSs). It will comprise ten members who should broadly reflect the diverse areas and professional interests affected by XBRL adoption and the implementation of IFRS taxonomies.
Technology

Excel 2007 Tip: Automatically saving Excel files and finding saved files

Excel 2007 automatically creates a backup of your work every 10 minutes. You can change this setting so that the backup is created more frequently, less frequently, or not at all. This tip explains how to change the AutoRecover feature to suit your personal needs and also shows you where your backed up files are saved.Change AutoRecover settings by following these steps:Click the Office button (the round button in the top left corner of your Excel 2007 screen)Click the Excel Options button that appears beneath the Office menu options.
Technology

Spreadsheet error research: Wasted time worse than mistakes

The time wasted working on bad spreadsheets is a bigger practical problem than errors within Excel models, a leading spreadsheet error expert concluded at the recent European Spreadsheet Risks Interest Group (EuSpRIG) conference in London.Presenting the results of a detailed study of errors in 25 sample spreadsheets, Stephen Powell from the Tuck Business School at Dartmouth College in New Hampshire found that 15 workbooks contained a total of 117 errors.
Technology

Instant messaging: Another distraction or a tool for collaboration?

Apparently, e-mail isn't fast enough.After years of reluctance to add another potential distraction to their employees' work days, companies are starting to embrace instant messaging.Instant messaging isn't new to the workplace, but it's mainly been used by employees who have installed IM programs on the sly. Now employers are getting into the act. IM programs allow users to start casual, real-time conversations with co-workers on their "buddy lists," which show who is online. With IMs, not only can you get instant answers, but you can talk with multiple people at once.
Technology

New Excel spam hits e-mail

Microsoft Excel is the newest packaging spammers have created for their stock pump-and-dump scams, Commtouch Software has reported, based on the Company's analysis of billions of e-mail messages globally.

Pages