{"id":7742,"date":"2016-10-16T19:50:28","date_gmt":"2016-10-17T00:50:28","guid":{"rendered":"https:\/\/kaceli.com\/a\/?p=7742"},"modified":"2016-10-18T10:31:27","modified_gmt":"2016-10-18T15:31:27","slug":"excel-2016-tutorial-beginner-to-intermediate","status":"publish","type":"post","link":"https:\/\/kaceli.com\/a\/excel-2016-tutorial-beginner-to-intermediate\/","title":{"rendered":"Excel 2016 Tutorial &#8211; Beginner to Intermediate"},"content":{"rendered":"<p>Want to learn Excel? Here is part 1 of a 2 part series tutorial on Excel 2016. I have designed it to be concepts-based and simple to follow. Check it out.<\/p>\n<p>A comprehensive tutorial on Excel 2016 covering most essential features for business professionals, students or anyone that wants to learn how to use Excel. \u00a0The concepts covered here apply also to previous versions of Excel such as Excel 2013, 2010 and 2007.<\/p>\n<p><iframe width=\"1140\" height=\"641\" src=\"https:\/\/www.youtube.com\/embed\/xUM-GvJwTrw?feature=oembed\" frameborder=\"0\" allowfullscreen><\/iframe><\/p>\n<p>Link to Excel 2016 Part I Tutorial: https:\/\/youtu.be\/xUM-GvJwTrw<br \/>\nFull Excel 2016 Tutorial URL: https:\/\/youtu.be\/8lXerL3DHRw<\/p>\n<p>The Quick Guide for Excel 2016 along with the data files to follow along are available from here: https:\/\/kaceli.com\/a\/excel-2016-data-file\/<\/p>\n<p>The following are covered in detail along with the starting times:<br \/>\n00:07 Getting Started with Excel 2016 &#8211; Learn the basics including the Tell Me feature.<br \/>\n11:15 Learn about the basic calculations in Excel 2016 such as SUM, AVERAGE, MAX, MIN, COUNT<br \/>\n21:45 Learn how to format a spreadsheet including conditional formatting in Excel 2016<br \/>\n25:04 Learn about additional core Excel functions and concepts such as SUM, Multiplying, Subtracting, Dividing in Excel 2016<br \/>\n32:41 Learn about the Quick Analysis Tools in Excel 2016<br \/>\n35:51 Learn about Data Sorting and Data Filtering in Excel 206<br \/>\n39:17: Learn about core concepts in Excel such as the types of references: Absolute, Relative Reference in Excel 2016<br \/>\n49:30 Learn how to create and use charts in Excel 2016<br \/>\n55:49 Learn how to use the Flash Fill Data feature in Excel 2016<br \/>\nKeep in touch:<br \/>\nWebsite: https:\/\/kaceli.com\/a<br \/>\nYouTube Channel: http:\/\/youtube.com\/skaceli<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Want to learn Excel? Here is part 1 of a 2 part series tutorial on Excel 2016. I have designed it to be concepts-based and simple to follow. Check it out. A comprehensive tutorial on Excel 2016 covering most essential features for business professionals, students or anyone that wants to learn how to use Excel. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":7743,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":"","footnotes":""},"categories":[2,106,107,89],"tags":[121,170,172,171,173],"class_list":["post-7742","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-fusce","category-excel-tutorials-and-learning","category-office-2016-tutorials","category-powerpoint","tag-excel-2016-tutorial","tag-excel-tutorial-for-beginners","tag-free-tutorial-on-excel","tag-intermediate-excel-tutorial","tag-learn-excel-easy"],"_links":{"self":[{"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/posts\/7742","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/comments?post=7742"}],"version-history":[{"count":0,"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/posts\/7742\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/media\/7743"}],"wp:attachment":[{"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/media?parent=7742"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/categories?post=7742"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/tags?post=7742"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}