• Premium
  • Computer Awareness
  • 10 lessons
  • About 1 h 59 min

Spreadsheets: Advanced

Advanced course on Spreadsheets (Computer Awareness): harder problems and exam-level speed.

About this course

Advanced course on Spreadsheets (Computer Awareness): harder problems and exam-level speed.

What you will learn, lesson by lesson

  1. Cell references: relative, absolute and mixed Predict what a formula becomes when copied by understanding relative, absolute and mixed cell references.
  2. 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.
  3. Lookups, sorting and filtering Use VLOOKUP and related ideas, sort and filter data correctly, and read lookup results by hand.
  4. Charts, errors and data analysis tools Choose the right chart type, recognise common error values and understand pivot tables and conditional formatting.
  5. 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. 1 Cell references: relative, absolute and mixed About 13 min Free preview
  2. 2 Functions: IF, SUMIF, COUNTIF and logical tests About 14 min Premium
  3. 3 Lookups, sorting and filtering About 13 min Premium
  4. 4 Charts, errors and data analysis tools About 12 min Premium
  5. 5 Mixed advanced problems on spreadsheets About 13 min Premium
  6. 6 Text and date functions: LEFT, RIGHT, MID, LEN, TRIM and date arithmetic About 13 min Premium
  7. 7 Rounding and counting functions: ROUND, INT, MOD, COUNTA, MEDIAN and RANK About 13 min Premium
  8. 8 How formulas react: copying, moving, inserting, deleting and other sheets About 14 min Premium
  9. 9 Multi-step problems: mark sheets, grade bands and conditional totals About 14 min Premium
  10. 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.

Keep going

Privacy · Terms · Refunds · Delivery