Q: I purchased an Epson EX7220 projector for our training room, and for convenience I set the projector up on the countertop alongside the classroom (as pictured below). I hoped to use the built-in keystone tools to adjust the screen to the proper rectangular display. Unfortunately, the keystone slide
Information management and technology assurance
Excel: The power of mapping
CPAs often have to produce recurring reports, such as quarterly balance sheets, from datasets, such as trial balances. The process can be tedious and prone to error, but an Excel technique called mapping can show the way to better results. Learn more in this Technology Workshop.
Embracing the automated audit
Technology is changing the way audits are being performed, with greater access to data but also more data to sort through. Auditors can remain efficient and effective by employing applications designed to help automate some procedures.
Data security risk: You can take it anywhere
While no security program or security software can guarantee that data will never be lost or stolen, application of a few basic principles can help address mobile security risks and mitigate professional liability exposure.
Harnessing the power of the cloud
Cloud computing and increasingly powerful mobile devices are breaking down communication, data access, and market barriers for CPAs, but the breakthroughs also open the door to potential trouble. A panel of technology experts offers advice on how CPAs can make the most of technology while minimizing the risks.
The price is right
Q: My Excel workbook calculates the cost of hundreds of manufactured inventory items. We want to create an Excel formula that will automatically set the sales price at three times cost, with the sales price ending in 99 cents. Further, these manufactured items are packaged nine to a box, and
LinkedIn job-hunting tips
Q: I am searching for a job, and several friends have recommended that I use LinkedIn to help with this endeavor. Based on their advice, I’ve updated my profile and searched LinkedIn’s job postings, but is there more that I could be doing with LinkedIn? A: Searching LinkedIn’s job postings
Boot-proof your email
Q: I open email messages as they arrive to determine how important they are, and if they are less important, I simply leave them open and respond to them later. However, my computer sometimes reboots automatically after installing updates, thereby closing all of my open email messages. When this happens,
Kick-start your computer
Q: My computer takes almost four minutes to start up. How can I make it start faster? A: You can take several measures to make your computer start faster. My first tip would be to buy a new Windows 8 computer with a solid-state drive (SSD). I have two such
Five apps for CPAs
For all but the most tech-averse souls, smartphones and tablets have become an integral part of CPAs’ daily lives. This development can be attributed in large part to the quality of the applications available for mobile devices. Here are five apps that will help CPAs take their mobile productivity to
Restore time
Q: Help, I removed the clock and date display from my Windows 8 System Tray, but I can’t figure out how to get it back. A: It is easier to remove the Clock and Date applet than to restore it because you can right-click on the app to hide it,
Six cybersecurity basics
The steady barrage of headlines about cybersecurity underscores a topic viewed with wary eyes by many executives, board members, and investors. Employees may have access to sensitive data through smartphones that they carry everywhere. Globalization has increased the geographic reach of companies – making them visible to ever more hackers.
Auditors have important role in cybersecurity
The steady stream of headlines about data breaches has the business community and regulators on high alert with regard to cybersecurity. An online PwC survey of global executives and IT directors conducted early in 2013 found that detected cybersecurity incidents rose 25% over the previous year. And 31% of executives
Internal auditors racing to keep pace with technology
Internal auditors have a strong desire to know more about emerging technologies and improve the way they use technology to perform their duties, a new survey shows. Mobile applications and social media are among the top areas of technical knowledge that internal auditors most need to improve, according to a
Use data privacy to gain a competitive advantage
Data privacy doesn’t have to be an issue that keeps executives awake at night. Instead, companies that approach data privacy the right way can use it to differentiate themselves, said Carolyn Holcomb, CPA, the leader of PwC’s data protection and privacy practice in the United States. “We see companies that
Anonymous recipient
Q: Is it possible to receive email anonymously? I don’t intend to do anything illegal, but occasionally I’d like to use an anonymous email address to sign up for reading websites or for temporary communication purposes. A: A website called Mailinator (mailinator.com) lets you create any email address and check
10 tips for implementing shared services
Shared services are being applied to an increasing number of functions. Human resources, IT, and finance were some of the first areas where shared services commonly were implemented. Now sales operations, supply chain operations, and marketing are taking advantage of shared-services platforms.
In bed with YouTube
Q: I recently produced several professional videos promoting our company’s services, and I’ve uploaded them on our webpage. Unfortunately, our website is hosted by one of those inexpensive web-hosting companies with a bare minimum of performance and internet bandwidth; therefore, our new videos take forever to load, and once they
A better letter
Q: Can you point me toward a good website that provides default business letters and contract wording so I don’t have to prepare all of my business letters and contracts from scratch? A: Instead of referring you to a website, I will instead direct you to Word 2013’s templates, which
Bugged by Excel’s calculation errors
Q: I found an anomaly with a rather simple Excel computation; specifically, Excel calculates 111,111,111 times 111,111,111 to equal 12,345,678,987,654,300, which is incorrect (the correct answer should end in “21,” not “00”). If Excel’s arithmetic fails, then what else is false, and why does this happen? (Author’s note: You
Features
SPONSORED REPORT
Get your clients ready for tax season
Help clients avoid surprises with year-end planning strategies for managing taxable income, maximizing deductions, and adjusting to OBBBA changes affecting individuals and businesses.
