Articles

Automate Shortcuts

Publication:

Journal of Accountancy

Date:

July 2001

Author:

Jeff Lenning

ccountants spend hours working at computers, and usually much of that time they’re doing repetitive tasks—such as opening the same group of spreadsheets or creating the same header or formatting for each new workbook and document. Wouldn’t it make sense to invest a little time to create programs that perform these repetitive jobs with just […]


Drilling for Information

Publication:

Journal of Accountancy

Date:

August 2000

Author:

Jeff Lenning

 n the late 1980s, most accountants put aside their columnar pads and calculators and advanced to computers. In some respects, that was a big step, but in reality, very little actually changed: The financial reports were simply transferred from paper to the computer screen. Although the efficiency of report generation was improved, the reports were […]


Financial Reports in a Snap

Publication:

Journal of Accountancy

Date:

April 2000

Author:

Jeff Lenning

IF YOU WANT TO distribute financial reports throughout your organization electronically rather than on paper, give the reports a drill-down capability and not have to use e-mail technology, there’s a simple way that uses only your existing hardware and software. THE PROCESS APPLIES the hyperlink function of Microsoft Excel. It’s relatively easy to set up […]