Dates and location
Hours
Dates and location
Hours
Description
How often to you need to revise an analysis in Excel because of new data?
What do you do when the timeframe of an analysis changes and requires a new formula? This one-hour video course will show participants how to use the OFFSET function in Excel to create flexible and dynamic models and visualizations. Simplify your workflow with a function that can make changes instantly based on different ranges of data and input variables.
Unlock learning anytime, anywhere with the Blackboard Learn app
Seamlessly access your on demand courses, assignments, and get PD hours on the go. Learn how to download now and elevate your education experience with the convenience of mobile learning.
Key Takeaways
By the end of the course, you will be able to:
- Understand the logic of the OFFSET function.
- Use the OFFSET function to create flexible models with different ranges of data.
- See how the OFFSET function can instantly change an N-period average.
- Discover how the OFFSET function insulates a model from inevitable mistakes.
- Create dynamic charts that always display only the data available.
Who Will Benefit
Business professionals who need to create models from data that is constantly changing.
How to Access the Course
This is an online session. This course is available 24 hours a day, 7 days a week. Once registered, you can access the material at any time.
However, you will only have access to the course for 90 days after REGISTRATION.
New mobile learning! Download Blackboard Learn from your app store (iOS or Android). Learn more.
To access the course on your computer please visit our BlackBoard site, and log-in using the same login and password used for the Registration Portal.
Please allow up to 15 minutes after registration for the course to appear on your BlackBoard page.
Registration, cancellation, withdrawal and all other CPA Ontario PD policies can be found here.
Speaker(s)
David Elsner is the President of DHE Consulting, providing training, consulting, and analytical solutions to organizations. He specializes in solution implementation, guiding businesses to make use of their data assets, and developing cost-saving strategies. David leads classes at the Rotman School of Management and CPA Ontario.