Practice Video: Trace Precedents and Dependents

Loading...
View Syllabus

Skills You'll Learn

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

Reviews

4.8 (3,651 ratings)
  • 5 stars
    83.48%
  • 4 stars
    14.10%
  • 3 stars
    1.88%
  • 2 stars
    0.27%
  • 1 star
    0.24%
UA

Jul 21, 2020

Practice Challenge of Week 6 is very difficult. It would be great if the team could add the step by step video on how to solve that challenge. It will be a big help for all the future learners.

LH

Jul 16, 2020

although is super tough to answer all the questions, but involved whole process until end makes me feel that I become more successful and valuable person. really encourage try this course.

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

  • Nicky Bull

    Nicky Bull

    Excel Consultant
  • Dr Prashan S. M. Karunaratne

    Dr Prashan S. M. Karunaratne

    Lecturer - Teaching & Leadership | FHEA
  • A/Professor Yvonne Breyer

    A/Professor Yvonne Breyer

    Director, Learning & Teaching| Head, Learning Futures

Explore our Catalog

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