Overview:
Learn how Excel can help to increase spreadsheet accuracy, consistency, and security. See how using color coding schemes can improve consistency across the workbook. Learn effective Naming conventions with the Define Names Command. Discover how Commenting works well for sharing spreadsheets with others and for documentation.
Areas Covered in the Session:
- Use Defined Names Commands; assign Names to Ranges and Tables
- Use the Name Manager
- Use Comments in a sharing environment and for Documentation
- Color Coding: Use consistent colors; includes Styles
- Set Conditional Formatting rules
- Secure spreadsheets with Protection related commands
Who Will Benefit:
- Managers
- Business Professionals
- Administrative Personnel
- Legal Professionals