Tutorials

  1.  Excel Primer 2013 from General Chemistry for those who haven’t used Excel before or if you need a quick review to sharpen your skills.
  2. Excel Video Tutorial: Converting Joules to Dollars.  You’ll need an electric bill to reproduce this tutorial.  You’ll find the final result here for your review.
  3. Getting CSV or TXT data into Excel (To see these videos in HD use the youtube viewer system tools to set the display resolution to 1080P and view the video in full screen mode).

4. Plot some data and compute the slope and intercept (with associated errors) using the Linest array function.

5. Build a histogram of wind speeds from weather data.

6. Numerical integration of weather data with an exact integration introduction.

7. My favorite Excel functions.

8. And just for fun.

9. Auto Loan Example

10. Home Heating Systems Explained

11. Excel Solver Examples