Description
Many business professionals have been thrust into using Excel daily without proper training. It turns out that there are a few simple rules that improve the functionality of every spreadsheet, and make your work easier to accomplish. In this session, we'll demonstrate how applying these fundamental principles change everything.
Topics include:
Using lists and tables for effective data management
Adding selection and navigation shortcuts to your personal toolbox
Understanding the purpose and application of absolute and relative references
Leveraging table references in functions
Organizing a spreadsheet effectively