Excel

Technology

Manipulating Sheets in Excel, Part II

In last week's AccountingWEB Weekly Earful, we discussed methods for manipulating the sheets within an Excel workbook file. There is a lot more that can be said on the subject, so we've decided to have another Sheets session this week.You've already learned about what those sheet tabs mean, the little Sheet1, Sheet2, Sheet3 tabs that appear at the bottom of your spreadsheet.
Technology

Iowa approves $180 million class action settlement against Microsoft

At the end of August, an Iowa district court approved a $180 million settlement against Microsoft in an anti-trust class action suit. The Iowa claim alleged the company had used its monopoly position to overcharge consumers for its Windows and Office programs. Under the settlement, Iowa residents who bought Microsoft software between May 1994 and June 2006 will be entitled to refunds in the form of cash or vouchers they can spend on new Microsoft products or PCs.Word users will get $10 back per license, while each Excel user will be entitled to $25.
Technology

Windows Vista service pack release scheduled for early 2008

Windows users will get another opportunity to jump aboard the Microsoft upgrade merry-go-round next year, when it plans to introduce a new service pack for Windows Vista.
Technology

Teaching old blogs new tricks

Despite understanding how valuable blogging can be, many firms are still failing to fully embrace it. Marketing management provider WebTrends found that contrary to 85 percent of marketers' perceptions that an effective web presence is important in achieving sales and objectives, just 5 percent blog on a regular basis.Instead, its research showed Internet tools such as e-direct and web analytics continue to dominate. Podcasts are another medium to watch for business, says the firm, as despite relatively low usage at the moment, it registered the highest level of user satisfaction.
Technology

Manipulating sheets in Excel

You've seen those little tabs at the bottom of the Excel spreadsheet screen – Sheet1, Sheet2, Sheet3 – how would you like to learn some tricks for manipulating those sheets and making them work for you?!When you open a new Excel workbook file, Sheet1 is the active spreadsheet. The active sheet is the one that is displayed on your screen. You can also tell which sheet is active by looking at the Sheet tabs at the bottom of the screen. The tab that is white is the active sheet.Move from one sheet to another by clicking on the various sheet tabs.
Technology

Excel Tip: Using the AutoFill feature for copying cells

Excel's AutoFill feature is activated by dragging the little square that appears in the lower right corner of the active cell. Here are the options for copying with AutoFill:If the cell contains a formula, dragging the AutoFill box will copy the formula to all cells over which you drag. The formula will be updated to logically respond to the information in the cells to which you copy.
Tax

Is your data safe? Survey reveals scandal of snooping IT staff

Results of a recent study reveal the hidden scandal of IT staff snooping at the confidential information of other employees.
Technology

Job hunters blackmailed in Monster.com hack

Monster, the world's largest recruitment website, was left reeling this week when thousands of jobseekers were targeted in a sophisticated phishing blackmail scam. American users who had registered with the site received e-mails last week inviting them to download a Job Seeker Tool from Monster.
Technology

How to start a company without an IT professional

Have you ever noticed that IT professionals are grumpy? I think that part of the reason is because they never get calls like this: "Hey IT guy, just calling to say that everything is working okay today and you're a great guy!" The calls are typically more like this: "Hey IT guy, why is it that the only messages our spam filter filters out are our sales leads? Luckily, however, it does let all the Viagra ads through, which is good because it gives us something to read while we're not selling anything.
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.

Pages