ITG195

Master Google Sheets: Complete Training Course

Q: What will I learn in this Introduction to Google Sheets course?

You'll learn comprehensive Google Sheets skills including navigating the cloud-based interface, efficient data entry and formatting, essential functions like SUM, IF, and VLOOKUP, creating pivot tables and charts for data analysis, automation using macros and Google Apps Script, time-saving shortcuts, and best practices for collaboration and data security. The course covers everything from basic spreadsheet operations to advanced data analysis techniques.

Q: What are the prerequisites for this course?

This is a beginner-level course that requires only basic IT skills. No prior experience with Google Sheets is necessary, though basic computer literacy and familiarity with general software applications will be helpful. The course is designed to accommodate students, entry-level professionals, and managers at all levels.

Q: How does Google Sheets differ from Microsoft Excel, and will this be covered?

Yes, understanding the key differences between Google Sheets and Microsoft Excel is one of the core learning objectives. The course specifically covers the unique cloud-based features of Google Sheets, its collaborative capabilities, and how its interface and functionality compare to Excel, helping you transition smoothly between the two platforms.

Q: Will I learn advanced features like automation and scripting?

Absolutely! The course includes a dedicated section on automation where you'll explore built-in functions, learn to create and use macros, and get introduced to Google Apps Script for automating repetitive tasks. This will significantly enhance your productivity and workflow efficiency.

Q: What teaching methods are used in this course?

The course uses a variety of engaging teaching methods including lectures, slide presentations, hands-on labs for practical experience, real-world case studies to demonstrate business applications, and interactive Q&A sessions. This multi-modal approach ensures you gain both theoretical knowledge and practical skills.

Q: How long is this course and what can I expect to accomplish in that time?

This is an intensive 1-day course designed to take you from beginner to proficient Google Sheets user. In this concentrated timeframe, you'll master essential functions, learn advanced data analysis techniques, discover automation capabilities, and gain practical skills for real-world business applications through hands-on exercises and case studies.

Q: Will I receive a certificate upon completion?

This course does not include a formal certification. However, you will gain comprehensive practical skills and knowledge that you can immediately apply in your work environment. The focus is on building real-world competency in Google Sheets rather than formal credentialing.

Q: Where is the training conducted?

Our online trainings are conducted usually using Zoom or Google Meet. Our physical trainings are normally held in Common Ground, Bangsar South .

Q: Can international participants join this course?

Please check the Available in section to see which countries the course is available in. If your country is not listed, please contact us.

Q: What is the difference between public, corporate, and training provider pricing?

Public pricing : applies for individuals signing up from different companies. Corporate pricing : applies if a company wants to have an intake for its employees only. Training provider pricing : applies only for other training providers looking to hire our trainers and use our content. Our content has a licensing fee.

Unlock the full potential of Google Sheets with our expertly designed course! Dive into essential features like pivot tables, advanced formulas, automation techniques, and more under expert guidance. Transform your workflow with practical skills tailored specifically for real-world applications.

Available in:
Malaysia

Face-to-Face Nov 23, 2026 9:00 AM - 5:00 PM Habil Hadi Mohammed

Created: February 7th 2025, 4:11 PM MYT Last Modified: November 14th 2026, 6:00 AM MYT

updated

beginner

We price match

Public Pricing

MYR 1750

Corporate Pricing

Pax:

Training Fees: MYR 6500/day

Total Fees: MYR 6500 ++

Training Provider Pricing

Pax:

Training Fees: MYR 2400/day

Material Fees: MYR 400

Total Fees: MYR 2800 ++

Features

1 day

8 modules

15 intakes

Full life-time access

English

Technical: 25 pax

Target Audience

students

managers

executives

Methodologies

lecture

slides

labs

case studies

q&A

Subsidies

What you'll learn

Create pivot tables and charts for advanced data analysis
Implement best practices for data security and collaboration
Automate tasks using macros and Google Apps Script
Apply time-saving keyboard shortcuts for increased productivity
Utilize essential functions like SUM, IF, and VLOOKUP
Master efficient data entry and basic formatting techniques
Understand the cloud-based interface of Google Sheets
Learn key differences between Microsoft Excel and Google Sheets

Why should you attend?

This course provides a comprehensive introduction to Google Sheets, a powerful cloud-based spreadsheet application. Participants will begin by exploring the user-friendly interface of Google Sheets and understanding its key differences from Microsoft Excel. This foundational knowledge will enable users to navigate their workspace efficiently and customize basic settings to suit their needs. The course progresses into data entry and formatting essentials, where learners will gain skills in efficient data entry, cell management, and basic formatting techniques. These skills are crucial for maintaining clarity and consistency across multiple sheets. As participants advance, they will delve into mastering functions and formulas, learning essential functions such as SUM, IF, and VLOOKUP. The section also covers writing and troubleshooting formulas to enhance productivity. Advanced data analysis tools are introduced next, with a focus on creating pivot tables and charts for insightful data visualization. Learners will apply conditional formatting and utilize the QUERY function for sorting and filtering data effectively. Automation is another key component of this course, where participants explore built-in functions, macros, and Google Apps Script to automate repetitive tasks. Finally, the course offers valuable hacks and efficiency tips for time-saving shortcuts and effective collaboration strategies. Participants will learn about data validation, error handling, and best practices for data security. Real-world applications are discussed to demonstrate how Google Sheets can solve business challenges while ensuring effective sharing practices.

