Google Sheets for Excel Users (7 CPE)

Course Description

Build confidence in Google Sheets with Google Sheets for Excel Users. It is a practical, step-by-step course designed to help you understand the similarities and differences from Excel so you can translate the skills you already have into confident, real-world Google Sheets work; you’ll learn the cloud-based workflows, functions, collaboration tools, and reporting features that matter most, follow a clear lesson-by-lesson path that shortens the learning curve, and earn 7 CPE along the way.

 

Agenda

Welcome + Orientation: Start here with the course overview, learning path, and what to expect as you move through the training

Lesson 1 Getting Started: Learn the Google Sheets interface, how exercise files work, how to make your own copy, autosave, and version history

Lesson 2 Structure & Navigation: Understand key terminology, references, navigation, and how IMPORTRANGE works across files

Lesson 3 Fundamental Features: Work with tables, named ranges, data validation, checkboxes, conditional formatting, smart chips, and alternating colors

Lesson 4 Working with Data: Use paste special, clean up imported data, and apply tools and functions like PROPER, LOWER, SPLIT, column stats, import tools, and IMPORTDATA

Lesson 5 Formulas & Functions: Build confidence with modern Google Sheets formulas including ARRAYFORMULA, SORTN, QUERY, GOOGLEFINANCE, IMPORTHTML, IMPORTFEED, and IMPORTXML

Lesson 6 PivotTables: Create and refine PivotTables using rows, columns, values, filters, slicers, grouping, formatting, show as options, and updates

Lesson 7 Charts: Create column, line, and bar charts, edit and format them, manage sorting and aggregation, and use SPARKLINE for in-cell visuals

Lesson 8 Collaboration: Work safely with roles, collaborators, general access links, protection, hidden sheets, notes, comments, filter views, and publish to web

Exam and Certificate: Complete the final exam, earn your certificate of completion, and submit the course evaluation CPE: 7 CPE for the full on-demand course

 

Learning Objectives

  • Identify key differences between Google Sheets and Microsoft Excel in terms of interface, terminology, file management, and autosave behavior.
  • Recognize at least three basic Google Sheets tools, including tables, pivot tables, charts, formulas, and data import functions, used to organize and analyze spreadsheet data.
  • State three Google Sheets features, such as the QUERY function, IMPORTRANGE, and smart chips.

Additional Information

  • Instructor: Jeff Lenning CPA
  • Recommended CPE: 7
  • Program level: Basic
  • Prerequisites: None
  • Advance preparation needed: None.
  • Recommended software: Excel 365 for Windows
  • Delivery method: QAS Self-Study
  • Refund policy: full refund within 30 days or until you earn CPE
  • Expiration date: One year
  • Field of Study: Computer Software & Applications
  • Registration: To register, click the Buy Now button and complete the checkout process
  • Complaint Resolution: jeff@excel-university.com or 949-200-7688
  • Access begins: Immediately

 

Excel University, Inc. is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have the final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the national Registry of CPE Sponsors through its website: www.nasbaregistry.org
Price: $179.00
Quantity:

Return to Catalog

Categories