Google Sheets Beginner to Advanced Tutorial
Google Sheets is a free online spreadsheet application provided by Google. It helps users organize data, perform calculations, create charts, manage projects, and autom
ate tasks.
This tutorial covers Google Sheets from beginner to advanced level with visual guidance suggestions.
Chapter 1: Getting Started with Google Sheets
What is Google Sheets?
Google Sheets is an online spreadsheet tool similar to Microsoft Excel that allows users to:
- Create spreadsheets
- Perform calculations
- Share files online
- Work collaboratively
- Analyze data
- Create charts and dashboards
How to Open Google Sheets
Steps:
- Open your browser
- Sign in with your Google account
- Then Open Google Sheets
3. Click on Google Apps Icon
4. Click the Blank Spreadsheet option
Main Parts of Google Sheets
1. Rows
Horizontal lines numbered 1, 2, 3,..to 8 and selected Cell E8
2. Columns
Vertical lines labeled E
3. Cell
Intersection of row and column.
Row number "8"
Column number "E"
Example: E8
Row and Column 1:
4. Formula Bar (Highlight with Yellow Color)
Chapter 3: Entering Data
How to Enter Data
- Click any cell
- Type text or numbers
- Press Enter
Types of Data
- Text
- Numbers
- Dates
- Currency
- Percentages
Picture for the above Data
Chapter 4: Basic Formatting
Formatting Options
Bold Text
Shortcut: Ctrl + B
Italic Text
Shortcut: Ctrl + I
Change Font Size
Use toolbar font-size option.
Cell Color
Use Fill Color tool.
Borders
Apply borders for tables.
- Toolbar screenshot showing formatting tool
Picture for formatting 1:
Chapter 5: Basic Formulas
Formula Basics
All formulas start with = sign.
Addition
Example:
=A1+B1
Subtraction
=A1-B1
Multiplication
=A1*B1
Division
=A1/B1
SUM Function
=SUM(B2:B11)
Adds numbers = F2 + F3 + F4 .... F11
Adds numbers = F2 + F3 + F4 .... F11
AVERAGE Function
=AVERAGE(B2:B11)
Calculates average.
MAX Function
=MAX(D2:D11)
Returns highest value.
MIN Function
=MIN(F2:F11)
Returns lowest value.
COUNT Function
=COUNT(H2:H11)
Counts numbers.
Chapter 7: Sorting and Filtering
Sorting Data
Steps:
- Select table
- Click Data
- Choose Sort Range
Filtering Data
Steps:
- Select data
- Click Data
- Create Filter
Chapter 8: Creating Charts
Types of Charts
- Pie Chart
- Bar Chart
- Line Chart
- Column Chart
How to Insert Chart
- Select data
- Click Insert
- Select Chart
- Chart Screen Short
- https://youtu.be/Nn2MiaItaro ( Bar Chart and pie Chart)
Chapter 9: Conditional Formatting
What is Conditional Formatting?
Automatically changes cell colors based on conditions.
Example
Highlight sales above 5000.
Steps:
- Select cells
- Click Format
- Conditional Formatting
- Set rules
Create Dropdown List
Steps:
- Select cells
- Click Data
- Data Validation
- Add dropdown items
Dropdown menu Screen Short PNG 1:
Dropdown menu Screen Short PNG 2:
Chapter 11: Freeze Rows and Columns
Freeze Header Row
Steps:
- Click View
- Freeze
- Select 1 Row
Chapter 12: Collaboration Features
Share Spreadsheet
Steps:
- Click Share button
- Enter email address
- Set permissions
- Send invite
Permission Types
- Viewer
- Commenter
- Editor
IF Function
=IF(G3>50,"Pass","Fail")
VLOOKUP Function
=VLOOKUP(A2,D1:F10,2,FALSE)
COUNTIF Function
=COUNTIF(A1:A10,">50")
CONCATENATE Function
=A1&" "&B1
Chapter 14: Pivot Tables
What is a Pivot Table?
Used for summarizing and analyzing large data.
Discover how Pivot Tables in Google Sheets can help you analyze large datasets quickly and efficiently. This tutorial covers creating Pivot Tables, customizing rows and columns, filtering data, and generating useful reports for better decision-making.
Steps:
- Select data
- Click Insert
- Pivot Table
- Choose Rows and Values
Chapter 15: Advanced Charts and Dashboards
Dashboard Components
- Charts
- KPIs
- Summary tables
- Slicers
Best Practices
- Use clean colors
- Keep layout simple
- Add clear titles
Picture
- Professional dashboard example
Chapter 16: Google Sheets Shortcuts
Shortcut | Function |
Ctrl + C | Copy |
Ctrl + V | Paste |
Ctrl + Z | Undo |
Ctrl + B | Bold |
Ctrl + Shift + V | Paste Values |
Ctrl + / | Show shortcuts |
Chapter 17: Importing and Exporting Files
Import Excel File
- Click File
- Import
- Upload Excel file
Export as PDF
- Click File
- Download
- PDF Document
Picture
- File menu screenshot
Chapter 18: Protecting Data
Protect Sheet
Steps:
- Right-click sheet
- Protect Sheet
- Set permissions
Picture
- Protection settings example
Chapter 19: Automation with Google Sheets
Google Apps Script
Used for automation.
Example:
function helloWorld() {
SpreadsheetApp.getActiveSpreadsheet()
.getActiveSheet()
.getRange('A1')
.setValue('Hello World');
}
Picture Uploading
- Apps Script editor screenshot
Chapter 20: Real-World Practice Projects
Project Ideas
1. Sales Report
Track monthly sales.
2. Attendance Sheet
Manage employee attendance.
3. Budget Planner
Track income and expenses.
4. Inventory System
Manage stock quantities.
5. CCTV Installation Tracker
Track camera locations and IP addresses.
Picture
- Example project templates
Tips for Beginners
- Practice daily
- Learn formulas step-by-step
- Use templates
- Watch tutorials regularly
- Experiment with charts and formatting
Conclusion
Google Sheets is a powerful tool for students, businesses, technicians, and professionals. By mastering beginner to advanced features, you can improve productivity, analyze data efficiently, and automate many daily tasks.
Keep practicing and exploring new features regularly.
0 Comments