This intermediate session takes you beyond the basics and introduces key features that help you organise, structure and interrogate your data with greater accuracy. You will learn how to prepare your datasets for analysis, make Sheets more interactive, and use tools that support clearer visualisation and improved data quality.

You'll explore practical tools including data validation, conditional formatting, filters and filter views, and sheet protection. This course also guides you through generating version and cell history to help you track changes and manage your spreadsheets confidently.

By the end, you'll be ready to work more efficiently in Google Sheets and will have a strong foundation for progressing to functions, pivot tables and dashboard creation.

Data Cleansing Techniques Data Validation & Entry Controls Conditional Formatting Skills Filter & Filter View Mastery Sheet Protection & Permissions Version & Cell History

       This course is perfect for people who:      

Basic knowledge of Google Sheets. Completing the introductory session is recommended but not mandatory.