Google Sheets: Enter & Fill Data

Course description

This course introduces learners to the foundational skills needed to confidently enter, manage, and format data in Google Sheets. Through nine practical lessons, participants will explore essential techniques for navigating spreadsheets, selecting and referencing data, and applying formatting for clarity and consistency. The course begins with efficient navigation methods using both mouse and keyboard, including shortcuts that streamline movement across large datasets. Learners will then explore how to work with cells and ranges, understand cell references, and apply various data selection techniques—both contiguous and non-contiguous—to support accurate formulas and functions. Participants will gain hands-on experience with common sheet commands such as undo, redo, and right-click options, as well as copy, cut, and paste—including advanced paste special options like values-only, formatting, and transposing. The course also covers data types and formatting, helping learners distinguish between text, numbers, dates, and currency, and apply appropriate formatting for each. Additional lessons focus on using the powerful AutoFill tool to quickly populate data and formulas, and inserting hyperlinks to cells, sheets, or external resources for better navigation and interactivity. By the end of the course, learners will be equipped with the core skills needed to confidently enter and manage data in Google Sheets, laying the groundwork for more advanced spreadsheet tasks.

Course outline