Master Google Sheets for data entry, formulas, charts, dashboards, and real‑world business reporting.
Learn Google Sheets step by step and build the practical spreadsheet skills that actually matter in real work, study, and everyday life. This beginner‑friendly Google Sheets course takes you from opening your first spreadsheet to designing clean dashboards, using formulas, charts, and pivot tables with confidence.
What you’ll learn
- Navigate the Google Sheets interface, menus, toolbars, tabs, and help, and move efficiently between cells, ranges, and multiple sheets..
- Structure sheets with clear rows, columns, and layouts by resizing, hiding, and reordering to keep data readable and professional..
- Enter text, numbers, dates, and times correctly and write basic formulas so calculations behave reliably instead of as plain text..
- Use data validation rules with dropdowns, numeric ranges, and date limits so collaborators enter clean, consistent data in your sheets..
- Treat dates and times as numbers, shift them with arithmetic, measure differences, and customise how they are displayed..
- Apply formatting like fonts, colors, borders, alignment, wrapping, merging, and conditional formatting to make reports clear..
- Use Smart Fill, auto‑complete, and autofill to split, combine, and extend data and formulas quickly and accurately. .
- Build tables with sorting, filtering, and named ranges while avoiding common mistakes that hide or break important data..
- Create and debug formulas and functions, interpret common error codes, and apply BODMAS and cell references correctly..
- Use math, logical, text, and date functions and combine them into practical formulas for real‑world tasks..
- Perform lookups with VLOOKUP, HLOOKUP, INDEX+MATCH, and ARRAYFORMULA plus IFERROR for flexible, robust models..
- Summarise data with charts and pivot tables, choosing chart types, styling them, and configuring pivot rows, columns, and filters..
- Protect critical ranges and sheets, collaborate safely with sharing roles and version history, and control who can edit what. .
- Configure printing and exports so Sheets printouts and PDFs are legible, scaled, and easy to share or open in Excel and CSV..
- Design a Google Sheets dashboard with KPI cards, status breakdowns, charts, and navigation driven by validated data..
- Choose between Google Sheets and Excel based on needs in collaboration, automation, file formats, and long‑term flexibility..
Course Content
- Introduction –> 4 lectures • 11min.
- Interface, Navigation, and Layout –> 3 lectures • 28min.
- Data Types, Entry, and Validation –> 3 lectures • 33min.
- Formatting and Intelligent Helpers –> 4 lectures • 36min.
- Tables, Filters, and Named Ranges –> 2 lectures • 18min.
- Formulas, Functions, and Errors –> 4 lectures • 21min.
- Essential Functions Toolkit –> 3 lectures • 37min.
- Lookup, Reference, and Arrays –> 3 lectures • 20min.
- Visualisation and Pivot Tables –> 4 lectures • 28min.
- Protection, Sharing, and Printing –> 2 lectures • 13min.
- Dashboard Project –> 2 lectures • 21min.
- Closing and Next Steps –> 2 lectures • 2min.
Requirements
Learn Google Sheets step by step and build the practical spreadsheet skills that actually matter in real work, study, and everyday life. This beginner‑friendly Google Sheets course takes you from opening your first spreadsheet to designing clean dashboards, using formulas, charts, and pivot tables with confidence.
Master the Google Sheets essentials
- Learn how to open Google Sheets, create new spreadsheets, use templates, and organise your files in Google Drive so you always know where your data lives.
- Navigate the Google Sheets interface confidently, including the menu bar, toolbar icons, sheet tabs, zoom, and help features.
- Work efficiently with cells and ranges: select ranges, move around quickly, use context menus, and manage multiple sheet tabs within a workbook.
- Adjust rows and columns like a pro by resizing, auto‑fitting, inserting, deleting, moving, hiding, and unhiding them to keep your layouts clear.
Clean, structured data entry
- Enter and edit text, numbers, dates, and times correctly so Google Sheets recognises them and your formulas calculate properly.
- Understand how dates and times are stored as numbers, use TODAY and NOW, add or subtract days, and calculate the number of days between two dates.
- Use custom date and time formats to match regional preferences or reporting standards without breaking the underlying data.
Professional formatting and layout
- Apply essential cell formatting: fonts, sizes, colours, borders, alignment, text wrapping, and merged cells to make reports easy to read.
- Use conditional formatting to highlight key values, trends, thresholds, and issues automatically.
- Copy formatting quickly with Paint Format and clear messy formatting when you want a fresh start.
Data validation, accuracy, and protection
- Set up data validation rules with dropdown lists, number ranges, and allowed date windows to prevent incorrect entries and keep data consistent.
- Choose between soft warnings and hard rejections so collaborators are guided, not frustrated.
- Protect ranges and entire sheets while leaving input cells editable, and understand how these protections interact with sharing permissions.
Smart tools for speed
- Use Smart Fill to recognise patterns and automatically clean or split data, such as names, codes, or phone numbers.
- Split text into columns, recombine values from multiple columns, and use auto‑complete to reduce typing.
- Master Autofill to quickly extend series of months, days, numbers, dates, and formulas across large ranges.
Formulas and functions, made simple
- Build simple formulas for addition, subtraction, multiplication, division, and percentages with confidence.
- Apply the correct order of operations (BODMAS), so complex formulas produce the answers you expect.
- Understand relative and absolute references, and when to use $A$1 style references so formulas copy correctly.
- Diagnose and fix common formula errors like DIV0!, REF!, VALUE!, and NAME? instead of getting stuck.
Essential Google Sheets functions
- Use the most useful math functions such as SUM, AVERAGE, MIN, MAX, and ROUND in real‑world scenarios.
- Apply logical functions like IF, AND, OR, and IFERROR to build smarter, more robust formulas.
- Clean data with text functions such as LEFT, RIGHT, MID, LEN, TRIM, LOWER, UPPER, and CONCAT/CONCATENATE.
- Work with date functions including TODAY, NOW, DATE, DAYS, and DATEDIF to drive schedules, timelines, and reports.
- Combine functions for powerful solutions, such as threshold checks with summaries, cleaning full names, and flagging recent activity.
Lookups, named ranges, and tables
- Turn raw ranges into structured tables using sorting, filtering, and named ranges.
- Sort by one or multiple columns and filter by condition or by values to quickly answer specific questions from your data.
- Create and manage named ranges so formulas stay readable and easier to maintain.
- Perform powerful lookups using VLOOKUP and HLOOKUP, and understand their key limitations and best practices.
- Upgrade to INDEX+MATCH for more flexible, robust lookups that do not break when columns move.
- Use ARRAYFORMULA to apply formulas across entire ranges and wrap them with IFERROR for cleaner, user‑friendly outputs.
Charts, pivot tables, and dashboards
- Insert and configure charts in Google Sheets, from basic column and bar charts to line and pie charts.
- Choose appropriate chart types, set data ranges and series, add titles and axis labels, and customise colours and styles.
- Understand how charts update automatically when your underlying data changes.
- Build pivot tables from scratch to summarise sales, counts, averages, and other metrics by categories like region or rep.
- Change value summaries, format pivot outputs, filter your pivot tables, add columns, and create charts directly from pivots.
- Put everything together in a practical dashboard project:
- Prepare a clean source sheet.
- Build KPI cards (for example, average scores or totals).
- Add charts showing status or category distributions.
- Create a Home dashboard sheet with navigation links to supporting sheets.
Sharing, collaboration, and printing
- Use Google Sheets version history, automatic saving, and sharing options to collaborate safely with teammates.
- Share with specific people or via links, and choose viewer, commenter, or editor roles appropriately.
- Configure page setup and printing: choose what to print, control orientation, margins, scaling, gridlines, headers, and repeating titles.
- Export your spreadsheets as PDF, Excel (XLSX), or CSV so they are easy to share with people outside Google Workspace.
Designed for real beginners and busy professionals
This course is designed as a Google Sheets crash course that gets you productive fast, focusing on the tools beginners actually use rather than advanced, rarely needed features. Every lesson is built around clear, real‑world tasks with a downloadable practice workbook, so you can always apply each new skill to actual spreadsheet data.
By the end of the course, you will feel at home in Google Sheets, able to build and maintain reliable spreadsheets, use formulas and functions confidently, create charts and pivot tables, and design simple dashboards that make your data easy to understand.
Get Tutorial
https://www.udemy.com/course/google-sheets-crash-course/b9a7ea71c9f18dc8e29e9bf130ef5a1bd141f7bd