{"id":34616,"date":"2025-09-15T09:28:22","date_gmt":"2025-09-15T14:28:22","guid":{"rendered":"https:\/\/excelevate.co\/wp\/?page_id=34616"},"modified":"2025-09-15T09:28:22","modified_gmt":"2025-09-15T14:28:22","slug":"modern-approaches-to-excel-formulas-training-workbook","status":"publish","type":"page","link":"https:\/\/excelevate.co\/wp\/home\/training\/modern-approaches-to-excel-formulas-training-workbook\/","title":{"rendered":"Modern Approaches to Excel Formulas Training Workbook"},"content":{"rendered":"<body><p><\/p>[et_pb_section fb_built=\u201d1\u2033 admin_label=\u201dsection\u201d _builder_version=\u201d4.16\u2033 global_colors_info=\u201d{}\u201d][et_pb_row admin_label=\u201drow\u201d _builder_version=\u201d4.16\u2033 background_size=\u201dinitial\u201d background_position=\u201dtop_left\u201d background_repeat=\u201drepeat\u201d custom_padding=\u201d||2px|||\u201d global_colors_info=\u201d{}\u201d][et_pb_column type=\u201d4_4\u2033 _builder_version=\u201d4.16\u2033 custom_padding=\u201d|||\u201d global_colors_info=\u201d{}\u201d custom_padding__hover=\u201d|||\u201d][et_pb_text admin_label=\u201dText\u201d _builder_version=\u201d4.20.0\u2033 background_size=\u201dinitial\u201d background_position=\u201dtop_left\u201d background_repeat=\u201drepeat\u201d global_colors_info=\u201d{}\u201d]\n<h1>Modern Approaches to Excel Formulas Training Workbook<\/h1>\n<p>\u00a0<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row admin_label=\u201drow\u201d _builder_version=\u201d4.20.0\u2033 background_color=\u201dRGBA(255,255,255,0)\u201d background_enable_image=\u201doff\u201d background_size=\u201dstretch\u201d background_position=\u201dtop_left\u201d custom_padding=\u201d||2px|||\u201d global_colors_info=\u201d{}\u201d][et_pb_column type=\u201d4_4\u2033 _builder_version=\u201d4.16\u2033 custom_padding=\u201d|||\u201d global_colors_info=\u201d{}\u201d custom_padding__hover=\u201d|||\u201d][et_pb_text admin_label=\u201dText\u201d _builder_version=\u201d4.27.4\u2033 background_size=\u201dinitial\u201d background_position=\u201dtop_left\u201d background_repeat=\u201drepeat\u201d global_colors_info=\u201d{}\u201d]<\/p>\n<h3>Summary<\/h3>\n<p>Use this workbook to follow along with our course titled <strong>Modern Approaches to Excel Formulas<\/strong>.<\/p>\n<p>[\/et_pb_text][et_pb_signup provider=\u201dmailerlite\u201d mailerlite_list=\u201dXLEV8_WP_API|85744827291928411\u2033 first_name_field=\u201doff\u201d last_name_field=\u201doff\u201d success_action=\u201dredirect\u201d success_redirect_url=\u201dhttps:\/\/excelevate.co\/wp\/wp-content\/uploads\/2025\/09\/Excel-Modern-Formulas-Workbook_2024-09-10.zip\u201d success_redirect_query=\u201doff|off|on|off|off\u201d title=\u201dGet your copy\u201d button_text=\u201dGet it now\u201d description=\u201d<\/p>\n<p>Want a copy of the Modern Approaches to Excel Formulas training workbook? Sign up for our email newsletter to access this great resource and lots of other insights!<\/p>\n<p>\u201d footer_content=\u201d<\/p>\n<p><span>We won\u2019t pass your details on to anyone else. By clicking the sign up button, you agree to our <\/span><a href=\"%22..\/home\/about\/terms-and-conditions\/%22\" data-et-target-link=\"%22_blank%22\" rel=\"%22noopener%22\">Terms of Use<\/a><span> and <\/span><a href=\"%22..\/home\/about\/privacy-policy\/%22\" data-et-target-link=\"%22_blank%22\" rel=\"%22noopener%22\">Privacy Policy.<\/a><\/p>\n<p>\u201d _builder_version=\u201d4.27.4\u2033 _module_preset=\u201ddefault\u201d form_field_text_color=\u201d#000000\u2033 background_color=\u201dRGBA(255,255,255,0)\u201d background_layout=\u201dlight\u201d hover_enabled=\u201d0\u2033 border_width_all=\u201d2px\u201d border_color_all=\u201d#000000\u2033 border_width_all_fields=\u201d1px\u201d border_color_all_fields=\u201d#000000\u2033 saved_tabs=\u201dall\u201d global_colors_info=\u201d{}\u201d sticky_enabled=\u201d0\u2033][\/et_pb_signup][et_pb_text content_tablet=\u201d<\/p>\n<div style=\"%22width:\" 50%; float: left;%22>\n<h3>Learning Objectives<\/h3>\n<table style=\"%22border:\" 0px; width: 100%;%22>\n<tbody>\n<tr>\n<td style=\"%22width:\" 32px; border: 0px; padding: 6px 0px;%22><img decoding=\"async\" src=\"%22https:\/\/excelevate.co\/wp\/wp-content\/uploads\/2023\/03\/important-icon_green_transparent.png%22\" style=\"%22width:\" 32px;%22 loading=\"lazy\"><\/td>\n<td style=\"%22border:\" 0px;%22>Understand efficiency and why it is important<\/td>\n<\/tr>\n<tr>\n<td style=\"%22padding:\" 6px 0px;%22><img decoding=\"async\" src=\"%22https:\/\/excelevate.co\/wp\/wp-content\/uploads\/2023\/03\/habit-icon_green_transparent.png%22\" style=\"%22width:\" 32px;%22 loading=\"lazy\"><\/td>\n<td>Learn the habits of highly efficient people<\/td>\n<\/tr>\n<tr>\n<td style=\"%22padding:\" 6px 0px;%22><img decoding=\"async\" src=\"%22https:\/\/excelevate.co\/wp\/wp-content\/uploads\/2023\/03\/shortcut_icon_green_transparent.png%22\" style=\"%22width:\" 32px;%22 loading=\"lazy\"><\/td>\n<td>Learn the power of using shortcuts<\/td>\n<\/tr>\n<tr>\n<td style=\"%22padding:\" 6px 0px;%22><img decoding=\"async\" src=\"%22https:\/\/excelevate.co\/wp\/wp-content\/uploads\/2020\/12\/light_bulb_efficiency_icon_transparent.png%22\" style=\"%22width:\" 32px;%22 loading=\"lazy\"><\/td>\n<td>Learn tips and tricks for improving efficiency<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div style=\"%22width:\" 50%; float: left;%22><img decoding=\"async\" src=\"%22https:\/\/excelevate.co\/wp\/wp-content\/uploads\/2023\/03\/Efficiency-cover-background_2023-03-05.jpg%22\" loading=\"lazy\"><\/div>\n<p>\u201d content_phone=\u201d<\/p>\n<h3>Learning Objectives<\/h3>\n<table style=\"%22border:\" 0px; width: 100%;%22>\n<tbody>\n<tr>\n<td style=\"%22width:\" 32px; border: 0px; padding: 6px 0px;%22><img decoding=\"async\" src=\"%22https:\/\/excelevate.co\/wp\/wp-content\/uploads\/2023\/03\/important-icon_green_transparent.png%22\" style=\"%22width:\" 32px;%22 loading=\"lazy\"><\/td>\n<td style=\"%22border:\" 0px;%22>Understand efficiency and why it is important<\/td>\n<\/tr>\n<tr>\n<td style=\"%22padding:\" 6px 0px;%22><img decoding=\"async\" src=\"%22https:\/\/excelevate.co\/wp\/wp-content\/uploads\/2023\/03\/habit-icon_green_transparent.png%22\" style=\"%22width:\" 32px;%22 loading=\"lazy\"><\/td>\n<td>Learn the habits of highly efficient people<\/td>\n<\/tr>\n<tr>\n<td style=\"%22padding:\" 6px 0px;%22><img decoding=\"async\" src=\"%22https:\/\/excelevate.co\/wp\/wp-content\/uploads\/2023\/03\/shortcut_icon_green_transparent.png%22\" style=\"%22width:\" 32px;%22 loading=\"lazy\"><\/td>\n<td>Learn the power of using shortcuts<\/td>\n<\/tr>\n<tr>\n<td style=\"%22padding:\" 6px 0px;%22><img decoding=\"async\" src=\"%22https:\/\/excelevate.co\/wp\/wp-content\/uploads\/2020\/12\/light_bulb_efficiency_icon_transparent.png%22\" style=\"%22width:\" 32px;%22 loading=\"lazy\"><\/td>\n<td>Learn tips and tricks for improving efficiency<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<div><img decoding=\"async\" src=\"%22https:\/\/excelevate.co\/wp\/wp-content\/uploads\/2023\/03\/Efficiency-cover-background_2023-03-05.jpg%22\" loading=\"lazy\"><\/div>\n<p>\u201d content_last_edited=\u201doff|desktop\u201d admin_label=\u201dText\u201d _builder_version=\u201d4.27.4\u2033 background_size=\u201dinitial\u201d background_position=\u201dtop_left\u201d background_repeat=\u201drepeat\u201d hover_enabled=\u201d0\u2033 global_colors_info=\u201d{}\u201d sticky_enabled=\u201d0\u2033]<\/p>\n<div style=\"text-align: center;\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/excelevate.co\/wp\/wp-content\/uploads\/2025\/09\/Modern-Formulas-Workbook-Screenshot_2025-09-10.png?w=1080&#038;ssl=1\" loading=\"lazy\"><\/div>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n<\/body><span class=\"et_bloom_bottom_trigger\"><\/span>","protected":false},"excerpt":{"rendered":"<p>This workbook accompanies our Modern Approaches to Excel Formulas training course.  Download and follow along with the examples.<\/p>\n","protected":false},"author":1,"featured_media":34618,"parent":68,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"Our <strong>Excel with Excel<\/strong> efficiency training is a three-hour course that targets intermediate Excel users who want to become more efficient with routine and ad-hoc tasks.\u00a0 We are working with the National Association of State Boards of Accountancy (NASBA) to approve this course for CPE credit.\u00a0 The course covers:\r\n<ul>\r\n \t<li>Using shortcuts (keyboard, ribbon, quick access, and pins)<\/li>\r\n \t<li>Tools, tips, and tricks<\/li>\r\n \t<li>Creating and using effective and efficient templates<\/li>\r\n \t<li>Creating and using macros<\/li>\r\n \t<li>Using the XLEV8 add-in<\/li>\r\n<\/ul>","_et_gb_content_width":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"class_list":["post-34616","page","type-page","status-publish","has-post-thumbnail","hentry"],"aioseo_notices":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/excelevate.co\/wp\/wp-json\/wp\/v2\/pages\/34616","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/excelevate.co\/wp\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/excelevate.co\/wp\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/excelevate.co\/wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/excelevate.co\/wp\/wp-json\/wp\/v2\/comments?post=34616"}],"version-history":[{"count":4,"href":"https:\/\/excelevate.co\/wp\/wp-json\/wp\/v2\/pages\/34616\/revisions"}],"predecessor-version":[{"id":34626,"href":"https:\/\/excelevate.co\/wp\/wp-json\/wp\/v2\/pages\/34616\/revisions\/34626"}],"up":[{"embeddable":true,"href":"https:\/\/excelevate.co\/wp\/wp-json\/wp\/v2\/pages\/68"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/excelevate.co\/wp\/wp-json\/wp\/v2\/media\/34618"}],"wp:attachment":[{"href":"https:\/\/excelevate.co\/wp\/wp-json\/wp\/v2\/media?parent=34616"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}