Webinar: Excel PivotTables for Accountants - Part I

WK266  |  Partner Virtual Events  |  Intermediate  |  Scheduled

Description

PivotTables are the most powerful feature of Excel, yet few accountants use them in their day-to-day activities. For some, PivotTables are too intimidating; for others, PivotTables are a foreign concept. With a little information, guidance, and demonstration from the instructor, you will be ready to begin using PivotTables to accomplish routine analysis and reporting. This webinar will begin with basic PivotTables and progress to advanced PivotTable topics.

Credits

Number of Credits Type of Credits
2 Accounting and Auditing
2 Other

Prerequisites

Fundamental knowledge of Microsoft Excel

Highlights

Drag-and-drop pivoting, group and ungrouping, and drilling down to underlying details Creating PivotTables from multiple ranges Linking PivotTables to external database and financial accounting systems

Objectives

Upon completing this course, you should be able to:

  • Identify and define the six main elements of a PivotTable report
  • Create PivotTables that summarize large volumes of data
  • Describe how to import the data from an accounting system and prepare the data to be used in the PivotTable
  • Create PivotTables from Multiple Consolidation Ranges

Preparation

None

Notes

This webinar is provided by K2 Enterprises. After registering for the course, you will receive an email from K2 with instructions for logging in to the webinar and obtaining your eMaterials.

Prices

Member (Early Bird)
$129.00
Non-Member (Early Bird)
$129.00
Member
$129.00
Non-Member
$129.00
Your Price: $129.00

This is your base price and does not reflect any additional session fees, optional add-ons, or guest registrations. Early Bird rates will be applied to all registrations made prior to December 19, 2017.

Facilitators

Lawrence McClelland, MBA, JD

Mac McClelland, an attorney and accounting professional, is an associate of K2 Enterprises of Hammond, Louisiana, and Network Management Group of Hutchinson, Kansas.

Mac was formerly the director of the Centre for Financial Studies at the University of Otago in Dunedin, New Zealand, where he lived and worked for seven years from 1990 to 1997. He was also a member of the faculty of the Advanced Business Programme, ranked in the top 100 MBA programs in the world by The Economist, specializing in business strategy and strategic management accounting.

He gained his practical experience in information systems with the National Aeronautics and Space Administration, and has an established practice in business and technology consulting. Mac has taught hundreds of continuing professional education seminars to accountants and business managers in the United States, New Zealand, Australia, Japan, and Southeast Asia. His presentations are highly rated, and he has won several awards for teaching excellence.

Mac has been published in leading business and practitioner journals, including Tax Ideas, Computers in Accounting, Journal of Accounting Education, Chartered Accountants Journal of New Zealand, and the top-rated Journal of Accounting Research.

Back to Facilitators