Google Sheets for Data Analysis & Business Intelligence

Lo que serás capaz de hacer

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 Google 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 for data analysis, 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 (EDA) and analysis. 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 for data prep and analysis 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 course quizzes 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 (Excel & Google Sheets Instructor, Maven Analytics ) __________ Looking for our full course library? Search " Maven Analytics " to browse our full collection of Excel, Power BI, SQL , Tableau , Python , Alteryx & Machine Learning courses!

Tu certificado lo emite la SEP, no solo una plataforma

Al demostrar la competencia recibes un certificado emitido por la Secretaría de Educación Pública a través del Gobierno del Estado de México: un documento oficial que puedes presentar con confianza ante cualquier empleador o institución.

Tu itinerario, de la inscripción al certificado

Un certificado oficial de la SEP

Sobre tu inscripción