Cikgu Tawfiq

Primary School Educator
Educational Technology Specialist
Data-Driven Innovator

My Areas of Expertise

Google Sheets

Organize, analyze, and visualize data efficiently with powerful spreadsheet tools.

Basic

- Intro to Google Sheets UI
- Data types and formatting
- Sorting & filtering
- Basic formulas (SUM, AVERAGE, IF)
- Data validation & dropdowns
- Conditional formatting

Advanced

- Nested formulas & custom functions
- Query function
- ArrayFormula, Regex
- ImportRange & connected Sheets
- Sheets as database backend
- Automation with Apps Script basics

Google AppSheet

Build custom no-code apps to automate workflows and improve task management.

Basic

- What is AppSheet?
- Connect Google Sheet to AppSheet
- Create basic app (CRUD)
- App interface design basics
- User input forms
- Deploy to mobile

Advanced

- Multi-table relationships
- Deep links & actions
- Workflow automation
- Conditional logic & visibility
- Custom UX views (dashboard, map, gallery)
- App performance optimization

Google Looker Studio

Transform raw data into interactive dashboards and reports for informed decision-making.

Basic

- Intro to Looker Studio
- Connect Sheets as data source
- Create charts & tables
- Filtering with controls
- Layout & design tips

Advanced

- Blend data from multiple sources
- Use calculated fields
- Create interactive dashboards
- Date functions & filters
- Drill-down reports
- Report sharing & publishing securely