Please join us as Darrell Scott presents:
"Excel Dashboards: Advanced Tips and Tricks", PDU: Strategic/Business
Today's competitive environment demands that businesses leverage their data for both historical, retrospective analysis as well as future, predictive analysis. PMI-Tulsa concludes its 3-part series on data analysis by highlighting the most widely-used data tool - Excel. Darrell Scott, Senior Consultant with CS3 Technology, will join us to share his favorite advanced tips and tricks that have helped him over his years in Accounting and ERP Systems consulting.
Date: November 9, 2018
Location: OSU-Tulsa, North Hall, BS Roberts Room
Many companies, departments and/or business analysts start their analysis of data using MS Excel tables and tools. As the company, department, and/or requirements grow, so does the demand for an ever-increasingly complex set of Excel skills. Whether striving to be as efficient as possible in the Extract and Transformation of raw data, or building queries that probe the content of data, Excel can help. Tools such as Pivot Tables, Goal Seek, Arrays, 3D Sum, Index/Match, along with the ever-popular VLookup, expand an analyst's abilities and therefore capabilities to extract meaningful business information out of raw data sets. This presentation is perfect for members or non-members alike that are looking to build their Excel skills or an understanding of its capabilities.