Resources

Resources

Connecting the classroom to the profession

Our goal is to leverage our resources to provide real-world examples that bring these topics to life for your students. Modules are designed to be flexible so you can easily adapt them to the skill level of your students. Save material in your Briefcase to refer to later or download directly to your computer.

KPMG is pleased to offer all educators access to course materials that have been developed for classroom use. These materials can be downloaded and duplicated for non-commercial, university educational purposes only. Using these materials for any other purpose, including but not limited to consulting practices, is strictly prohibited. KPMG recognizes and supports the doctrine of "fair use" as set forth in Section 107 of the U.S. copyright law when materials accessed through the KPMG University Connection are reproduced for educational purposes.

Accounting Basics Videos: Bonds

Gia Chevis, Ph.D., Baylor University
2016

This is one of four videos in the Accounting Basics Video Series. This five-minute animated video clearly explains how... Read More >
Login or register to fully view this resource.

Accounting Basics Videos: Net Present Value

Gia Chevis, Ph.D., Baylor University
2016

This is one of four videos in the Accounting Basics Video Series. This five-minute animated video clearly explains the... Read More >
Login or register to fully view this resource.

Accounting Basics Videos: Revenue Recognition Video

Gia Chevis, Ph.D., Baylor University
2016

This is one of four videos in the Accounting Basics Video Series. This six-minute animated video clearly explains how to... Read More >
Login or register to fully view this resource.

Accounting Basics Videos: Statement of Cash Flows

Gia Chevis, Ph.D., Baylor University
2016

This is one of four videos in the Accounting Basics Video Series. This six-minute animated video clearly explains the... Read More >
Login or register to fully view this resource.

Accounts Receivable Aging Report

KPMG
2013

This exercise provides students with step-by-step instructions to create an Accounts Receivable (A/R) Aging Report using... Read More >
Login or register to fully view this resource.

Audit Documentation

KPMG
2014

This checklist serves as a guide when reviewing audit documentation. Faculty and students may use this resource as an... Read More >
Login or register to fully view this resource.

Client Interviewing Skills

KPMG
2014

Strong communications skills are important in any career. This communication framework outlines how to structure a message... Read More >
Login or register to fully view this resource.

Excel Technical Videos for Students

KPMG
2014

KPMG has created a series of short, practical video modules demonstrating key tips for using Excel effectively. Choose from... Read More >
Login or register to fully view this resource.

Excel™ Auto Filters

KPMG
2014

Auto Filter is an easy way to find the data you need faster. Watch this short, practical video to improve your knowledge of... Read More >
Login or register to fully view this resource.

Excel™ Conditional Formatting

KPMG
2014

Conditional formatting enables you to highlight specific cells within a specified range.
Login or register to fully view this resource.

Excel™ LOOKUP Functions

KPMG
2014

Learn how to use this very easy Excel tool to return a value either from a range or array. Functions covered: VLOOKUP,... Read More >
Login or register to fully view this resource.

Excel™ Paste Special Function

KPMG
2014

Watch this video to learn how to specify formatting when you paste slides, pictures, objects, and text.
Login or register to fully view this resource.

Excel™ Pivot Tables

KPMG
2014

Learn how to summarize, analyze, explore, and present tables using this useful tool.
Login or register to fully view this resource.

Excel™ Table Formatting

KPMG
2014

This quick video will teach you how to use predefined table styles to easily format a table.
Login or register to fully view this resource.

Excel™ TEXT Functions

KPMG
2014

TEXT functions enable a user to quickly format data. This video provides quick tips on how to use several standard TEXT... Read More >
Login or register to fully view this resource.

Excel™ Text to Columns

KPMG
2014

Learn how to quickly split text into multiple columns by watching this video.
Login or register to fully view this resource.

Excel™Subtotals

KPMG
2014

This video will show you how to quickly subtotal multiple categories in a single sheet, as well as provide a grand total.
Login or register to fully view this resource.

Grade Point Average Calculator

KPMG
2013

Learn how to construct a GPA calculator using VLOOKUP, HLOOKUP, and SUMIF formulas. This exercise includes a step by step... Read More >
Login or register to fully view this resource.

How to Check Financial Statements

KPMG
2015

This lecture and in-class activity teach students why it is important to check financial statements carefully as part of an... Read More >
Login or register to fully view this resource.

KPMG Ace the Case Study Guide

KPMG
2014

This guide provides students with a basic approach to analyze a case study in 8 easy steps. It also provides basic tips on... Read More >
Login or register to fully view this resource.

KPMG Microsoft™ Excel Formula Guide

KPMG
2016

This extensive Excel guide is a terrific resource for students interested in sharpening their Excel skills. This guide... Read More >
Login or register to fully view this resource.

Make the Connection: Crafting Engaging and Effective Tax Communications

Dr. Tracy Noga, Bentley University
2015

This series of five video modules introduces students to various forms of written communication used in the tax profession. ... Read More >
Login or register to fully view this resource.

Module 1: Introduction to Effective Communication

Dr. Tracy Noga, Bentley University
2015

This short, entertaining video gives students quick tips to ensure they are communicating their intended message.
Login or register to fully view this resource.

Module 2: General Writing Tips

Dr. Tracy Noga, Bentley University
2015

Helpful writing "rules of thumb" delivered by a Director of Corporate Communications for the KPMG Business... Read More >
Login or register to fully view this resource.

Module 3: How to Write a Tax Research Memo

Dr. Tracy Noga, Bentley University
2015

This video provides an introduction to the purpose and format of a tax research memo.
Login or register to fully view this resource.

Module 4: Crafting a Client Letter

Dr. Tracy Noga, Bentley University
2015

Learn the differences between a research memo and a client letter, as well as the specifics of how to craft an effective... Read More >
Login or register to fully view this resource.

Module 5: Workpapers, eMail, and Instant Messenger

Dr. Tracy Noga, Bentley University
2015

Strong written communication skills are important in building a professional brand. This video covers how to write... Read More >
Login or register to fully view this resource.

Summary of the KPMG Professional Judgment Framework

Steve Glover, Ph.D., Doug Prawitt, Ph.D.
2013

Adapted from the KPMG Elevating Professional Judgment in Auditing and Accounting monograph, this summary provides a short... Read More >
Login or register to fully view this resource.

Tax Video: Double Sided Journal Entry

KPMG
2017-12-18

This video walks through a few basic examples of common book-to-tax adjustments, including permanent and temporary... Read More >
Login or register to fully view this resource.

Tax Video: Overview of Unrelated Business Taxable Income (UBTI)

KPMG
2017-12-18

This video provides a quick explanation of unrelated business taxable income (UBTI) for some exempt organizations and a... Read More >
Login or register to fully view this resource.

Tax Video: Passthrough Entity Overview

KPMG
2017-12-18

This video defines a Passthrough entity and explains why it is a popular business structure.
Login or register to fully view this resource.

Tips for Effective Business Writing

KPMG
2014

Sharpen your business writing skills by learning tips for using plain language, active vs. passive voice, and ensuring your... Read More >
Login or register to fully view this resource.

What is an Audit? A guide to the auditing process and why it is important

KPMG
2016

This document gives a high-level overview of what an audit is and the kind of work that is performed during an audit. This... Read More >
Login or register to fully view this resource.

Writing Effective E-mails

KPMG
2014

Quick tips to ensure your e-mail communications are effective.
Login or register to fully view this resource.