{"id":7752,"date":"2016-10-20T22:04:05","date_gmt":"2016-10-21T03:04:05","guid":{"rendered":"https:\/\/kaceli.com\/a\/?p=7752"},"modified":"2016-10-20T22:04:05","modified_gmt":"2016-10-21T03:04:05","slug":"excel-tutorial-2016-excel-part-2-of-2-intermediate-to-advanced-tutorial","status":"publish","type":"post","link":"https:\/\/kaceli.com\/a\/excel-tutorial-2016-excel-part-2-of-2-intermediate-to-advanced-tutorial\/","title":{"rendered":"Excel Tutorial 2016: Excel Part 2 of 2 &#8211; Intermediate to Advanced Tutorial"},"content":{"rendered":"<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. This is part 2 of 2 of the Excel 2016 tutorial. Check it out. You will not be disappointed. Visit us also at https:\/\/kaceli.com\/a for more info. The 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\/-wJBzxefr8k?feature=oembed\" frameborder=\"0\" allowfullscreen><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p>If you like the video, please &#8220;Like,&#8221; &#8220;Favorite,&#8221; and &#8220;Share&#8221; it with our friends to show your support on this work. Subscribe to this channel so that you do not miss out on the new videos on this series.<\/p>\n<p>Microsoft Excel 2016 Tutorial URL: https:\/\/youtu.be\/8lXerL3DHRw<\/p>\n<p>Microsoft Excel 2016 Tutorial Part I: https:\/\/www.youtube.com\/watch?v=xUM-GvJwTrw<br \/>\nMicrosoft Excel 2016 Tutorial Part II: https:\/\/youtu.be\/-wJBzxefr8k<\/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>Here is what is covered along with the times. The times might be a bit off. If someone is willing to update them, I can post them here.<\/p>\n<p>00:05 Learn how to use Named References and Cross-sheet calculations in Excel 2016<br \/>\n1:02:29 Learn how to Calculate Percentages in Excel 2013 three types of calculations<br \/>\n10:23 Learn how to use Financial Functions such as PMT, IPMT, PPMT in Excel 2016<br \/>\n22:21 Learn how to use the IF statement and logical functions in Excel 2016<br \/>\n28:29 Learn how to use One Click Forecasting in Excel 2016<br \/>\n30:03 Learn how to use the new and modern charts in Excel 2016<br \/>\n31:43 Learn how to use Pivot Tables in Excel 2016<br \/>\n38:06 Learn how to use Data Gathering in Excel 2016<br \/>\n40:14 Learn how to use the new Financial Charts in Excel 2016<br \/>\n39:45 Learn how to use the 3D Maps and Data Visualization Exel 2016<br \/>\n43:41 Learn how to use the Freeze Panes in Excel 2016<br \/>\n45:11 Learn how to Set the Print Area in Excel 2016<br \/>\n47:33 Learn how to Encrypt and put a Password in a Spreadsheet in Excel 2016<br \/>\n48:14 Learn how to use data validation in Excel 2016<br \/>\n51:56 Learn how to link Excel Data to a Word Report<br \/>\n56:29 Learn how to import and export data in Excel 2016<br \/>\n58:47 Learn how to export an Excel file to PDF in Excel 2016<\/p>\n<p>Keep in touch:<br \/>\nWebsite: https:\/\/kaceli.com\/a<br \/>\nYouTube Channel: http:\/\/youtube.com\/skaceli<\/p>\n","protected":false},"excerpt":{"rendered":"<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. This is part 2 of 2 of the Excel 2016 tutorial. Check it out. You will not be disappointed. Visit us also at https:\/\/kaceli.com\/a for more info. The concepts covered here [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":7753,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":"","footnotes":""},"categories":[5,106,107],"tags":[121,175,174,126],"class_list":["post-7752","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-education-2","category-excel-tutorials-and-learning","category-office-2016-tutorials","tag-excel-2016-tutorial","tag-excel-intermediate-tutorial","tag-excel-tutorial-free","tag-learn-excel"],"_links":{"self":[{"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/posts\/7752","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=7752"}],"version-history":[{"count":0,"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/posts\/7752\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/media\/7753"}],"wp:attachment":[{"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/media?parent=7752"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/categories?post=7752"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/tags?post=7752"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}