Skill Development Tools

Resources

SKILL DEVELOPMENT TOOLS

It takes more than strong technical skills in a specific discipline to succeed in today’s business environment. Professionals need to be well-rounded with strong communication skills.

Many of the tools in this section were developed by KPMG Business School for use by our professionals. These materials include quick Excel tutorials, practice exercises, and performance support resources that can be incorporated into your classes or can be used by students independently.

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.

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.

Flowcharting: A tool for understanding business processes

Dr. Margarita Lenk, Ph.D., Colorado State University
2016

In this module students learn the value and mechanics of flowcharting. A practice exercise is included providing students... Read More >
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.

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.

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.

Writing Effective E-mails

KPMG
2014

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