Practice Video: Using Formulas in Data Validation

Loading...
View Syllabus

Skills You'll Learn

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

Reviews

4.8 (3,680 ratings)
  • 5 stars
    83.47%
  • 4 stars
    14.13%
  • 3 stars
    1.87%
  • 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
Data Validation
We kick off this course with data validation and conditional formatting. This module takes you through creating and applying data validation, as well as working with formulas in data validation. This is followed by basic and advanced conditional formatting.

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.