{"id":33949,"date":"2021-10-14T17:41:38","date_gmt":"2021-10-14T15:41:38","guid":{"rendered":"https:\/\/blog.sheetgo.com\/?p=33949"},"modified":"2025-11-11T21:25:47","modified_gmt":"2025-11-11T20:25:47","slug":"modele-okr-excel","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/fr\/blog\/human-resources-templates\/okr-template-excel\/","title":{"rendered":"Mod\u00e8le de suivi des OKR dans Microsoft Excel"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; module_class=&#8221;sheetgo-post&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; da_disable_devices=&#8221;off|off|off&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; da_is_popup=&#8221;off&#8221; da_exit_intent=&#8221;off&#8221; da_has_close=&#8221;on&#8221; da_alt_close=&#8221;off&#8221; da_dark_close=&#8221;off&#8221; da_not_modal=&#8221;on&#8221; da_is_singular=&#8221;off&#8221; da_with_loader=&#8221;off&#8221; da_has_shadow=&#8221;on&#8221;][et_pb_row _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; hover_enabled=&#8221;0&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<p>Many organizations use Objectives and Key Results (OKRs) for setting objectives or goals and measuring performance.<\/p>\n<p>Developed originally by <a href=\"https:\/\/en.wikipedia.org\/wiki\/OKR\" target=\"_blank\" rel=\"noopener\">Andy Grove<\/a> in the 70s, the method saw a rise in popularity after being adopted by tech giant Google. The OKR framework is arguably one of the catalysts that helped Google grow to its current size.<\/p>\n<p>Meanwhile, the OKR framework has been adopted by many other fast-rising companies in the technology sector such as LinkedIn, Twitter, Dropbox, Spotify, and Uber.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; hover_enabled=&#8221;0&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<h2>What do OKRs actually mean for companies?<\/h2>\n<p>Every organization benefits from having clearly defined goals and metrics. This is where OKRs come in to help companies plan and evaluate organizational performance.<\/p>\n<p>First, set clearly defined goals throughout the entire organization. Then, track the progress made towards completion to make sure these goals are being achieved.The OKR method is designed to help teams:<\/p>\n<ul>\n<li>Align targets across the entire organization<\/li>\n<li>Set goals at the individual, team, and company level<\/li>\n<li>Reach ambitious milestones quickly<\/li>\n<li>Encourage innovation<\/li>\n<\/ul>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; hover_enabled=&#8221;0&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<h2>Is there a difference between KPIs and OKRs?<\/h2>\n<p>Both KPIs and OKRs are performance measurement tools. However, KPIs and OKRs are not the same thing. KPIs (Key Performance Indicators) focus on reporting results and performance. In contrast, OKRs are goal-oriented. Besides, OKRs are more specific and have results that can be measured in a numerical format.<\/p>\n<p>Another difference is the time span. Once KPIs are set, they usually remain the same for an extended period of time. In contrast, OKR\u2019s are more short-term focused. As such, they track progress over a defined time period: usually a business quarter.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; hover_enabled=&#8221;0&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<h2>How can organizations track OKRs?<\/h2>\n<p>As mentioned before, the OKR framework is popular amongst tech companies in Silicon Valley. However, not only do the tech giants benefit from using OKRs. Any company that operates in a fast-paced business environment will find OKRs useful for achieving specific goals within short timeframes.<\/p>\n<p>While many tools exist to help organizations manage their performance, there is no real need to invest heavily in expensive specialist software. Instead, create an effective OKR tracking system using an <a href=\"https:\/\/drive.google.com\/uc?export=download&amp;id=150J60o8D03pwa71nun8ZFl8Z_Ja-35dp\" target=\"_blank\" rel=\"noopener\">OKR template<\/a> in Microsoft Excel.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;3_5,2_5&#8243; make_equal=&#8221;on&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#F6F8F9&#8243; custom_padding=&#8221;30px|30px|30px|30px|true|true&#8221; border_radii=&#8221;on|12px|12px|12px|12px&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_css_main_element=&#8221;margin:auto&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;RGBA(255,255,255,0)&#8221; hover_enabled=&#8221;0&#8243; text_font_size_tablet=&#8221;17px&#8221; text_font_size_phone=&#8221;17px&#8221; text_font_size_last_edited=&#8221;off|desktop&#8221; header_4_font_tablet=&#8221;&#8221; header_4_font_phone=&#8221;&#8221; header_4_font_last_edited=&#8221;on|tablet&#8221; text_orientation_tablet=&#8221;center&#8221; text_orientation_phone=&#8221;center&#8221; text_orientation_last_edited=&#8221;on|phone&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; text_font_size=&#8221;30px&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<p><strong>Start tracking <span style=\"background-color: rgba(41,121,255,0.2);\">OKRs<\/span> and department progress<\/strong><\/p>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_css_main_element=&#8221;margin:auto&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_button button_url=&#8221;https:\/\/drive.google.com\/uc?export=download&#038;id=150J60o8D03pwa71nun8ZFl8Z_Ja-35dp&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;Get template&#8221; button_alignment=&#8221;center&#8221; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;16px&#8221; button_text_color=&#8221;#ffffff&#8221; button_bg_color=&#8221;#2979ff&#8221; button_border_width=&#8221;0px&#8221; button_border_radius=&#8221;6px&#8221; button_font=&#8221;|700|||||||&#8221; button_use_icon=&#8221;off&#8221; custom_margin=&#8221;0px|0px|0px|0px|true|true&#8221; custom_margin_tablet=&#8221;10px||||false|false&#8221; custom_margin_phone=&#8221;10px||||false|false&#8221; custom_margin_last_edited=&#8221;on|phone&#8221; custom_padding=&#8221;15px|16px|15px|16px|true|true&#8221; saved_tabs=&#8221;all&#8221; global_colors_info=&#8221;{}&#8221; button_bg_color__hover_enabled=&#8221;on|hover&#8221; button_bg_color__hover=&#8221;rgba(41,121,255,0.7)&#8221; button_bg_enable_color__hover=&#8221;on&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; hover_enabled=&#8221;0&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<h2>Why use Excel to track OKRs?<\/h2>\n<ul>\n<li><b>Flexibility:<\/b> Excel spreadsheets can be modified and changed according to your organization\u2019s needs and requirements. As such, there is no need for complicated software solutions or putting pressure on your IT department to build a customized system.<\/li>\n<li><b>Accessibility:<\/b> Whether you are working from a tablet, a desktop, laptop, or smartphone, managers and employees always have access to the workflow.<\/li>\n<li><b>Compatibility:<\/b> Microsoft Excel is easily compatible with other software that your organization might be using. Therefore, any related company data you already have is easily imported into Excel spreadsheets.<\/li>\n<li><b>Ease of use:<\/b> Many employees are familiar with spreadsheets and if they are not, it is easy to train them. Indeed, using an Excel-based template is ideal for beginners and advanced users alike.<\/li>\n<\/ul>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/05\/2.png&#8221; alt=&#8221;Okr Template Excel dashboard 2&#8243; title_text=&#8221;Okr Template Excel dashboard 2&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; hover_enabled=&#8221;0&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<h2>Get the Company OKR template<\/h2>\n<p>Click the blue button below to get started.<\/p>\n<p>[\/et_pb_text][et_pb_button button_url=&#8221;https:\/\/drive.google.com\/uc?export=download&#038;id=150J60o8D03pwa71nun8ZFl8Z_Ja-35dp&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;Get template&#8221; button_alignment=&#8221;center&#8221; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;16px&#8221; button_text_color=&#8221;#ffffff&#8221; button_bg_color=&#8221;#2979ff&#8221; button_border_width=&#8221;0px&#8221; button_border_radius=&#8221;6px&#8221; button_font=&#8221;|700|||||||&#8221; button_use_icon=&#8221;off&#8221; custom_margin=&#8221;30px|0px|30px|0px|false|true&#8221; custom_margin_tablet=&#8221;10px||||false|false&#8221; custom_margin_phone=&#8221;10px||||false|false&#8221; custom_margin_last_edited=&#8221;on|phone&#8221; custom_padding=&#8221;15px|16px|15px|16px|true|true&#8221; saved_tabs=&#8221;all&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221; button_bg_color__hover_enabled=&#8221;on|hover&#8221; button_bg_color__hover=&#8221;rgba(41,121,255,0.7)&#8221; button_bg_enable_color__hover=&#8221;on&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_button][et_pb_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; hover_enabled=&#8221;0&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<h3>Step 1: Define teams and objectives<\/h3>\n<p>The first step for each team is to agree on its objectives. Afterwards, enter these objectives into the <b>Team Objectives<\/b> tab.<\/p>\n<p>Ensure that each objective has a clearly distinguishable title to avoid confusion when allocating key results to each objective.<\/p>\n<p>Keep in mind that objectives are not the same as goals. Goals represent a destination while objectives are milestones on the way to that destination.<\/p>\n<p>Besides that, ensure that your objectives are S.M.A.R.T., that is to say: specific, measurable, attainable, realistic, and time-bound.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/05\/objectives-goed.png&#8221; alt=&#8221;Okr Template Excel objectives 5&#8243; title_text=&#8221;Okr Template Excel objectives 5&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; hover_enabled=&#8221;0&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; sticky_enabled=&#8221;0&#8243; custom_padding=&#8221;2px|||||&#8221;]<\/p>\n<h3>Step 2: Teams set their Key Results<\/h3>\n<ol>\n<li>In the <b>Key Results<\/b> tab, choose an <b>Objective<\/b> from the dropdown menu and enter how you will achieve that goal in <b>Column B: Key Result<\/b>. Remember that key results must be measurable.<\/li>\n<li>Now type the name of the colleague responsible in <b>Column C: Owner<\/b>.<\/li>\n<li>Then enter a <b>Metric<\/b> in <b>Column D<\/b>.<\/li>\n<li>Finally, enter a <b>Start Value<\/b> and <b>Target<\/b> in <b>Columns E and F<\/b>.<\/li>\n<\/ol>\n<p>The sample data contains some insight into what these values can look like.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/05\/results-goed.png&#8221; alt=&#8221;Okr Template Excel results 6&#8243; title_text=&#8221;Okr Template Excel results 6&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; hover_enabled=&#8221;0&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<h3>Step 3: Log progress<\/h3>\n<p>Enter the progress towards their OKRs and fill out <b>Column G: Current Value<\/b> in the <b>Key Results<\/b> tab.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; hover_enabled=&#8221;0&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<h2>Congratulations!<\/h2>\n<p>Your OKR template in Excel is now up and running.<\/p>\n<p>If you are looking for more templates, check out the post on Sheetgo&#8217;s <a href=\"https:\/\/www.sheetgo.com\/blog\/human-resources-templates\/employee-timesheet-template-excel\/\">Employee timesheet template in Excel<\/a>.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row make_equal=&#8221;on&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#F6F8F9&#8243; custom_padding=&#8221;30px|30px|30px|30px|true|true&#8221; border_radii=&#8221;on|12px|12px|12px|12px&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_css_main_element=&#8221;margin:auto&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;RGBA(255,255,255,0)&#8221; text_orientation=&#8221;center&#8221; hover_enabled=&#8221;0&#8243; text_font_size_tablet=&#8221;17px&#8221; text_font_size_phone=&#8221;17px&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; header_4_font_tablet=&#8221;&#8221; header_4_font_phone=&#8221;&#8221; header_4_font_last_edited=&#8221;on|tablet&#8221; text_orientation_tablet=&#8221;center&#8221; text_orientation_phone=&#8221;center&#8221; text_orientation_last_edited=&#8221;on|phone&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; text_font_size=&#8221;30px&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<p><strong>Start tracking individuals&#8217; <span style=\"background-color: rgba(41,121,255,0.2);\">OKRs<\/span> and department progress<\/strong><\/p>\n<p>[\/et_pb_text][et_pb_button button_url=&#8221;https:\/\/drive.google.com\/uc?export=download&#038;id=150J60o8D03pwa71nun8ZFl8Z_Ja-35dp&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;Get template&#8221; button_alignment=&#8221;center&#8221; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;16px&#8221; button_text_color=&#8221;#ffffff&#8221; button_bg_color=&#8221;#2979ff&#8221; button_border_width=&#8221;0px&#8221; button_border_radius=&#8221;6px&#8221; button_font=&#8221;|700|||||||&#8221; button_use_icon=&#8221;off&#8221; custom_margin=&#8221;25px|0px|25px|0px|true|true&#8221; custom_margin_tablet=&#8221;10px||||false|false&#8221; custom_margin_phone=&#8221;10px||||false|false&#8221; custom_margin_last_edited=&#8221;on|phone&#8221; custom_padding=&#8221;15px|16px|15px|16px|true|true&#8221; hover_enabled=&#8221;0&#8243; saved_tabs=&#8221;all&#8221; global_colors_info=&#8221;{}&#8221; button_bg_color__hover_enabled=&#8221;on|hover&#8221; button_bg_color__hover=&#8221;rgba(41,121,255,0.7)&#8221; button_bg_enable_color__hover=&#8221;on&#8221; theme_builder_area=&#8221;post_content&#8221; sticky_enabled=&#8221;0&#8243;][\/et_pb_button][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Many organizations use Objectives and Key Results (OKRs) for setting objectives or goals and measuring performance. Developed originally by Andy Grove in the 70s, the method saw a rise in popularity after being adopted by tech giant Google. The OKR framework is arguably one of the catalysts that helped Google grow to its current size. [&hellip;]<\/p>\n","protected":false},"author":40,"featured_media":33950,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[42],"tags":[44],"class_list":["post-33949","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-human-resources-templates","tag-human-resources"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/33949","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/comments?post=33949"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/33949\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/33950"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=33949"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=33949"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=33949"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}