Data Analysis Basics
Ask good questions of data, clean it, and explain what you found.
See the courseExcel and Spreadsheets Essentials
Get comfortable with spreadsheets, from tidy tables to formulas and charts.
- Beginner
- 5 modules
- About 4 hours
- Free preview
Free while the course is in review.
You'll be able to
- Set up a clean table that is easy to read
- Use SUM, AVERAGE and IF without fear
- Sort and filter to find what you need
- Make a simple chart that tells a clear story
Who it's for
Anyone who opens Excel or Google Sheets and feels lost, at work or at home.
What you'll learn
Build a tidy table
Use one row per item and one column per detail, with clear headings.
Your first formulas
Add, average and count numbers with SUM, AVERAGE and COUNT.
Sort and filter
Find the rows you need without deleting anything.
Make decisions with IF
Use IF to label rows, for example 'over budget' or 'fine'.
Charts that tell a story
Pick the right chart and label it so anyone can read it.
Final project
Build a monthly budget sheet with a tidy table, totals, an over-budget flag and one clear chart.
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
Ratings are not available right now.
Good next courses
SQL for Beginners
Ask a database questions and get answers in seconds.
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.