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

How the election may affect taxation of business income

This report summarizes recent proposals to reform the U.S. business income tax system and considers the path to enactment of any such legislation.

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

Did you follow 2016’s biggest accounting news?

CPAs will remember 2016 as a year of new standards and new faces. How well did you follow the biggest accounting events? The 7 questions in this quiz will help you find out