
효율성 100배 UP! 일잘러의 실무엑셀
스터디파이
실무엑셀을 처음 접하거나, 기초에서 심화 단계로 업그레이드 하고 싶은 분들을 위한 강의입니다.
입문
Excel
Even those with no coding experience can automate Google Sheets and Apps Script tasks! I will teach you the easiest way by creating examples that can be used in actual work.
189 learners

Automation with Google Sheets and Apps Script
Automate email delivery of certificates, diplomas, and quotes
Google Apps Script Basics
 There are many people who repeat the same task over and over again.
 Get off work faster with task automation 🔥

To: Startup marketers and managers, solopreneurs, small business owners, non-profit managers, and freelancers!
💸Without complex development environments or project setup, automate finance, taxation, HR, customer management, and communication with just free tools like Google Sheets and Apps Script ! Learn easily and enjoyably with real-world examples . We'll help you build a solid foundation for automating tasks with Apps Script.
You can create this kind of automation with Google Sheets and Apps Script.
Example 1. Sending payslips to all employees in 10 seconds.
Example 2. Complete month-end accounting with a single click.
Example 3. Send text messages directly from Google Sheets without having to visit a cumbersome text messaging site.
Example 4. A Slackbot that automatically monitors exchange rates, stock prices, and financial data.
#1
A practitioner who was tired of multitasking and repetitive tasks in tax, finance, HR, customer management, and customer communication, and created automation himself, will tell you.
#2
We'll share the automation features you've created so your colleagues can use them right away, and we'll also share practical tips to help you use them more conveniently yourself.
In this class, we will create an example of ' automating customer and employee email communication' .
 Part 1. Apps Script Basics
 Learn how to integrate AppsScript with Sheets. 
 Part 2. Sending Bulk Emails
 Learn how to send emails with different recipients, subject lines, and content based on data entered in a sheet. 
 Part 3. Create a personalized PDF and send it via email.
 Learn how to create individual PDF files (certificates, completion certificates, and quotations) and send them via email as attachments. 
Q. When and who would benefit from attending the lecture?
 A small business owner who stays alone until late at night every month to close the accounts .
 Small startup managers and marketers who have to do all customer management work manually
 Non-profit organization operators who must manage members while also performing other tasks.
 Freelancers who suffer from the same tax and settlement work every time! 
If you feel like you could automate something but can't seem to find a way to get started, I'm confident this course will be helpful. Once you understand a little more about how to do it, you'll discover new ways to do it.
Q. I've never coded before. Will this be okay? What level of instruction will the class be?
Yes, even if you have absolutely no coding experience, it's okay. I'll explain everything step-by-step so even "no coding experience" can take the course. Even though I hadn't studied coding before, I learned only what I needed as I built the automation features I needed.
Q. What can I make by taking the class?
This course is conducted through hands-on exercises. You'll learn how to send personalized emails in bulk and how to send emails with personalized attachments to customers. You can immediately apply these exercises to automate awards, certificates, membership cards, and quotations. Furthermore, you can explore the necessary features yourself and freely develop your own.
 Hello! This is Dougie, the creator of this lecture.
 As a non-developer and co-founder, I've handled various tasks (tax, finance, accounting, customer service, customer support, HR, etc.) before I started working on automating my work. I hope this helps more people free themselves from repetitive tasks!
Who is this course right for?
Freelancer, small business owner: One person covers a wide range of tasks
Startup Manager: Finance, Tax, HR
Marketer, Account Manager: Communications, CS
Nonprofit Organization Worker: Membership Management, Business Operations
189
Learners
29
Reviews
2
Answers
4.9
Rating
1
Course
안녕하세요 더기입니다
프리랜서, 1인 대표, 스타트업 매니저, 운영자님들을 위한 업무 자동화 / 구글 시트 / 앱스 스크립트 강의를 진행합니다.
운영,재무,세무,CS 등 멀티 플레이어로 일했던 지난 경험, 노하우를 꼭꼭 담아 쉽고 재미있게 알려드릴게요😇
질문, 강의, 컨설팅 문의 : workwithdugi@gmail.com
All
16 lectures ∙ (1hr 33min)
All
29 reviews
4.9
29 reviews

Reviews 1
∙
Average Rating 5.0
5
한줄 한줄 이해가 정말 잘 됩니다. 코딩에 대한 지식 없고, 막연히 업무 자동화에 도전해보고 싶다는 분들에게 진심으로 추천드립니다. 장점은 1. 초심자의 눈높이에 맞춰서 쉽게 설명해주십니다 2. 수업에 나오는 예제가 이해하기 쉽고, 업무에 적용하기도 쉽습니다. 전자책, 회원가입 이메일, cs 이메일 등 불특정 다수에게 보내는 업무 등에 적용하기 쉽습니다. 3. 불필요하게 어려운 표현이나 방법이 없습니다. 개인적으로 가장 만족한 부분입니다. 저희가 슈퍼코딩사이어인이 될 게 아니겠죠? 자동화를 통해 짜치는 업무를 빠르게 해내고자 하는데, 이를 위해 신청한 사람들의 눈높이에 맞게 편하게 설명해주십니다. 인프런 강의 중에 가장 만족합니다. 다음 강의에는 이런 게 있으면 좋겠습니다. 1. 특정 시트에서 '오늘' 새롭게 등록된 열에게만 메일 보내기 등 과거 데이터 말고 새로 입력된 데이터만 보내기 2. 마지막 영상에서 말씀주신 문자보내기 등도요.

Reviews 1
∙
Average Rating 5.0
5
아직 수강 중이지만, 강사님이 친절하게 하나씩 설명해주셔서 도움 많이 받고 있습니다! 처음에 var, function 같은 언어가 익숙하지 않더라도, 계속 듣다보니 좀 더 직관적으로 이해가 되더라고요 ㅎㅎ 얼른 실무에 적용해보고 싶습니다
안녕하세요! 따뜻한 바다코끼리님:) 코딩 경험이 없더라도 바로 적용해보실 수 있게 최대한 쉽게 설명하려 노력했습니다. 먼저 이론을 다 배우는 것이 아닌 필요한 코딩을 그때그때 조금씩 습득하면서 만들면 좀 더 기억에 잘남고 이후에도 유용하게 사용할 수 있더라구요. 강의 진행하다가 궁금한 점이 생기시면 언제든 질문을 남겨주세요 :) 감사합니다

Reviews 1
∙
Average Rating 5.0

Reviews 2
∙
Average Rating 5.0
5
정말 재미있게 잘 봤습니다! 많은 업무 자동화 강의들 있지만 그 중에서도 가장 실용적이고 발군이라고 생각합니다. 90분 안에 이렇게 많은 내용을 담아내시다니 놀랍네요. 아울러 끝에서 보여주신 LMS 기능의 경우 외부 API를 사용하는 것일까요? 꼭 LMS가 아니더라도, 외부 API를 끌고 와서 하는 작업들을 보여주시면 큰 도움이 될 것 같습니다. 감사합니다.
외부 LMS 처럼 구글 외부에 있는 기능들은 외부 API를 사용해야합니다. 다음 강의에서는 외부 API를 활용하는 내용도 포함하도록 준비해볼게요 :)
$15.40
Explore other courses in the same field!