{"id":7421,"date":"2015-01-01T20:38:45","date_gmt":"2015-01-01T20:38:45","guid":{"rendered":"https:\/\/kaceli.com\/a\/?p=7421"},"modified":"2016-01-30T23:54:40","modified_gmt":"2016-01-30T23:54:40","slug":"learning-excel-2013-a-full-tutorial-of-most-features","status":"publish","type":"post","link":"https:\/\/kaceli.com\/a\/learning-excel-2013-a-full-tutorial-of-most-features\/","title":{"rendered":"Learning Excel 2013: A full tutorial of most features"},"content":{"rendered":"<p>A full 18 module free tutorial on Excel 2013 is now available from our YouTube channel. Feel free to check it out and refer friends and link to it. Other modules are also now available in individual format. The video covers:<\/p>\n<p>Data File: https:\/\/drive.google.com\/file\/d\/0B3-9HUBAvpxnVm9GVDBjSVVPcGc\/view?usp=sharing<\/p>\n<p>This video covers the following topics along with the timeline:<br \/>\n0:5 Getting Started with Excel<br \/>\n7:06 Basic Calculations: SUM, AVERAGE, MAX, MIN<br \/>\n24:50 Arithmetic Calculations: Subtraction, Multiplication, Division<br \/>\n31:30 Relative, Absolute and Mixed Cell References<br \/>\n41:32 Conditional Formatting and Data Analysis<br \/>\n45:00 Data Sorting and Filtering<br \/>\n50:45 Creating and Modifying Charts<br \/>\n59:00 Cross-Sheet Calculations<br \/>\n1:05:15 Calculating Percentages in Excel<br \/>\n1:09:44 Using the IF statement in a Formula<br \/>\n1:15:55 PMT, IPMT, PPMT functions in Financial Calculations<br \/>\n1:26:20 Using Named References<br \/>\n1:31:15 Data Validation Using Drop-Down Lists<br \/>\n1:34:30 Pivot Tables<br \/>\n1:40:12 Setting and Clearing the Print Area<br \/>\n1:44:20 Linking Excel Data with Word<br \/>\n1:49:00 Importing and Exporting Data in .csv files<br \/>\n1:53:00 Saving Data in PDF Format<\/p>\n<p><iframe width=\"1140\" height=\"641\" src=\"https:\/\/www.youtube.com\/embed\/1mNwJkUYS9A?feature=oembed\" frameborder=\"0\" allowfullscreen><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>A full 18 module free tutorial on Excel 2013 is now available from our YouTube channel. Feel free to check it out and refer friends and link to it. Other modules are also now available in individual format. The video covers: Data File: https:\/\/drive.google.com\/file\/d\/0B3-9HUBAvpxnVm9GVDBjSVVPcGc\/view?usp=sharing This video covers the following topics along with the timeline: 0:5 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":7423,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":"","footnotes":""},"categories":[5,6],"tags":[83,82,81],"class_list":["post-7421","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-education-2","category-malesuada","tag-excel-2013-tutorial","tag-full-tutorial","tag-office-2013"],"_links":{"self":[{"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/posts\/7421","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=7421"}],"version-history":[{"count":0,"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/posts\/7421\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/media\/7423"}],"wp:attachment":[{"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/media?parent=7421"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/categories?post=7421"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/tags?post=7421"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}