{"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":"","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,"featured_image_urls":{"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]},"post_excerpt_stackable":"<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 change, replacing data, deleting data Copy and paste Fill Drag and drop cells Hide columns or rows Appearance Resize column width or row height Formatting cells Labels \u2013 format text (bold, size), text wrap Merge cells, border, fill color Sorting data Freeze panes Filters Custom&hellip;<\/p>\n","category_list":"<a href=\"https:\/\/inside.wooster.edu\/technology\/category\/professional-development\/\" rel=\"category tag\">Professional Development<\/a>, <a href=\"https:\/\/inside.wooster.edu\/technology\/category\/uncategorized\/\" rel=\"category tag\">Uncategorized<\/a>","author_info":{"name":"Emily Armour (she\/her)","url":"https:\/\/inside.wooster.edu\/technology\/author\/earmourwooster-edu\/"},"comments_num":"0 comments","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}]}}