Cursos
Google Sheets

4 hour course

Google Sheets

4.9 sobre 5 en G2

Try this course with a Free Trial

Want to master Google Sheets? Learn how to create, edit, and format spreadsheets to organize and analyze data efficiently.

Learn to:

Create Professional Spreadsheets
Format Data Effectively
Utilize Formulas and Functions
Collaborate in Real-Time

Features:

Learn by doing simulations
Skill assessments
Certificate

Habilidad	Pre-evaluación	Lección	Post-evaluación	Modo de aprendizaje

Google Sheets Describir

Habilidad	Pre-evaluación	Lección	Post-evaluación	Modo de aprendizaje
Sheets Fundamentals			Aprendizaje verificado
Create Spreadsheets Start a New Google Sheets File and Organize Your Data Efficiently	No empezado	No empezado	No empezado
Open a Spreadsheet Access and Open Existing Google Sheets Files from Drive or Recent Documents	No empezado	No empezado	No empezado
Navigate Spreadsheets Learn How to Move, Scroll, and Select Cells Efficiently in Google Sheets	No empezado	No empezado	No empezado
File Management Manage, Organize, and Access Your Google Sheets Files Effectively	No empezado	No empezado	No empezado
Print Spreadsheets Set Up Print Settings and Page Layouts for Your Google Sheets Documents	No empezado	No empezado	No empezado
Get Help Find Troubleshooting Tips and Support Resources for Google Sheets	No empezado	No empezado	No empezado

Habilidad	Pre-evaluación	Lección	Post-evaluación	Modo de aprendizaje
Edit Spreadsheets			Aprendizaje verificado
Select Cells and Ranges Easily Highlight and Work with Multiple Cells or Ranges in Google Sheets	Cuenta requerida
Edit Cell Data Learn How to Modify, Replace, and Manage Data Entries in Google Sheets
Cut, Copy, and Paste Data Duplicate and Move Data Efficiently Using Copy and Paste Options in Google Sheets
Undo, Redo, and Repeat Easily Reverse Mistakes and Restore Previous Actions in Google Sheets
Use Paste Special Use Paste Special Options to Transpose and Format Data in Google Sheets
Insert and Move Cells Insert, Move, and Manage Columns to Organize Your Data in Google Sheets
Delete Cells Remove Unwanted Cells and Clean Up Your Spreadsheets in Google Sheets
Hide Rows and Columns Hide, Unhide, and Manage Columns to Simplify Your Google Sheets View
Find and Replace Text Quickly Locate and Update Data Using Find and Replace in Google Sheets
Check Spelling Check Spelling Automatically and Correct Errors in Google Sheets

Habilidad	Pre-evaluación	Lección	Post-evaluación	Modo de aprendizaje
Format Spreadsheets			Aprendizaje verificado
Format Text Customize and Clear Text Formatting for a Clean Look in Google Sheets
Align and Merge Cells Combine Multiple Cells to Organize and Format Data in Google Sheets
Cell Borders and Background Colors Apply and Customize Cell Borders to Highlight Data in Google Sheets
Format Numbers and Dates Customize Date Formats to Display Data Clearly in Google Sheets
Adjust Row Height and Column Width Adjust Column Width and Row Height for Better Data Visibility in Google Sheets
Freeze Rows and Columns Freeze or Lock Rows and Columns to Keep Data Visible While Scrolling in Google Sheets
Copy Formatting Copy and Apply Formatting Quickly Using the Format Painter Tool in Google Sheets
Apply Conditional Formatting Use Conditional Formatting to Highlight Trends and Important Data in Google Sheets

Habilidad	Pre-evaluación	Lección	Post-evaluación	Modo de aprendizaje
Formulas and Functions			Aprendizaje verificado
Formula Basics Master Essential Google Sheets Formulas to Automate Calculations and Analyze Data Efficiently
Autofill Quickly Copy Patterns and Sequences Using Autofill in Google Sheets for Faster Data Entry
Sums and Averages Use the SUM Function in Google Sheets to Quickly Add Up Numbers and Calculate Totals Automatically
MIN and MAX Find the Highest and Lowest Values in Google Sheets Using the MIN and MAX Functions
COUNT Use the COUNTIF Function in Google Sheets to Count Cells That Meet Specific Criteria
Insert Functions Learn How to Use Formulas and Functions in Google Sheets to Automate Calculations and Save Time
Absolute and Relative Cell References Lock Cells in Google Sheets with Absolute References to Keep Formulas Consistent When Copying
Cell Range Names Simplify Your Formulas by Creating and Using Named Ranges in Google Sheets

Habilidad	Pre-evaluación	Lección	Post-evaluación	Modo de aprendizaje
Manage Sheets and Data			Aprendizaje verificado
Insert, Rename, and Delete Sheets Manage Tabs in Google Sheets by Adding, Renaming, or Deleting Worksheets Easily
Duplicate, Move, and Hide Sheets Organize Your Google Sheets by Copying, Moving, and Hiding Tabs for Better Workflow Management
Sort Data Organize Your Data Efficiently by Sorting Columns and Rows in Google Sheets
Filter Data Quickly Display Only the Data You Need by Using Filters in Google Sheets
Data Validation Control Data Entry and Prevent Errors with Data Validation Rules in Google Sheets
Protect Spreadsheets Learn how to lock cells and control who can edit your Google Sheets

Habilidad	Pre-evaluación	Lección	Post-evaluación	Modo de aprendizaje
Insert Objects			Aprendizaje verificado
Insert a Chart Visualize Your Data with Charts and Graphs in Google Sheets for Clear Insights
Customize a Chart Edit Chart Titles, Labels, and Legends in Google Sheets to Make Your Data Stand Out
Insert Images Add and Position Pictures in Google Sheets to Enhance Your Spreadsheets Visually
Insert Links Add Hyperlinks in Google Sheets to Connect Cells to Websites, Files, or Other Sheets

Habilidad	Pre-evaluación	Lección	Post-evaluación	Modo de aprendizaje
Share, Collaborate, and Convert			Aprendizaje verificado
Upload and Convert Spreadsheets Easily Import Excel Files and Convert Them to Google Sheets for Online Editing
Download and Email Spreadsheets Save and Export Your Google Sheets as Excel, PDF, or CSV Files for Offline Use
Share Spreadsheets Collaborate in Real Time by Sharing Google Sheets with Teammates and Clients
Collaborate Work Together in Google Sheets by Adding Comments, Notes, and Real-Time Edits
Work with Versions View and Restore Previous Versions in Google Sheets to Track Edits and Changes
Add-Ons Enhance Productivity by Installing and Managing Powerful Add-Ons in Google Sheets