Excel for the Hands-on Controller/CFO – How to Clean Up ‘Dirty’ Data and Enhance Your Lookup Skill Set!

In this course we discuss how to make data that comes to us in a ‘dirty’ and unusable format useful.  Many times, report writers give us data with subtotals or other information that are not very helpful at all.  In this course we focus on how to make this data useful. 

Finally, we explore new ways to create unique identification formulas that will enhance the relational database aspect of your data (i.e. COUNTIFS, SUMIFS, FIND, SEARCH, VLOOKUP, etc.)