Relevante Invites you for its upcoming Webinar on “Excel Advanced Formulas”
5 views
Skip to first unread message
Relevante Inc
Apr 20, 2011, 6:22:42 AM4/20/11
to MS Excel Macro Vba
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: jmo...@relevante.com
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: jmo...@relevante.com
Reply all
Reply to author
Forward
0 new messages