Up & Running with Google Sheets
Maven Analytics,Enrique Ruiz
5:57:03
Description
Learn Google Sheets for data analysis and visualization, and build data literacy skills with fun, real-word projects!
What You'll Learn?
- Learn how to create and manage worksheets and navigate the Google Sheets interface
- Build foundational data literacy skills, including managing, exploring, analyzing and visualizing data
- Write formulas and functions to aggregate values, create logical tests, join data, and manipulate text and dates
- Use Pivot Tables to explore and analyze data, including grouping, sorting, filtering and more
- Learn data visualization and storytelling best practices, and bring data to life using common charts and graphs
- Apply sharing and collaboration tools like notes, comments, timelines, protection, and web publishing
Who is this for?
What You Need to Know?
More details
DescriptionThis is a hands-on, project-based course designed to help you build the skills you need to manage, explore, analyze, and visualize data in Google Sheets.
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.
COURSEÂ OUTLINE:
Intro to Google Sheets
In this section we’ll introduce Google Sheets, create & manage spreadsheets, explore its interface, review important settings, and draw comparisons with Microsoft Excel
Spreadsheet Fundamentals
In this section we’ll cover spreadsheet fundamentals, including data literacy concepts like tables, cell references, sorting & filtering, data types, formatting, and more
Formulas &Â Functions
In this section we’ll introduce essential formulas & functions you need to work with data in Google Sheets, including math, logical, text, date, and lookup functions
Data Analysis with Pivot Tables
In this section we’ll cover exploring & analyzing data with pivot tables, Google Sheets’ essential “drag & drop†tool that lets you perform calculations without formulas or functions
Data Visualization with Charts &Â Graphs
In this section we’ll cover visualizing data with charts & graphs, including how to identify the right chart type, how to format it properly, and how to use it to tell a story
Sharing &Â Collaboration
In this section we’ll cover Google Sheets’ sharing & collaboration options, including sharing spreadsheets with others, collaborating in real time, setting notifications, and more
__________
Ready to dive in? Join today and get immediate, LIFETIME access to the following:
6 hours of high-quality video
6 quizzes
Up &Â Running with Google Sheets ebook (100+Â pages)
Downloadable project files &Â solutions
Expert support and Q&AÂ forum
30-day Udemy satisfaction guarantee
If you're ready to build powerful, practical data literacy and analytics skills with Google Sheets, this is the course for you.
Happy learning!
-Enrique Ruiz (Lead Excel &Â Google Sheets Instructor, Maven Analytics)
Who this course is for:
- Spreadsheet users who want to build job-ready data prep, analysis, visualization and collaboration skills
- Data professionals looking for an intuitive, comprehensive introduction to Google Sheets
- Students looking to learn practical skills with unique, hands-on projects and demos
- Anyone looking to develop core data literacy and analytical thinking skills
This is a hands-on, project-based course designed to help you build the skills you need to manage, explore, analyze, and visualize data in Google Sheets.
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.
COURSEÂ OUTLINE:
Intro to Google Sheets
In this section we’ll introduce Google Sheets, create & manage spreadsheets, explore its interface, review important settings, and draw comparisons with Microsoft Excel
Spreadsheet Fundamentals
In this section we’ll cover spreadsheet fundamentals, including data literacy concepts like tables, cell references, sorting & filtering, data types, formatting, and more
Formulas &Â Functions
In this section we’ll introduce essential formulas & functions you need to work with data in Google Sheets, including math, logical, text, date, and lookup functions
Data Analysis with Pivot Tables
In this section we’ll cover exploring & analyzing data with pivot tables, Google Sheets’ essential “drag & drop†tool that lets you perform calculations without formulas or functions
Data Visualization with Charts &Â Graphs
In this section we’ll cover visualizing data with charts & graphs, including how to identify the right chart type, how to format it properly, and how to use it to tell a story
Sharing &Â Collaboration
In this section we’ll cover Google Sheets’ sharing & collaboration options, including sharing spreadsheets with others, collaborating in real time, setting notifications, and more
__________
Ready to dive in? Join today and get immediate, LIFETIME access to the following:
6 hours of high-quality video
6 quizzes
Up &Â Running with Google Sheets ebook (100+Â pages)
Downloadable project files &Â solutions
Expert support and Q&AÂ forum
30-day Udemy satisfaction guarantee
If you're ready to build powerful, practical data literacy and analytics skills with Google Sheets, this is the course for you.
Happy learning!
-Enrique Ruiz (Lead Excel &Â Google Sheets Instructor, Maven Analytics)
Who this course is for:
- Spreadsheet users who want to build job-ready data prep, analysis, visualization and collaboration skills
- Data professionals looking for an intuitive, comprehensive introduction to Google Sheets
- Students looking to learn practical skills with unique, hands-on projects and demos
- Anyone looking to develop core data literacy and analytical thinking skills
User Reviews
Rating
Maven Analytics
Instructor's Courses
Enrique Ruiz
Instructor's Courses
Udemy
View courses Udemy- language english
- Training sessions 85
- duration 5:57:03
- Release Date 2023/12/16
