Sub-Total: $0.00
Auditing Data and Spreadsheets
Learn how to audit spreadsheets for hidden risks and secure your sensitive data. In this Data Survival Skills session, Robin demonstrates how seemingly simple Excel files can contain more than meets the eye—from hidden sheets and embedded queries to formulas and linked data sources. She walks through techniques like uncovering hidden columns, showing formulas, and tracing dependencies to reveal where sensitive information may be exposed. Finally, Robin demonstrates how to properly protect your workbook and sheets with passwords, hidden formulas, and locked cells—ensuring that confidential data stays safe, no matter who opens the file.
#Excel #DataSecurity #DataProtection #SpreadsheetAuditing #BusinessIntelligence #DataPrivacy #DataGovernance #DataRiskManagement
If you’re a data analyst, you’ve no doubt learned different skills, techniques, and tools pertaining to data. But sometimes it can be difficult to know when and why to apply these tools. In this weekly series, instructor Robin Hunt explains a new skill, secret, tip, technique, best practice, or golden piece of advice in each installment. Robin covers topics that can help you do your job better, such as joining data and data designs, privacy for data, transforming and cleaning data, and making data sets and visualizing data.
Note: Because this is an ongoing series, viewers will not receive a certificate of completion.