Excel

Technology

A Conversation with Mark Holland: Don't Be Frightened of Software as a Service

Having launched an online accounting service, Revas, Baker Tilly OnLine managing partner Mark Holland urges the accountancy profession to embrace the latest technology tools.Much as it may affront us, there are still those people who subscribe to the old stereotype that accountants are single minded, number crunching, spreadsheet-loving technophobes. While there may be a few who still conform to that image, a great number of us don't as we all realize that technology is continually changing. So too must our profession.
Technology

Yankee Group advisory: SMBs demanding Software-as-a-Service

As small and medium sized businesses (SMBs) increasingly move to Web-based accounting applications deployed in Software as a Service (SAAS) arrangement, CPAs face a key decision on whether to help SMBs make the move or stand by and risk losing clients.
Technology

Salesforce.com customers victimized by phishing scheme

Customer Relationship Management software vender Salesforce.com has sent a letter to its customers, warning that they may be the targets of malicious software or phishing scams, after one of its employees received a phishing e-mail message and was tricked into divulging a corporate password. In addition to obtaining the employee's password, the scammer was able to download a copy of a customer contact list from the unsuspecting Salesforce.com employee. The list included customer first and last names, company names, e-mail addresses, telephone numbers, and other data.
Technology

New Internet Tax Freedom Act becomes law

To no one's surprise, President Bush signed the oddly named Internet Tax Freedom Act Amendments Acts of 2007 last week, extending the moratorium on Internet access taxes for another seven years. This moratorium has been going on since 1998 and will be 16 years old when those who are in favor of the access taxes once again try to blow out its candles.The vote in Congress was unanimous in favor of the moratorium.
Tax

Scammers hit those who would help wildfire victims

The Internal Revenue Service has warned taxpayers to be on the lookout for a new e-mail scam that appears to be a solicitation from the IRS and the U.S. government for charitable contributions to victims of the recent Southern California wildfires.In an effort to appear legitimate, the bogus e-mails include text from an actual speech about the wildfires by a member of the California Assembly.The scam e-mail urges recipients to click on a link, which then opens what appears to be the IRS Web site but which is, in fact, a fake.
Technology

Dell plays down impact of 2003-06 restatements

Texas-based PC manufacturer Dell this week filed restatements of its 2003, 2004, 2005, and 2006 annual results to reduce revenue and profit figures that were inflated in the original accounts.
Technology

Excel Compendium: Practical uses for Lookup and Reference functions

Excel's VLOOKUP, HLOOKUP, INDEX, and MATCH functions can make life a lot easier for accountants.
Technology

Technology generation upgrades: Are educators and employers on the same page?

Information technology (IT) and information systems are pervasive in today’s business environment. CPAs, therefore, have to understand IT processes and controls. What are accounting educators doing to prepare students as they enter an environment in which data moves through computerized accounting packages, intranet portals, or enterprise resource planning (ERP) systems? More importantly, though, are accounting educators and professionals even on the same page with respect to IT education?Technology generation upgrades: Are educators and employers on the same page?
A&A

ExcelZone spreadsheet seminar tips: Think first, Excel second

An experienced group of management accountants gathered earlier this year at the Law Society in London for AccountingWEB UK ExcelZone's inaugural seminar on "smarter management reporting with Excel." The event, the first in a series, was sponsored by ExcelZone partner Rugged Logic. ExcelZone contributor Simon Hurst was on hand to pass on tips for smoother working with accounting data and spreadsheets. "Before we get on to the practical stuff, the first thing you need to do when reporting with Excel is to design a good spreadsheet," says Simon Hurst, AccountingWEB contributor.
Technology

IBM expands software line for small and mid-sized businesses

IBM has announced new software and resources to help mid-sized customers more effectively manage the quality of their software and network infrastructures, just like their counterparts in large enterprises. The new software underscores IBM's expanded focus on providing small and mid-sized businesses with the solutions necessary to remain competitive in the market. Typically, IT departments in small and mid-sized businesses lack resources or a formalized IT department to support their operations.
Technology

