Dynamic ranges and print areas with the Offset function

#excelhacks #exceltutorials Excel’s Offset function, available in the last couple of versions for Windows and Mac, lets you create ranges that change location and size dynamically. In this video, we look at a few examples, then use the function to change the size of a print area on the fly. About Bob: Bob Flisser has been a software trainer since the mid-1990s, specializing in Microsoft and Adobe suites. He has written and recorded video courses for LinkedIn Learning, Pluralsight, Skillsoft, Tuts+, and others, and is the co-author of a dozen books of tips and shortcuts for Microsoft applications. He has also written magazine articles and training manuals and set up corporate training centers. Connect with Bob: Experts Exchange: https://www.experts-exchange.com/memb... LinkedIn:   / bobflisser   Learn more about Experts Exchange: Info: https://go.experts-exchange.com/ Try free for 7 days: https://go.experts-exchange.com/pricing #excelforbeginners #excelhacks #exceltutorials