This course is designed for those interested to learn the basics of Google Sheets and its many functionalities, how to style cells, add formulas, create custom functions, and return search results into a Google Sheet. Read more.
I'm here to help you learn, achieve your dreams, come join me on this amazing adventure today. Providing Web development courses and digital marketing
Access all courses in our library for only $9/month with All Access Pass
Get Started with All Access PassBuy Only This CourseAbout This Course
Who this course is for:
- Web developers
- App developers
- Coders who want to explore how to use Google Apps Script
- Anyone who wants to learn more about Google Apps Script
- JavaScript developers who want to add a new language to their portfolio
- Anyone who wants to create amazing apps
- Anyone who wants to power up their Google Suite of Products with really amazing features
What you’ll learn:Â
- Appending new rows of content to Google Sheets
- Setting styling like font size to cells
- Setting of formulas within cells
- Updating values dynamically
- Using of UI object within the spreadsheetÂ
- Creating custom functions
- Getting and updating cell data
- Creating content from spreadsheet as HTML tables – then email or use it in a web app
- Sending emails to active users
- Copying spreadsheet as a PDF – creating a blob and emailing the PDF
- Selecting and getting active selected content
- Searching option added to user menu – searching Google Drive folders and returning results into Sheet
- Adding folder search results to a spreadsheet
- Checking for values in sheet and updating column values depending on result
- Copying and duplicating of sheet contents
Requirements:Â
- JavaScript and prior coding experience
- Prior programming experience
- A Google account
Google Sheet has a lot of really great functionality. In the course lessons, we will be exploring how to make use of some of these functions, adding them to mini projects where you are encouraged to build and extend upon.Â
Source code is included so you can copy and paste the code to try for yourself.
Our Promise to You
By the end of this course, you will have learned more of how to use Google Sheets.
10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.
Get started today and learn more about the functions of Google Sheets.
Course Curriculum
Section 1 - Introduction | |||
Spreadsheet App Introduction | 00:00:00 | ||
Bound Script Starter Lesson | 00:00:00 | ||
Add More Content To Spreadsheet | 00:00:00 | ||
Spreadsheet Formulas | 00:00:00 | ||
Update Sheet Content | 00:00:00 | ||
Spreadsheet UI | 00:00:00 | ||
Finder And Replace Content | 00:00:00 | ||
Finder And Replace Content 2 | 00:00:00 | ||
Get Cell Values | 00:00:00 | ||
Get Content As HTML | 00:00:00 | ||
Email Spreadsheet HTML Table | 00:00:00 | ||
Copy Spreadsheet As PDF | 00:00:00 | ||
Copy Spreadsheet As PDF 2 | 00:00:00 | ||
Copy Spreadsheet As PDF 3 | 00:00:00 | ||
Content Copy | 00:00:00 | ||
Search Drive Files | 00:00:00 | ||
Search Drive Files 2 | 00:00:00 | ||
Value Checker If Exists | 00:00:00 | ||
Course Conclusion Code Review | 00:00:00 | ||
Finder And Replace Content | 00:00:00 |
About This Course
Who this course is for:
- Web developers
- App developers
- Coders who want to explore how to use Google Apps Script
- Anyone who wants to learn more about Google Apps Script
- JavaScript developers who want to add a new language to their portfolio
- Anyone who wants to create amazing apps
- Anyone who wants to power up their Google Suite of Products with really amazing features
What you’ll learn:Â
- Appending new rows of content to Google Sheets
- Setting styling like font size to cells
- Setting of formulas within cells
- Updating values dynamically
- Using of UI object within the spreadsheetÂ
- Creating custom functions
- Getting and updating cell data
- Creating content from spreadsheet as HTML tables – then email or use it in a web app
- Sending emails to active users
- Copying spreadsheet as a PDF – creating a blob and emailing the PDF
- Selecting and getting active selected content
- Searching option added to user menu – searching Google Drive folders and returning results into Sheet
- Adding folder search results to a spreadsheet
- Checking for values in sheet and updating column values depending on result
- Copying and duplicating of sheet contents
Requirements:Â
- JavaScript and prior coding experience
- Prior programming experience
- A Google account
Google Sheet has a lot of really great functionality. In the course lessons, we will be exploring how to make use of some of these functions, adding them to mini projects where you are encouraged to build and extend upon.Â
Source code is included so you can copy and paste the code to try for yourself.
Our Promise to You
By the end of this course, you will have learned more of how to use Google Sheets.
10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.
Get started today and learn more about the functions of Google Sheets.
Course Curriculum
Section 1 - Introduction | |||
Spreadsheet App Introduction | 00:00:00 | ||
Bound Script Starter Lesson | 00:00:00 | ||
Add More Content To Spreadsheet | 00:00:00 | ||
Spreadsheet Formulas | 00:00:00 | ||
Update Sheet Content | 00:00:00 | ||
Spreadsheet UI | 00:00:00 | ||
Finder And Replace Content | 00:00:00 | ||
Finder And Replace Content 2 | 00:00:00 | ||
Get Cell Values | 00:00:00 | ||
Get Content As HTML | 00:00:00 | ||
Email Spreadsheet HTML Table | 00:00:00 | ||
Copy Spreadsheet As PDF | 00:00:00 | ||
Copy Spreadsheet As PDF 2 | 00:00:00 | ||
Copy Spreadsheet As PDF 3 | 00:00:00 | ||
Content Copy | 00:00:00 | ||
Search Drive Files | 00:00:00 | ||
Search Drive Files 2 | 00:00:00 | ||
Value Checker If Exists | 00:00:00 | ||
Course Conclusion Code Review | 00:00:00 | ||
Finder And Replace Content | 00:00:00 |
Great Course
I really enjoyed this course. It is was excellently paced and very informative.