COURSE INFORMATION 

COURSE DESCRIPTION 

Are you tired of drowning in disorganized data? It's time to stop just "using" spreadsheets and start mastering them. Google Sheets is more than just a place to store numbers—it's a dynamic, collaborative, and powerful tool that can transform how you manage projects, analyze performance, and make data-driven decisions.

TARGET PARTICIPANTS 

This programme is suitable for: 

• Non-finance managers 

• Executives and supervisors 

• Professionals with non-heavy data usage 

• Project managers and team members 

• Team members working simultaneously 

LEARNING OBJECTIVES 

Upon completion of this programme, participants will be able to: 

• Understand the basis of Google Sheets and its functionality 

• Create formulas, data visualization  

• Improve collaborative efforts 

• Create pivot table for charts and data analysis 

• Create visualizations that are engaging and informative 

• Use Google specific functions in reporting  

ENTRY REQUIREMENTS/ PRE-REQUISITES (IF APPLICABLE) 

• No formal pre-requisites required 

• Suitable for employees at all organisational levels 

EXPECTED BENEFITS TO ORGANISATION 

• Navigate the Google Sheets environment and confidently utilize the primary menu, tools, and shortcuts for efficient operation. 

• Accurately input and structure data within sheets 

• Apply essential formatting techniques including custom number formats, text wrap, and basic conditional formatting. 

• Utilize foundational formulas such as SUM, AVERAGE, COUNT, and basic arithmetic operations to perform common calculations. 

• Organize data effectively using built-in tools for sorting data (single and multi-column) and applying basic filters. 

• Create simple, clear charts and graphs to visualize data trends and share insights quickly. 

• Collaborate in real-time by sharing workbooks, managing access permissions, and using comments effectively. 

LEARNING OUTCOMES 

At the end of the programme, participants will be able to demonstrate: 

• Knowledge 

  • Improve collaboration within team with improved communication and common understanding of goals. 

  • Familiarity with Google Sheet as an alternative for et as an data entry, cleaning and analysis 

• Skills 

  • Use Google Sheets to create an engaging report and analysis to turn data into information.  

• Workplace Application 

  • Use Google Sheets for real time update and up-to-date reports.  

MODULE BREAKDOWN 

Module 1: Introduction to Sheets for Data Analysis 

• What is Google Sheets? 

• Comparing Sheets to Excel 

• Google Sheets Keyboard Shortcuts 

• Navigating Google Sheets 

• Maintaining / Changing file name 

• Let’s start collaborating! 

• Controlling the data – version history & activity dashboard 

Module 2: Data Manipulation and Cleaning 

• Removing duplicates 

• Trim whitespace 

• Text corrections 

• Splitting column 

• Merge columns 

• Data formats 

• Google Sheets unique features 

Module 3: Data Management and Structuring 

• Named ranges 

• Data validation 

• Conditional formatting 

Module 4: Data Analysis with Function & Formulas 

• Understanding formulas and functions 

• Using formulas 

• Logical functions 

• IF, IFERROR and IFS 

• AND and OR 

• Nested function 

• Mathematical functions 

• COUNTIF, SUMIF, AVERAGEIF 

• COUNTIFS, SUMIFS, AVERAGEIFS 

• Lookup functions 

• VLOOKUP, HLOOKUP, INDEX & MATCH 

• Array formulas and references 

Module 5: Pivot Table & Advanced Analysis 

• Introducing Pivot Tables 

• Creating a Pivot Table 

• Pivot table: Groupings 

• Pivot table: Filtering 

• Pivot table: Slicer 

• Pivot table: Calculated fields 

Module 6: Introduction to Data Visualization  

• Data vs Information 

• The Problem Statement 

• Types of visualization 

Module 7: Creating Charts in Google Sheets

• Creating charts and visualizations 

• Bars & Column Charts 

• Line Chart 

• Pie Chart 

• Scorecard Chart 

• Scatterplot Chart 

• Geo Chart 

Module 8: Advanced Visualization Techniques 

• Using slicers 

• Importing data 

• Sparklines 

Module 9: Building Dashboards in Google Sheets 

• Understanding the Dashboard Concept 

• Best practices in creating a dashboard 

Module 10: Final Project: Building the Prototype Dashboard 

• Participants to build a sample dashboard based on dummy data 

TRAINING METHODOLOGY 

The programme will be delivered using a combination of: 

• Instructor-led lecture 

• Live demonstration 

• Hands-on practical exercises 

• Individual and group activities 

• Case studies based on real workplace data 

ASSESSMENT/ EVALUATION METHOD 

Participants will be assessed through: 

• Case study analysis and group discussion 

• Scenario based exercises 

• Observation and facilitator feedback 

• Post training reflection or assessment 

PROGRAMME DURATION SUMMARY 

Total Training Hours: 14 hours 

• Theory: 45% 

• Practical/ Discussion: 55% 

TRAINING MATERIALS PROVIDED 

• Participant handbook 

• Case Studies and discussion guides 

• Presentation slides 

• Reference materials 

CERTIFICATION 

Certificate of Attendance will be issued upon completion of the programme.