Mastering Google Sheets: From Basics to Automation
A comprehensive instructor-led course guiding you from Excel fundamentals to advanced data analysis, automation, and dashboard creation. Ideal for beginners and professionals seeking practical, job-oriented Excel skills for modern workplaces.
1 instructor teaches this course
20
menu_book
Classes & activities
Starts at
₹23,600Inclusive of GST
What you'll be able to do after completing these classes
done
Confidently navigate Microsoft Excel, manage files, and use sharing and permission features for effective collaboration.
done
Apply formulas, functions, Pivot Tables, lookups, and charts to analyze, visualize, and report data efficiently.
done
Automate tasks and build interactive dashboards using advanced Excel features, culminating in a collaborative, portfolio-ready project.
Classes and Activities
person_outline
Google Sheets Interface, Drive & Sharing Basics
1 hr
expand_more
Get familiar with the Google Sheets interface, understand Google Drive organization, and learn the basics of sharing and permissions.
person_outline
Data Entry & Navigation
1 hr
expand_more
Master data entry methods, keyboard shortcuts, and navigation tools to work efficiently in Google Sheets.
person_outline
Basic Formulas & Cell References
1 hr
expand_more
Explore the use of basic formulas and the importance of relative, absolute, and mixed cell references in calculations.
Learn to retrieve data efficiently using VLOOKUP and the more flexible INDEX-MATCH combination in Google Sheets.
person_outline
Charts & Visualization
1 hr
expand_more
Explore different chart types and visualization tools in Google Sheets to communicate your data insights clearly.
About the course
This 10-weeks hands-on, instructor-led course is designed to take you from the basics of Microsoft Excel to advanced features and automation. You'll learn to navigate Excel, manage files, and collaborate effectively. The curriculum covers essential data entry, organization, formatting, and analysis using formulas, functions, Pivot Tables, and charts. You'll also explore advanced tools such as lookups, data validation, automation with macros and scripts, and AI-powered features. The course emphasizes real-world applications, collaborative workflows, and culminates in a portfolio-ready dashboard project, making it perfect for analysts, finance professionals, HR, marketing, operations, educators, and remote teams.