Home > News & Events > Educational Events >> Excel Pivot Tables Webinar
 |
Excel Pivot Tables Webinar: Part 3 |
| Thursday, December 15th 2011 |
| Excel 2007 Version at 12:00PM – 1:15PM (ET) |
|
|
|
CPE CREDITS: 1.5 Computer Science*
PROGRAM LEVEL: Advanced
PREREQUISITE: Must have basic excel skills. Should already know PivotTable basics: creating, adding fields, field settings, and PivotTable Options.
|
 |
LEARNING OBJECTIVES:
Sample general ledger data will be used to create an Income Statement with various calculated fields.
Objectives also include:
• |
Calculated Fields |
• |
Calculated Items |
• |
Differences between using Grouping and a calculated field |
• |
Using “Solve Order” to change how data is calculated |
|
|
Presenter:

|
Kevin J. Hull, MBA
Global Financial Analyst – IT
DuPont |
Kevin J. Hull has a background in financial reporting, budgeting and forecasting, and database designing. In his current job he works with global financial leaders to consolidate and analyze financials to assist IT in prioritizing their initiatives. He is also responsible for providing financial system expertise and leadership in the design, configuration, re-engineering and implementation of system financial modules.
Prior to his current job, he was a consultant successfully deployed in the banking and manufacturing industries providing reconciliations, 10-Q reporting, and database development. He successfully implemented streamlined processes for companies saving both time and money. He also worked in the credit card industry where he was the manager of the financial reporting department. He was responsible for producing executive financial reports, annual budgets, consolidated financials of 18 companies, and key metrics reporting for the operating departments. He also headed the implementation of a new financial package and streamlined processes using various database software.
Kevin has an M.B.A. from DePaul University in Chicago and currently resides in West Grove, PA with his wife and two daughters. |
|
* If you are required to have CPE credits – you must have your individual log in and participation (groups using one log in cannot be monitored and this is required by NASBA)
|
About Relevante Inc.
Relevante is a leading consulting practice providing Accounting & Technology Solutions to Fortune 1000 and other industry leaders. The company services clients throughout the metro markets of Philadelphia, New York and Hyderabad, India. For more information about Relevante, please visit our website at: www.relevante.com |
|
 |
Relevante Inc. is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE Sponsors. Complaints regarding registered sponsors may be addressed to the National Registry of CPE Sponsors, Nashville TN 37219-2417. Telephone: 615-880-4200. Website:www.nasba.org |
|
|
|
|