MySmartCoPilot

Your country

Tools that support it use your country for local currency, number formats, units and paper size. Your choice is saved only in this browser.

Data and databases

Excel & Google Sheets

The planned outline of 16 modules. Lessons are written, run and reviewed before they are published.

Coming soon 16 modules

Coming soon. This track is being written. Below is its planned outline: a lesson appears here once its examples have been run and its technical review is signed off.

Planned outline

  1. Module 1

    Start here: apps, cells, formats and sharing

    Coming soon
  2. Module 2

    Formulas, references and names

    Coming soon
  3. Module 3

    Percentages, logic and conditional totals

    Coming soon
  4. Module 4

    Text: clean, split and extract

    Coming soon
  5. Module 5

    Dates, times and working days

    Coming soon
  6. Module 6

    Lookups: VLOOKUP, INDEX-MATCH and XLOOKUP

    Coming soon
  7. Module 7

    Tables, validation and conditional formatting

    Coming soon
  8. Module 8

    Get data in and clean it

    Coming soon
  9. Module 9

    PivotTables and summary formulas

    Coming soon
  10. Module 10

    Charts and dashboards

    Coming soon
  11. Module 11

    Dynamic arrays, LET and LAMBDA

    Coming soon
  12. Module 12

    What-if analysis, Solver and statistics

    Coming soon
  13. Module 13

    Financial functions (education only)

    Coming soon
  14. Module 14

    Power Query and the Data Model

    Coming soon
  15. Module 15

    Protect, test and audit workbooks

    Coming soon
  16. Module 16

    Automation, Python and AI

    Coming soon

Related tools

Excel Viewer (XLSX, XLS, ODS, Numbers) Open any spreadsheet without Excel — every sheet, formula and comment, nothing uploaded. CSV to Excel Converter CSV to .xlsx without losing leading zeros, phone numbers or long IDs. Excel to CSV Converter Turn any sheet into clean CSV — every sheet at once, title rows and merged cells fixed. Compare Two Excel or CSV Files See exactly which rows were added, removed or changed between two spreadsheets. Chart Maker (Graph from Data) Paste a table, pick a suggested chart, download it — all in your browser.

Official documentation

More in Data and databases