Ledger DrillBeta
Log inJoin for free

Dates and text

How a spreadsheet stores dates, how to count days and work out due dates, and how to join, split and tidy text that arrives in a mess.

Premium5 rooms43 questions43 min
See the first roomHow a spreadsheet stores a date

Rooms in this module

  1. How a spreadsheet stores a date8 min, easyPremium
  2. How to count the days between two dates8 min, easyPremium
  3. TODAY and how to work out a due date8 min, easyPremium
  4. How to join and split text10 min, easyPremium
  5. How to clean up imported data9 min, mediumPremium

How this works

Each room answers one problem. A task is a few lines of reading, then questions you answer in the books: post to an account, type a figure, sort, match or write a journal. Every answer is marked at once, with the rule behind it. There are no videos.

Questions

How many rooms and questions are in Dates and text?

5 rooms and 43 questions. Every question is marked at once.

How long does it take?

About 43 minutes in all. A room takes 8 to 10 minutes, so you can do one at a time.

Is it free?

No. These rooms need Premium. Each room shows the start of its first task before you pay.

What should I do first?

Looking things up. It is the module before this one in Spreadsheets for the office.