Excel and Spreadsheets Essentials
Get comfortable with spreadsheets, from tidy tables to formulas and charts.
See the courseSQL for Beginners
Ask a database questions and get answers in seconds.
- Beginner
- 5 modules
- About 4 hours
- Free preview
Free while the course is in review.
You'll be able to
- Pick the columns and rows you need
- Sort and filter results
- Count and total with GROUP BY
- Combine two tables with a JOIN
Who it's for
Beginners who want a first technical data skill for analyst or tech roles.
What you'll learn
Tables and SELECT
Read a table and pick the columns you want to see.
Filter and sort
Use WHERE to keep the rows you need and ORDER BY to sort them.
Count and total
Summarise rows with COUNT, SUM and GROUP BY.
Join two tables
Combine customers and orders using the ID they share.
Check your answers
Test a query on a small sample and make sure the numbers make sense.
Final project
Write the queries that answer three questions about a small shop database, and check each answer makes sense.
Taught your way
- Pick simple words or more detail, and more or fewer pictures.
- Lessons fit 10, 20 or 40 minute sessions.
- Already know some of it? A quick check lets you skip ahead.
- Every lesson ends with practice and feedback on your own work.
Learner ratings
No ratings yet. Only learners who have practised in this course can rate it, so every rating here is from someone who took it.
Taken this course? Log in after practising to leave a rating.
Good next courses
Data Analysis Basics
Ask good questions of data, clean it, and explain what you found.
See the coursePython for Beginners
Write your first small programs and automate simple tasks with Python.
See the courseQuestions
All questionsIs the same course the same for everyone?
The modules and what you are checked against are the same, so everyone learns the same skills. How each lesson is explained, and the examples it uses, change for you.
Do I need any experience?
No. Every course starts from the basics. If you already know some of it, an optional two-minute check lets you skip ahead.
How much does it cost?
While courses are in preview and their content is being reviewed, you can start them for free. Prices will be shown on each course page before any course goes on sale.
What if I don't understand a lesson?
Choose "Try it another way" under any idea to get it simpler, with more detail, with another example, as a picture or as a story. You can also ask your learning companion a question.
Preview: lessons and feedback are still being reviewed, and courses are not on sale yet.