Publications

Author and award winning instructor Jeff Lenning CPA has written several books and 40+ articles featured in various publications. We've compiled them all in a single place for easy reference.

Secure Email

By Jeff Lenning | January 28, 2014 | Comments Off on Secure Email

Summary Corresponding through Email has become an integral part of daily business life. For many email messages, the content is not confidential, and security is not an issue. However, there are certain email messages that do contain confidential information and securing those communications is essential, especially given client/attorney privilege. Fortunately, there are a variety of…

Read More

Automate Excel Functions

By Jeff Lenning | January 28, 2014 | Comments Off on Automate Excel Functions

Easy-to-create macros can take over many manual processes.   Key to Instructions To help readers follow the instructions in this article, we use two different typefaces: Boldface type is used to identify the names of icons, agendas and URLs. Sans serif type indicates commands and instructions that users should type into the computer and the…

Read More

Bulletproof Backups

By Jeff Lenning | January 28, 2014 | Comments Off on Bulletproof Backups

SUMMARY Bulletproof backups are possible. Backing up your computer data is important, and you know that. This article strives to inspire you to action by showing you how easy and reliable backups really can be.   INSPIRATIONAL STORY There are only 3 rules of computing: (1) backup (2) backup and (3) backup. However, based on…

Read More

Remote Access

By Jeff Lenning | January 28, 2014 | Comments Off on Remote Access

Overview Like most professionals, your personal life and your professional life are blurred. When you are at home, you probably think about work and often try to get a few things done. However, working from home is inconvenient because of the crude methods used to transfer computer files from the office computer to your home…

Read More

Network Security

By Jeff Lenning | January 28, 2014 | Comments Off on Network Security

Overview A secure computer network is of paramount importance in today’s technology climate. Securing your network does not need to be expensive or confusing. Protecting the confidential data that exists on your network is critical for business success. The compromise of confidential client information could result in litigation. In addition, significant business interruptions can occur…

Read More

Automate Shortcuts

By Jeff Lenning | January 28, 2014 | Comments Off on Automate Shortcuts

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…

Read More

Drilling for Information

By Jeff Lenning | January 28, 2014 | Comments Off on Drilling for Information

 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…

Read More

Financial Reports in a Snap

By Jeff Lenning | January 28, 2014 | Comments Off on Financial Reports in a Snap

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…

Read More