Google Sheets Intermedio: Domina la alternativa a Excel

Discover the power of Google Sheets, a versatile online spreadsheet program! This course will guide you through everything you need to know, from the basics to advanced techniques, and show you how it stacks up against Microsoft Excel. You'll learn to perform all the familiar operations you’re used to, and much more.

By the end of this course, you will be able to:

• Create Google Sheets from scratch: Build your own spreadsheets with ease.
• Master advanced functions: Unlock powerful capabilities with functions like QUERY, FILTER, UNIQUE, JOIN, and IMPORTHTML.
• Build insightful reports: Utilize tools like pivot tables, charts, dashboards, and macros to visualize and analyze your data.
• Seamlessly integrate with Excel: Work with Excel files in Google Sheets and convert between Sheets and Excel formats.
• Automate data collection: Connect Google Forms to Sheets for effortless data input.

We'll explore key topics including:

• What is Google Sheets? Understand its core features and purpose.
• Google Sheets vs. Excel: Learn the key differences and advantages of using Sheets.
• Benefits of using Sheets: Discover why Google Sheets is a powerful and collaborative tool.
• Basic Operations: Become proficient in essential tasks like copying, selecting, and filtering data.
• Understanding Google Sheets: Explore how Sheets works, how to share it, and utilize features like Filter Views and Explore Panel.
• Calculations in Sheets: Learn to use functions and formulas, including named ranges and conditional formatting.
• Exclusive Sheets Functions: Dive into powerful functions like QUERY, SPARKLINES, SPLIT, and GOOGLE TRANSLATE.
• Reporting & Visualization: Create compelling pivot tables, charts, and dashboards to present your data effectively.
• Data Migration: Easily migrate data between Sheets and Excel.
• Advanced Features: Explore macros for automation and leverage the power of Google Forms for data collection.

This course is perfect for anyone looking to enhance their data management skills and leverage the power of the cloud with Google Sheets.