Google Sheets: Navigate & Build Spreadsheets

Course description

This course offers a thorough exploration of Google Sheets, equipping learners with essential skills and practices to maximize productivity. It begins with a look at fundamental features such as the formula bar, cell references, and formatting, offering a solid foundation in spreadsheet navigation and data manipulation. Building on this, learners will discover techniques such as creating new sheets, importing and exporting files, and using templates to streamline workflows efficiently. Significant emphasis is placed on collaboration tools within Google Sheets, such as sharing files, requesting approvals, publishing spreadsheets, emailing files, and enabling offline access for seamless teamwork. The course also introduces methods to manage files effectively by accessing version history, renaming or moving files, and creating shortcuts to Google Drive. Participants are guided through the help menu, where they can search for features, access training resources, view updates, provide feedback, and master keyboard shortcuts designed to boost efficiency. Practical scenarios, such as creating project timelines with templates and navigating between files on Google Drive, are demonstrated to ensure real-world applicability of the skills learned. By the end of the course, learners will have the expertise to create, manage, save, and optimize spreadsheets while harnessing Google Sheets features to adapt to both professional and personal spreadsheet needs with confidence.

Course outline