Excel for Bookkeeping

MGMT 828.52

This seminar provides an overview of the design and use of Excel spreadsheets that can be tailored to keep track of primary bookkeeping tasks.

READ MORE ABOUT THIS COURSE

What you can learn.

  • Review key functionalities, including recording cash receipts and disbursements, monthly bank reconciliations, and creating templates for financial statements
  • Learn to build templates and reports for accounts payable, receivable, investments, property, inventory, and salaries
  • Understand the use of macros and formulas to take your bookkeeping to the next level

About this course:

This seminar provides an overview of the design and use of Excel spreadsheets that can be tailored to keep track of primary bookkeeping tasks. The seminar reviews key functionalities, including recording cash receipts and disbursements; monthly bank reconciliations; and creating templates for financial statements, such as balance sheets, profit and loss statements, and statement of cash flow. The seminar also covers building templates for accounts payable, receivable, investments, property, inventory, and salaries. The course finishes with an overview of macros and formulas that can take your bookkeeping to the next level, as well as report building, Excel charts, and preparing documents for stakeholders and other reviewers.
Suggested Prerequisites

It is advisable that you complete the following (or equivalent) since they are prerequisites for Excel for Bookkeeping.

Primary knowledge and experience using Excel.

Contact Us

Our team members are here to help. Hours: Mon-Fri, 8am-5pm.
Keep up to date on the latest news and offerings in Accounting & Bookkeeping

vector icon of building

Corporate Education

Learn how we can help your organization meet its professional development goals and corporate training needs.

Learn More

vector icon of building

Donate to UCLA Extension

Support our many efforts to reach communities in need.

Innovation Programs

Student Scholarships

Coding Boot Camp

Lifelong Learning