Excel

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

Pages


Already a member? log in here.