Main

Computational Tools for Engineers - Introduction to Excel

Main.ExcelIntroduction History

Hide minor edits - Show changes to output

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

[[https://docs.google.com/spreadsheets/d/1srvLJTvjp-zaFqVRevr_yb0bq8w_Ng_lI1q0fb4uVEU/edit?usp=sharing | Link for today]]
May 01, 2014, at 03:14 PM by 10.8.116.165 -
Added lines 6-7:

[[https://docs.google.com/spreadsheets/d/1srvLJTvjp-zaFqVRevr_yb0bq8w_Ng_lI1q0fb4uVEU/edit?usp=sharing | Link for today]]
April 27, 2014, at 08:29 PM by 197.149.171.26 -
Added lines 1-36:
(: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:)

!!!!Introduction to Spreadsheets

[[http://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:)
 <div id="disqus_thread"></div>
    <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 = 'http://' + disqus_shortname + '.disqus.com/embed.js';
            (document.getElementsByTagName('head')[0] || document.getElementsByTagName('body')[0]).appendChild(dsq);
        })();
    </script>
    <noscript>Please enable JavaScript to view the <a href="http://disqus.com/?ref_noscript">comments powered by Disqus.</a></noscript>
    <a href="http://disqus.com" class="dsq-brlink">comments powered by <span class="logo-disqus">Disqus</span></a>
(:htmlend:)