Intro to Google Sheets

In this course you’ll build the skills you need to manage, explore, analyze, and visualize data in Google Sheets, using real-world projects and datasets.

We’ll start by introducing the Sheets interface and workflow, then dive into spreadsheet fundamentals like table structures, data types, formatting, sorting and filtering.

From there we’ll dig into formulas and functions, introduce key topics like syntax, reference types, and common errors, and practice applying some of the most common and powerful techniques for data management and analysis. We’ll use functions to count and aggregate values, create logical tests, join data across tables, manipulate text and date values, and more.

Next we’ll introduce Pivot Tables, an essential spreadsheet tool for data exploration. We’ll prepare raw data for analysis, create views to slice and dice the data, and apply tools like sorting, grouping, and calculated fields.

We’ll also dive into the world of data visualization and storytelling, review best practices for effective design, and bring our data to life using visuals like bars and columns, line and area charts, scatterplots and maps.

Last but not least, we’ll demonstrate some of Google Sheets’ unique sharing and collaboration features, including comments, notifications, edit history, sheet protection, and more.

This is a hands-on and project-based course, designed to help you build practical data literacy and analytical thinking skills. You’ll work with unique, real-world datasets, and apply your skills with hands-on assignments every step of the way.

COURSE CURRICULUM:

WHO SHOULD TAKE THIS COURSE?

• Anyone looking to develop core data literacy and analytical thinking skills
• Data professionals looking for a comprehensive introduction to Google Sheets
• Spreadsheet users who want to build job-ready data prep, analysis, visualization and collaboration skills

WHAT ARE THE COURSE REQUIREMENTS?

• We will be using Google Sheets for course demos (free, in-browser)
• No advance preparation is required (basic data skills are a plus, but not a prerequisite)

WHAT ARE THE COURSE OBJECTIVES?

• Identify the basics for getting up & running with Google Sheets, including signing in, creating & managing spreadsheets, and navigating the menus & settings

• Identify and interpret fundamental spreadsheet and data literacy concepts, including data terminology, data types, data validation rules, conditional formatting, and sorting & filtering

• Identify and interpret formulas syntax, reference types, and errors, as well as math, logical, text, date, and lookup functions

• Identify and interpret examples of analyzing data with pivot tables, including their source data structure, calculation options, calculated fields, and sorting, filtering & grouping

• Identify and interpret examples of visualizing data with charts & graphs, line & area charts, bar & column charts, combo charts, pie & donut charts, scatterplots, and maps

• Identify options for sharing & collaborating in Google Sheets, including access types, roles, comments, edit history & notifications, protecting sheets, and publishing to the web

CPE ACCREDITATION DETAILS:

• CPE Credits: 10

• Field of Study: Information Technology

• Delivery Method: QAS Self Study

Maven Analytics LLC 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.

For more information regarding administrative policies such as complaints or refunds, please contact us at admin@mavenanalytics.io or (857) 256-1765.

*Last Updated: May 14, 2024