Excel and Google Sheets essentials
Format data, write formulas, look things up, and turn a table into pivots and charts in Excel or Google Sheets.
4 modules · 12 lessons · about 3 hours · Beginner
What you'll be able to do
Use spreadsheets confidently for everyday work.
- Cells, ranges, data types and formatting that makes a sheet readable.
- Write formulas, copy them safely with $ references, and fix errors.
- Summaries, decisions with IF and SUMIF, and lookups across tables.
- Sort, filter, pivot and chart a table to answer real questions.
Course outline
1Getting around a spreadsheet
- Cells, rows and columns
- Entering and formatting data
- Making sheets easy to read
2Formulas and references
- Your first formulas
- Relative and absolute references
- Reading and fixing formula errors
3Functions you'll use every day
- Everyday functions
- Decisions with IF, COUNTIF and SUMIF
- Lookups with XLOOKUP and VLOOKUP
4Making sense of your data
- Sorting and filtering
- Pivot tables
- Charts that make the point
How you'll learn
- Short lessons that build on each other, so every step makes sense.
- A tutor you can ask anytime. It knows the lesson you're on.
- Quick checks along the way, so you know it stuck.
Questions
Is Excel and Google Sheets essentials really free?
Yes. Make a free account and start right away. No card needed, and nothing to cancel later.
Do I need any experience?
No. It starts from zero and explains each new idea as it comes up.
How long does it take?
12 lessons in all, about about 3 hours in total. Go at your own pace: your progress is saved.
What if I get stuck?
Ask the tutor. It knows the lesson you're on and explains things another way until it clicks.
Can I learn on my phone?
Yes. Lernelle works in any browser, on your phone, tablet or computer.
Does it stay up to date?
Yes. We update the course when things change, and you can bring the new version into yours with one click.
Ready to start?
It takes a minute to sign up, and the first lesson is waiting.