Course Information
Course Overview
If you want to learn data analysis? If you want to automate your work? Succeed in your career! This course is for you!
What Students Will Learn:*
1. Master the art of dynamic modeling for enhanced automation and reduced manual workload.
2. Effectively manage people and resources through strategic deployment of Google Sheets.
3. Visualize matrices, including Net Promoter Score and performance metrics.
4. Utilize Google Sheets for task delegation and efficient tracking.
*Requirements for the Course:*
1. A free Google account.
2. No prior spreadsheet knowledge required.
3. A computer and a passion for learning.
*Practical Learning Experience Includes:*
- Practice sheets accompanied by detailed lectures.
- Quizzes to reinforce understanding.
- Challenging bonus activities with solutions for hands-on application.
*Who Should Enroll:*
- Professionals aspiring for roles in operations, Work Flow Management (WFM), training, and audit departments.
- Newly promoted team leads/managers seeking effective team management techniques.
- Students eager to gain knowledge for career success.
- Freshers commencing their professional journey.
- Beginners desiring a structured, engaging, and practical Google Sheets course.
*Benefits of the Course:*
- Empowerment to create dynamic models and captivating dashboards.
- Proficiency in managing large datasets and conducting efficient data analysis.
- Increased confidence in navigating and using advanced features of Google Sheets.
*Course Learnings Include:*
- Proficient navigation in Google Sheets and utilization of basic features.
- Data filtering, sorting, and presentation techniques for visually appealing sheets.
- Application of logical functions (IF, SUM, AVERAGE, etc.) for complex problem-solving.
- Integration of multiple functions for comprehensive task solutions.
- Importing data seamlessly from various sheets.
- Dynamic creation of charts and graphs for effective data visualization.
Guaranteed to be both enjoyable and intellectually rewarding, this course promises a significant learning curve for all participants.
Course Content
- 10 section(s)
- 41 lecture(s)
- Section 1 About this course!
- Section 2 Introduction to google sheet
- Section 3 Basic google sheet functions
- Section 4 Let's try some logic!!
- Section 5 Let's visualize data!!
- Section 6 Let's Sort things!! and Filter!
- Section 7 Let's Create some charts!!
- Section 8 Data Validation
- Section 9 Let's create dynamic dashboard!
- Section 10 Dealing with errors!!
What You’ll Learn
- Learn to create Dynamic modelling (Less manual work and more automation)
- Learn to manage people and resources effectively using google sheets.
- Learn to visualise matrices( NET PROMOTER SCORE, PERFORMANCE ETC)
- Learn to use google sheets for delegating task and track them effectively.
Skills covered in this course
Reviews
-
FFaisal Pathan
the course was really informative.
-
ddeepak mishra
good
-
MManisha Luthra
It is going good but since usually very basic things are already known to most people,we can directly come to the point as well.
-
TTanya Agarwal
very good explanation from the basic