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!
  • Your learning style
  • + Simple programs
    • The first program
    • Writing the first program
    • Adela's turn
    • Generalize
    • Dialogs
    • Numeric expressions
    • Strings
    • Secluded Cells
    • 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 validation
    • Vladidation in C#
    • Exercises
  • + Data analysis
    • Data tables
    • Ranges
    • When Ranges have blank data
    • Processing a Range
    • Normalizing
    • Range validation
    • Exercise walkthrough
    • Validate then process
    • Filtering
    • Min and max
    • Adela programs
    • Exercises
  • + Tips
    • Blocked macros
    • Common errors
    • Excel objects
    • Excel on Macs
    • Rounding numbers
    • Shortcut keys
    • VBA documentation
    • Pseudents

Lessons

Here are all of the lessons in the course. Click on a heading to sort.

Title Order in course Sort descending Tags
Generalize 21
Dialogs 22 Dialogs
Numeric expressions 23
Strings 24
Secluded Cells 25 Variables
Easy is good 26
Debugging 27
More debugging 28 Debugging
Another worked example 29
Exercises 30
Decisions 31 If
If-then-else 32 If
Logical operators 33 If
Multiway 34 If
Nested ifs 35 If
Guard pattern 36
Basic validation: strings 37
Basic validation: numeric 38
Better validation 39
Vladidation in C# 40 Validation

Pagination

  • First page « First
  • Previous page ‹‹
  • Page 1
  • Current page 2
  • Page 3
  • Page 4
  • Next page ››
  • Last page Last »

DO NOT START HERE

Read the lessons on the left of the screen. All exercises are embedded in the lessons.

Creative Commons Attribution-ShareAlike 4.0      Terms of use