Excel: Creating Drop-Down Lists

Go to class
Write Review

Free Online Course: Excel: Creating Drop-Down Lists provided by LinkedIn Learning is a comprehensive online course, which lasts for Less than 1 hour of material. The course is taught in English and is free of charge. Upon completion of the course, you can receive an e-certificate from LinkedIn Learning. Excel: Creating Drop-Down Lists is taught by Chris B. Smith.

Overview
  • Learn how to save time and ensure more accurate data by creating drop-down lists in Excel.

Syllabus
  • Introduction

    • Welcome
    1. Drop-Down List Concepts
    • Drop-down list concepts
    2. Set Up a Drop-Down List
    • Step one: Prepare drop-down list data
    • Step two: Create your drop-down list
    • Step three: Input and error messages
    3. Use Drop-Downs to Drive Other Actions
    • Real-world examples
    • Use drop-down lists with VLOOKUP
    4. Reuse a Drop-Down List
    • Extend or delete a drop-down list
    Conclusion
    • Next steps