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 1

• Basic design considerations
• Using data validation and other techniques to create an interactive user experience
• Using PivotTables and other techniques to summarize data