{"id":3528,"date":"2015-12-15T08:51:15","date_gmt":"2015-12-15T08:51:15","guid":{"rendered":"https:\/\/web.sidmouthcollege.devon.sch.uk\/ictblog\/?p=3528"},"modified":"2015-12-15T08:51:15","modified_gmt":"2015-12-15T08:51:15","slug":"excel-2016-quick-start-guide","status":"publish","type":"post","link":"https:\/\/web.sidmouthcollege.devon.sch.uk\/ictblog\/excel-2016-quick-start-guide","title":{"rendered":"Excel 2016 Quick Start Guide"},"content":{"rendered":"

New to Excel 2016 or upgrading from a previous version? Use this guide to learn the basics.<\/strong><\/p>\n

\"excel1\"<\/a><\/p>\n

Create something<\/strong><\/p>\n

\n
\n

Begin with a Blank workbook <\/strong>to get right to work. Or save yourself a bunch of time by selecting and then customizing a template that resembles what you need. Click File <\/strong>> New<\/strong>, and then select or search for the template you want.<\/p>\n

\"Excel2\"<\/a><\/p>\n

Find recent files<\/strong><\/p>\n

\n
\n

Whether you only work with files stored on your PC\u2019s local hard drive or you roam across various cloud services, clicking File <\/strong>> Open <\/strong>takes you to your recently used workbooks and any files that you may have pinned to your list.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

\"Excel3\"<\/a><\/p>\n

Stay connected<\/strong><\/p>\n

\n
\n

Need to work on the go and across different devices? Click File <\/strong>> Account <\/strong>to sign in and access your recently used files anywhere, on any device, through seamless integration between Office, OneDrive, OneDrive for Business, and SharePoint.<\/p>\n

\u00a0\"Excel4\"<\/a><\/p>\n

Set your preferences<\/strong><\/p>\n

\n
\n

Something not working quite as expected? It\u2019s easy to change and customize options at any time. Click File <\/strong>> Options<\/strong>, and then set up Excel 2016 the way you want.<\/p>\n

\u00a0\"Excel5\"<\/a><\/p>\n

Discover contextual tools<\/strong><\/p>\n

\n
\n

You can make contextual ribbon commands available by selecting relevant objects in your workbook. For example, clicking a chart element displays the Chart Tools <\/strong>tabs, and clicking any inserted picture displays the Picture Tools <\/strong>tab.<\/p>\n

\u00a0\"Excel6\"<\/a><\/p>\n

Enable optional add-ins<\/strong><\/p>\n

\n
\n

Get all of the statistical functions you need by enabling the optional add-ins you want. To display the list of available add-ins, click File <\/strong>> Options<\/strong>. In the Options <\/strong>dialog box that opens, click Add-ins<\/strong>, and then click the Go <\/strong>button next to Manage: Excel Add-ins<\/strong>.<\/p>\n

\u00a0\"Excel7\"<\/a><\/p>\n

Insert functions, build formulas<\/strong><\/p>\n

\n
\n

On the Formulas <\/strong>tab, click Insert Function <\/strong>to display the Insert Function <\/strong>dialog box. Here, you can search for and insert functions, look up the correct syntax, and even get in-depth help about your selected functions.<\/p>\n

\u00a0\"Excel8\"<\/a>\"Excel8a\"<\/a><\/p>\n

Share your work with others<\/strong><\/p>\n

\n
\n

To invite others to view or edit your workbooks in the cloud, click the Share <\/strong>button in the top right corner of the app window. In the Share <\/strong>pane that opens, you can get a sharing link or send invitations to the people you select.<\/p>\n

\u00a0\"Excel9\"<\/a><\/p>\n

Get help with Excel<\/strong><\/p>\n

\n
\n

Type a keyword or phrase into the Tell me what you want to do <\/strong>box on the ribbon to find the Excel features and commands that you\u2019re looking for, read our online Help <\/strong>content, or perform a Smart Lookup <\/strong>on the Web for more insights.<\/p>\n

\u00a0\"Excel10\"<\/a><\/p>\n

 <\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

New to Excel 2016 or upgrading from a previous version?<\/p>\n","protected":false},"author":1,"featured_media":3601,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,7,9],"tags":[61,65,118,127,148,156,179,237,245,391,409],"class_list":["post-3528","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-how-to","category-parent-support","category-software","tag-cloud-services","tag-college","tag-excel","tag-files","tag-guide","tag-ict","tag-it","tag-office","tag-online","tag-web","tag-work"],"_links":{"self":[{"href":"https:\/\/web.sidmouthcollege.devon.sch.uk\/ictblog\/wp-json\/wp\/v2\/posts\/3528","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/web.sidmouthcollege.devon.sch.uk\/ictblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/web.sidmouthcollege.devon.sch.uk\/ictblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/web.sidmouthcollege.devon.sch.uk\/ictblog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/web.sidmouthcollege.devon.sch.uk\/ictblog\/wp-json\/wp\/v2\/comments?post=3528"}],"version-history":[{"count":0,"href":"https:\/\/web.sidmouthcollege.devon.sch.uk\/ictblog\/wp-json\/wp\/v2\/posts\/3528\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/web.sidmouthcollege.devon.sch.uk\/ictblog\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/web.sidmouthcollege.devon.sch.uk\/ictblog\/wp-json\/wp\/v2\/media?parent=3528"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/web.sidmouthcollege.devon.sch.uk\/ictblog\/wp-json\/wp\/v2\/categories?post=3528"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/web.sidmouthcollege.devon.sch.uk\/ictblog\/wp-json\/wp\/v2\/tags?post=3528"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}