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
Hear from Excel expert, Neale Blackwood who shares the basics, plus shortcuts and more advanced techniques. He also shows us some tricks for using the Name Box. This is an intense, hands-on training session with example workbook with a detailed manual also provided, so be prepared to follow along!
Register for other virtual meetups coming up soon