Back to Catalog
Using AI for Spreadsheet Data Preparation and Analysis
- Duration
- 2 days
- Format
- Intensive Course
- Competency Levels
- Role-Based Application
Clean data, create classifications, formulas, and insight summaries.
The Kerjabaik Academy team can discuss the schedule, delivery format, and your organization's in-house requirements.
Request ScheduleLearning Outcomes
- Read data structure
- Clean spreadsheets
- Write data insights
Learning Topics and Activities
- 1.Reading Data Structure
- 2.Data Cleaning
- 3.Formulas and Light Analysis
- 4.Insight and Data Narrative
- 5.Simple Visualization
Designed for
- Data admins
- Analysts
- Finance staff
- Program staff
Challenges Discussed
- Spreadsheet data is inconsistently structured
- Insights are hard to extract
- Visualizations do not communicate findings clearly
Practical Activity
Clean data, create classifications, formulas, and insight summaries.
Practical Deliverables
- Clean table
- Formula
- Insight
- Simple chart
Responsible Use Practices
- Source validation
- Practical deliverable rubric
- Work-context review
Tools and Resources
- ChatGPT
- Gemini
- Microsoft Copilot
- Google Docs / Microsoft Word
- Google Sheets / Microsoft Excel