Advanced validation and collaboration in Excel 2003

Course details

• Identify advanced data validation and collaboration Excel 2003
• Data validation in Excel 2003
• © s After completing this topic, you should be able to validate data in Excel 2003.
• Audit data in Excel 2003
• © s After completing this topic, you should be able to audit data in Excel 2003.
• Using data validation in Excel 2003
• © s After completing this topic, you should be able to validate data in an Excel sheet cá¡lculo 2003.
• Protection spreadsheets in Excel 2003
• © s After completing this topic, you should be able to protect a worksheet in Excel 2003 cá¡lculo.
• Protecting workbooks in Excel 2003
• © s After completing this topic, you should be able to use Password ± as, encryption and digital signatures to protect Excel 2003 workbooks.
• Data protection in Excel 2003
• © s After completing this topic, you should be able to protect ranges, spreadsheets and workbooks in Excel 2003.
• Books shared in Excel 2003
• © s After completing this topic, you should be able to share and combine workbooks in Excel 2003.
• Track Changes in Excel 2003
• © s After completing this topic, you should be able to control changes using a number of tools of Excel 2003.
• Collaboration in an Excel 2003
• © s After completing this topic, you should be able to use the collaboration features of Excel 2003 to monitor changes and to combine books.
• Validation and data protection in Excel 2003
• © s After completing this topic, you should be able to apply the data validation tools and protect and share workbooks in Excel 2003.