{"id":5853,"date":"2016-06-23T16:16:13","date_gmt":"2016-06-23T20:16:13","guid":{"rendered":"http:\/\/cis.bentley.edu\/sandbox\/?page_id=5853"},"modified":"2022-02-07T11:42:58","modified_gmt":"2022-02-07T16:42:58","slug":"excel2016","status":"publish","type":"page","link":"https:\/\/cissandbox.bentley.edu\/sandbox\/index.php\/resources\/excel2016\/","title":{"rendered":"Excel 2016 Tutorials"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"5853\" class=\"elementor elementor-5853\" data-elementor-settings=\"[]\">\n\t\t\t\t\t\t<div class=\"elementor-inner\">\n\t\t\t\t\t\t\t<div class=\"elementor-section-wrap\">\n\t\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-90173e1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"90173e1\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6709a25c\" data-id=\"6709a25c\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1991b598 elementor-widget__width-inherit elementor-widget elementor-widget-text-editor\" data-id=\"1991b598\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<a href=\"https:\/\/youtu.be\/ALX4wAXw098?list=PLlU1GghhEkTIbKljevwrI313GOPIqIfKT\" target=\"_blank\" rel=\"noopener\">Create a Chart<\/a>\r\n\r\n<iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/ALX4wAXw098?list=PLlU1GghhEkTIbKljevwrI313GOPIqIfKT\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe>\r\n\r\n<a href=\"https:\/\/youtu.be\/3VWsSd7qrBQ?list=PLlU1GghhEkTIbKljevwrI313GOPIqIfKT\" target=\"_blank\" rel=\"noopener\">Date Function<\/a>\r\n\r\n<iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/3VWsSd7qrBQ?list=PLlU1GghhEkTIbKljevwrI313GOPIqIfKT\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe>\r\n\r\n<a href=\"https:\/\/youtu.be\/W2LeSiZBgEk?list=PLlU1GghhEkTIbKljevwrI313GOPIqIfKT\" target=\"_blank\" rel=\"noopener\">Absolute and Relative References<\/a>\r\n\r\n<iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/W2LeSiZBgEk?list=PLlU1GghhEkTIbKljevwrI313GOPIqIfKT\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe>\r\n\r\n<a href=\"https:\/\/youtu.be\/mGj247yWOa8?list=PLlU1GghhEkTIbKljevwrI313GOPIqIfKT\" target=\"_blank\" rel=\"noopener\">If Statements<\/a>\r\n\r\n<iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/mGj247yWOa8?list=PLlU1GghhEkTIbKljevwrI313GOPIqIfKT\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe>\r\n\r\n<a href=\"https:\/\/youtu.be\/PXKBXUh0Ml0?list=PLlU1GghhEkTIbKljevwrI313GOPIqIfKT\" target=\"_blank\" rel=\"noopener\">Nested-If Statements<\/a>\r\n\r\n<iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/PXKBXUh0Ml0?list=PLlU1GghhEkTIbKljevwrI313GOPIqIfKT\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe>\r\n\r\n<a href=\"https:\/\/youtu.be\/Cc-24qH8R4c?list=PLlU1GghhEkTIbKljevwrI313GOPIqIfKT\" target=\"_blank\" rel=\"noopener\">Basic Excel Functions<\/a>\r\n\r\n<iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/Cc-24qH8R4c?list=PLlU1GghhEkTIbKljevwrI313GOPIqIfKT\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe>\r\n\r\n<a href=\"https:\/\/youtu.be\/su1UHk4povE?list=PLlU1GghhEkTIbKljevwrI313GOPIqIfKT\" target=\"_blank\" rel=\"noopener\">Formatting in Excel<\/a>\r\n\r\n<iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/su1UHk4povE?list=PLlU1GghhEkTIbKljevwrI313GOPIqIfKT\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe>\r\n\r\n<a href=\"https:\/\/youtu.be\/JZPy-ScGdog?list=PLlU1GghhEkTIbKljevwrI313GOPIqIfKT\" target=\"_blank\" rel=\"noopener\">IFFY Function<\/a>\r\n\r\n<iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/JZPy-ScGdog?list=PLlU1GghhEkTIbKljevwrI313GOPIqIfKT\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe>\r\n\r\n<a href=\"https:\/\/youtu.be\/8NinKZlGsyY?list=PLlU1GghhEkTIbKljevwrI313GOPIqIfKT\" target=\"_blank\" rel=\"noopener\">Vlookup<\/a>\r\n\r\n<iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/8NinKZlGsyY?list=PLlU1GghhEkTIbKljevwrI313GOPIqIfKT\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe>\r\n\r\n<a href=\"https:\/\/youtu.be\/Dps-98mqA50?list=PLlU1GghhEkTIbKljevwrI313GOPIqIfKT\" target=\"_blank\" rel=\"noopener\">Named Ranges<\/a>\r\n\r\n<iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/Dps-98mqA50?list=PLlU1GghhEkTIbKljevwrI313GOPIqIfKT\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe>\r\n\r\n<a href=\"https:\/\/youtu.be\/BR2xhAZCYj0?list=PLlU1GghhEkTIbKljevwrI313GOPIqIfKT\" target=\"_blank\" rel=\"noopener\">Access Data from Different Workbooks<\/a>\r\n\r\n<iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/BR2xhAZCYj0?list=PLlU1GghhEkTIbKljevwrI313GOPIqIfKT\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Create a Chart Date Function Absolute and Relative References If Statements Nested-If Statements Basic Excel Functions Formatting in Excel IFFY Function Vlookup Named Ranges Access Data from Different Workbooks<\/p>\n","protected":false},"author":176,"featured_media":0,"parent":205,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"elementor_header_footer","meta":{"_acf_changed":false,"_mi_skip_tracking":false,"ocean_post_layout":"full-width","ocean_both_sidebars_style":"","ocean_both_sidebars_content_width":0,"ocean_both_sidebars_sidebars_width":0,"ocean_sidebar":"0","ocean_second_sidebar":"0","ocean_disable_margins":"enable","ocean_add_body_class":"","ocean_shortcode_before_top_bar":"","ocean_shortcode_after_top_bar":"","ocean_shortcode_before_header":"","ocean_shortcode_after_header":"","ocean_has_shortcode":"","ocean_shortcode_after_title":"","ocean_shortcode_before_footer_widgets":"","ocean_shortcode_after_footer_widgets":"","ocean_shortcode_before_footer_bottom":"","ocean_shortcode_after_footer_bottom":"","ocean_display_top_bar":"default","ocean_display_header":"default","ocean_header_style":"","ocean_center_header_left_menu":"0","ocean_custom_header_template":"0","ocean_custom_logo":0,"ocean_custom_retina_logo":0,"ocean_custom_logo_max_width":0,"ocean_custom_logo_tablet_max_width":0,"ocean_custom_logo_mobile_max_width":0,"ocean_custom_logo_max_height":0,"ocean_custom_logo_tablet_max_height":0,"ocean_custom_logo_mobile_max_height":0,"ocean_header_custom_menu":"0","ocean_menu_typo_font_family":"0","ocean_menu_typo_font_subset":"","ocean_menu_typo_font_size":0,"ocean_menu_typo_font_size_tablet":0,"ocean_menu_typo_font_size_mobile":0,"ocean_menu_typo_font_size_unit":"px","ocean_menu_typo_font_weight":"","ocean_menu_typo_font_weight_tablet":"","ocean_menu_typo_font_weight_mobile":"","ocean_menu_typo_transform":"","ocean_menu_typo_transform_tablet":"","ocean_menu_typo_transform_mobile":"","ocean_menu_typo_line_height":0,"ocean_menu_typo_line_height_tablet":0,"ocean_menu_typo_line_height_mobile":0,"ocean_menu_typo_line_height_unit":"","ocean_menu_typo_spacing":0,"ocean_menu_typo_spacing_tablet":0,"ocean_menu_typo_spacing_mobile":0,"ocean_menu_typo_spacing_unit":"","ocean_menu_link_color":"","ocean_menu_link_color_hover":"","ocean_menu_link_color_active":"","ocean_menu_link_background":"","ocean_menu_link_hover_background":"","ocean_menu_link_active_background":"","ocean_menu_social_links_bg":"","ocean_menu_social_hover_links_bg":"","ocean_menu_social_links_color":"","ocean_menu_social_hover_links_color":"","ocean_disable_title":"default","ocean_disable_heading":"default","ocean_post_title":"","ocean_post_subheading":"","ocean_post_title_style":"","ocean_post_title_background_color":"","ocean_post_title_background":0,"ocean_post_title_bg_image_position":"","ocean_post_title_bg_image_attachment":"","ocean_post_title_bg_image_repeat":"","ocean_post_title_bg_image_size":"","ocean_post_title_height":0,"ocean_post_title_bg_overlay":0.5,"ocean_post_title_bg_overlay_color":"","ocean_disable_breadcrumbs":"default","ocean_breadcrumbs_color":"","ocean_breadcrumbs_separator_color":"","ocean_breadcrumbs_links_color":"","ocean_breadcrumbs_links_hover_color":"","ocean_display_footer_widgets":"default","ocean_display_footer_bottom":"default","ocean_custom_footer_template":"0","footnotes":""},"class_list":["post-5853","page","type-page","status-publish","hentry","entry"],"acf":[],"_links":{"self":[{"href":"https:\/\/cissandbox.bentley.edu\/sandbox\/index.php\/wp-json\/wp\/v2\/pages\/5853","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cissandbox.bentley.edu\/sandbox\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/cissandbox.bentley.edu\/sandbox\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/cissandbox.bentley.edu\/sandbox\/index.php\/wp-json\/wp\/v2\/users\/176"}],"replies":[{"embeddable":true,"href":"https:\/\/cissandbox.bentley.edu\/sandbox\/index.php\/wp-json\/wp\/v2\/comments?post=5853"}],"version-history":[{"count":12,"href":"https:\/\/cissandbox.bentley.edu\/sandbox\/index.php\/wp-json\/wp\/v2\/pages\/5853\/revisions"}],"predecessor-version":[{"id":10547,"href":"https:\/\/cissandbox.bentley.edu\/sandbox\/index.php\/wp-json\/wp\/v2\/pages\/5853\/revisions\/10547"}],"up":[{"embeddable":true,"href":"https:\/\/cissandbox.bentley.edu\/sandbox\/index.php\/wp-json\/wp\/v2\/pages\/205"}],"wp:attachment":[{"href":"https:\/\/cissandbox.bentley.edu\/sandbox\/index.php\/wp-json\/wp\/v2\/media?parent=5853"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}