Excel

Technology

Excel 2008 and MacBook Air debut at MacWorld

If all that comes to mind when you think of a MacWorld is a burger-based theme park, then you're lagging in the fast-moving world of technology. Following hard on the heels of the Consumer Electronics Show (CES) in Las Vegas, last week's Apple's own MacWorld conference and expo in San Francisco was the biggest yet with 485 exhibitors and marked a shift of emphasis for Apple.Apple's recent strategy has concentrated on the groundbreaking iPod, iPhone, and AppleTV, leaving the world of business to Microsoft.
Technology

Spreadsheet blip adds $140,000 to Arizona school payroll

A story emanating from the accounts department of the Tucson Unified School District is on its way to the spreadsheet hall of shame after teachers were paid an extra $141,114.38 at the beginning of January, 2008. According to a report in the Arizona Daily Star, the trouble started when the district agreed to back-dated pay raises and retroactive pay for teachers in December.
Technology

DaaS joins SaaS and PaaS as latest buzzword

Software as a Service provider Salesforce.com is adding another string to its bow in the form of Development as a Service. First there was SaaS; then there was PaaS; now it's DaaS that's being pushed by Salesforce.com. Development as a Service is being touted as part of the firm's wider Platform as a Service initiative. DaaS essentially is a set of development tools and API that can be used to development applications that run on the Force.com cloud under the PaaS model.
Technology

ExcelZone's Five Minute Pivot Table Tips - Index

ExcelZone's series of Five Minute tips aims to develop your skills at using Excel pivot tables. If you want to try out each tip for yourself, Excel expert David Carter takes you through a worked example on a small sample database of sales invoices.In the worked examples you will analyze the invoices to show sales by product, sales by customer, gross margins, margin percentage etc. The series is therefore relevant to sales and marketing people as well as accountants.
Technology

AICPA announces top ten technology initiatives for 2008

Information Security Management will be the most important initiative affecting IT strategy, investment, and implementation in business organizations over the next 12-18 months, according to the American Institute of Certified Public Accountants' 19th Annual Top Technology Initiatives survey.
Technology

Google Desktop Search slows Excel

As reported recently on the Daily Dose of Excel site, Charles Williams of DecisionModels.com tried to find out what was causing the delays on certain versions of Excel when he tried to clear a large range of cells. Following further discussions on VBA news groups, it was found that problem could be linked to the EnableEvents property.
Practice

Social networking breeds new wave of 'Trojan 2.0' attacks

The great Facebook boom of 2007 has been accompanied by a new generation of phishing and trojan horse virus attacks, according to security experts.In its review of the year, MessageLabs noted that websites such as Facebook, Linked-In, and Plaxo presented rich pickings for identity thieves looking to gather personal information.
Technology

CPA Technology Advisor announces annual Readers' Choice Awards

The following announcement was issued by the CPA Technology Advisor on the occasion of their annual Readers' Choice Awards presentations.With the changing of calendars from 2007 to 2008, it's also time to announce the results of the CPA Technology Advisor 2007 Readers' Choice Awards, an annual insight into the minds of tax and accounting professionals. The Awards, featuring more than 25 categories of professional applications, hardware, services and other technologies, give those in these professions a way to express appreciation for the systems that help them in their practice.
Technology

Tutorial: Import data from MYOB into Excel. By David Carter.

It is very easy to get nominal transactions out of MYOB and into Excel, although it's a bit of a rocky ride to get them out in the format you want. In this first of two tutorials David Carter shows how to get nominal transactions out of MYOB and into Excel via Excel's Data - Import External Data command. MYOB (for Mind Your Own Business) is one of the most attractive entry-level packages around. It was originally written for the Apple Macintosh and was one of the first Windows packages in the early 90's.
Technology

2007 Xmas gadget countdown - the people's choice

Every year in the run-up to Christmas, the executive peripherals editor at our sister site, AccountingWEB.co.uk, Nigel Harris, chooses the objects that most deeply stimulate his electronic desires. We've decided to cross the ocean this year and include Nigel's gadget picks here in the U.S.
A&A