What is RSS?

RSS means Really Simple Syndication. RSS is a special format based on XML, which was first used to unite headers with web content. In fact, RSS feeds are XML files containing data according to the RSS specification, and usually located on a website.As soon as an RSS feed appears in the Internet, any connected computer can access it. In order for the user to be able to use the RSS feed, he needs special software or services called readers or aggregators.RSS allows users to save their time, however it is rather difficult to create an RSS feed manually.
Technology

Windows loyalists force Microsoft to keep XP in business

The decision to keep the Microsoft XP operating system available till mid-2008 has fuelled suggestions that the expensively developed, but critically challenged, Vista replacement is facing a serious acceptance problem. The company says it's just responding to a trend in which more businesses wait for a hardware change before upgrading software, and that 60 million license sales to date is still respectable. But extending XP is also an insurance against an end-of-life defection from closed Vista to open source.
Technology

Virus Alert: Beware fake Microsoft patch e-mails

Microsoft Security alerts are such a part of computing life that virus writers have now created spoof security alert e-mails to trick users into activating a trojan horse program.
Technology

Math errors found in Excel 2007

Microsoft has confirmed the existence of a serious bug in Excel 2007 that can cause an incorrect amount to appear in a cell. The problem that has been isolated so far occurs when a calculation should produce the result of 65535. Instead of the correct result, Excel displays 100000. For example, enter the following formula in an Excel 2007 cell:=77.1*850You will see that 100000 appears as the result. Other formulas have the same effect.It should be noted that, although the spreadsheet displays 100000, the value of the cell is correct at 65535.
A&A

Here comes QuickBooks 2008

Intuit Inc. has released its new line of QuickBooks 2008 products and services. According to Intuit, the 2008 version of the nation's best-selling small business financial software focuses on ease-of-use improvements for important day-to-day tasks, as well as connecting in new ways with new applications. Other new features extend the power of QuickBooks beyond accounting by integrating with new online services and industry-leading applications.
Technology

A new approach to Excel pivot tables

In common with many of the features of the Office suite, working with Excel pivot tables has been changed both by the application of the new Office 2007 interface and by several specific enhancements.Creating a pivot tableFirst find the PivotTable option. Although PivotTables used to live in the Data menu, the new ribbon interface has moved the PivotTable option to the Table section of the Insert ribbon.
Technology

Human error and criminal cleverness still beating data security

Although often criticized for amplifying scares on which the sponsors trade, new surveys show that online data theft is changing with new service delivery trends, as well as outpacing most companies' security efforts. New research from Deloitte confirms that your company's security is far more likely to be breached through its doors than its online portals. Two-thirds of respondents to its annual financial-service company survey say they have suffered repeated external security breaches, mostly via customers. One-third say employees have also caused them.
Technology

Business faces up to social networking

It's not just teenagers and bored employees who spend time posting on the likes of Facebook and MySpace to chat with their friends – more than a tenth of the sites' users visit them for business reasons, it has been claimed.Research group emedia found 11% of respondents use social networking websites for business purposes with another 8% contact existing or potential clients via the services.Facebook in particular has come in for strong criticism
Technology

Excel 2min Tip: Round your budgets to the nearest thousand

If you have a spreadsheet containing a lot of numbers, it will be easier to read if you round the numbers to the nearest thousand.To display figures to the nearest thousand, use the Format – Custom feature and include three things: a dot, a zero, and a comma.Example: To display the numbers on the left as the numbers on the right, follow these steps:1021.76...........1.1560...................0.6540...................0.521.....................0.01345.26...........1.3-520.78...........-0.5Type the first column of
Technology

Boomers use online brain games to stave off dementia

The generation that refuses to age is not going to sit back and wait for Alzheimer's Disease and other signs of dementia to take hold. Instead, savvy Baby Boomers are expanding their minds (no, not the way they did in the 60s) with the aid of the computer, puzzles, and games.

Pages