Course Syllabus

Day 1

Module 1

Module 2

Short Break

15 mins

Module 3

Module 4

Recap and Q&A

15 mins

Lunch

1 hour

Module 5

Module 6

Short Break

15 mins

Module 7

Module 8

Recap and Q&A

15 mins

End of Day 1

Ratings and Reviews

( 0 ratings )

( 0 reviews )

Instructor

Tasmeea Rahman Data Analytics & Engineering Training Specialist

Trainer Profile

TTT Certificate

TTT Accreditation

Tasmeea Rahman is a highly accomplished corporate trainer and academic professional with a unique blend of technical expertise and pedagogical excellence. Currently pursuing her PhD in Project Management with a focus on Energy Management in the electrical power industry at Universiti Putra Malaysia, she maintains an exceptional 4.00/4.00 CGPA while actively contributing to the professional training landscape. With extensive experience as a Freelance Corporate Trainer since 2023, Tasmeea specializes in delivering comprehensive training programs across multiple domains. Her training portfolio encompasses advanced data analytics tools including Python, Power BI, Minitab, Jaspersoft, Apache Superset, and TIBCO Spotfire, as well as machine learning applications. She also excels in teaching engineering design software such as AutoCAD, Autodesk Fusion 360, Solid Edge, and Autodesk 3Ds Max for both 2D and 3D electrical and mechanical designs. Her project management training capabilities further complement her diverse skill set. Her academic credentials are impressive, holding a Master of Engineering Management from Universiti Putra Malaysia (CGPA: 3.713/4.00), an MBA in Marketing from the University of Dhaka (CGPA: 3.61/4.00), and a Bachelor's degree in Electrical and Electronics Engineering. This multidisciplinary educational background enables her to bridge technical concepts with business applications effectively. As an Adjunct Lecturer at Leading University, she demonstrated her ability to develop curricula and deliver engaging lectures on complex electrical and electronics subjects, including VLSI design, digital signal processing, and microprocessor systems. Tasmeea's research contributions are noteworthy, with publications in high-impact journals including a first-author paper in Renewable and Sustainable Energy Reviews (Q1, Impact Factor: 15.9) and co-authored works in IEEE Access. She holds a Train the Trainer Certification from HRD Corp Malaysia and is certified in Agile Project Management by Google. Her technical proficiency spans programming languages like Python and C++, engineering software including MATLAB and CISCO Packet Tracer, and various data analytics platforms. With her combination of industry experience, academic rigor, and certified training expertise, Tasmeea delivers practical, industry-relevant training that empowers professionals to excel in their respective fields.

8 Students

93 Courses

8 Years

( 3 ratings )

100%

( 3 reviews )

Instructor

Dr. Esther Suria Kala ICT & Cybersecurity Training Expert

Trainer Profile

TTT Certificate

Dr. Esther Suria Kala is a highly accomplished ICT consultant and corporate trainer with nearly 30 years of extensive experience in information technology, project management, and organizational development. As the founder of Angel Software Solutions, she has established herself as a versatile and dedicated professional who delivers cutting-edge training solutions across Malaysia and internationally.

Her academic credentials are exceptional, including a PhD in Psychology with a focus on Human Behaviour and Human Resources, an MBA in Finance, and degrees in both Computer Science and Human Resources. Currently pursuing a second PhD in IT Information Security, Dr. Esther demonstrates an unwavering commitment to continuous learning and staying at the forefront of technological advancement. Her educational foundation is complemented by an impressive array of professional certifications, including Microsoft Certified Trainer (MCT), CISSP, ITIL, SAP Certified Associate, Certified Cyber Security Professional, Data Scientist, AI Engineering, and ECBA certifications.

Dr. Esther's technical expertise spans an extensive range of domains, from traditional programming languages like Java, C++, and PHP to modern technologies including Python, AI coding, machine learning, RPA, and IR 4.0 microservices. She is proficient in database management systems including Microsoft SQL Server and Oracle, web development frameworks, and enterprise solutions like SAP Crystal Reports and SharePoint Server. Her knowledge extends to cybersecurity, ethical hacking, network administration, and data analytics, making her uniquely qualified to address both technical and strategic business challenges.

As a trainer, Dr. Esther excels in bridging the gap between technical complexity and practical application. She delivers comprehensive training programs for both IT and non-IT professionals, covering everything from software development and cloud computing to soft skills such as digital marketing, business analysis, customer service, and project management. Her ability to communicate effectively in both English and Bahasa Malaysia enables her to connect with diverse audiences across different organizational levels.

