Electrical Engineering With Excel Foolproofing Excel Engineering Workbooks
Foolproofing Excel Engineering Workbooks Transcript and Lesson Notes
Welcome to electrical engineering with Excel. Can you really make an Excel workbook foolproof? Well, not entirely. But we can do our best, at insuring that the formulas are protected, and that Excel’s data validation too
Quick Summary
Welcome to electrical engineering with Excel. Can you really make an Excel workbook foolproof? Well, not entirely. But we can do our best, at insuring that the formulas are protected, and that Excel’s data validation too
Key Takeaways
- Review the core idea: Welcome to electrical engineering with Excel. Can you really make an Excel workbook foolproof? Well, not entirely. But we can do our best, at insuring that the formulas are protected, and that Excel’s data validation too
- Understand how Foolproofing Excel Engineering Workbooks fits into Foolproofing Excel Engineering Workbooks.
- Understand how Excel fits into Foolproofing Excel Engineering Workbooks.
- Understand how Excel Data Validation fits into Foolproofing Excel Engineering Workbooks.
- Understand how LM117 fits into Foolproofing Excel Engineering Workbooks.
Key Concepts
Full Transcript
Welcome to electrical engineering with Excel. Can you really make an Excel workbook foolproof? Well, not entirely. But we can do our best, at insuring that the formulas are protected, and that Excel’s data validation tool is used, to make sure the user is restricted to inputs, that are within the allowable limits. This video applies data validation to the previously developed workbook for the LM117 amd LM317 voltage regulator calculator. Download the Excel workbook: https://github.com/oldhackEE/Electrical-Engineering-With-Excel/blob/11ee3c94e44660b12ae5e7f6668a9836fc139f4e/LM117%20Voltage%20Regulator%20Calculator.xlsm 00:00 Intro 00:30 Evolution of the Electrical Engineering with Excel Workbooks 03:16 Restrictions of Input and Output Voltages 04:24 Basics of Data Validation 07:50 Using Logic Functions for Multi-Level Data Validation on Input and Output Voltages 10:34 Making a Meaningful Error Alert 11:38 Resistor Set Current Data Validation 13:08 Load Current Data Validation 14:18 Correcting VBA Code for E-Series with a Zero Input 15:57 Pasting Into Input Cell Wipes Out Data Validation 16:25 Cell Notes 17:47 Worksheet Protection
Lesson FAQs
What is Foolproofing Excel Engineering Workbooks about?
Welcome to electrical engineering with Excel. Can you really make an Excel workbook foolproof? Well, not entirely. But we can do our best, at insuring that the formulas are protected, and that Excel’s data validation too
What key concepts are covered in this lesson?
The lesson covers Foolproofing Excel Engineering Workbooks, Excel, Excel Data Validation, LM117, LM317.
What should I learn before Foolproofing Excel Engineering Workbooks?
Review the previous lessons in Electrical Engineering With Excel, then use the transcript and key concepts on this page to fill any gaps.
How can I practice after this lesson?
Practice by applying the main concepts: Foolproofing Excel Engineering Workbooks, Excel, Excel Data Validation, LM117.
Does this lesson include a transcript?
Yes. The full transcript is visible on this page in indexable HTML sections.
Is this lesson free?
Yes. CourseHive lessons and courses are available to learn online for free.
Continue Learning
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.
