Skip to main content
Home Programming with Excel VBA
Main navigation
  • Home
  • Lists
    Lessons Exercises Badges Patterns Principles
  • Search
  • Login
Lessons
  • + Getting ready
    • What is the course about?
    • Why should you care?
    • How the course runs
    • Working together
    • Gather.Town
    • Using this site
    • Exercises
    • Feedback
    • When you get stuck
    • How to succeed
    • Set up Excel
    • Your professor
    • Let's get into it!
  • + Simple programs
    • The first program
    • Writing the first program
    • Adela's turn
    • Generalize
    • Dialogs
    • Numeric expressions
    • Strings
    • Easy is good
    • Debugging
    • More debugging
    • Another worked example
    • Exercises
  • + Decisions
    • If-then-else
    • Logical operators
    • Multiway
    • Nested ifs
    • Guard pattern
    • Basic validation: strings
    • Basic validation: numeric
    • Better vladidation
    • Tickets walkthrough
    • Exercises
  • + Data analysis
    • Data tables
    • Ranges
    • Processing a Range
    • Normalizing
    • Range validation
    • Validate then process
    • Exercise walkthrough
    • Filtering
    • Min and max
    • Adela programs
    • Exercises
  • + Extras
    • Common errors
    • Excel objects
    • Excel on Macs
    • Rounding numbers
    • Shortcut keys
    • VBA documentation

Exercise walkthrough

Here's another worked example, in video this time.

Cthulhu captures humans who stray on its goat lands. Over the last year, it has asked each human their age, and to rate their liking of goats. Write a program to analyze the data. It should show stats for liking, for humans within an age range.

Book traversal links for Exercise walkthrough
  • ‹ Validate then process
  • Up
  • Filtering ›

Creative Commons Attribution-ShareAlike 4.0      Terms of use      Powered by Skilling