Her impressive client portfolio includes leading organizations such as Maybank, Telekom Malaysia, Malaysian Airlines, Tenaga Nasional Berhad, Bank Negara, Ministry of Education, Ministry of Finance, and numerous multinational corporations. This extensive experience across banking, telecommunications, government, aviation, and technology sectors demonstrates her adaptability and deep understanding of varied industry requirements. Recognized with the Outstanding Achievement Award in Information Technology from University Malaya in 2013, Dr. Esther continues to empower organizations through innovative training solutions that drive digital transformation and professional excellence.

226 Courses

English, Malay, Hindi, German, Tamil

30 Years

( 0 ratings )

( 0 reviews )

Instructor

Habil Hadi Mohammed Additive Manufacturing & 3D Printing Specialist

Trainer Profile

Habil Hadi Mohammed is a highly skilled Mechanical Engineer and Research Fellow specializing in advanced manufacturing technologies, with particular expertise in additive manufacturing, 3D printing, and functionally graded materials (FGM). Currently pursuing his PhD in Biomedical Engineering at Universiti Putra Malaysia (UPM), he combines strong academic credentials with practical engineering experience to deliver innovative solutions across multiple industries. With a Master's degree in Manufacturing Systems Engineering (CGPA 3.81/4) and a Bachelor's in Mechanical Engineering, Habil has established himself as an expert in the rapidly evolving field of additive manufacturing. His research focuses on cutting-edge topics including multi-material 3D printing, material extrusion processes, and surface finishing techniques for FDM printed parts. His work has been recognized at international conferences in Slovenia, Malaysia, and Hong Kong, where he has presented papers on FGM implementation and material flow control in additive manufacturing. As a Research Fellow at UPM since 2021, Habil has demonstrated exceptional capabilities in software development, automation, and prototype design. He has successfully developed software for multi-material FGM 3D printers, designed automated sports equipment, and created hydroponic plant systems. His current role as a Developer Engineer for an international Swiss company showcases his ability to bridge theoretical knowledge with practical application, where he designs, programs, and develops machines using both 3D printing and conventional manufacturing techniques. Habil's technical proficiency spans multiple programming languages including Python, C/C++, Arduino, XCode, and Swift, complemented by expertise in CAD software such as AutoCAD, Fusion360, ANSYS, and SolidWorks. His analytical skills are enhanced by proficiency in data analysis tools including Minitab, SPSS, and Python. Beyond technical skills, his management experience as an Area Manager demonstrates strong leadership abilities, having successfully doubled sales through strategic planning and employee training. Multilingual and culturally adaptable, Habil brings a unique global perspective to engineering challenges, making him an invaluable asset for organizations seeking innovation in manufacturing technology and engineering education.

120 Courses

English

9 Years

( 0 ratings )

( 0 reviews )

Instructor Reviews

Tasmeea Rahman

Data Analytics & Engineering Training Specialist

"Tasmeea was an excellent teacher. Very pleasant, willing to assist and answer concerns, and continuously asked how she could assist more. She made the course enjoyable as well as informative."

"Thank you so much for your invaluable guidance. I really enjoyed it and appreciated how much fun you made it! I feel much more equipped to cope with difficult challenges."

"The training was both fascinating and beneficial. Many members of the staff commented on how useful it was. Tasmeea delivers the topic with authority, wit, and passion."

FAQ

Frequently Asked Questions About This Course

What will I learn in this Introduction to Google Sheets course?

What are the prerequisites for this course?

How does Google Sheets differ from Microsoft Excel, and will this be covered?

Will I learn advanced features like automation and scripting?

What teaching methods are used in this course?

How long is this course and what can I expect to accomplish in that time?

Will I receive a certificate upon completion?

Where is the training conducted?

Can international participants join this course?

What is the difference between public, corporate, and training provider pricing?

Do I have to pay right away?

I just enrolled in an intake. Does that mean I can attend the course on that date?

What happens if quorum for an intake is not reached?

Why should you attend?

What you'll learn

Create pivot tables and charts for advanced data analysis
Implement best practices for data security and collaboration
Automate tasks using macros and Google Apps Script
Apply time-saving keyboard shortcuts for increased productivity
Utilize essential functions like SUM, IF, and VLOOKUP
Master efficient data entry and basic formatting techniques
Understand the cloud-based interface of Google Sheets
Learn key differences between Microsoft Excel and Google Sheets

Course Syllabus

Day 1

Module 1

Module 2

Short Break

15 mins

Module 3

Module 4

Recap and Q&A

15 mins

Lunch

1 hour

Module 5

Module 6

Short Break

15 mins

Module 7

Module 8

Recap and Q&A

15 mins

End of Day 1

Instructor Reviews

Tasmeea Rahman

Data Analytics & Engineering Training Specialist

"Tasmeea was an excellent teacher. Very pleasant, willing to assist and answer concerns, and continuously asked how she could assist more. She made the course enjoyable as well as informative."

"Thank you so much for your invaluable guidance. I really enjoyed it and appreciated how much fun you made it! I feel much more equipped to cope with difficult challenges."

"The training was both fascinating and beneficial. Many members of the staff commented on how useful it was. Tasmeea delivers the topic with authority, wit, and passion."

We price match