{"id":4612,"date":"2014-09-18T18:33:44","date_gmt":"2014-09-18T23:33:44","guid":{"rendered":"http:\/\/cis.bentley.edu\/sandbox\/?page_id=4612"},"modified":"2022-02-07T11:44:38","modified_gmt":"2022-02-07T16:44:38","slug":"excel-2013-tutorial","status":"publish","type":"page","link":"https:\/\/cissandbox.bentley.edu\/sandbox\/index.php\/resources\/excel-2013-tutorial\/","title":{"rendered":"Excel 2013 Tutorials"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"4612\" class=\"elementor elementor-4612\" 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-319e1160 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"319e1160\" 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-2392ecc0\" data-id=\"2392ecc0\" 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-1db24690 elementor-widget__width-inherit elementor-widget elementor-widget-text-editor\" data-id=\"1db24690\" 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<h2><a href=\"https:\/\/www.youtube.com\/watch?v=jfMcSYZ4GRs\" target=\"_blank\" rel=\"noopener\">Formatting Excel Worksheet <\/a><\/h2>\r\n<iframe loading=\"lazy\" src=\"\/\/www.youtube-nocookie.com\/embed\/jfMcSYZ4GRs\" width=\"640\" height=\"360\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe>\r\n<h2><a href=\"https:\/\/www.youtube.com\/watch?v=K6HTOO8dZE8\" target=\"_blank\" rel=\"noopener\">Writing Formulas for Basic Calculations <\/a><\/h2>\r\n<iframe loading=\"lazy\" src=\"\/\/www.youtube-nocookie.com\/embed\/K6HTOO8dZE8\" width=\"640\" height=\"360\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe>\r\n<h2><a href=\"https:\/\/www.youtube.com\/watch?v=a5tow6cwl54\" target=\"_blank\" rel=\"noopener\">Creating and Editing Data Bars <\/a><\/h2>\r\n<iframe loading=\"lazy\" src=\"\/\/www.youtube.com\/embed\/a5tow6cwl54\" width=\"640\" height=\"360\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe>\r\n<h2><a href=\"https:\/\/www.youtube.com\/watch?v=U82Q2yJp4L8\" target=\"_blank\" rel=\"noopener\">Flash Fill <\/a><\/h2>\r\n<iframe loading=\"lazy\" src=\"\/\/www.youtube-nocookie.com\/embed\/U82Q2yJp4L8\" width=\"640\" height=\"360\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe>\r\n<h2><a href=\"https:\/\/www.youtube.com\/watch?v=BiyhTK78MJc\" target=\"_blank\" rel=\"noopener\">Making Decisions with IF Function <\/a><\/h2>\r\n<iframe loading=\"lazy\" src=\"\/\/www.youtube-nocookie.com\/embed\/BiyhTK78MJc\" width=\"640\" height=\"360\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe>\r\n<h2><a href=\"https:\/\/www.youtube.com\/watch?v=7n0WO4HekuQ\" target=\"_blank\" rel=\"noopener\">Relative &amp; Absolute Referencing <\/a><\/h2>\r\n<iframe loading=\"lazy\" src=\"\/\/www.youtube-nocookie.com\/embed\/7n0WO4HekuQ\" width=\"640\" height=\"360\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe>\r\n<h2><a href=\"https:\/\/www.youtube.com\/watch?v=sG5mUdhnFmA\" target=\"_blank\" rel=\"noopener\">Finding Data Using VLookup<\/a><\/h2>\r\n<iframe loading=\"lazy\" src=\"\/\/www.youtube-nocookie.com\/embed\/sG5mUdhnFmA\" width=\"640\" height=\"360\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe>\r\n<h2><a href=\"https:\/\/www.youtube.com\/watch?v=BsUZoVlH9DM\" target=\"_blank\" rel=\"noopener\">Conditional Formatting<\/a><\/h2>\r\n<iframe loading=\"lazy\" src=\"\/\/www.youtube-nocookie.com\/embed\/BsUZoVlH9DM\" width=\"640\" height=\"360\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe>\r\n<h2><a href=\"https:\/\/www.youtube.com\/watch?v=ihr5KZ8uOd4\" target=\"_blank\" rel=\"noopener\">Date Functions<\/a><\/h2>\r\n<iframe loading=\"lazy\" src=\"\/\/www.youtube-nocookie.com\/embed\/ihr5KZ8uOd4\" width=\"640\" height=\"360\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe>\r\n<h2><a href=\"https:\/\/www.youtube.com\/watch?v=6vep1DROxXA\" target=\"_blank\" rel=\"noopener\">AutoFill<\/a><\/h2>\r\n<iframe loading=\"lazy\" src=\"\/\/www.youtube-nocookie.com\/embed\/6vep1DROxXA\" width=\"640\" height=\"360\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe>\r\n<h2><a href=\"https:\/\/www.youtube.com\/watch?v=1jvNjAWADo04\" target=\"_blank\" rel=\"noopener\">Creating a Chart<\/a><\/h2>\r\n<iframe loading=\"lazy\" src=\"\/\/www.youtube-nocookie.com\/embed\/1jvNjAWADo0\" width=\"640\" height=\"360\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe>\r\n<h2><a href=\"https:\/\/www.youtube.com\/watch?v=MQLoMUuAY9A\" target=\"_blank\" rel=\"noopener\">Analyzing Information with PivotTables<\/a><\/h2>\r\n<iframe loading=\"lazy\" src=\"\/\/www.youtube-nocookie.com\/embed\/MQLoMUuAY9A\" width=\"640\" height=\"360\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe>\r\n<h2><a href=\"https:\/\/www.youtube.com\/watch?v=CZmeTkkrGg4\" target=\"_blank\" rel=\"noopener\">Nested IF Statement<\/a><\/h2>\r\n<iframe loading=\"lazy\" src=\"\/\/www.youtube-nocookie.com\/embed\/CZmeTkkrGg4\" width=\"640\" height=\"360\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe>\r\n<h2><a href=\"https:\/\/www.youtube.com\/watch?v=JpgC0Cjq-9Y\" target=\"_blank\" rel=\"noopener\">What If Analysis<\/a><\/h2>\r\n<iframe loading=\"lazy\" src=\"\/\/www.youtube-nocookie.com\/embed\/JpgC0Cjq-9Y\" width=\"640\" height=\"360\" 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>Formatting Excel Worksheet Writing Formulas for Basic Calculations Creating and Editing Data Bars Flash Fill Making Decisions with IF Function Relative &amp; Absolute Referencing Finding Data Using VLookup Conditional Formatting Date Functions AutoFill Creating a Chart Analyzing Information with PivotTables Nested IF Statement What If Analysis<\/p>\n","protected":false},"author":148,"featured_media":0,"parent":205,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"elementor_header_footer","meta":{"_acf_changed":false,"_mi_skip_tracking":false,"ocean_post_layout":"","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-4612","page","type-page","status-publish","hentry","entry"],"acf":[],"_links":{"self":[{"href":"https:\/\/cissandbox.bentley.edu\/sandbox\/index.php\/wp-json\/wp\/v2\/pages\/4612","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\/148"}],"replies":[{"embeddable":true,"href":"https:\/\/cissandbox.bentley.edu\/sandbox\/index.php\/wp-json\/wp\/v2\/comments?post=4612"}],"version-history":[{"count":22,"href":"https:\/\/cissandbox.bentley.edu\/sandbox\/index.php\/wp-json\/wp\/v2\/pages\/4612\/revisions"}],"predecessor-version":[{"id":10551,"href":"https:\/\/cissandbox.bentley.edu\/sandbox\/index.php\/wp-json\/wp\/v2\/pages\/4612\/revisions\/10551"}],"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=4612"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}