Skip to main content
by learnformula
Explore courses
search
For Business
Team license & compliance management
For Higher Education
Academic partnerships
For Government Agencies
Government training solutions
For Instructors & Course Creators
Teach on our marketplace
Become a Sponsor
Reach professionals where they learn
Log inStart 7-Day Free TrialStart Free TrialStart Free Trial
search
Explore courses
  1. Courses
  2. /Office Productivity
  3. /MS Excel

Excel University Lesson 401: Mastering Internal Workpapers

Build bulletproof, automated workpapers to maximize your daily productivity.

Created byJeff Lenningworkspace_premiumBest Instructor
IntermediateUpdated Sep 28, 2026

What You'll Learn

  • check_circleApply advanced filtering and sorting to manage large datasets efficiently
  • check_circleImplement custom formatting to improve report readability without manual column insertion
  • check_circleUtilize outline groups and subtotal functions to create interactive, structured reports
  • check_circleConfigure multi-level workbook protection to secure sensitive data and formulas
  • check_circleDevelop a digital workpaper index using hyperlinks for improved file organization

About This Course

This course focuses on the development of reliable, internal-use Excel workpapers designed to streamline accounting and finance tasks. It covers a range of features, functions, and techniques including sorting, filtering, outlining, custom formatting, and workbook protection. Participants learn to transition from manual, error-prone processes to automated, efficient workflows for tasks such as journal entry preparation and budget analysis. The curriculum emphasizes the importance of building workbooks that are maintainable, scalable, and designed to minimize manual intervention.

Topics Covered:

  • Excel internal workpaper design principles
  • Advanced sorting and filtering techniques
  • Data outlining and subtotaling methods
  • Custom cell formatting and accounting styles
  • Workbook and worksheet protection levels
  • Hyperlink organization for digital files
  • Print layout and page setup configuration
  • Keyboard shortcuts for productivity

Course Content

3 activities • 17 videos • duration: 2h 46m

  • videocamSenior Orientation
    Duration 3:17
  • videocamC1 Overview
    Duration 2:37
  • videocamC2 Selected Shortcuts
    Duration 6:43
  • videocamC3 Sorting & Filtering
    Duration 15:10
  • videocamC4 Outlining
    Duration 11:28
  • videocamC5 Formatting
    Duration 27:52
  • videocamC6 Printing
    Duration 12:42
  • videocamC7 Protecting
    Duration 11:23
  • videocamC8 Hyperlink Feature
    Duration 13:21
  • quizSenior Year Orientation Quiz

Your Instructor

Jeff Lenning

CPA and Microsoft Certified Trainer

menu_book36 courses
star1,189 reviews

In his live CPE training sessions, Jeff Lenning CPA has shown thousands of CPAs and accounting professionals across the country how to use Excel to streamline their work and become more efficient. Several publications have featured his Excel articles, including the Journal of Accountancy and California CPA Magazine. After graduating from the University of Southern California, Jeff began his career in the audit practice at Arthur Andersen’s Orange County office. He was a senior financial analyst at Gateway computers and the accounting manager at Interpore Cross International. In 2000, he founded Click Consulting Inc., a technology-consulting firm that specializes in Excel training, consulting, development, and personal coaching. He is a past president of the CalCPA OCLB Chapter, the former chair of the California CPA State Technology Committee, co-chair of the California CPA OCLB Chapter Technology Committee, a board member of the California CPA OCLB Chapter, on the California Society of CPAs Council, and an instructor for the AICPA and the California CPA Education Foundation. A Microsoft Office Certified Excel Expert, he is a nationally recognized speaker and trainer. He was recently recognized with the California CPA Education Foundation's Award for Instructor Excellence.

Credit Information

What Students Are Saying

5.0 out of 5
Student's Choice
4 reviews

Frequently Asked Questions

We are a registered provider with 300+ associations and regulatory bodies worldwide. We operate across 27 global markets including Canada, the US, Australia, and the UK. Every course page clearly displays its specific accreditations. Upon completion, you receive a professional certificate that can be validated online. Our certificates include all necessary accreditation details, credit hours, and completion dates, and are formatted specifically to meet the submission requirements of most global regulatory bodies.

You May Also Like

  • Ethics: Business Ethics

    2026 Ethics and Corporate Compliance

    starRated5.0out of 5,(581 reviews)
    2 CPD hrs
  • Accounting & Tax: Technology for Accountants

    Claude Fundamentals for Accountants (2026 Update)

    starRated5.0out of 5,(662 reviews)
    2.5 CPD hrs
  • Project Management: Productivity

    Microsoft Copilot for Finance and Accounting

    starRated4.9out of 5,(41 reviews)
    1.5 CPD hrs