The Ideal Gas Law with a Spreadsheet
Channel: Chris Armstrong
Date: 2020-12-31

This video covers how to solve Ideal Gas Law problems with a spreadsheet. A fairly trivial task -- but a good starting point for solving more complex things when you have to keep track of your variables and get instant answers to changes.

00:12 -- Wolfram|Alpha
01:04 -- Demo of complete version
02:45 -- Setting up for manual calculations
05:19 -- Defined names and ranges
08:34 -- Different values of the Gas Constant
13:20 -- Selecting your units with data validation and drop-downs
15:18 -- Changing the gas constant depending on your drop-down selection
18:00 -- Using VLOOKUP to extend your units
23:23 -- VBA buttons