LF logo
by learnformula
search
Log in
search
Courses/Office Productivity/MS Excel

Excel University Lesson 101: Foundations for Accounting Professionals

Automate recurring tasks and master the essential Excel features to reclaim your time.

Created byJeff Lenning
BeginnerUpdated Sep 22, 2026
Excel University Lesson 101: Foundations for Accounting Professionals

What You'll Learn

check_circleApply keyboard shortcuts to increase personal productivity in Excel
check_circleImplement named references to improve formula clarity and maintenance
check_circleConvert data ranges into tables to enable automatic expansion and structured referencing
check_circleConfigure data validation to restrict user input and ensure data consistency
check_circleAutomate recurring manual tasks using Excel features and functions

About This Course

This course provides a comprehensive foundation in Excel techniques specifically designed for accounting and finance professionals. It focuses on automating recurring data-driven tasks to improve efficiency and reduce manual workload. The curriculum covers essential keyboard shortcuts, named references, table management, and data validation to ensure data integrity and streamline workbook maintenance. By implementing these features, users can transform Excel from a basic calculator into a robust platform for reliable, automated reporting.

Topics Covered:

  • Keyboard shortcut mastery for navigation
  • Absolute and relative cell reference management
  • Named ranges and formula readability
  • Table object conversion and auto-expansion
  • Structured table references for formulas
  • Data validation for input control
  • In-cell dropdown list creation
  • Recurring process automation strategies

Your Instructor

Jeff Lenning
Jeff Lenning

CPA and Microsoft Certified Trainer

menu_book14 courses
star1,160 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

Professional development requirements vary by profession, country, and regulatory body. Before enrolling, review the course details and confirm that the content, learning format, and any listed credits meet your specific requirements. You are responsible for confirming eligibility with your regulator or professional association and keeping the records required for reporting.

What Students Are Saying

0.0
Student's Choice
0 reviews

Frequently Asked Questions

We are a registered provider with 327+ associations and regulatory bodies worldwide. We operate across 29 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

Office Productivity: Other Office Productivity

AI Tools for Administrative Efficiency

star5.0(4)
1 CPD hr
Accounting & Tax: Technology for Accountants

Claude Fundamentals for Accountants (2026 Update)

star5.0(383)
2.5 CPD hrs
Accounting & Tax: Accounting

CPAs as AI System Evaluators

star5.0(3)
3 CPD hrs