https:\/\/www.youtube.com\/watch?v=8lXerL3DHRw<\/a><\/p>\nIf you like the video, please “Like,” “Favorite,” and “Share” 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
Excel 2016 Tutorial URL: https:\/\/youtu.be\/8lXerL3DHRw<\/p>\n
The Quick Guide for Excel 2016 along with the data files to follow along are available from here: https:\/\/kaceli.com\/a\/word2016files\/<\/p>\n
The following are covered in detail along with the starting times:
\n00:07 Getting Started with Excel 2016 – Learn the basics including the Tell Me feature.
\n11:15 Learn about the basic calculations in Excel 2016 such as SUM, AVERAGE, MAX, MIN, COUNT
\n21:45 Learn how to format a spreadsheet including conditional formatting in Excel 2016
\n25:04 Learn about additional core Excel functions and concepts such as SUM, Multiplying, Subtracting, Dividing in Excel 2016
\n32:41 Learn about the Quick Analysis Tools in Excel 2016
\n35:51 Learn about Data Sorting and Data Filtering in Excel 206
\n39:17: Learn about core concepts in Excel such as the types of references: Absolute, Relative Reference in Excel 2016
\n49:30 Learn how to create and use charts in Excel 2016
\n55:49 Learn how to use the Flash Fill Data feature in Excel 2016
\n58:17 Learn how to use Named References and Cross-sheet calculations in Excel 2016
\n1:04:29 Learn how to Calculate Percentages in Excel 2013 three types of calculations
\n1:12:23 Learn how to use Financial Functions such as PMT, IPMT, PPMT in Excel 2016
\n1:24:21 Learn how to use the IF statement and logical functions in Excel 2016
\n1:30:29 Learn how to use One Click Forecasting in Excel 2016
\n1:32:03 Learn how to use the new and modern charts in Excel 2016
\n1:33:43 Learn how to use Pivot Tables in Excel 2016
\n1:40:06 Learn how to use Data Gathering in Excel 2016
\n1:42:14 Learn how to use the new Financial Charts in Excel 2016
\n1:53:45 Learn how to use the 3D Maps and Data Visualization Exel 2016
\n1:45:41 Learn how to use the Freeze Panes in Excel 2016
\n1:47:11 Learn how to Set the Print Area in Excel 2016
\n1:49:33 Learn how to Encrypt and put a Password in a Spreadsheet in Excel 2016
\n1:50:14 Learn how to use data validation in Excel 2016
\n1:53:56 Learn how to link Excel Data to a Word Report
\n1:58:29 Learn how to import and export data in Excel 2016
\n2:02:47 Learn how to export an Excel file to PDF in Excel 2016<\/p>\n
Keep in touch:
\nWebsite: https:\/\/kaceli.com\/a
\nYouTube Channel: http:\/\/youtube.com\/skaceli<\/p>\n[wysija_form id=”1″]\n","protected":false},"excerpt":{"rendered":"
Here is a comprehensive tutorial on using Excel 2016, whether you are a student, a business user or in a corporate environment. Learn Excel (including the new features) in just a couple hours from the basics to the advanced features such as financial formulas to recharge your career and resume. Visit us also at https:\/\/kaceli.com\/a […]<\/p>\n","protected":false},"author":1,"featured_media":7580,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":"","_uag_custom_page_level_css":"","footnotes":""},"categories":[5,106,6,4,107],"tags":[120,124,126,125,123],"class_list":["post-7579","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-education-2","category-excel-tutorials-and-learning","category-malesuada","category-design-2","category-office-2016-tutorials","tag-excel-2016","tag-free-tutorial-on-office-2016","tag-learn-excel","tag-new-features-of-excel-2016","tag-tutorial-excel-2016-free"],"spectra_custom_meta":{"_edit_lock":["1454197326:1"],"_edit_last":["1"],"_oembed_b6d3963b9399dd3731da39cbddb612f4":["{{unknown}}"],"_thumbnail_id":["7580"],"_wpb_vc_js_status":["false"],"_wpb_vc_js_interface_version":["2"],"textfalse":[""],"_layout":["left"],"_padding":["false"],"_introduce_align":["left"],"_disable_breadcrumb":["true"],"_disable_post_lightbox":["true"],"_single_post_type":["image"],"_classic_orientation":["landscape"],"_single_video_site":["youtube"],"_disable_featured_image":["true"],"_disable_meta":["true"],"_disable_tags":["true"],"_disable_related_posts":["true"],"_disable_about_author":["true"],"_disable_comments":["true"],"_enable_slidehsow":["false"],"_slideshow_source":["layerslider"],"_edge_full_height":["true"],"_edge_height":["700"],"_edge_orderby":["menu_order"],"_edge_order":["ASC"],"_edge_animation_speed":["600"],"_edge_pause_time":["15000"],"_edge_direction_nav":["true"],"_icarousel_count":["3"],"_icarousel_orderby":["menu_order"],"_icarousel_order":["ASC"],"_icarousel_autoplay":["true"],"_icarousel_3d":["true"],"_icarousel_perspective":["35"],"_icarousel_pause_on_hover":["true"],"_icarousel_easing":["easeOutCubic"],"_icarousel_animation_speed":["500"],"_icarousel_pause_time":["5000"],"_icarousel_direction_nav":["true"],"_flexslider_height":["400"],"_flexslider_pagination":["circle"],"_flexslider_count":["10"],"_flexslider_disableCaption":["true"],"_flexslider_orderby":["menu_order"],"_flexslider_order":["ASC"],"_flexslider_slideshow":["true"],"_flexslider_pauseOnHover":["true"],"_flexslider_easing":["easeOutCubic"],"_flexslider_slideshowSpeed":["5000"],"_flexslider_animationDuration":["600"],"_banner_minHeight":["200"],"_banner_padding":["30"],"_banner_animation":["fade"],"_banner_orderby":["menu_order"],"_banner_order":["ASC"],"_banner_slideshow":["true"],"_banner_slideshowSpeed":["5000"],"_banner_animationDuration":["600"],"_enable_local_backgrounds":["false"],"background_selector_orientation":["full_width_layout"],"boxed_layout_shadow_size":["0"],"boxed_layout_shadow_intensity":["0"],"body_color_rgba":["1"],"body_source":["no-image"],"body_parallax":["false"],"page_color_rgba":["1"],"page_source":["no-image"],"page_parallax":["false"],"header_color_rgba":["1"],"header_source":["no-image"],"header_parallax":["false"],"banner_color_rgba":["1"],"banner_source":["no-image"],"banner_parallax":["false"],"footer_color_rgba":["1"],"footer_source":["no-image"],"footer_parallax":["false"],"_mk_post_love":["4"],"_sidebar":["Free Tutorials"],"_theme_options_build":["6a3af18ea5f53"],"views":["9460"],"_dynamic_styles":["Tjs="],"_yoast_wpseo_title":["Excel tutorial"],"_eb_reusable_block_ids":["a:0:{}"],"_eael_post_view_count":["2292"],"rank_math_title":["Excel tutorial"],"rank_math_news_sitemap_robots":["index"],"rank_math_robots":["a:1:{i:0;s:5:\"index\";}"],"rank_math_analytic_object_id":["198"],"rank_math_internal_links_processed":["1"],"_uag_page_assets":["a:9:{s:3:\"css\";s:0:\"\";s:2:\"js\";s:0:\"\";s:18:\"current_block_list\";a:0:{}s:8:\"uag_flag\";b:0;s:11:\"uag_version\";s:10:\"1782610208\";s:6:\"gfonts\";a:0:{}s:10:\"gfonts_url\";s:0:\"\";s:12:\"gfonts_files\";a:0:{}s:14:\"uag_faq_layout\";b:0;}"],"_elementor_page_assets":["a:0:{}"]},"uagb_featured_image_src":{"full":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2016\/01\/Excel-2016-Complete-Tutorial-by-Sali-Kaceli-e1496367079255.png",1062,591,false],"thumbnail":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2016\/01\/Excel-2016-Complete-Tutorial-by-Sali-Kaceli-e1496367079255-150x150.png",150,150,true],"medium":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2016\/01\/Excel-2016-Complete-Tutorial-by-Sali-Kaceli-e1496367079255-300x300.png",300,300,true],"medium_large":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2016\/01\/Excel-2016-Complete-Tutorial-by-Sali-Kaceli-e1496367079255-768x427.png",768,427,true],"large":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2016\/01\/Excel-2016-Complete-Tutorial-by-Sali-Kaceli-e1496367079255-1024x1024.png",1024,1024,true],"1536x1536":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2016\/01\/Excel-2016-Complete-Tutorial-by-Sali-Kaceli-e1496367079255-1536x1536.png",1536,1536,true],"2048x2048":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2016\/01\/Excel-2016-Complete-Tutorial-by-Sali-Kaceli-e1496367079255-2048x2048.png",2048,2048,true],"image-size-150x150":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2016\/01\/Excel-2016-Complete-Tutorial-by-Sali-Kaceli-e1496367079255-150x150.png",150,150,true],"image-size-550x550":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2016\/01\/Excel-2016-Complete-Tutorial-by-Sali-Kaceli-e1496367079255-550x550.png",550,550,true],"image-size-550x550-@2x":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2016\/01\/Excel-2016-Complete-Tutorial-by-Sali-Kaceli-e1496367079255-1100x1100.png",1100,1100,true],"photo-album-thumbnail-small":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2016\/01\/Excel-2016-Complete-Tutorial-by-Sali-Kaceli-e1496367079255-150x100.png",150,100,true],"photo-album-thumbnail-square":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2016\/01\/Excel-2016-Complete-Tutorial-by-Sali-Kaceli-e1496367079255-500x500.png",500,500,true],"employees-large":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2016\/01\/Excel-2016-Complete-Tutorial-by-Sali-Kaceli-e1496367079255-500x500.png",500,500,true],"employees-small":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2016\/01\/Excel-2016-Complete-Tutorial-by-Sali-Kaceli-e1496367079255-225x225.png",225,225,true],"blog-magazine-thumbnail":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2016\/01\/Excel-2016-Complete-Tutorial-by-Sali-Kaceli-e1496367079255-200x200.png",200,200,true],"blog-magazine-thumbnail-@2x":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2016\/01\/Excel-2016-Complete-Tutorial-by-Sali-Kaceli-e1496367079255-400x400.png",400,400,true],"woocommerce-recent-carousel":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2016\/01\/Excel-2016-Complete-Tutorial-by-Sali-Kaceli-e1496367079255-330x260.png",330,260,true],"blog-carousel":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2016\/01\/Excel-2016-Complete-Tutorial-by-Sali-Kaceli-e1496367079255-245x180.png",245,180,true],"blog-carousel-@2x":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2016\/01\/Excel-2016-Complete-Tutorial-by-Sali-Kaceli-e1496367079255-490x360.png",490,360,true],"blog-showcase":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2016\/01\/Excel-2016-Complete-Tutorial-by-Sali-Kaceli-e1496367079255-260x180.png",260,180,true],"blog-showcase-@2x":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2016\/01\/Excel-2016-Complete-Tutorial-by-Sali-Kaceli-e1496367079255-520x360.png",520,360,true],"portfolio-x_x":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2016\/01\/Excel-2016-Complete-Tutorial-by-Sali-Kaceli-e1496367079255-300x300.png",300,300,true],"portfolio-two_x_x":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2016\/01\/Excel-2016-Complete-Tutorial-by-Sali-Kaceli-e1496367079255-600x300.png",600,300,true],"portfolio-four_x_x":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2016\/01\/Excel-2016-Complete-Tutorial-by-Sali-Kaceli-e1496367079255-1200x300.png",1200,300,true],"portfolio-x_two_x":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2016\/01\/Excel-2016-Complete-Tutorial-by-Sali-Kaceli-e1496367079255-300x620.png",300,620,true],"portfolio-two_x_two_x":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2016\/01\/Excel-2016-Complete-Tutorial-by-Sali-Kaceli-e1496367079255-600x600.png",600,600,true],"portfolio-three_x_two_x":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2016\/01\/Excel-2016-Complete-Tutorial-by-Sali-Kaceli-e1496367079255-900x600.png",900,600,true],"portfolio-three_x_x":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2016\/01\/Excel-2016-Complete-Tutorial-by-Sali-Kaceli-e1496367079255-900x300.png",900,300,true],"portfolio-four_x_two_x":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2016\/01\/Excel-2016-Complete-Tutorial-by-Sali-Kaceli-e1496367079255-1200x600.png",1200,600,true],"portfolio-x_x-@2x":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2016\/01\/Excel-2016-Complete-Tutorial-by-Sali-Kaceli-e1496367079255-600x600.png",600,600,true],"portfolio-two_x_x-@2x":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2016\/01\/Excel-2016-Complete-Tutorial-by-Sali-Kaceli-e1496367079255-1200x600.png",1200,600,true],"portfolio-four_x_x-@2x":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2016\/01\/Excel-2016-Complete-Tutorial-by-Sali-Kaceli-e1496367079255-2400x600.png",2400,600,true],"portfolio-x_two_x-@2x":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2016\/01\/Excel-2016-Complete-Tutorial-by-Sali-Kaceli-e1496367079255-600x1240.png",600,1240,true],"portfolio-two_x_two_x-@2x":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2016\/01\/Excel-2016-Complete-Tutorial-by-Sali-Kaceli-e1496367079255-1200x1200.png",1200,1200,true],"portfolio-three_x_x-@2x":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2016\/01\/Excel-2016-Complete-Tutorial-by-Sali-Kaceli-e1496367079255-1800x600.png",1800,600,true],"portfolio-three_x_two_x-@2x":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2016\/01\/Excel-2016-Complete-Tutorial-by-Sali-Kaceli-e1496367079255-1800x1200.png",1800,1200,true],"portfolio-four_x_two_x-@2x":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2016\/01\/Excel-2016-Complete-Tutorial-by-Sali-Kaceli-e1496367079255-2400x1200.png",2400,1200,true],"portfolio-four_x_x-@mobile":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2016\/01\/Excel-2016-Complete-Tutorial-by-Sali-Kaceli-e1496367079255-736x184.png",736,184,true],"portfolio-three_x_x-@mobile":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2016\/01\/Excel-2016-Complete-Tutorial-by-Sali-Kaceli-e1496367079255-736x245.png",736,245,true],"portfolio-three_x_two_x-@mobile":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2016\/01\/Excel-2016-Complete-Tutorial-by-Sali-Kaceli-e1496367079255-736x490.png",736,490,true],"portfolio-four_x_two_x-@mobile":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2016\/01\/Excel-2016-Complete-Tutorial-by-Sali-Kaceli-e1496367079255-736x368.png",736,368,true],"landscape-desktop":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2016\/01\/Excel-2016-Complete-Tutorial-by-Sali-Kaceli-e1496367079255-1920x1280.png",1920,1280,true],"landscape-tablet":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2016\/01\/Excel-2016-Complete-Tutorial-by-Sali-Kaceli-e1496367079255-1024x768.png",1024,768,true],"landscape-mobile":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2016\/01\/Excel-2016-Complete-Tutorial-by-Sali-Kaceli-e1496367079255-736x414.png",736,414,true],"portrait-desktop":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2016\/01\/Excel-2016-Complete-Tutorial-by-Sali-Kaceli-e1496367079255-1280x1920.png",1280,1920,true],"portrait-tablet":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2016\/01\/Excel-2016-Complete-Tutorial-by-Sali-Kaceli-e1496367079255-768x1024.png",768,1024,true],"portrait-mobile":["https:\/\/kaceli.com\/a\/wp-content\/uploads\/2016\/01\/Excel-2016-Complete-Tutorial-by-Sali-Kaceli-e1496367079255-414x736.png",414,736,true]},"uagb_author_info":{"display_name":"Sali","author_link":"https:\/\/kaceli.com\/a\/author\/skaceligmail-com\/"},"uagb_comment_info":1,"uagb_excerpt":"Here is a comprehensive tutorial on using Excel 2016, whether you are a student, a business user or in a corporate environment. Learn Excel (including the new features) in just a couple hours from the basics to the advanced features such as financial formulas to recharge your career and resume. Visit us also at https:\/\/kaceli.com\/a…","_links":{"self":[{"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/posts\/7579","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=7579"}],"version-history":[{"count":0,"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/posts\/7579\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/media\/7580"}],"wp:attachment":[{"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/media?parent=7579"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/categories?post=7579"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kaceli.com\/a\/wp-json\/wp\/v2\/tags?post=7579"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}