Description
When properly designed, interactive spreadsheets can create a better experience for the user, standardize input, check for input errors; and guide the user by providing feedback and instructions. This allows lower-skilled personnel to perform tasks normally requiring higher skill levels, allows higher-skilled personnel to focus on tasks that cannot be delegated, reduces the chance for errors, and ensures a more consistent presentation. Adding automation further enhances this process. This webinar teaches how to create interactive spreadsheets using no-code and coding techniques.
Part 2
-
Basic design considerations
-
Using code scripting and other techniques to manipulate spreadsheet data and create an interactive user experience
-
Using code script and other techniques to summarize data including the use of code script to refresh PivotTables