Readers Find Technology Workshops Helpful

BY SCOTT WALLACE

I just have to applaud you on the Technology Workshop series in the JofA . For three months in a row, the topics have been timely (for example, the Excel Pivot Table/Access tie-in, Auto Filter, Conditional Formatting).

Could I suggest covering macros, buttons and visual basic for automating purposes?

Scott Wallace, Accounting Instructor
Blue Mountain Community College
Pendleton, Oregon

I’ve been a member of the AICPA for longer than I’d like to think, so I’ve received a lot of issues of the JofA .

The “Spreadsheet Smarts” article ( JofA , Jan.00, page 53) was one of the easiest to follow, most practical and beneficial I’ve read throughout the years. I came to work this morning, went through each of the three spreadsheet functions covered and was amazed at the results. Unfortunately, it’s true that most of us barely scratch the surface when it comes to using the many built-in tools in Microsoft Office products.

This article will be passed around to everyone in my company’s finance department to provide them with the opportunity to improve the functionality and efficiency of their many spreadsheets.

Thanks!

Gail Millward, CPA
Reno, Nevada

I appreciate the variety of articles in the JofA , particularly “Spreadsheet Smarts.” I find such articles very useful in training others as well as myself.

Spreadsheets have many labor- and time-saving functions of which many professionals are not aware. I would greatly appreciate it if, in the near future, you could include an article focusing on developing and maintaining graphs and shortcuts related to this.

Roger G. Bobo, CPA
Murfreesboro, Tennessee

Letters to the Editor

The opinions and views expressed are those of the letter writers and do not necessarily reflect those of the AICPA.

The JofA encourages readers to write letters on important professional issues in addition to comments on published articles. Because space is limited, letters submitted for publication should be no longer than 500 words. Please include telephone and fax numbers.

SPONSORED REPORT

Revenue recognition: A complex effort

Implementing the new standard requires careful judgment. Learn how to make significant accounting judgments and document them and collaborate with peers for consistent application.

VIDEO

How to Excel pivot a general ledger

The general ledger is a vast historical data archive of your company's financial activities, including revenue, expenses, adjustments, and account balances. J. Carlton Collins, CPA, shows how to prepare data for, and mine data with, PivotTables.

QUIZ

News quiz: Taking an economic snapshot and looking to the future

Recent news included IRS actions that affect individuals and partnerships and a possibly influential move by a Big Four accounting firm.Take this short quiz to see how much you know about the news.