Your cart is empty.
Keep shoppingGoogle Sheets - Beginner
126 students
Google Sheets - Beginner
Google Sheets Basics: Navigation, Data Entry, Formatting, Simple Formulas, Functions and Charts
Created byIntellezy Trainers
Last updated 6/2025
English
What you'll learn
- Understand the fundamentals of Google Sheets and navigate through workbooks
- Enter data, create formulas, and utilize functions effectively
- Format spreadsheets, columns, and rows for better organization
- Prepare workbooks for printing and sharing
- Create and format charts, and insert graphics for enhanced data visualization
Explore related topics
Course content
11 sections • 54 lectures • 3h 55m total length
Requirements
- No prior knowledge of spreadsheets is required. Basic computer skills and access to a computer with internet are necessary. A Google account (free or Google Workspace) is needed to use Google Sheets. No additional software or hardware is required.
Description
This course provides a foundational understanding of Google Sheets. It begins with an introduction to its primary functions as a charting tool, simple database, and spreadsheet. Learners will learn to open Google Sheets, import and convert spreadsheets, and navigate the interface. The course covers essential components like the formula bar, rows, columns, cells, and ranges. It includes creating and saving spreadsheets, navigating, working with cells and ranges, and using data selection techniques. Learners will explore commands, copy and paste functions, and data types. Formatting values, using the autofill handle, inserting links, and understanding formulas and functions are also covered. The course emphasizes calculation hierarchy, creating basic formulas, and working with basic functions. Learners will understand cell references, formatting and aligning data, modifying columns and rows, and using borders and fill. Practical exercises include inserting notes, comments, and checkboxes, applying themes, using zoom tools, and working with tabs. The course also covers hiding and unhiding spreadsheets, sorting and filtering data, using filter views, freezing panes, finding and replacing, spell check, preparing spreadsheets for printing, changing settings, downloading and emailing files, sharing spreadsheets, and inserting and formatting charts. By the end, learners will manage and analyze data, create visually appealing spreadsheets, and collaborate effectively.
Who this course is for:
- Perfect for beginners with little to no experience with Google Sheets, or those who are already familiar with the application looking to solidify their foundation. Ideal for anyone looking to improve their data management and analysis skills.