Мастер Google Таблиц: Полный курс по аналитике автоматизаци

Course Overview

• Course Title: Мастер Google Таблиц: Полный курс по аналитике автоматизаци
• Instructor: PapaHR
• Target Audience:
  • Beginners with basic Excel skills
  • Professionals looking to enhance analytical skills
  • Users with a Google account
  • Individuals interested in optimizing work processes
• Prerequisites:
  • Basic knowledge of Excel or other spreadsheet editors
  • Willingness to learn new Google Sheets functions
  • Access to a Google account
  • Desire to develop analytical skills and optimize work processes

Curriculum Highlights

• Key Topics Covered:
  • Introduction to Google Sheets and differences from Excel
  • Document creation and access management
  • Document formatting
  • Pivot tables
  • Basic formula usage
  • Counting and summing functions
  • Text functions
  • Logical functions
  • Date and time functions
  • Range functions (VLOOKUP, HLOOKUP, etc.)
  • Unique, filter, and sort functions
  • QUERY function and queries
  • Miscellaneous functions (IMAGE, hyperlinks, text translation, data import)
  • Charts
  • Sparklines
  • Google Forms and survey processing
  • Macros and add-ons
• Key Skills Learned:
  • Understanding Google Sheets capabilities
  • Collaborative document management
  • Effective document formatting
  • Using pivot tables and formulas
  • Working with counting, summing, logical, and text functions
  • Applying functions for dates, ranges, text, and numbers
  • Utilizing advanced tools like QUERY, IMAGE, hyperlinks
  • Creating charts and sparklines
  • Automating processes with macros and add-ons
  • Solving real business tasks

Course Format

• Duration: 18 hours on-demand video
• Format: Self-paced online course
• Resources:
  • Access on mobile and TV
  • Certificate of completion