دورة من ONLEARN
Automate Your Workflow with Google Apps Script in Sheets
Unlock powerful custom functions, triggers, and automations directly within your spreadsheets to save hours and eliminate manual tasks.
متوسطEnglish3 أقسام5 ساعات515 متعلّماً
ما ستتمكّن من فعله
- Write basic to intermediate Google Apps Script functions to automate tasks in Google Sheets.
- Understand and utilize Sheet, Range, and Cell objects for data manipulation.
- Create custom menus and dialogs to trigger scripts directly from Google Sheets.
- Implement event-driven scripts (e.g., onOpen, onChange) for dynamic automation.
- Debug Apps Script code effectively using the built-in debugger and Logger service.
- Automate email notifications and data transfers between sheets.
- Develop practical, real-world automation solutions for common spreadsheet tasks.
داخل هذه الدورة
3 أقسام · 15 نشاطاً · 5 ساعات إجمالاً
01Getting Started with Google Apps Script
- Introduction to Google Apps Script and the Script Editor10:00
- Your First Script: 'Hello World' in Google Sheets15:00
- Understanding Script Bindings and Permissions12:00
- Working with Logger and Basic Debugging10:00
- Exercise: Create a Simple Greeting Function20:00
02Interacting with Google Sheets Data
- Accessing Sheets, Ranges, and Cells15:00
- Reading and Writing Data to Cells and Ranges20:00
- Manipulating Rows and Columns15:00
- Filtering and Sorting Data with Scripts18:00
- Exercise: Data Cleanup and Formatting25:00
03Advanced Scripting and Automation Triggers
- Creating Custom Menus and Dialogs15:00
- Understanding Event-Driven Triggers (onOpen, onChange)18:00
- Time-Driven Triggers and Schedulers15:00
- Sending Automated Emails with GmailApp20:00
- Project: Automated Daily Report Emailer30:00
عن هذه الدورة
Unlock the power of automation in Google Sheets! This intermediate course teaches you to write custom scripts with Google Apps Script, transforming repetitive tasks into efficient, one-click solutions.
لمن هذه الدورة
- Office professionals and data analysts who use Google Sheets regularly.
- Anyone looking to automate repetitive tasks and save time in their workflow.
- Business owners or team leads seeking to streamline data management processes.
- Individuals interested in learning practical coding skills for productivity gains.
قبل أن تبدأ
- A Google account (free to create)
- Basic familiarity with Google Sheets functions and interface
- No prior coding experience required, but basic logic understanding is beneficial
تجارب التعلّم
281 تقييماًتقييمات المتعلّمين
4.8 / 5 · متوسط تقييم المتعلّمين
تفاصيل مفيدة
كيف سأتعلّم؟
تابع أقسام الدورة وأنشطتها في مشغّل الدورات على Onlearn بالوتيرة التي تناسبك. يُحفظ تقدّمك في حسابك.
هل هذا اشتراك؟
لا. تُشترى كل دورة بشكل منفرد بدفعة واحدة.