{"id":22525,"date":"2016-03-29T13:32:44","date_gmt":"2016-03-29T17:32:44","guid":{"rendered":"https:\/\/it.wooster.edu.wooster.edu\/?p=1944"},"modified":"2024-03-19T10:21:48","modified_gmt":"2024-03-19T14:21:48","slug":"microsoft-excel-basics-for-staff","status":"publish","type":"post","link":"https:\/\/inside.wooster.edu\/technology\/microsoft-excel-basics-for-staff\/","title":{"rendered":"Microsoft Excel Basics for staff"},"content":{"rendered":"<h2>Agenda<\/h2>\n<p>(may be covered in two sessions)<\/p>\n<p><a href=\"https:\/\/support.office.com\/en-us\/article\/create-a-worksheet-in-excel-2016-94b00f50-5896-479c-b0c5-ff74603b35a3?ui=en-US&amp;rs=en-US&amp;ad=US\" target=\"_blank\" rel=\"noopener\">Excel 2016 Quick Start (Microsoft Support)<\/a><\/p>\n<p><a href=\"https:\/\/support.office.com\/en-us\/article\/basic-tasks-in-excel-dc775dd1-fa52-430f-9c3c-d998d1735fca?ui=en-US&amp;rs=en-US&amp;ad=US\" target=\"_blank\" rel=\"noopener\">Basic Tasks in Excel (Microsoft Support)<\/a><\/p>\n<ol>\n<li>Tour of layout: task bar, formula bar, worksheet<\/li>\n<li>Define terms: cells, column, row, workbook, worksheet, active cell<\/li>\n<li>Entering data\n<ul>\n<li>Cell reference<\/li>\n<li>Moving around in the worksheet: enter key, tab key, arrow keys<\/li>\n<li>Editing data: making a change, replacing data, deleting data<\/li>\n<li>Copy and paste<\/li>\n<li>Fill<\/li>\n<li>Drag and drop cells<\/li>\n<li><a href=\"https:\/\/support.office.com\/en-us\/article\/hide-or-show-rows-or-columns-659c2cad-802e-44ee-a614-dde8443579f8\" target=\"_blank\" rel=\"noopener\">Hide columns or rows<\/a><\/li>\n<\/ul>\n<\/li>\n<li>Appearance\n<ul>\n<li>Resize column width or row height<\/li>\n<li>Formatting cells<\/li>\n<li>Labels \u2013 format text (bold, size), text wrap<\/li>\n<li>Merge cells, border, fill color<\/li>\n<\/ul>\n<\/li>\n<li>Sorting data\n<ul>\n<li><a href=\"https:\/\/support.office.com\/en-us\/article\/freeze-panes-to-lock-rows-and-columns-dab2ffc9-020d-4026-8121-67dd25f2508f?ui=en-US&amp;rs=en-US&amp;ad=US\" target=\"_blank\" rel=\"noopener\">Freeze panes<\/a><\/li>\n<li>Filters<\/li>\n<li>Custom sort<\/li>\n<li>multiple variables<\/li>\n<\/ul>\n<\/li>\n<li>Calculations with formulas\n<ul>\n<li><a href=\"https:\/\/support.office.com\/en-us\/article\/analyze-and-format-in-excel-2016-11a632c1-197e-454f-a515-374a4aa2b3dd?ui=en-US&amp;rs=en-US&amp;ad=US\" target=\"_blank\" rel=\"noopener\">Autosum<\/a><\/li>\n<li>Multiply<\/li>\n<\/ul>\n<\/li>\n<li>Creating a chart<\/li>\n<\/ol>\n<h5>Links below are to Hoonuit video tutorials.\u00a0Login to\u00a0<a href=\"https:\/\/secure2.atomiclearning.com\/sso\/shibboleth\/wooster\">Hoonuit via our Wooster portal<\/a>\u00a0and use your College credentials.<\/h5>\n<h4>Excel\u00a02016<\/h4>\n<p>Which version of Excel?\u00a0Office 2016 is available for download for Windows and Mac<\/p>\n<p><a href=\"https:\/\/learnit.hoonuit.com\/5516\/learnit\" target=\"_blank\" rel=\"noopener\">Excel 2016<\/a><\/p>\n<p><a href=\"https:\/\/www.linkedin.com\/learning\/excel-2016-essential-training\/welcome?u=137757834\" target=\"_blank\" rel=\"noopener\">New features in Excel 2016 for Mac<\/a><\/p>\n<h4>Office 365<\/h4>\n<ul>\n<li>OneDrive \u00a0<a href=\"http:\/\/www.atomiclearning.com\/highed\/one-drive-training\">OneDrive Training<\/a><\/li>\n<li>Excel\u00a0online \u00a0<a href=\"http:\/\/www.atomiclearning.com\/highed\/excel-online-training\" target=\"_blank\" rel=\"noopener\">Microsoft Excel Online<\/a><\/li>\n<\/ul>\n<p><strong>How to create Charts\/Tables<\/strong><\/p>\n<p><a href=\"https:\/\/www.linkedin.com\/learning\/excel-2016-essential-training\/creating-charts?resume=false&amp;u=137757834\" target=\"_blank\" rel=\"noopener\">Creating charts<\/a>\u00a0and tables from data<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Agenda (may be covered in two sessions) Excel 2016 Quick Start (Microsoft Support) Basic Tasks in Excel (Microsoft Support) Tour of layout: task bar, formula bar, worksheet Define terms: cells, column, row, workbook, worksheet, active cell Entering data Cell reference Moving around in the worksheet: enter key, tab key, arrow keys Editing data: making a [&hellip;]<\/p>\n","protected":false},"author":25,"featured_media":1734,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_uag_custom_page_level_css":"","wpo365_audiences":[],"wpo365_private":false,"footnotes":""},"categories":[37,1],"tags":[],"coauthors":[178],"class_list":["post-22525","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-professional-development","category-uncategorized"],"acf":[],"gutentor_comment":0,"uagb_featured_image_src":{"full":["https:\/\/inside.wooster.edu\/technology\/wp-content\/uploads\/sites\/83\/2015\/10\/Microsoft_Excel_2013_logo.svg_.png",2000,1964,false],"thumbnail":["https:\/\/inside.wooster.edu\/technology\/wp-content\/uploads\/sites\/83\/2015\/10\/Microsoft_Excel_2013_logo.svg_-150x150.png",150,150,true],"medium":["https:\/\/inside.wooster.edu\/technology\/wp-content\/uploads\/sites\/83\/2015\/10\/Microsoft_Excel_2013_logo.svg_-300x295.png",300,295,true],"medium_large":["https:\/\/inside.wooster.edu\/technology\/wp-content\/uploads\/sites\/83\/2015\/10\/Microsoft_Excel_2013_logo.svg_-768x754.png",768,754,true],"large":["https:\/\/inside.wooster.edu\/technology\/wp-content\/uploads\/sites\/83\/2015\/10\/Microsoft_Excel_2013_logo.svg_-1024x1006.png",1024,1006,true],"1536x1536":["https:\/\/inside.wooster.edu\/technology\/wp-content\/uploads\/sites\/83\/2015\/10\/Microsoft_Excel_2013_logo.svg_-1536x1508.png",1536,1508,true],"2048x2048":["https:\/\/inside.wooster.edu\/technology\/wp-content\/uploads\/sites\/83\/2015\/10\/Microsoft_Excel_2013_logo.svg_.png",2000,1964,false]},"uagb_author_info":{"display_name":"Emily Armour (she\/her)","author_link":"https:\/\/inside.wooster.edu\/technology\/author\/earmourwooster-edu\/"},"uagb_comment_info":0,"uagb_excerpt":"Agenda (may be covered in two sessions) Excel 2016 Quick Start (Microsoft Support) Basic Tasks in Excel (Microsoft Support) Tour of layout: task bar, formula bar, worksheet Define terms: cells, column, row, workbook, worksheet, active cell Entering data Cell reference Moving around in the worksheet: enter key, tab key, arrow keys Editing data: making a&hellip;","_links":{"self":[{"href":"https:\/\/inside.wooster.edu\/technology\/wp-json\/wp\/v2\/posts\/22525","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/inside.wooster.edu\/technology\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/inside.wooster.edu\/technology\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/inside.wooster.edu\/technology\/wp-json\/wp\/v2\/users\/25"}],"replies":[{"embeddable":true,"href":"https:\/\/inside.wooster.edu\/technology\/wp-json\/wp\/v2\/comments?post=22525"}],"version-history":[{"count":2,"href":"https:\/\/inside.wooster.edu\/technology\/wp-json\/wp\/v2\/posts\/22525\/revisions"}],"predecessor-version":[{"id":44145,"href":"https:\/\/inside.wooster.edu\/technology\/wp-json\/wp\/v2\/posts\/22525\/revisions\/44145"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/inside.wooster.edu\/technology\/wp-json\/wp\/v2\/media\/1734"}],"wp:attachment":[{"href":"https:\/\/inside.wooster.edu\/technology\/wp-json\/wp\/v2\/media?parent=22525"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/inside.wooster.edu\/technology\/wp-json\/wp\/v2\/categories?post=22525"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/inside.wooster.edu\/technology\/wp-json\/wp\/v2\/tags?post=22525"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/inside.wooster.edu\/technology\/wp-json\/wp\/v2\/coauthors?post=22525"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}