There are a few different options for transferring charts out of Excel and into applications like Word or PowerPoint. In this section, we'll copy the RC Circuit Response chart from Section 4 into a PowerPoint presentation. First, select the chart in Excel and type Ctrl-C. Switch to PowerPoint and … Read more about Transferring Excel Charts to Other Software
Gaussian Fit in Excel
A Gaussian function has many different purposes in engineering although most people probably recognize it as a "bell curve". Most commonly, it can be used to describe a normal distribution of measurements. Sometimes it's necessary to fit a Gaussian function to data, so this post will teach you how … Read more about Gaussian Fit in Excel
SUMPRODUCT and SUMSQ Excel Functions
There are two more advanced summing functions that we'll discuss – SUMPRODUCT and SUMSQ. SUMPRODUCT multiplies individual components in arrays together and then returns the sum of those components. The syntax is as follows: SUMPRODUCT(array1, [array2], [array3],…) array1: the first array … Read more about SUMPRODUCT and SUMSQ Excel Functions
SUMIF and SUMIFS Excel Functions for Engineering Calculations
This section and the next will cover the advanced summing functions available in Excel. The SUMIF and SUMIFS functions enable you to sum values in a range of cells if they meet specified criteria. Values that don't meet the criteria are excluded from the sum. The syntax for SUMIF is as … Read more about SUMIF and SUMIFS Excel Functions for Engineering Calculations
Solving Systems of Simultaneous Nonlinear Equations in Excel
Unlike simultaneous linear equations, simultaneous non-linear equations cannot be solved using linear algebra. However, we can extend the concept of using Goal Seek from solving a single implicit equation to solving systems of nonlinear equations. In our worksheet, we'll set up equations for flow … Read more about Solving Systems of Simultaneous Nonlinear Equations in Excel
Solving Non-Linear Equations in Excel with Goal Seek
In addition to solving nonlinear equations like the Colebrook equation graphically, you can also solve them numerically using a feature called Goal Seek. Our worksheet is set up to do just that. This spreadsheet is set up to use a guess for the value of f as an input. You'll use the "Outputs" table … Read more about Solving Non-Linear Equations in Excel with Goal Seek
Solving a System of Simultaneous Linear Equations in Excel
Systems of linear equations can be solved in Excel using formulas that perform matrix calculations. This worksheet is set up to find three unknowns in a free-body diagram using some of those matrix functions. The problem contains a beam supported by a pin and a tension cable, with a weight at the … Read more about Solving a System of Simultaneous Linear Equations in Excel
Protecting Excel Worksheets and Workbooks
So far, you've seen a few different methods to prevent errors from being generated in your spreadsheets, but those methods won't prevent someone from making unauthorized changes to your worksheet or workbook that cause errors. Another person could cause problems if they make changes to cell formulas … Read more about Protecting Excel Worksheets and Workbooks