Beginner To Expert in 6 Hours
Google Sheets Made Easy - Expert Instructor with 25 Years of Experience - Quickly Learn The Fundamentals of Spreadsheets
Lo que serás capaz de hacer
This training provides you everything you need to know about Google Sheets. From the fundamentals, to advanced features, after taking this online class you will be able to use Google Sheets at an expert level. You can learn Google Sheets easily and quickly if it is taught correctly. Developed by a professor with over 25 years of experience teaching individuals of all ability levels "how to use" spreadsheets, Todd McLeod has designed, refined, and perfected this course to make it easy for you to master Google Sheets. In only six hours of video lectures, provided to you in 88 separate lectures so that no one video is too long, you will learn all of the following about Google Sheets: Learn to navigate around Google Sheets Learn to enter and edit data in Google Sheets Learn to adjust the way data and information are displayed in Google Sheets Learn to write formulas quickly and easily with the point-and-click method Learn to use relative, absolute, and mixed references in Google Sheets Learn to create powerful calculations with Google Sheets functions Learn to use documentation so that you can work with every function Learn to visually represent your data with charts in Google Sheets Learn to use Google Sheets data tools like sorting and filtering Learn to " freeze columns and rows " with freeze panes in Google Sheets Learn to remove duplicates from data in Google Sheets Learn to use Google Sheets to leverage data with Pivot Tables & Slicers Learn to format worksheets including conditional formatting Learn to automate Google Sheets tasks with time-saving macros Learn to use passwords in Google Sheets to protect your work in multiple scenarios Learn tips, tricks, and shortcuts in Google Sheets Learn to use printing and sharing in Google Sheets Learn to gather data with Google Forms and have the data put into Google Sheets Learn to create powerful random data generators Learn to use freeze panes, sorting, and filtering Learn to print your worksheets with various formatting Access all of the Google Sheets files used in the videos! This class is guaranteed to teach you Google Sheets. Described as “ fun, ” “ amazing, ” and “ life changing ,” this Google Sheets training will forever transform the way you work with spreadsheets . Try this course for yourself and see how easy it is to master Google Sheets.
- The Ultimate Google Sheets Course - Master Google Sheets - formulas and functions - shortcuts and tips - charts and graphs - for beginners to advanced users
- Taught by a best-selling Udemy author, Udemy Instructor Partner, & Tenured College Professor with 25 years of experience teaching people how to use spreadsheets
- From the fundamentals to advanced features, this training will give you a strong foundation in Google Sheets: formulas, functions, pivot tables, and macros
- Presented in high-quality video lectures, this Google Sheets course will allow you to master Google Sheets and be skilled with all spreadsheets everywhere
- A comprehensive 53 page course outline is included in the course, along with lifetime access, allowing you to review material any time and learn new material
- Hands-on exercises with video solutions, including all Google Sheets files, allow you to apply what you are learning and grow your skills with Google Sheets
Temario
UNIDAD 1 - Course information · 4 leccionesUNIDAD 1 - Course information
UNIDAD 1 - Course information
- Welcome
- Accessing the course files
- All of the course files are here
- Getting your certificate
UNIDAD 2 - An introduction to Google Sheets · 8 leccionesUNIDAD 2 - An introduction to Google Sheets
UNIDAD 2 - An introduction to Google Sheets
- Understanding Google Sheets
- Two essential skills: files & moving files
- Opening Google Sheets and creating a file
- File operations with Google Sheets
- A brief preview of sharing a Google Sheet
- Google drive, sheets, excel, & file extensions
- Exploring Google Sheets interface
- Keyboard shortcuts
UNIDAD 3 - Hands-on exercises · 1 leccionesUNIDAD 3 - Hands-on exercises
UNIDAD 3 - Hands-on exercises
- Hands-on exercise #1
UNIDAD 4 - Getting started with Google Sheets · 8 leccionesUNIDAD 4 - Getting started with Google Sheets
UNIDAD 4 - Getting started with Google Sheets
- A cool preview of Google Docs
- Managing files in Google Drive
- Mouse pointer awareness
- Adding data to Google Sheets
- Formatting numbers in Google Sheets
- Making selections in Google Sheets
- Using the status bar for quick answers
- Managing files in Google Drive
UNIDAD 5 - Hands-on exercises · 2 leccionesUNIDAD 5 - Hands-on exercises
UNIDAD 5 - Hands-on exercises
- Hands-on exercise #2
- Hands-on exercise #3
UNIDAD 6 - The fundamentals of spreadsheets · 4 leccionesUNIDAD 6 - The fundamentals of spreadsheets
UNIDAD 6 - The fundamentals of spreadsheets
- Writing a formula
- Relative & absolute references
- Creating a gradebook
- Creating charts
UNIDAD 7 - Hands-on exercises · 2 leccionesUNIDAD 7 - Hands-on exercises
UNIDAD 7 - Hands-on exercises
- Hands-on exercise #4
- Hands-on exercise #5
UNIDAD 8 - Working with functions in Google Sheets · 11 leccionesUNIDAD 8 - Working with functions in Google Sheets
UNIDAD 8 - Working with functions in Google Sheets
- An introduction to functions
- The sum function & range notation
- Exploring functions and documentation
- Using the average function & documentation
- Creating a gradebook with the functions
- Using the max and min functions, & documentation
- Using the rand and randbetween functions, & documentation
- Comparing concat and concatenation, & documentation
- Using the textjoin function & documentation
- Splitting text on a delimiter and using textjoin
- Using xlookup, and not using vlookup & hlookup
UNIDAD 9 - Hands-on exercises · 6 leccionesUNIDAD 9 - Hands-on exercises
UNIDAD 9 - Hands-on exercises
- Hands-on exercises #6
- Hands-on exercises #7
- Hands-on exercise #8
- Hands-on exercise #9
- Hands-on exercise #10
- Hands-on exercises #11
UNIDAD 10 - Progressing with Google Sheets · 6 leccionesUNIDAD 10 - Progressing with Google Sheets
UNIDAD 10 - Progressing with Google Sheets
- Inserting & deleting columns & rows
- Moving columns, rows, ranges, and cells
- Managing your worksheets in Google Sheets
- Freezing rows & columns
- Hiding rows & columns
- Working with versions
UNIDAD 11 - Hands-on exercises · 1 leccionesUNIDAD 11 - Hands-on exercises
UNIDAD 11 - Hands-on exercises
- Hands-on exercise #12
UNIDAD 12 - Formatting in Google Sheets · 7 leccionesUNIDAD 12 - Formatting in Google Sheets
UNIDAD 12 - Formatting in Google Sheets
- Formatting & feeling
- Changing font formatting
- Adding border & fill formatting
- The paintbrush formatting tool
- Alternating colors (row striping)
- Conditional formatting
- Table formatting
UNIDAD 13 - Hands-on exercises · 1 leccionesUNIDAD 13 - Hands-on exercises
UNIDAD 13 - Hands-on exercises
- Hands-on exercise #13
UNIDAD 14 - Importing & exporting files with Google Sheets · 4 leccionesUNIDAD 14 - Importing & exporting files with Google Sheets
UNIDAD 14 - Importing & exporting files with Google Sheets
- Converting Microsoft Excel files to Google Sheets
- Exporting Google Sheets to Microsoft Excel
- Importing other files types into Google Sheets
- My favorite statistical site
UNIDAD 15 - Hands-on exercises · 1 leccionesUNIDAD 15 - Hands-on exercises
UNIDAD 15 - Hands-on exercises
- Hands-on exercise #14
UNIDAD 16 - Working with data in Google Sheets · 6 leccionesUNIDAD 16 - Working with data in Google Sheets
UNIDAD 16 - Working with data in Google Sheets
- Gathering data with a form
- Generating data - The Outdoor Gear Coop
- Generating data - the name generator
- Removing duplicates
- Filtering data
- Sorting data
UNIDAD 17 - Hands-on exercises · 1 leccionesUNIDAD 17 - Hands-on exercises
UNIDAD 17 - Hands-on exercises
- Hands-on exercise #15
UNIDAD 18 - Pivot tables · 4 leccionesUNIDAD 18 - Pivot tables
UNIDAD 18 - Pivot tables
- An introduction to pivot tables
- Exploring different pivot tables
- Pivot charts
- Pivot tables, charts, and slicers
UNIDAD 19 - Hands-on exercises · 1 leccionesUNIDAD 19 - Hands-on exercises
UNIDAD 19 - Hands-on exercises
- Hands-on exercise #16
UNIDAD 20 - Macros · 2 leccionesUNIDAD 20 - Macros
UNIDAD 20 - Macros
- Introduction to macros
- Another macro example
UNIDAD 21 - Hands-on exercises · 1 leccionesUNIDAD 21 - Hands-on exercises
UNIDAD 21 - Hands-on exercises
- Hands-on exercise #17
UNIDAD 22 - Printing, sharing, & collaborating in Sheets · 5 leccionesUNIDAD 22 - Printing, sharing, & collaborating in Sheets
UNIDAD 22 - Printing, sharing, & collaborating in Sheets
- Printing your Google Sheets
- Sharing a Google sheet
- Working with others on a Google Sheet
- Protecting a Google Sheet
- Using data validation to ensure valid data
UNIDAD 23 - Google Sheets - Useful Articles · 1 leccionesUNIDAD 23 - Google Sheets - Useful Articles
UNIDAD 23 - Google Sheets - Useful Articles
- Supercharge Your Google Sheets Skills with AI
UNIDAD 24 - Congratulations · 2 leccionesUNIDAD 24 - Congratulations
UNIDAD 24 - Congratulations
- Great work!
- Bonus lecture
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 certificado con INEC
- Lo emite la Secretaría de Educación Pública (SEP), a través del Gobierno del Estado de México
- Documento oficial con folio verificable en línea
- Lo otorga la Universidad Tecnológica Fidel Velázquez
Otras plataformas en línea
- Constancia privada emitida por la misma plataforma
- Solo acredita horas cursadas o asistencia
- Sin respaldo de una autoridad educativa
Tu itinerario, de la inscripción al certificado
- 1
Inscripción con pago único
Pagas $2,800 MXN una sola vez y entras de inmediato al curso.
- 2
Estudias a tu ritmo
24 unidades con videos, lecturas y actividades, disponibles 24/7 durante 12 meses.
- 3
Cuestionarios por unidad
Cuestionarios para comprobar lo aprendido.
- 4
Certificado
Emitido por la SEP a través del Gobierno del Estado de México, con folio verificable.
Un certificado oficial de la SEP
Muestra · verificable por folio y QR
- Emitido por la Secretaría de Educación Pública (SEP), a través del Gobierno del Estado de México. No es una constancia privada: es un documento oficial, y ese respaldo marca la diferencia frente a otras plataformas en línea.
- Contenido impartido por Todd McLeod.
- Folio y QR verificables para compartirlo con quien te contrate.
Empieza hoy, a tu ritmo
Un solo pago y acceso inmediato al curso completo durante 12 meses.
- 24 unidades · 89 lecciones · 60 h
- 12 meses de acceso
- Certificado emitido por la SEP (Gob. del Estado de México) con folio verificable
Sobre tu inscripción
¿Cómo es el pago?
Un solo pago de $2,800 MXN. No hay mensualidades ni cargos recurrentes.
¿Cuánto tiempo tengo acceso?
12 meses desde tu inscripción, 24/7, para avanzar a tu ritmo.
¿Quién imparte el contenido?
El curso es impartido por Todd McLeod; INEC gestiona tu inscripción, evaluación y certificado.
¿Qué pasa cuando vence mi acceso?
Puedes renovar tu cuenta tú mismo desde la plataforma, sin trámites ni esperas.