Survey says 40 percent of networks at SMBs are not secure

Despite having anti-virus and anti-spam software as well as a firewall installed, four in 10 small and medium sized companies in the United States still do not believe their networks are secure, a new survey shows.In a poll of 455 IT executives for U.S. SMBs, 42 percent said their networks were not secure, even though 96 percent and 93 percent of respondents respectively said they had anti-virus and a firewall installed. Eighty percent said they also used spam filtering.
Technology

Wanted: Your favorite Excel macros

Gail Perry, our managing editor, is looking for contributions to a new book she is penning about Excel macros.
Technology

Beta version of Microsoft Office Live Workspace is now live

Microsoft Corporation has officially opened its online office document-sharing site. Office Live Workspace is a public open beta site, available to anyone with a Windows Live ID. The focus of the site is the ability for users to share and save documents online. Users must have Microsoft Office applications - Excel, Word, PowerPoint, and Outlook - installed on their computers to take advantage of the capabilities of the online site.
Technology

Microsoft woos accountants

Following the launch last week of Microsoft Office Accounting 2008, the company has set its sights on the accounting profession.Membership in the Microsoft Professional Accountants' Network (MPAN) is available for free to anyone in the accounting professional and provides accountants with some valuable incentives to start using and recommending the accounting software:One complimentary license of Microsoft Office Accounting ProfessionalFree unlimited support until Septe
Technology

ID theft techniques changing constantly

The most popular ways to steal someone’s identity have nothing to do with the Internet.The Center for Identity Management and Information Protection says that mail theft, dumpster diving, stolen wallets, and other low-tech or no-tech methods are used far more often, with only 10 percent of scammers using the Internet exclusively. According to a 2006 Gartner Research study, last year an estimated 15 million people were victims of identity theft.
Technology

Whaling and spear phishing are latest scams targeting execs

Cybercriminals, no longer satisfied with a sweeping, general approach, are adding another weapon to their arsenal - so-called spear phishing attacks, or scams that are targeted at specific individuals.Not surprisingly, according to security vendor MessageLabs, the latest targets are executives. Finding the names of top executives is easy - they're usually found on company websites. Cybercrimals then do some research on the individuals and write e-mails that directly relate to their role at the company in hopes that they will click on a link, Network World reported.
Technology

Microsoft releases Office Accounting 2008

Microsoft Office Accounting 2008, an enhanced version of the well-received 2007 financial management software for small businesses, is now available. In addition to new features and tools, Office Accounting 2008 has expanded its market distribution to include a bilingual Spanish-English version for the U.S.-based Hispanic market as well as a new product for the United Kingdom.
A&A

Sage makes a Peachtree offer some won't be able to refuse

This week, Sage Software announced the availability of free software for the clients of accountants who are ready to make the switch to Peachtree. Through January 31, 2008, accountants who recommend Peachtree to their clients currently using Intuit's QuickBooks can get Peachtree by Sage Complete Accounting 2008 for the clients for free with proof of ownership of QuickBooks. Customers who then make the switch to Peachtree will also get six months of support free, from the date of registration, with the Guaranteed Start-up Success program.
Technology

Microsoft releases new security guide for Office 2007

In an effort to help Microsoft Office users remain productive and keep data secure, Microsoft has released a new document, 2007 Microsoft Office Security Guide, designed to help defeat attacks that target e-mail and desktop documents. The guide offers detailed documentation for securing Office 2007 applications to protect against specially written document files with malicious code hidden within them. It is an unfortunate fact that e-mail attachments, macros, and add-ins can contain viruses or other malware.
Technology

Can resellers make money out of Software-as-a-Service?

The software as a service (SaaS) model represents a fundamental shift in the dynamics of the computer industry. David Bradshaw, principal analyst with the IT market watcher Ovum outlines issues for resellers - which are also relevant for accountancy firms who get involved with SaaS providers. Software products provide the 'feedstock' for a wide range of other players in the overall software and IT services market. The switch to software as a service has profound effects on many of these players.

Pages