Practice Video: Trace Precedents and Dependents

Video placeholder
Loading...
View Syllabus

Skills You'll Learn

Lookup Table, Microsoft Excel Vba, Data Validation, Microsoft Excel Macro

Reviews

4.8 (8,005 ratings)

  • 5 stars
    84.52%
  • 4 stars
    13.09%
  • 3 stars
    1.79%
  • 2 stars
    0.36%
  • 1 star
    0.22%

DM

Mar 7, 2019

Love this course....It taught me a lot. It was little more challenging but I passed it. I definitely need more practice at doing these formulas and equations. Thank You for offering this great course

EK

Dec 17, 2020

Thank you, dear all Prashan, Nicky and Yvonne! The teaching course has been concise, clear and very user friendly!

I have enjoyed my learning of MS Excel Intermediate II with MacQuarie University.

From the lesson

Formula Auditing and Protection

If you are worried that errors have crept into your worksheet, this module will show you how to check for errors, trace precedents and dependents, resolve circular references, and finally, protect your worksheets and workbooks from further harm.

Taught By

  • Placeholder

    Nicky Bull

    Lecturer and Lead Content Designer

  • Placeholder

    Dr Prashan S. M. Karunaratne

    Senior Lecturer - Teaching & Leadership | SFHEA

  • Placeholder

    Professor Yvonne Breyer

    Deputy Dean, Education and Employability

Explore our Catalog

Join for free and get personalized recommendations, updates and offers.