- Premium
- Computer Awareness
- 10 lessons
- About 1 h 59 min
Spreadsheets: Advanced
Advanced course on Spreadsheets (Computer Awareness): harder problems and exam-level speed.
Start: Cell references: relative, absolute and mixed
Sign in to keep track of your progress.
About this course
Advanced course on Spreadsheets (Computer Awareness): harder problems and exam-level speed.
What you will learn, lesson by lesson
- Cell references: relative, absolute and mixed Predict what a formula becomes when copied by understanding relative, absolute and mixed cell references.
- Functions: IF, SUMIF, COUNTIF and logical tests Write and read IF, nested IF, AND, OR, SUMIF and COUNTIF formulas and compute their results by hand.
- Lookups, sorting and filtering Use VLOOKUP and related ideas, sort and filter data correctly, and read lookup results by hand.
- Charts, errors and data analysis tools Choose the right chart type, recognise common error values and understand pivot tables and conditional formatting.
- Mixed advanced problems on spreadsheets Solve combined problems with references, functions, lookups and charts by evaluating formulas step by step.
Lessons in this course
- 1 Cell references: relative, absolute and mixed About 13 min Free preview
- 2 Functions: IF, SUMIF, COUNTIF and logical tests About 14 min Premium
- 3 Lookups, sorting and filtering About 13 min Premium
- 4 Charts, errors and data analysis tools About 12 min Premium
- 5 Mixed advanced problems on spreadsheets About 13 min Premium
- 6 Text and date functions: LEFT, RIGHT, MID, LEN, TRIM and date arithmetic About 13 min Premium
- 7 Rounding and counting functions: ROUND, INT, MOD, COUNTA, MEDIAN and RANK About 13 min Premium
- 8 How formulas react: copying, moving, inserting, deleting and other sheets About 14 min Premium
- 9 Multi-step problems: mark sheets, grade bands and conditional totals About 14 min Premium
- 10 Final self-assessment: advanced spreadsheets Premium
Questions about this course
Should I do Foundation first?
If Spreadsheets is new to you, yes. Start with Spreadsheets: Foundation, then Practice, and come back to this course after.
Is this course free?
This is a premium course. Lessons marked “Free preview” are open to everyone.
How do I keep track of what I've finished?
Create a free account and sign in. Each lesson you finish is saved to your account and shown here and on your dashboard.
Student reviews
No reviews yet. Students who finish a lesson can rate this course.