{"id":46,"date":"2018-02-07T22:45:14","date_gmt":"2018-02-07T22:45:14","guid":{"rendered":"http:\/\/web.colby.edu\/joules2dollars\/?page_id=46"},"modified":"2018-02-08T02:37:05","modified_gmt":"2018-02-08T02:37:05","slug":"tutorials","status":"publish","type":"page","link":"https:\/\/web.colby.edu\/joules2dollars\/tutorials\/","title":{"rendered":"Tutorials"},"content":{"rendered":"<ol>\n<li>\u00a0<a href=\"http:\/\/web.colby.edu\/joules-to-dollars\/files\/2015\/01\/Excel-Primer-2013.pdf\">Excel Primer 2013<\/a>\u00a0from General Chemistry for those who haven&#8217;t used Excel before or if you need a quick review to sharpen your skills.<\/li>\n<li>Excel Video Tutorial: <a href=\"http:\/\/web.colby.edu\/joules-to-dollars\/files\/2015\/01\/J2.mp4\">Converting Joules to Dollars.<\/a>\u00a0 You&#8217;ll need an <a href=\"http:\/\/web.colby.edu\/joules-to-dollars\/files\/2015\/01\/ElectricBill0115.pdf\">electric bill<\/a> to reproduce this tutorial.\u00a0 You&#8217;ll find the final result <a href=\"http:\/\/web.colby.edu\/joules-to-dollars\/files\/2015\/01\/J2.xlsx\">here<\/a> for your review.<\/li>\n<li>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).<\/li>\n<\/ol>\n<p><iframe loading=\"lazy\" title=\"Importing Data to Excel\" width=\"525\" height=\"295\" src=\"https:\/\/www.youtube.com\/embed\/9aNX0GZ0vTc?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<p>4. Plot some data and compute the slope and intercept (with associated errors) using the Linest array function.<\/p>\n<p><iframe loading=\"lazy\" title=\"Linear Function Calculations in Excel\" width=\"525\" height=\"295\" src=\"https:\/\/www.youtube.com\/embed\/F0VK0kKf66o?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<p>5. Build a histogram of wind speeds from weather data.<\/p>\n<p><iframe loading=\"lazy\" title=\"Creating a Histogram of Wind Speed\" width=\"525\" height=\"295\" src=\"https:\/\/www.youtube.com\/embed\/da1I9or53O0?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<p>6. Numerical integration of weather data with an exact integration introduction.<\/p>\n<p><iframe loading=\"lazy\" title=\"Exact and Numerical Integration\" width=\"525\" height=\"295\" src=\"https:\/\/www.youtube.com\/embed\/Py4t-YtwPoI?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<p>7. My favorite Excel functions.<\/p>\n<p><iframe loading=\"lazy\" title=\"Favorite Excel Functions\" width=\"525\" height=\"295\" src=\"https:\/\/www.youtube.com\/embed\/cDtIjG6aJJg?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<p>8. And just for fun.<\/p>\n<p><iframe loading=\"lazy\" title=\"DeflateGate\" width=\"525\" height=\"295\" src=\"https:\/\/www.youtube.com\/embed\/4XIL7fMYXH0?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<p>9. <a href=\"http:\/\/web.colby.edu\/joules-to-dollars\/files\/2015\/02\/AutoLoanExcelTutorial.mp4\">Auto Loan Example<\/a><\/p>\n<p>10. Home Heating Systems Explained<\/p>\n<p><iframe loading=\"lazy\" title=\"Home Heating Systems\" width=\"525\" height=\"295\" src=\"https:\/\/www.youtube.com\/embed\/ha7ET_Czh8U?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<p>11. Excel Solver Examples<\/p>\n<p><iframe loading=\"lazy\" title=\"Solver Example\" width=\"525\" height=\"295\" src=\"https:\/\/www.youtube.com\/embed\/vga4uMB_P0Q?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u00a0Excel Primer 2013\u00a0from General Chemistry for those who haven&#8217;t used Excel before or if you need a quick review to sharpen your skills. Excel Video Tutorial: Converting Joules to Dollars.\u00a0 You&#8217;ll need an electric bill to reproduce this tutorial.\u00a0 You&#8217;ll find the final result here for your review. Getting CSV or TXT data into Excel &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/web.colby.edu\/joules2dollars\/tutorials\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Tutorials&#8221;<\/span><\/a><\/p>\n","protected":false},"author":132,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"ngg_post_thumbnail":0,"footnotes":""},"_links":{"self":[{"href":"https:\/\/web.colby.edu\/joules2dollars\/wp-json\/wp\/v2\/pages\/46"}],"collection":[{"href":"https:\/\/web.colby.edu\/joules2dollars\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/web.colby.edu\/joules2dollars\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/web.colby.edu\/joules2dollars\/wp-json\/wp\/v2\/users\/132"}],"replies":[{"embeddable":true,"href":"https:\/\/web.colby.edu\/joules2dollars\/wp-json\/wp\/v2\/comments?post=46"}],"version-history":[{"count":4,"href":"https:\/\/web.colby.edu\/joules2dollars\/wp-json\/wp\/v2\/pages\/46\/revisions"}],"predecessor-version":[{"id":74,"href":"https:\/\/web.colby.edu\/joules2dollars\/wp-json\/wp\/v2\/pages\/46\/revisions\/74"}],"wp:attachment":[{"href":"https:\/\/web.colby.edu\/joules2dollars\/wp-json\/wp\/v2\/media?parent=46"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}