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.

Get the Word Out

By Jeff Lenning | January 28, 2014 | Comments Off on Get the Word Out

Get the Word Out How do you distribute financial reports to clients, shareholders and key people in your organization? If you’re low-tech, you probably mail them. If you’ve been following my suggestions of several years ago, you create hyperlinks in Excel files and e-mail the files so clients can drill down into them for details…

Read More

Email Defense: Stop Spam and Viruses

By Jeff Lenning | January 28, 2014 | Comments Off on Email Defense: Stop Spam and Viruses

Overview Protecting employees from “bad” email is becoming more and more difficult. Yet, it remains the responsibility of the employer. Although laws have been introduced recently to control spam (unsolicited commercial email), it seems as if the spammers are unaware of them and thus continue operating at full force. There are many problems with spam,…

Read More

Wireless Networks

By Jeff Lenning | January 28, 2014 | Comments Off on Wireless Networks

Summary Wireless networks are popular due to their relative convenience and low cost of implementation. However, in an effort by manufacturers to make their wireless devices easy to setup, most wireless routers are shipped with security disabled. Since many assume that if the wireless is working, then it is working properly (securely), few ever go…

Read More

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

Accountants 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

In 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