• Courses
  • Placement
  • Data Science
    IBM
  1. All Courses
  2. Self-Paced

MS Excel and Google Spreadsheets - Skill Up

Self-Paced Course
course-thumbnail
interested count2k+ interested Geeks

The Excel & Google Sheets Course is an 8-week structured program that teaches you everything from the basics of Excel to advanced data automation in Google Sheets. Youll master data entry, formulas, formatting, analysis tools, visualization, and automation using real-world examples and projects.

course duration8 Weeks
interested count2k+ interested Geeks

Course Overview

This 8-week course combines theory, hands-on practice, and projects to help you become confident with Excel and Google Sheets. Youll learn to manage data, use formulas, create dashboards, automate with VBA and Google Apps Script, and collaborate in real-time. By the end, youll be able to analyze, visualize, and automate data workflows for business or personal projects.

Course Highlights

  • Learn Excel basics: navigation, formatting, and formulas
  • Master data manipulation and validation techniques
  • Work with advanced formulas: Lookup, Array, Logical, and Statistical functions
  • Build PivotTables, charts, and interactive dashboards
  • Automate workflows with Macros, VBA, and Google Apps Script
  • Create dynamic reports using Power Query and Power Pivot
  • Explore Google Sheets collaboration tools, AI features, and integrations
  • Apply knowledge through practical projects and case studies
Read more

Course Content

01Week 1: Excel Basics and Formatting
  • Excel Introduction and Basics
  • Navigation in Excel
  • Data Manipulation
  • Data Entry Features
  • Grouping and Hiding
  • Basic Formatting
  • Visual and Interactive Elements


02Week 2: Intermediate Formatting and Formulas
  • Conditional Formatting
  • Lookup Functions
  • Text and Date Functions
  • Advanced Lookup and Array Functions
  • Statistical and Conditional Functions
  • Data Sorting
  • Choose and Array Functions



03Week 3: Data Analysis and Visualization
  • Filtering and Data Entry
  • PivotTables Basics
  • Advanced Pivot Features
  • Data Analysis Tools
  • Basic Charts
  • Advanced Charts
  • Statistical Visualizations
04Week 4: Advanced Excel and Automation
  • Power Query Basics
  • Power Pivot Basics
  • Advanced Power Query & Pivot
  • Macros Introduction
  • VBA Basics
  • VBA Advanced
  • Specialized Charts
Read more

Rewards You Never Want To Miss!

Rewards
GfG Connect
Talk 1-on-1 with Experts! with GfG connect
Rewards
Live Webinars
Join Power Packed Webinars
Rewards
Certificates
Show Off Your Skills with Certificates!
Rewards
GfG T-Shirt
Exclusive T-Shirt On Sharing Your Progress