OM02 - Operations Management

Financing Reporting & ExcelŽ: Clean Up Your Data

Friday, August 23, 2013, 1:15 PM - 2:30 PM

Do you export the same report into Excel every month? Do you spend excess amounts of time every month to get that data formatted correctly? Have you tried to use a macro to assist in this process, but not been successful? If so, join this session to learn step-by-step instructions for the functions you can use to format your financial data and save valuable time each month.


  • Explain the difference between "Text to Columns" and formulas
  • Use "Insert Function" to build formulas
  • Apply five functions for text manipulation
  • Determine techniques for nesting formulas

Audience: Attendees should have intermediate to advanced knowledge of spreadsheet applications.

CLM App Credit: Information Technology * 75 Minutes * CPE Field of Study: Computer Science * Audience: A

Speaker: Ivan L. Hemmans III, O'Melveny & Myers, LLP



CPE: Computer Science