Sitemap Relevante India BookMark
Relevante
Events
WEBINAR

EXCEL ADVANCED FORMULAS - Part 2
Wednesday, August 24th 2011

Excel 2007 Version at 12:00PM – 1:15PM (ET)

 

CPE CREDIT: 1.5 Computer Science*


PROGRAM LEVEL: Advanced


PREREQUISITE: Medium knowledge of spreadsheets

 

LEARNING OBJECTIVES:


Learn to take a general ledger extract and create a dynamic income statement that changes with the click of a button. The case will take you through and explain the advanced functions:

 

Objectives also include:

 

Learn how to clean-up, break out and combine your data using
 
-
Text to Columns
 
-
Left, Right, & Mid functions
 
-
Concatenate
 
-
Trim & Clean
 
-
Year, Month, & Text functions
Automate and make dynamic reports using
 
-
lookup, vlookup, and hlookup
 
-
Sumif


 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.