The Ultimate Guide to Design Automation: Mastering Canva AI Generative Design
Masocampus
The era of creating designs one by one is over. Experience the speed of turning "thoughts" into "results" with Canva AI.
입문
AI, canva, Generative AI
Google Spreadsheets Practical Techniques
Google's Excel, Google Spreadsheet! Learn how to use and reference functions in Google Spreadsheet. After taking the course, you will be able to skillfully conduct data analysis with Google Spreadsheet.
25 learners are taking this course
Level Basic
Course period Unlimited
Google Sheets
Google Sheets
Google Sheets
Google Sheets
What you will gain after the course
Data analysis using functions and references
Various visualization techniques for each purpose
Ability to import, preprocess, and manage external data
The ability to easily analyze data with pivot tables
From data analysis to collaboration and pivot tables.
Learn how to use spreadsheets 🗂️
💎 Please check before taking the class!
- This lecture has poor audio quality, so please preview the lecture first.
- Since this is a hands-on course, we recommend bringing a dual monitor or a spare device that allows you to separate the lecture and practice screens. Furthermore, since the practical training will be conducted on a Windows OS, we recommend taking the course on a Windows environment.
- Lecture notes and practice files are available in the <0. Textbook Download Center> section.
Google Spreadsheets
Practical Techniques 📊
Google Drive serves similar purposes to Excel, but has the advantage of being free. It offers access to all essential Excel features, including the VLOOKUP function, charting, and pivot tables, all of which are readily available to any office worker.
We'll begin by learning how to manipulate data freely using functions, references, and conditional calculations. Then, through hands-on examples, you'll learn data visualization techniques as powerful as those found in Excel. We'll also cover how to securely work with Google Spreadsheets' collaborative features, using various sharing settings and permissions.
I recommend this to these people 💁♀️
With Google Spreadsheets
Those who want to do full-scale data analysis
Anyone who wants to create an insight sharing environment
With free business tools
People who want to increase productivity
Starting a business, joining a company, changing jobs, etc.
Dreamers
💡 You can acquire these capabilities.
- Using Functions with Google Spreadsheets
We conduct a practice analysis of customer churn risk using aggregated customer sales data. - Google Spreadsheet Data Visualization
Gain visualization capabilities by creating visualization objects and utilizing sparklines. - Analysis with Pivot Tables
You can summarize and analyze data and apply slicers, just like a pivot table in Excel. - Maintain security with permission management for collaborative work
Collaborate safely with permission settings and communication features for co-editing.
What you'll learn 📚
1. Using functions and references
Performing a sensitivity analysis
2. With LOOKUP data
Create a drop-down menu to view all at once
3. Create a chart
Customize
4. With Pivot Table
Analysis and visualization all in one!
Expected Questions Q&A 💬
Q. Do I need to know how to use Excel pivot tables or references to take this course?
Don't worry if you don't know anything. This course isn't designed for students with Excel knowledge, but rather for those willing to learn Google Spreadsheets.
Q. Can I take the course even if I don't know anything about Google Spreadsheets?
Basically, it is composed of functions similar to Excel, so if you are proficient in Excel, it may not be difficult to take the course. However, if you take Maso Campus' 'Google Spreadsheet Practical Introduction' course, you will be able to take the course with less difficulty, so we recommend taking that course first.
Q. Are there any requirements or prerequisites for taking the course?
Since this is a hands-on course, we recommend bringing a dual monitor or a spare device that allows you to separate the lecture and practice screens. Furthermore, since the practical training will be conducted on a Windows OS, we recommend taking the course in a Windows environment.
Google Spreadsheet Series 💪
Introducing the Knowledge Sharer ✒️
Recommended for
these people
Who is this course right for?
People who dream of starting a business/joining a company/changing jobs/re-skilling/talent transformation
For those who want to perform full-scale data analysis using Google Spreadsheets
For those who want to create an efficient insight sharing environment with appropriate visualization
For those who want to increase productivity with free business tools
9,422
Learners
1,337
Reviews
114
Answers
4.7
Rating
99
Courses
"I will grow more than yesterday. And, I will help those who strive to grow more than yesterday."
With Actionable Content that embodies the sincerity and aspirations of Maso Campus,
100 million cumulative hours of lectures shared online and offline since 2013!
This precious experience and time are always the source of growth for both Maso Campus and our students.
The Miso Campus team strictly adheres to two principles for the growth of us all. 1. Actionable Content that can be put into practice immediately after learning. 2. Respecting the time and effort of participants.
The Miso Campus team strictly adheres to two principles for the growth of us all.
1. Actionable Content that you can actually use after learning 2. Time-Saving Curriculum that respects the participant's time and effort Grow with Miso Campus's Actionable and Time-Saving Curriculum
1. Actionable Content that you can surely use once you learn it
2. Time-Saving Curriculum that respects the time and effort of participants
We hope you will walk the path of growth together with Masocampus's Actionable and Time-Saving Curriculum.
We hope you will walk the path of growth together with Maso Campus's Actionable and Time-Saving Curriculum.
Curriculum
All
16 lectures ∙ (7hr 0min)
Course Materials:
Lecture resources
Published:
Last updated:
Reviews
Not enough reviews.
Please write a valuable review that helps everyone!
$61.60
Masocampus's other courses
Check out other courses by the instructor!
Similar courses
Explore other courses in the same field!
![[Basics] Even those with no coding experience can do it! Automating Google Sheets tasks in 90 minutes강의 썸네일](https://cdn.inflearn.com/public/courses/331717/cover/a395d468-0688-4908-88c2-4d087f24d7b7/thumbnail.jpg?f=avif&w=420)