[et_pb_section fb_built=”1″ _builder_version=”4.16″ _module_preset=”default” da_disable_devices=”off|off|off” global_colors_info=”{}” theme_builder_area=”post_content” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on”][et_pb_row _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Project managers face the difficult duty of coordinating budgets and projects while overseeing employees and presenting reports to their superiors. Reaching multiple deadlines staying organized is an almost impossible task. This is only made worse if you have to manage an online team. As this is a common problem for many businesses, numerous software companies have developed tools to alleviate some of the workload. Sadly, most of these tools are extremely expensive, and actually complicate matters further thanks to the need for extra training to use the features effectively. Not only do you waste money, but you also waste precious time. That’s why Sheetgo has a project management template in Excel.<\/p>\n
If you\u2019ve used Microsoft Excel before, you\u2019re aware of its large array of capabilities, including real-time data syncing and comprehensive sharing capabilities. As a result, it\u2019s the perfect spreadsheet program for project management and collaboration with colleagues. The high level of cloud computing Microsoft Excel uses takes teamwork to a new level. The Project management template by Sheetgo is, therefore, the best way to create an entirely automated system using your Excel files. Let\u2019s explore how the template works and how you can implement it into your operations in a matter of minutes.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
To begin, follow these steps:<\/p>\n
[\/et_pb_text][et_pb_button button_url=”https:\/\/drive.google.com\/uc?export=download&id=1h8VkCX2NaTYuyz73obROgNfi89TUp6D9″ url_new_window=”on” button_text=”Get template” button_alignment=”center” _builder_version=”4.27.4″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#ffffff” button_bg_color=”#2979ff” button_border_width=”0px” button_border_radius=”6px” button_font=”|700|||||||” button_use_icon=”off” custom_margin=”0px|0px|30px|0px|false|true” custom_margin_tablet=”10px||||false|false” custom_margin_phone=”10px||||false|false” custom_margin_last_edited=”on|phone” custom_padding=”15px|16px|15px|16px|true|true” saved_tabs=”all” global_colors_info=”{}” button_bg_color__hover_enabled=”on|hover” button_bg_color__hover=”rgba(41,121,255,0.7)” button_bg_enable_color__hover=”on” theme_builder_area=”post_content”][\/et_pb_button][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\n
Open up the Project management file in Excel and open the Inputs<\/b> sheet.<\/p>\n
Adjust your settings in the boxes. This includes the project start date, Gannt view format, and the day of the week of which your work week starts.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/project-management-\u2013-3.png” alt=”project management template excel” title_text=”project management \u2013 3″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\n
Go to the WBS<\/b> tab within the master sheet, and enter your project data by overwriting the sample data (columns E to G).<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/project-management-\u2013-4.png” alt=”project management template excel” title_text=”project management \u2013 4″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]Please note:<\/b> the template creates a WBS ID code for every task automatically. Do not edit the gray template columns, since they contain pre-written formulas.[\/et_pb_text][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” custom_padding=”||0px|||” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\nWhat is a WBS?<\/h4>\n
WBS is an abbreviation for Work Breakdown Structure. It\u2019s a technique for breaking down a project into small, achievable chunks.<\/p>\n
Organize the project by clicking on the WBS tap and filling out columns E to G: \u2018Project\u2019, \u2018Sub-project\u2019, and \u2018Task title\u2019.\u00a0Here\u2019s an example of breaking down a project into smaller steps:<\/p>\n
Project:<\/strong> \u201cPlanning\u201d<\/p>\n Sub-project:<\/strong> \u201cPreliminary scope plan\u201d<\/p>\n Task title:<\/strong> \u201cResearch\u201d<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\n Now, input the dependency of each task in columns H and I. This lets you know whether a task can begin when another one starts (Start-to-start), or whether a task can only begin once another has been completed (Start-to-finish).<\/p>\n For example, in the screenshot below, you can see that task 1.5.1 can only begin once 1.1.1 has is complete.<\/p>\n Enter any dependencies of tasks in column H. Change the dependency relationship of your tasks by selecting an option from the dropdown menu in Column I.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/project-management-\u2013-5.png” alt=”project management template excel” title_text=”project management \u2013 5″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\n Use column J to enter how many days a task must be completed. Use column K to add the name of the task owner.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/project-management-\u2013-6.png” alt=”project management template excel” title_text=”project management \u2013 6″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]Please note:<\/b> Do not change any content within the grey cells of columns L and M. Formulas within the columns automatically calculate the start and end date of a task.[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”3_5,2_5″ make_equal=”on” _builder_version=”4.22.2″ _module_preset=”default” background_color=”#F6F8F9″ custom_padding=”30px|30px|30px|30px|true|true” border_radii=”on|12px|12px|12px|12px” locked=”off” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”3_5″ _builder_version=”4.22.2″ _module_preset=”default” custom_css_main_element=”margin:auto” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” background_color=”RGBA(255,255,255,0)” hover_enabled=”0″ text_font_size_tablet=”17px” text_font_size_phone=”17px” text_font_size_last_edited=”on|phone” header_4_font_tablet=”” header_4_font_phone=”” header_4_font_last_edited=”on|tablet” text_orientation_tablet=”center” text_orientation_phone=”center” text_orientation_last_edited=”on|phone” global_colors_info=”{}” theme_builder_area=”post_content” text_font_size=”30px” sticky_enabled=”0″]<\/p>\n Start tracking<\/span> your team’s progress<\/strong><\/p>\n [\/et_pb_text][\/et_pb_column][et_pb_column type=”2_5″ _builder_version=”4.22.2″ _module_preset=”default” custom_css_main_element=”margin:auto” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_button button_url=”https:\/\/drive.google.com\/uc?export=download&id=1h8VkCX2NaTYuyz73obROgNfi89TUp6D9″ url_new_window=”on” button_text=”Get template” button_alignment=”center” _builder_version=”4.27.4″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#ffffff” button_bg_color=”#2979ff” button_border_width=”0px” button_border_radius=”6px” button_font=”|700|||||||” button_use_icon=”off” custom_margin=”0px|0px|0px|0px|true|true” custom_margin_tablet=”10px||||false|false” custom_margin_phone=”10px||||false|false” custom_margin_last_edited=”on|phone” custom_padding=”15px|16px|15px|16px|true|true” saved_tabs=”all” global_colors_info=”{}” button_bg_color__hover_enabled=”on|hover” button_bg_color__hover=”rgba(41,121,255,0.7)” button_bg_enable_color__hover=”on” theme_builder_area=”post_content”][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n You can now easily track the progress of all the tasks from the Gantt<\/strong> sheet.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/project-management-\u2013-12.png” alt=”project management template excel” title_text=”project management \u2013 12″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n And there you have it! With the number of hours you save using this Sheetgo template, you can now invest this time into other important aspects of your business.<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" Project managers face the difficult duty of coordinating budgets and projects while overseeing employees and presenting reports to their superiors. Reaching multiple deadlines staying organized is an almost impossible task. This is only made worse if you have to manage an online team. As this is a common problem for many businesses, numerous software companies […]<\/p>\n","protected":false},"author":40,"featured_media":39196,"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":[59],"tags":[46],"class_list":["post-39050","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-project-management-templates","tag-project-management"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/39050","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=39050"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/39050\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/39196"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=39050"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=39050"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=39050"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}Step 3: Enter the dependencies of the tasks<\/h3>\n
Step 4: Select the duration of a task and the owner<\/h3>\n
Step 5: Monitor progress<\/h4>\n