ArmasourcingAcademyStart free

Google Sheets: Beginner to Advanced

Master Google Sheets from basics to VLOOKUP, QUERY, Pivot Tables, and advanced formulas

Beginner8 lessons2 h 8 video walkthroughsFree

What this course covers

The most in-demand Google Sheets course. Go from absolute beginner to advanced user, covering formatting, conditional functions, pivot tables, charts, VLOOKUP, INDEX MATCH, IMPORTRANGE, and the powerful QUERY function. Based on the top-rated Udemy curriculum.

Course outline

  1. Spreadsheet Basics & NavigationVideo · 10 min
  2. Essential Functions: SUM, COUNT, AVERAGEVideo · 10 min
  3. Conditional Functions: IF, SUMIF, COUNTIFVideo · 12 min
  4. Pivot Tables: Analyze Data Like a ProVideo · 12 min
  5. Charts & Data VisualizationVideo · 8 min
  6. VLOOKUP & INDEX MATCHVideo · 15 min
  7. The QUERY Function: SQL in SheetsVideo · 15 min
  8. IMPORTRANGE & Advanced TechniquesVideo · 12 min

Certificate

Finish every lesson and the certificate is issued on the spot. Each certificate has its own verify page a client can open, and a button to add it to LinkedIn.

Part of these learning paths

More in Tools & Software

All courses in this topic
AI Automation with Zapier & Make

Automate repetitive VA tasks with Zapier, Make, and AI-powered workflows, save 5+ hours per week

Intermediate · 7 lessons · 45 min
AI Foundations: How AI Works (Non-Technical)

Understand AI, machine learning, and large language models in plain English, no tech background needed

Beginner · 5 lessons · 35 min
AI Meeting & Calendar Management

Run efficient meetings, manage calendars, and automate scheduling with AI

Beginner · 3 lessons · 30 min