{"id":1300,"date":"2018-03-04T05:05:31","date_gmt":"2018-03-04T05:05:31","guid":{"rendered":"https:\/\/mrsbarkerstearoom.com\/?page_id=1300"},"modified":"2021-08-24T01:02:59","modified_gmt":"2021-08-24T01:02:59","slug":"i-excel","status":"publish","type":"page","link":"https:\/\/mrsbarkerstearoom.com\/?page_id=1300","title":{"rendered":"I Excel!"},"content":{"rendered":"<p>Microsoft\u00a0<b>Excel<\/b>\u00a0is a spreadsheet program\u00a0used\u00a0to store and retrieve data in a grid format of columns and rows. It is the perfect tool for analysing classroom data.<\/p>\n<p>Excel is part of the Microsoft Office suite. When you open a new file in excel it is referred to as a w<em>orkbook <\/em>and each of the pages in your <em>workbook<\/em> is called a <em>worksheet (or spreadsheet).<\/em><\/p>\n<p>Click on the <em>Excel Video Training<\/em> image below to access a range of videos that will enable you to develop your excel skills. Click on the\u00a0<em>Basic Tasks in Excel\u00a0<\/em>to access a step by step written guide to basic excel functions.<\/p>\n<p><a href=\"https:\/\/support.office.com\/en-us\/article\/excel-video-training-9bc05390-e94c-46af-a5b3-d7c22f6990bb?ui=en-US&amp;rs=en-US&amp;ad=US\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-1301 alignnone\" src=\"https:\/\/mrsbarkerstearoom.com\/wp-content\/uploads\/2018\/03\/Excel-Training-Videos-300x297.jpg\" alt=\"\" width=\"397\" height=\"393\" srcset=\"https:\/\/mrsbarkerstearoom.com\/wp-content\/uploads\/2018\/03\/Excel-Training-Videos-300x297.jpg 300w, https:\/\/mrsbarkerstearoom.com\/wp-content\/uploads\/2018\/03\/Excel-Training-Videos-768x761.jpg 768w, https:\/\/mrsbarkerstearoom.com\/wp-content\/uploads\/2018\/03\/Excel-Training-Videos-510x505.jpg 510w, https:\/\/mrsbarkerstearoom.com\/wp-content\/uploads\/2018\/03\/Excel-Training-Videos.jpg 1389w\" sizes=\"auto, (max-width: 397px) 100vw, 397px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/support.office.com\/en-us\/article\/basic-tasks-in-excel-dc775dd1-fa52-430f-9c3c-d998d1735fca\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1312\" src=\"https:\/\/mrsbarkerstearoom.com\/wp-content\/uploads\/2018\/03\/Basic-Tasks-in-Excel-300x264.jpg\" alt=\"\" width=\"351\" height=\"309\" srcset=\"https:\/\/mrsbarkerstearoom.com\/wp-content\/uploads\/2018\/03\/Basic-Tasks-in-Excel-300x264.jpg 300w, https:\/\/mrsbarkerstearoom.com\/wp-content\/uploads\/2018\/03\/Basic-Tasks-in-Excel-768x676.jpg 768w, https:\/\/mrsbarkerstearoom.com\/wp-content\/uploads\/2018\/03\/Basic-Tasks-in-Excel-510x449.jpg 510w, https:\/\/mrsbarkerstearoom.com\/wp-content\/uploads\/2018\/03\/Basic-Tasks-in-Excel.jpg 984w\" sizes=\"auto, (max-width: 351px) 100vw, 351px\" \/><\/a><\/p>\n<p>I love the fact that you can use excel in OneNote. Open your OneNote file (in the desktop version) and select INSERT &#8211; SPREADSHEET. You will notice that you have the option to insert an\u00a0<em>Existing Excel Spreadsheet\u00a0<\/em>or a N<em>ew Excel Spreadsheet.\u00a0<\/em>Once the spreadsheet has been inserted you can edit at anytime from within OneNote, simply hover over the\u00a0excel file on your OneNote page and the <strong>Edit<\/strong> icon will appear in the top left corner of the file. Click on <strong>Edit<\/strong> to open the file. It will open in the full Excel program. When you have finished editing simply click SAVE and it will save back into your OneNote file.<\/p>\n<p><a href=\"https:\/\/mrsbarkerstearoom.com\/wp-content\/uploads\/2018\/03\/Excel-screenshot.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-1317 alignnone\" src=\"https:\/\/mrsbarkerstearoom.com\/wp-content\/uploads\/2018\/03\/Excel-screenshot-300x147.png\" alt=\"\" width=\"464\" height=\"227\" srcset=\"https:\/\/mrsbarkerstearoom.com\/wp-content\/uploads\/2018\/03\/Excel-screenshot-300x147.png 300w, https:\/\/mrsbarkerstearoom.com\/wp-content\/uploads\/2018\/03\/Excel-screenshot-510x249.png 510w, https:\/\/mrsbarkerstearoom.com\/wp-content\/uploads\/2018\/03\/Excel-screenshot.png 677w\" sizes=\"auto, (max-width: 464px) 100vw, 464px\" \/><\/a><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-1316 alignnone\" src=\"https:\/\/mrsbarkerstearoom.com\/wp-content\/uploads\/2018\/03\/Edit-excel-in-OneNote-300x258.png\" alt=\"\" width=\"451\" height=\"388\" srcset=\"https:\/\/mrsbarkerstearoom.com\/wp-content\/uploads\/2018\/03\/Edit-excel-in-OneNote-300x258.png 300w, https:\/\/mrsbarkerstearoom.com\/wp-content\/uploads\/2018\/03\/Edit-excel-in-OneNote-768x661.png 768w, https:\/\/mrsbarkerstearoom.com\/wp-content\/uploads\/2018\/03\/Edit-excel-in-OneNote-510x439.png 510w, https:\/\/mrsbarkerstearoom.com\/wp-content\/uploads\/2018\/03\/Edit-excel-in-OneNote.png 831w\" sizes=\"auto, (max-width: 451px) 100vw, 451px\" \/><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft\u00a0Excel\u00a0is a spreadsheet program\u00a0used\u00a0to store and retrieve data in a grid format of columns and rows. It is the perfect tool for analysing classroom data. Excel is part [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1302,"parent":1885,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-1300","page","type-page","status-publish","has-post-thumbnail","hentry"],"_links":{"self":[{"href":"https:\/\/mrsbarkerstearoom.com\/index.php?rest_route=\/wp\/v2\/pages\/1300","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mrsbarkerstearoom.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/mrsbarkerstearoom.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/mrsbarkerstearoom.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mrsbarkerstearoom.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1300"}],"version-history":[{"count":8,"href":"https:\/\/mrsbarkerstearoom.com\/index.php?rest_route=\/wp\/v2\/pages\/1300\/revisions"}],"predecessor-version":[{"id":1324,"href":"https:\/\/mrsbarkerstearoom.com\/index.php?rest_route=\/wp\/v2\/pages\/1300\/revisions\/1324"}],"up":[{"embeddable":true,"href":"https:\/\/mrsbarkerstearoom.com\/index.php?rest_route=\/wp\/v2\/pages\/1885"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/mrsbarkerstearoom.com\/index.php?rest_route=\/wp\/v2\/media\/1302"}],"wp:attachment":[{"href":"https:\/\/mrsbarkerstearoom.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1300"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}