Tech IT SolutionGoogle Sheets
Become expert in Google Sheets — formulas, pivot tables, data analysis, dashboards, automation with Apps Script — perfect for jobs, freelancing & productivity
Why join this course
Google Sheets is free, collaborative and powerful. Learn essential and advanced formulas, pivot tables, charts, automation with Apps Script and interactive dashboards for real work such as sales tracking and expense management.
Free, cloud-based, collaborative
Work together in real time from anywhere.
100% practical training
Every topic is practiced on a computer in class, not just explained.
Mentor support
Ask doubts any time and get personal help.
Automation included
Apps Script to save hours of manual work.
By the end you will be able to
- Google Sheets Basics & Advanced Formatting
- Formulas & Functions (VLOOKUP, INDEX-MATCH, ARRAYFORMULA, QUERY)
- Pivot Tables, Charts & Data Visualization
- Data Cleaning, Validation & Conditional Formatting
- Google Apps Script for Automation & Custom Functions
- Dashboards, Reports & Real-time Collaboration
- 10+ Real-world Projects (Sales Dashboard, Inventory Tracker, Budget Planner...)
Who is this course for?
Add a job-ready skill next to your degree or diploma.
Upskill for a promotion, a better role or a career switch.
Use these skills to deliver client work or run your own business better.
Curriculum overview
6 modules, explained in detail. Open a module to see exactly what is inside.
1Google Sheets Fundamentals7 topics
Learn the interface, how Sheets compares to Excel, and best practices for entering and formatting data.
What is inside
- Interface tour
- Sheets vs Excel
- Cell formatting
- Data entry best practices
- Freeze rows/columns
- Filters & Sorting
- Import/Export data
2Essential & Advanced Formulas12 topics
From SUM to nested IF and lookups, master the formulas you will use every day.
What is inside
- SUM
- AVERAGE
- COUNTIF/SUMIF
- IF
- Nested IF
- VLOOKUP
- HLOOKUP
- INDEX-MATCH
- XLOOKUP
- ARRAYFORMULA
- QUERY function
- TEXT functions
3Data Analysis & Visualization7 topics
Analyze and visualize with pivot tables, charts, slicers, sparklines and conditional formatting.
What is inside
- Pivot Tables & Charts
- Slicers
- Sparklines
- Conditional Formatting
- Data Validation
- Drop-down lists
- Charts (Combo, Gauge, Timeline)
4Google Apps Script & Automation6 topics
Automate with Apps Script: custom functions, triggers and simple automation.
What is inside
- Introduction to Apps Script
- Custom functions
- Triggers (onEdit, time-driven)
- Automate emails/reports
- Send data to Google Forms/Sheets
- Simple macros
5Dashboards & Real-World Projects7 topics
Build interactive dashboards and complete real-world projects.
What is inside
- Building interactive dashboards
- Sales tracking
- Expense manager
- HR attendance
- Inventory control
- Student marks analysis
- 10+ portfolio projects
6Certification & Job Skills6 topics
Best practices, collaboration and sharing, version history and job skills, plus certification.
What is inside
- Best practices for professional use
- Collaboration & Sharing
- Version history
- Project submission
- Resume tips for data entry/analyst roles
- Mock interview questions
What you will build
Real work for your portfolio, not just exercises.
Sales tracker
Live tracking with formulas.
Expense manager
Budgets, charts and summaries.
Interactive dashboard
Filters and charts in one view.
Tools you will use
How you will learn
Career outcomes
Roles this course prepares you for:
- Resume & LinkedIn profile building
- Portfolio and project review
- Mock interviews with IT leads
- Hiring-partner drives and referrals
Certificate, batches & details
W Tech Certification + Project Portfolio
Issued after you pass the final evaluation of the course.
Flexible batches
Morning, afternoon, evening and weekend batches. Classroom at GTB Nagar or live online.
Course at a glance
| Duration | 2–3 months (Flexible batches) |
|---|---|
| Level | Beginner to Advanced |
| Mode | Classroom (GTB Nagar, Delhi) & live online |
| Teaching format | Live Sessions + Assignments |
| Prerequisites | No prior experience needed. We start from the basics and build up step by step. |
| Batches | Weekday morning / afternoon / evening & weekend |
| Certificate | W Tech Certification + Project Portfolio |
| Fees | Call or WhatsApp for the current fee · EMI options available |
Frequently asked questions
Who can join Google Sheets?
No prior experience needed. We start from the basics and build up step by step. Students, graduates, job seekers and working professionals are all welcome.
How long is the course and what are the batch timings?
The course runs for 2–3 months (Flexible batches). We run weekday morning, afternoon and evening batches plus weekend batches for college students and working professionals.
Are classes online or in the classroom?
Both. Attend live in our GTB Nagar (Delhi) classroom or join live instructor-led online classes from anywhere in India. Sessions are recorded, and you can switch between modes.
What certificate will I receive?
W Tech Certification + Project Portfolio, awarded after you pass the final evaluation.
Will I work on real projects?
Yes. Most of the training is hands-on labs and guided projects, and you finish with work you can show in your portfolio.
What jobs can I apply for after this course?
Typical roles include MIS Executive, Operations Executive, Data Assistant. Your outcome depends on your skills, portfolio and interview performance, and our placement team supports you at every step.
Do you help with placement?
Yes. We help with resume and LinkedIn profiles, portfolio review, mock interviews and hiring-partner drives. This is placement assistance, not a job guarantee.
What is the fee, and is EMI available?
Fees depend on the batch and mode. Call or WhatsApp us for the current fee and flexible EMI / installment options.
Can I attend a free demo class first?
Yes. Book a free demo class to meet the mentors and see how the training works before you enrol.
Related courses
Start your Google Sheets journey
Talk to a counselor, sit in a free demo class and pick the batch that fits your schedule.
Book Free Demo
Leave your details and we will call you.