Imagine this situation. Building contractor Jones has asked CPA Smith to review payables and receivables. “I want to be sure that our vendors have billed us as agreed,” says Jones. Smith wants to send a staff person to Jones office to compile the information into an Excel worksheet for further analysis and reporting.
How can Smith design a spreadsheet for data entry and analysis that
helps speed data entry, is easily modified, and is responsive to changing assumptions?
provides instructions to guide the data entry process?
is also suitable for presentation to the client?
What’s more, since Smith won’t be doing the data entry himself, how can he include automation to give feedback during the data entry process and provide validity checks to prevent “garbage-in garbage out” problems?
Or consider this problem. A frantic client calls Ray Knight, CPA and owner of Knight Consulting. “My accounting software won’t work, the software vendor is out of business, and the data isn’t compatible with any other available software. Help!”
Ray helps the client set up another accounting software package for current year operations, but the client still needs access to information from prior years. Ray received a data dump from a recovery specialist and is considering the next steps. What issues should Ray consider when integrating data for use in Excel? How can he modify the dataset? How can he design a spreadsheet that will provide interactivity with the client for ad hoc analysis and reporting? You can find out the answers to these and more questions in the May 12 webcast Using Excel with External Data.
Can’t make the May date? No worries. Both webcasts will be presented again in July by L. Keith Jordan, CPA. In addition to 30 years experience in accounting, supervision, and management, Jordan is an expert in IT and business applications.
Why not make a day of advancing your Excel skills?