Technology news

Technology

Automating Data Validation Lists in Excel

Working in an Excel spreadsheet can be somewhat like the Wild West – unless other provisions are made, users can enter any value in any cell. One way you can restrict users to a predefined set of values is by way of Excel's Data Validation feature.
Technology

Improving the Integrity of Excel's SUM Function

My unscientific observation is that the SUM function is the most widely used function within Excel spreadsheets. This function makes it easy to add up multiple cells at once without laboriously adding multiple cells together individually.
Technology

ZenPayroll Adds Contractors to Its Cloud-Based Payroll Service

When ZenPayroll launched in 2012, its mission was to bring the power of modern software to the payroll industry through a Cloud-based service that's easy to use, comprehensive, and accessible 24/7 from any computer or mobile device.
Technology

Microsoft's Chip In Program Offers Crowdfunded Laptops to Students

Microsoft is dipping its corporate toe into the crowdfunding pool. An experimental program dubbed Chip In allows students to tap friends and relatives in a quest to fund their next computer.
Technology

Winners of 2013 Innovation Awards Announced

The winners and finalists for the tenth annual Tax & Accounting Technology Innovation Awards are all Cloud-based solutions, highlighting the movement of accounting and tax experts toward mobile technologies. The awards were presented June 3 by CPA Practice Advisor.
Technology

Resolving #VALUE! Errors in Microsoft Excel

It's a frustrating experience when a simple Excel spreadsheet displays #VALUE! in a worksheet cell rather than the expected result. Many times the problem is obvious, but sometimes the culprit is harder to track down.
Tax

IRS Fine-Tunes e-File System to Prevent Processing Delays

After performance issues to its electronic filing system caused delays in processing tax returns during the 2012 filing season, the IRS has made several enhancements to the system over the past year that are expected to improve the tax-filing process.
Technology

Firms Must Also Look Internally to Keep Their IT Systems Secure

While you might think your IT systems are safe and secure, think again. One of the greatest security threats comes from a firm's own staff. Learn five ways your staff can wreck your IT systems and cost your business in lost productivity.
Technology

Overcome a Nuance of Excel's Subtotal Feature

Many users rely on the Subtotal feature in Excel to instantly insert totals, averages, counts, or other statistics into a list. As you'll see, the feature is easy to use – until you want to copy or format just the total rows.
Technology

Apple Has Been Accused of Large-Scale Tax Avoidance

Apple CEO Tim Cook appeared before the Senate Permanent Subcommittee on Investigations to defend his company's tax practices, including a 2 percent corporation tax rate deal it struck with the Irish government on two of its subsidiaries.
Technology

Social Media: Ten Things Accountants Should Never Do

If you're an accountant who has been experimenting with social media, this article is for you. It will be of particular interest if you've been disappointed by your social media experiences. And you're not alone if you started out with unrealistic expectations or misunderstood how social media works.
Technology

Farewell, Lotus 1-2-3

IBM recently announced that Lotus 1-2-3 will no longer be available for purchase. Most readers of this article will likely have one of two reactions: "What is Lotus 1-2-3?" or "Lotus 1-2-3 was still on the market?"
Technology

Are Mobile Devices Causing a Digital Divide in the Workplace?

Each day when Bill Walter hops on the elevator in the building that houses his CPA firm, a majority of the people riding with him have their smartphones in hand – checking e-mails or surfing the Internet – before arriving at their particular floors.
Technology

Excel Tip: Determining the Remaining Length of a Loan Using NPER

Learn how to use the NPER function in Excel to determine just how long it will take you to payoff that credit card bill on which you’re making monthly payments..
Technology

AICPA/CPA Canada Survey: Managing Data Tops List of 2013 Tech Initiatives

According to the 2013 North American Top Technology Initiatives Survey conducted by AICPA and CPA Canada, managing and retaining data topped the list of ten technology initiatives for accounting firms in the United States and Canada.
Technology

The End Is Near for Windows XP

Despite three subsequent Windows releases, Windows XP remains the second most popular operating system version. Regardless, the 38 percent of computer users currently relying on Windows XP will soon need to move to a modern operating system, or risk exposure to malware.
Technology

LinkedIn Tips Part 5: Groups

The groups likely to be most valuable to start-up practices will be those groups your client prospects belong to. You can find these by looking at the profiles of prospective clients on LinkedIn and scrolling down to see their groups.
Technology

Keynote Speakers Announced for Boomer Technology Circles and Talent Development Advantage

Rebecca Ryan, Founder, Next Generation Consulting, Inc., and Rick Richardson, managing partner of Richardson Media & Technologies LLC, will be the keynote speakers at the 2013 Boomer Technology Circles Summit and Talent Development Advantage August 19-20, 2013.
Technology

Announcing CCH Axcess: New Modular Tax, Compliance, and Management Tool

CCH has announced the launch of CCH Axcess – a Cloud-based modular tax preparation, compliance, and firm management solution built from the ground up, offering the accounting profession a powerful solution for complete firm management.
Technology

Resetting the Last Cell in an Excel Worksheet

It's frustrating when Excel acts as if the active area of a worksheet is significantly larger than the actual area where you have data. Suddenly your scroll bars move you into uncharted areas, such as column TX or row 5,000.

Pages