|
Conference sessions on Monday:
9:00 to 12:00 - Functions and Formulas Bob Umlas will walk us through the most useful and productivity boosting formulas and functions in Excel.
1:00 to 2:45 - Periodic Reporting with Excel Damon Longworth will demonstrate how easy it is to setup and maintain reports that will require periodic updates.
3:00 to 4:45 - Tips and Tricks Bob Umlas will go through a fast paced display of tips and tricks to increase productivity with Excel.
Conference sessions on Tuesday:
9:00 to 12:00 - Introduction to Macros (VBA) Damon Longworth will introduce macros in an easy practical way that will get you started using macros to automate all your routine tasks.
1:00 to 2:45 - Array Formulas Bob Umlas will expose us to the power and flexibility of the often misunderstood Array formulas.
3:00 to 4:45 - Charting Damon Longworth shows strategies to easily create charts. This session will guide you through the best ways to create graphical representation of your data, along with some unique ways to present your information to the end user.
Conference sessions on Wednesday:
9:00 to 12:00 - Intermediate VBA Bob Umlas walks you through all the facets of writing code in VBA. Participants will walk away with usable examples that can be put to use in their daily projects.
1:00 to 2:45 - Using Array Variants in VBA Damon Longworth demonstrates the power of array variants in VBA. He will walk you through practical examples and easy to understand processes.
3:00 to 4:45 - Filtering, Data Validation, Conditional Formatting Bob Umlas will go through a variety of uses for Filtering (including Advanced filters), Cascading data validations, interesting uses for conditional formatting.
|