Excel Timesaving Features – Part 2 builds on the skills from Part 1 and introduces advanced tools for data validation, protection, and reporting. You’ll learn how to create custom formats, protect your workbooks, build templates, and audit formulas to ensure accuracy.

This session is designed to help you create robust, scalable spreadsheets that are easy to maintain and share.

Excel users who want to improve the reliability and usability of their spreadsheets. If you’re ready to take control of your data and reduce errors, this course is for you.

Completion of Excel Timesaving Features – Part 1 or equivalent experience.

By the end of Part 2, you’ll be able to:

• Validate and protect your data
• Create reusable templates for consistent reporting
• Audit formulas to troubleshoot and maintain accuracy
• Use subtotals and custom formats to enhance reporting

Module 4: Summarising Data using Criteria

• SUMIF(s)
• COUNTIF(s)
• AVERAGEIF(s)

Module 5: Data Validation

• Data Validation Rules
• Designing User Instructions and Error Messages
• Creating updatable Drop Down Lists

Module 6: Conditional Formatting

• Conditional Formatting based on Cell Content
• Advanced Conditional Formatting based on a Formula

Module 7: New Excel Checkboxes

• Inserting and Formatting Checkboxes
• Using checkboxes with Formulas and Conditional Formatting