This session will look at the core Excel tool and helps understand how we can use ranges in a more dynamic way. Ranges are the building blocks of Excel, so having a solid understanding of what ranges are, their properties, how we can define them and how we can use them, can lead us to better formulas, charts, VBA and Power Query. In his presentation, Mark Proctor will cover various techniques, tips and tricks, and will also show us the pitfalls of some common methods implemented by users every day in the real world. You will be surprised by the secrets hidden in ranges and the benefits we can extract from them if we know how to use those to our advantage.