Understanding Range Names in Excel

1. Topics

1.1. Benefiting from Use

1.2. Using Range Names

1.2.1. Navigating with Range Names

1.2.2. Using a Range Name in a Formula

1.2.3. Using Range Names in VBA Code

1.2.4. Setting Print Areas

1.2.5. Marking Data Entry Locations

1.3. Creating Range Names

1.3.1. Using the Name Manager

1.3.2. Using the Name Box

1.3.3. Creating Row/Columns Range Names

1.3.4. Testing the Range Name

1.3.5. Modifying Range Names

1.3.5.1. Adjust Existing Range Names

1.3.5.2. Delete a Range Name

2. Questions

2.1. Benefits of using Range Names

2.2. Uses of Range Names

2.3. Ways to Create a Range Name

3. Pre-Assessment

4. Learners

4.1. Assessments

4.2. Quizzes

4.3. Questions

5. Concerns

5.1. Ensure users come back for more

5.2. Doing a "soft" evaluation vs. an analytical  evaluation

5.3. Keeping content engaging

6. Quizzes

6.1. Step by Step Questions

6.2. Multiple Choice

6.3. Select the Correct Feature

6.4. True/False

7. Post-Assessment

8. Badges

8.1. Good Job

8.2. Way to Go

8.3. Expert

9. Social Media

9.1. Self-Maintained Community