The use of Named Ranges can divide the Excel community, especially amongst financial modellers. Some users hate them, and others love them. If names are well structured and used correctly, they can;
• improve model structure
• cut down development and maintenance time
• make formulas easier to read and understand – self documenting
• remove some of the limitations of formatted tables
• work well with dynamic arrays
Join us for this virtual meetup to hear from Excel expert, Neale Blackwood who will share the basics, plus shortcuts and more advanced techniques. He will also show us some tricks for using the Name Box. This will be an intense, hands-on training session with example workbook and a detailed manual provided upon registration, so be prepared to follow along!
Register for other virtual meetups coming up soon: https://plumsolutions.com.au/meetup