Welcome to a video library for using Excel as a problem-solving and communication tool. SCROLL DOWN to browse the topics that may help you answer some of your own questions.
Check out Jay’s Toolbox YouTube Channel for playlists.
Intro and Roadmap (000) – Intro and roadmap for the Excel video series (under construction). Download static slides for this presentation.
Simple Starting Example (020) – Worked-out start-to-finish example problem, creating a simple team tool.
Add, Subtract, Multiply Divide (025) – Basic math operations. Basic troubleshooting of your formulas.
SUM and AVERAGE (030) – How to sum and average a range in Excel. Download Excel worked-out examples (BasicMath.xlsx) at: https://jaystoolbox.vt.domains/download/basic-excel-functions-and-examples/
COUNT and COUNTA (035) – How to count values and text entries in a large list or table.
Cell References in Formulas (040) – Using absolute and relative cell references when copying-and-pasting (or dragging) formulas over-and-over.
Interpolate in Excel (045) – How to create an automated linear interpolation scheme in Excel.
Using MATCH and INDEX in Excel (050) – Use these functions to create an automated tool for looking up and then interpolating values from a multi-column table. Link here to DOWNLOAD STATIC SLIDES.
Create hyperlinks in Excel (055) – How to create hyperlinks in cells or buttons. “Jump” to specific places in your file or link to web addresses.
Steam Tables in Excel: Intro (060) – Introductory overview of the implementation of steam properties in Excel. Can use as a stand-alone tool, a learning tool, or the springboard for thermal systems problem-solving in Excel.
Steam Tables Example Problem for Closed System (065) – Demonstrates how to solve a simple closed system problem in Excel and use the basic Steam Tables Tool to determine thermodynamic properties.
Steam Tables Example Problem for Open System (070) – Demonstrates how to solve a simple sssf open system problem in Excel and use the Basic Steam Tables Tool to determine thermodynamic properties.
Air Tables in Excel: Intro (075) – Introductory overview of the implementation of air properties in Excel. Can use as a stand-alone tool or the springboard for air-related systems problem-solving in Excel.
Air Tables Example Problem for Open System (080) – Demonstrates how to solve a simple sssf air compressor open system problem in Excel and use the Basic Air Tables Tool to determine thermodynamic properties.
Refrigerant Property Tables in Excel: Intro (085) – Implementation of thermodynamic properties for R134a, R22, and ammonia in Excel. Use as stand-alone tools, or the springboard for refrigerant-related thermal systems problems.
Drop-Down Pick Lists Part 1 (090) – Demo problem illustrating a user-tool for calculating the mass of any ideal gas contained in a closed system. Using a drop-down pick-list to select an ideal gas. Download the Excel demo file from the link below in Part 2.
Drop-Down Pick Lists Part 2 (095) – Demo problem illustrating a bill-of-material user-tool. Using drop-down pick-lists to select tabulated materials.
Regression and Correlation (100) – How to determine the best linear y=mx+b expression for a set of (x,y) data using Excel.