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.

RESOURCES

Keeping you informed and prepared amid the coronavirus outbreak

We’re gathering the latest news stories along with relevant columns, tips, podcasts, and videos on this page, along with curated items from our archives to help with uncertainty and disruption.

VIDEO

Excel walk-through: Sparklines

Want to liven up your spreadsheets with some color and graphical elements? Kelly L. Williams, CPA, Ph.D., shows how to use Excel sparklines, which illustrate data trends and patterns via small charts that fit in a single Excel cell.