Mastering Excel: Named Ranges, OFFSET and Dynamic Charts

by Mark Moore

This lesson focuses on many seemingly unrelated topics but then combines them in unexpected ways to create something greater than the sum of its parts. First we review the concept of Named Ranges. What are they? How can they help in Excel?Then we cover the OFFSET function. It is truly one of the most powerful, flexible and mostly unused functions in Excel. It is unused because it does take some getting used to, OFFSET doesn't 'work' like the rest...

• Format: Paperback
• Language: English
• ISBN: 154687495X
• ISBN13: 9781546874959
• Release Date: May 2017
• Publisher: Createspace Independent Publishing Platform
• Length: 58 Pages
• Weight: 0.20 lbs.
• Dimensions: 0.1" x 6.0" x 9.0"