Excel

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

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.

Pages


Already a member? log in here.