My Profile   |   Contact Us   |   Your Cart   |   Sign In
Excel PivotTables for Accountants - (EPT14)
Tell a Friend About This EventTell a Friend
 

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 use PivotTables to accomplish data analysis and reporting. This seminar begins with basic PivotTables and progresses throughout the day to advanced PivotTable topics.

12/1/2014
When: 12/1/2014
8:30 AM until 4:30 PM
Where: LCPA Training Center
2400 Veterans Memorial Blvd
Ste 500
Kenner, Louisiana  70062
Presenter: Mac McClelland


Online registration is closed.
« Go to Upcoming Event List  

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 use PivotTables to accomplish data analysis and reporting. This seminar begins with basic PivotTables and progresses throughout the day to advanced PivotTable topics. 

 

Specific topics covered in this session include how to build basic PivotTables, grouping and ungrouping data, creating calculated items and fields, and drilling down to underlying details. You will also learn how to build PivotTables consolidated from multiple data ranges and PivotTables dynamically linked to external databases and financial accounting systems in this seminar. Additionally, you will learn how to take advantage of advanced features available in PivotTables, including Slicers and PowerPivot.  

 

Course participants have access to all sample data files used in this course, along with supplementary video segments designed to reinforce key learning objectives. 

 

Designed for: Accounting and financial professionals who want to use the power of Excel PivotTables to analyze and summarize data

 

Objectives:

  • Identify and define the six main elements of a PivotTable report and describe how they are used when creating basic PivotTables; describe How to Group and Ungroup Data in PivotTables, How to Use Field Settings to Alter the Data Displayed, How to Sort and Filter Data in a PivotTable, and How to Update the PivotTable for Changes in the Underlying Data
  • Describe how to import PivotTable data from an accounting system and prepare the data to be used in the PivotTable; additionally, describe how to use Tables and Named Dynamic Ranges as sources for PivotTables
  • Define Consolidation PivotTables, describe how to construct Consolidation PivotTables, and identify the advantages of using Consolidation PivotTables in lieu of other consolidation techniques
  • Describe how to make calculations in PivotTables using techniques such as Calculated Items, Field Settings, Calculated Fields, Modifying Show Data As options, and New Percentage Options in Excel 2010 and 2013
  • Describe how to create PivotTables in enterprise-class organizations using PowerPivot and Slicers
  • Explain how to analyze data in PivotTables using tools and techniques such as Sorting, Filtering, Extracting Data with GETPIVOTDATA, and working with PivotCharts
  • Describe how to apply specific PivotTable techniques to solve problems in areas of PivotTable Formatting, Reporting Report Filters as Separate Reports, Removing Ghost Items, Grouping Data into Fiscal Quarters and Fiscal Years, and Keeping PivotTable Row Order Intact

 

Highlights:

  • Introducing PivotTables
  • Formatting PivotTables
  • Preparing your data for PivotTables
  • Creating calculations in PivotTables
  • Consolidating data with PivotTables
  • Analyzing data with PivotTables
  • Building enterprise-class PivotTables

 

Requisite Knowledge: Fundamental understanding of Excel

 

Speaker: Mac McClelland

Vendor: K2 Enterprises

Field of Study: Management

Level: Advanced

CPE Credits: 8

 

Note: Instructional delivery method: Group-live demo and discussion using color computer projection – NOT a hands-on course

 

Testimonials:

 

“I learned a lot that will assist me in my job.”

--T.D., CPA WA 

 

“Excellent class and very valuable information!”

--S.B., CPA MN

 

Registration Fees:

 

 

Members

CPA Non-Members

Early Bird (through 11/12)

$179

$279

Standard (after 11/12)

$229

$329

 

Community Search
Sign In


Forgot your password?

Not a member? Join now!

News & Tax Alerts
CPE/Events

Society of Louisiana
Certified Public Accountants

2400 Veterans Memorial Blvd., Suite 500
Kenner, LA 70062-4739

504.464.1040
800.288.5272 Map/Directions


Advertise/Exhibit

Classifieds

CPA Locator

Press Room

Staff Directory

Facility Rental

Privacy & Terms

About LCPA