(A*) Create Bulletproof Spreadsheets with Automation & Templates (hands-on) (T2PM)
*Advanced* Is your spreadsheet beautiful until someone else gets their hands on it? Do you spend hours trying to figure out WHAT HAPPENED? We’ll highlight dozens of Excel features that can guarantee an immaculate file – and make it incredibly easy for your coworkers to interact with the file. Whether we’re building dynamic functions that change as the inputs change, or color-coding cells, or building powerful macros to automate the ‘sealing’ of a file, this session will give you tools to fix old problems and avoid new ones. Build template sheets, validate your users’ data entry, and more.