Sitemap Relevante India BookMark
Relevante
Events

 

WEBINAR
Excel Pivot Tables: Part 3

Thursday, January 20th 2011

This event is offered two times on on January 20th: Excel 2003 Version at 12:00PM – 1:15PM and Excel 2007 Version at 2:00PM – 3:15PM (ET). Join us at a time that is convenient to you. Your registration gives you access to both times.

 

 

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
Director – Business Intelligence Solutions
Relevante Inc.

Kevin J. Hull has a background in financial reporting, budgeting and forecasting, and database designing. He has been successfully deployed in the banking and manufacturing industries providing reconciliations, 10-Q reporting, and database development. He has successfully implemented streamlined processes for companies saving both time and money.

 

Prior to Relevante, Kevin 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.

 

 

* 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
 
Home | About Us | What We Do | Jobs | News & Events | Why Relevante | Contact Us © 2002-2011 Relevante Inc. All Rights Reserved.
Legal Disclaimer. Privacy Statement.