Essential Excel Conference

Excel is the default program for many financial professionals–and highly effective–if used correctly. It can be used for everything from simple tabular analysis to creating in-depth aggregate pivot tables. This course will give participants the necessary tools to turn data into meaningful information and will examine cutting edge ways to store, retrieve, report, and analyze data using Excel and plugins. It will provide recommendations on how to more efficiently use Excel and potential traps to avoid.Participants are encouraged to bring their technology devices to follow along with the interactive discussions, technology demonstrations, sample spreadsheets, and demo tools. Financial professionals will walk away from this course with valuable tools and insights into understanding, managing, and utilizing data in an organized and meaningful manner inside their organizations.

Excel is ubiquitous in the accounting and financial professionals’ workplace, but some of the best functions and features for accounting and financial professionals are unknown or underutilized. Leverage Tables, shortcuts, and best practices to increase efficiency. Master the functions such as VLOOKUP, INDEX & MATCH, Dynamic Array Formulas. As well as Formulas and uses such as Depreciation, Amortization, Interest, Payment, and more. In this course, we will even take you deeper into statistical analysis with formulas for everything from median, most, and standard deviation and regression analysis.