Main

## Main.ExcelIntroduction History

May 05, 2014, at 04:10 PM by 23.255.240.62 -
Deleted lines 5-6:

May 01, 2014, at 03:14 PM by 10.8.116.165 -

April 27, 2014, at 08:29 PM by 197.149.171.26 -
(:title Computational Tools for Engineers - Introduction to Excel:)
(:keywords introduction, Microsoft Excel, spreadsheet, nonlinear, optimization, engineering optimization, Excel, Visual Basic, university course:)
(:description Introduction to Excel - Problem-Solving Techniques for Chemical Engineers at Brigham Young University:)

[[https://en.wikipedia.org/wiki/Spreadsheet|Spreadsheet programs]] are powerful tools to view, calculate, and visualize sets of tabular data. The tables have values, equations, and functions that are manipulated in cells that are organized into rows and columns. As values within the spreadsheet change, the dependent calculations in the workbook are updated.

Both Microsoft Excel and Google Spreadsheets will be used in this course although other tools such as OpenOffice can also be used.

Microsoft Excel is not a programming language but does include an integrated development environment for recording and running macros. Excel macros are a series of commands that can be repeated to operate repeatedly on different sets of data. This language is known as Visual Basic for Applications. This course first reviews spreadsheet programming and then extends the spreadsheet capabilities with Visual Basic for Applications.

As an introduction to Excel, the following tutorial demonstrates how to navigate through a workbook, create worksheets, select active cells, input equations, browse available formulas, and other basic Excel functions.

(:html:)
<iframe width="560" height="315" src="//www.youtube.com/embed/sUx7-kX5sjg?list=PLLBUgWXdTBDi-E--rwBujaNkTejLNI6ap" frameborder="0" allowfullscreen></iframe>
(:htmlend:)

----

(:html:)
<script type="text/javascript">
/* * * CONFIGURATION VARIABLES: EDIT BEFORE PASTING INTO YOUR WEBPAGE * * */
var disqus_shortname = 'apmonitor'; // required: replace example with your forum shortname

/* * * DON'T EDIT BELOW THIS LINE * * */
(function() {
var dsq = document.createElement('script'); dsq.type = 'text/javascript'; dsq.async = true;
dsq.src = 'https://' + disqus_shortname + '.disqus.com/embed.js';