R
Relevante Inc
Date: May 18th 2011
Overview:
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
• GetPivotData
• Create drop down selection boxes
• Error handling statements.
Participants will get “1.5 Computer Science” CPE Credits.
For more information visit:
http://www.relevante.com/htmls/educational_events/05182011.html
You can also E-Mail at: (e-mail address removed)
Overview:
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
• GetPivotData
• Create drop down selection boxes
• Error handling statements.
Participants will get “1.5 Computer Science” CPE Credits.
For more information visit:
http://www.relevante.com/htmls/educational_events/05182011.html
You can also E-Mail at: (e-mail address removed)