CosynkAI School · Level 2 · Lesson 2 · Free

Fix and change a table

Names in CAPITALS, phone numbers in five formats, the same client twice, “n/a” where a number should be. Cleaning that by hand takes an afternoon. Today you’ll clean a messy table in one message, add a column with a formula, and catch the AI making a mistake.

15 minutes · Level 2 · Lesson 2 of 8 · Free · Practice file included

By the end of this lesson you will

  • clean a messy table in one message
  • add new columns that calculate by themselves
  • get any Excel formula explained in plain English
  • spot the difference between a correct file and a wrong summary

Inside this lesson

  1. Part 1 · The 2-minute win: Clean a messy customer table
  2. Part 2 · The 3-step check: Trust the file, not the story
  3. Part 3 · Change any table: 6 ready messages
  4. Part 4 · Formulas without learning formulas: Describe it, paste it
  5. Part 5 · Don’t fall into these: Common mistakes

This lesson is free. Open it on your phone or computer and follow the pictures, step by step. Start Lesson 2 free.

Level 2 · Office: all lessons

For office work: Excel files, dashboards, PDFs, email, meetings and presentations with AI.

  1. Lesson 1 · Compare two Excel files (free)
  2. Lesson 2 · Fix and change a table (free)
  3. Lesson 3 · Many files into one Excel
  4. Lesson 4 · Dashboards and charts
  5. Lesson 5 · PDFs and documents
  6. Lesson 6 · Email and meetings
  7. Lesson 7 · Presentations in 15 minutes
  8. Lesson 8 · Your work assistant
  9. Final · Final task + certificate

Other levels: Level 1 · Start · Level 3 · Creative. About CosynkAI School · My account