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