Main content
Back to Catalog

Using AI for Spreadsheet Data Preparation and Analysis

Duration
2 days
Format
Intensive Course
Competency Levels
Role-Based Application

Using AI for Spreadsheet Data Preparation and Analysis equips participants to produce clean table, formula, insight through hands-on, work-based practice.

The Kerjabaik Academy team will help adjust the schedule, format, and your organization's in-house needs.

Request Schedule

Learning Outcomes

  • read data structure
  • clean spreadsheets
  • write data insights

Learning Topics and Activities

  1. 1.Reading Data Structure
  2. 2.Data Cleaning
  3. 3.Formulas and Light Analysis
  4. 4.Insight and Data Narrative
  5. 5.Simple Visualization

Designed for

  • data admins
  • analysts
  • finance staff
  • program staff

Challenges Addressed

  • spreadsheet data is messy
  • insights are hard to extract
  • visualizations are not communicative

Practical Activity

Clean data, create classifications, formulas, and insight summaries.

Learning Outputs

  • clean table
  • formula
  • insight
  • simple chart

Responsible Use Practices

  • source validation
  • output rubric
  • work-context review

Tools

  • ChatGPT
  • Gemini
  • Microsoft Copilot
  • Google Docs / Microsoft Word
  • Google Sheets / Microsoft Excel