Microsoft Excel - How to create a Project Management Plan
4.0 (28 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
145 students enrolled

Microsoft Excel - How to create a Project Management Plan

Creating your own Project Management Plan using Microsoft Excel. Microsoft Excel 2010, Excel 2013, Excel 2016
4.0 (28 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
145 students enrolled
Created by Excel World
Last updated 2/2018
English
English
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 43 mins on-demand video
  • 2 articles
  • 29 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Microsoft Excel, Project Management Plan
Requirements
  • Microsoft Excel 2010, Microsoft Excel 2013, or Microsoft Excel 2016
Description

Want to create and mange Project Plan?

Find to hard to learn Microsoft Project software?

Want to use familiar software like Microsoft Excel to create Project Management Plan?

This course is exactly for you!

The Microsoft Excel - How to create a Project Management Plan is built to simplify your life and help you manage you plan successfully. With this concise one-hour-course, you will get both required knowledge of Project Manager and neccessary skills of using Microsoft Excel. This course gives you step-to-step instructions to built Project Plan by using familiar Office Tool - Microsot Excel. At the end of each lecture, there are prepared files for you to practice exactly what you have learned through the video lecture. 

By getting through 18 lectures, 14 practical exercises, 4 quizzes, these values are exactly what you will receive:

  • Understanding Triple Contraint of Project Management
  • Understanding 5 Project Management Process Group
  • Getting the knowledge of 9 Project Management Knowledge Areas
  • Define Scope, Time and Cost of the project
  • Unlock the power and versatility of Microsoft Excel
  • Using Excel Worksheet formulas to create beautiful Project Plan

So, let enroll the course right now and take the next step in your professional career.

Who this course is for:
  • Who wants to master in Microsoft Excel to create and manage Project Management Plan.
Course content
Expand all 18 lectures 43:18
+ Introduction
3 lectures 05:23

Hi, welcome to the “Microsoft Excel - How to create a Project Management Plan” course. ( V1_7s)


This course is perfect for those who acquire the basic knowledge of Project Manager and practical Excel skills to build the project management plan. (V2_11s)


Let me walk through you the content of this course. (V3_3s)


First, we’ll learn basic management knowledge to manage a project such as the Triple Constraints, 9 Project Management Knowledge Areas and 5 Process Groups of the project. (V5_14s)

This part of this course is fundamental for those who wants to know the core knowledge of project management. (V6_8s)


Then, we’ll learn how to work with Microsoft Excel, (V7_4s)

this part of this course will cover all practical Excel functions that help you to build the project plan in the most commonly used software – Microsoft Excel. (V8_12s)


I will cover everything that is necessary so that you will get more confident when define the scope, time and cost of the project and add them into your detailed project plan by using Excel. (V10_15s)


After each of the lecture, there are prepared Excel files for you to practice what you have learn through the lecture. (Unsolved, Solved) (V11_8s)


Each file is a continuation of the previous files and at the end of the course you can create a completed project management plan in Excel. (V12_10s)


Below each section of the course, there is also quizzes for you guys to check the knowledge you have gained through the section. (V13_8s)


No superfluous information are taught in this course. This course will give you concise and simple instructions. (V14_9s)


So let’s begin now! (V15_2s)

Preview 02:03

All projects are carried out under certain constraints – traditionally, they are cost, time and scope. These three factors that commonly called 'the triple constraint' and they are represented as a triangle. Each constraint forms the vertices: (V1_18s)

  • Projects must meet the scope – the customer requirements (V2_4s)
  • Projects must be delivered on time (V3_3s)
  • Projects must be delivered within cost (V5_3s)


Once a customer asks you to complete a project, the person will state, for instanst, the project must contain certain features , be delivered by a particular date, or cost no more than amount of money. (V7_15s)


The triple constraint is about balancing each constraint to reach a successful conclusion. When the project is going on progress, the project manager may find that any changes impact one or more of the constraints.  (V9_16s)


As a project manager, there are lot of thing you need to know. Especially 9 Project Management Knowledge Areas.  (V10_9s)

The purpose of these Knowledge Areas is to better organize the different processes and bring the processes having common characteristics under one category. (V11_12s)

  1. Project Integration Management
  2. Project Scope Management
  3. Project Time Management
  4. Project Cost Management
  5. Project Quality Management
  6. Project Human Resource Management
  7. Project Communications Management
  8. Project Risk Management
  9. Project Procurement Management
  10. Sometimes there will be a 10th knowledge area that project manager need to control, that is Stakeholder Management.  (V12_34s)


Therein, There are 4 Core knowledge areas: Scope Management, Time Management, Cost Management, Quality Management. 

There are 4 Facilitating knowledge areas: HR Management, Communication Management, Risk Management, Procurement Management. 

An 1 Overall knowledge area: Integration Management.  (V13_29s)


I also add a link in this lecture's description for you to discover if you want to know more about The Triple Constraint and The 9 Project Management Knowledge Areas. (V16_12s)


https://www.smartsheet.com/triple-constraint-triangle-theory

https://www.thebalance.com/the-10-project-management-knowledge-areas-3866902

Preview 02:50
Quiz 1: Our First Quiz
2 questions
+ STEP 1: Define SCOPE
2 lectures 09:05

In this video, I'm going to show you how to create the Work Break Down Structure to your Project Management Plan. (V1_8s)


First of all, list all the activities of your Plan, then put them into process group. There are 5 process groups: Initiating, Planning, Executing, Monitoring & Controlling AND Closing (V2_20s)


I. Initiating 

This process group involves the processes and activities needed to define the beginning of a project.  (V3_10s)


In this project, I will add "Project Kick-off Meeting" to the Initiate Phase.  (V4_6s)

Select the row,  (V6_1s)

right click then click "Insert" to insert a new row under it. (V7_6s)

Copy the format of the first cell to the other cells. (V7.1_s)

Then input "Project Kick-off Meeting" (V8_3s)

Continue to input a new task "Sign Contracts" to this process group. (V9_6s)


 II. Planning 

The main purpose of this process group is to plan time, cost and resources to estimate the work needed and to manage risk during project execution.  (V10_14s)

In our example, I will input 3 tasks "Select Project Manager, Form Project Team AND Situation Analysis" (V11_11s)

Insert 3 rows. (V12_2s)

Select Project Manager (V13_2s)

Form Project Team (V14_2s)

Situation Analysis (V15_2s)


III. Executing 

Executing consists of the processes used to complete the work defined in the project management plan. It's about accomplishing the project's objectives.  (V16_14s)

I will input some tasks to this group: (V17_3s)

Target Market Analysis  (V18_2s)
Product Analysis  (V19_2s)
Product Design (V20_2s)
Product Manufacturing  (V21_2s)
Product Marketing  (V22_2s)
Product Distribution (V23_2s)


IV. Monitoring & Controlling 

The monitoring process group involves managing and tracking the project. Potential problems can be identified quickly for the team to take corrective action.    (V24_14s)

I also input some tasks to this group: (V26_4s)

Quality Performance Control  (V27_2s)
Risk Control  (V29_1s)
Budget Control (V30_1s)


V. Closing 

Closing a project means finishing all activities across all process groups, disbanding the project team and signing off the project with the customer.    (V32_13s)

I will input some tasks to this group: (V33_3s)

Project Lesson Learned (V34_2s)
Close Project Meeting (V35_2s)


Finally we get the Work Breakdown Structure of the project. Depend on different projects, we may create more level of work task. In this example, we only have 5 process groups and small tasks under each groups. Maybe if the project go bigger, you should add more details of each smaller task under each task.(V36_26s)

https://www.project-management-prepcast.com/pmbok-knowledge-areas-and-pmi-process-groups

Preview 04:02

In the previous video lecture, we have created a Work Breakdown structure for the project. The next thing we need to do is setting the priority for each task. (V1_13s)


Now, I am going to add a new column.  (V3_3s)

Name the column "Priority".  (V4_2s)

Edit the font, color and border of the cells a little bit. (V4.1_xs)

Then, create Data list for this column.  (V5_3s)

I will add 3 types of priority: High, Medium and Low. (V7_6s)


To do this, select all cells under the "Priority" column,  (V8_5s)

then go to Data tab on the ribbon,  (V9_3s)

select "Data validation". (V10_2s)


Change "Any value" to "List",  (V11_3s)

then type all values that you want in the data dropdown list.  (V12_5s)

In here, I will add "High, Medium and Low",  (V13_5s)

each value is separated by a comma.  (V14_3s)

Click OK to see the change. (V15_2s)


Now, under "Priority" column, we can choose a data from a list by just clicking from the drop-down list. (V16_9s)



--------------------------------------------------------------------------------------------------------------------

To make them more colorful, I also add Conditional Formatting for the cells under this columns.  (V17_7s)


I will create the conditions that if the cell's value is "High", the color of this cell will change to RED. If the cell's value is "Medium", the color of this cell will change to GREEN. And if the cell's value is "Low", the color of this cell will change to YELLOW.  (V18_21s)


In order to do this, select all cells under the "Priority" column,  (V19_5s)

then go to Home tab on the ribbon, (V20_3s)

select "Conditional Formatting", (V21_3s)

choose "New Rule".(V22_2s)


In this box, we have to input each condition rule to Excel. We have 3 condition sentences which are "High is Red, Medium is Green and Low is Yellow". That means we have to input 3 New rules. (V25_18s)


Now let try to add Rule for "High is Red". (V26_5s)


Select "Format only cells that contain", (V27_3s)

choose "Cell value", (V28_2s)

"equal to", (V29_1s)

type the value of the cell, in here is "High". (V30_4s)

Click on "Format" button to change to format of the cell if the condition is matched. (V32_6s)

Click to Fill tab, then choose the color that we want, in here we choose Red to warns the manager that the task is important. (V33_11s)

You can also choose the text and border of the cell by editting them in "Font" and "Border" tab. (V34_7s)

Finally click OK. (V35_2s)


That's it. You have created new condition rule for the "Priority" column. Do similarly to "Medium is Green" and "Low is Yellow". (V37_10s)

----------------------------------------------------------------------------------

After creating bunch of rules, maybe you want to review or edit the old rules. (V38_7s)


To do this, go to Home tab, (V39_3s)

click on "Condition Formatting", (V40_2s)

then choose "Manage Rules", (V41_2s)

all the created rules are listed in the box. (V42_3s)

In case you want to edit the rule, Click on each condition row to edit each rule. (V43_7s)

Set Priority for each Task
05:03
Quiz 2: Microsoft Excel Quiz
1 question
+ STEP 2: Define TIME
4 lectures 11:56

In this section, I will guide you how to create Gantt chart in Excel. (V1_5s)


Gantt chart is the chart that shows the project tasks in level, presents the task names, start date, end date and duration of each tasks.  (V2_12s)

The task names we already have, so that the rest of work is to create fields of time. (V3_8s)


First thing I gonna do is to create 3 new columns  (V4_4s)

"Start Date",  (V5_1s)

"End Date"  (V6_1s)

"Duration" (V7_1s)


Next, change the format type of "Start Date" and "End Date" to "Date".  (V8_7s)

There are many types to show date, depends on each country.  (V9_5s)

We can choose to show day-month-year, month-day-year, year-month-day and so on. (V10_11s)


After choosing the format of the cell, input some value to these cells....  (V11_7s)


The format of Duration column, I will change to "number" with no decimal places. (V12_7s)


Besides of it, I also change the cell color and text size of Start Date and End Date to make them distinguish with other columns. (V13_11s)

Adding Start Date, End Date and Duration for each Task
02:20

In this video lecture, I gonna show you how to create Timeline for the Gantt chart. (V1_7s)

First of all, select multiple columns,  (V2_3s)

then right click and choose "Column Width".  (V3_4s)

In this box, input the size of the column's width that you want.  (V4_6s)

In this case, I will input 4, then click OK.  (V5_6s)


The header I going to add the days of month, so I will change the format type to date.  (V7_8s)

Because the cell is very narrow, I only want to show the date of the day.  (V8_7s)

To do that, open format cell box, (V9_4s)

switch to Custom format type,  (V10_3s)

then edit the format cell that you want.  (V11_4s)

In here, I will delete month and year of the day.  (V12_4s)

Now the cell only show the date, but you if you want you can see the full version in this box. (V13_10s)


Do the same thing to other months, then we will get the calendar of the year.  (V14_6s)


Change the color of this header to make them unified with the rest of the table.  (V15_6s)


Saturday and Sunday is the day off, so I will gray out the cells.  (V16_7s)


Only do it to the first week, then drag it to clone it to the other weeks.  (V17_6s) 


To mark what actual days doing specific task, I will create a cell "Actual". (V18_7s) 

Add value,  (V19_1s)

change the color of it  (V20_2s)

and choose a pattern style.  (V21_3s)

Now we have a standard cell, just copy it to the day that you plan to do the specific tasks.   (V22_8s)


Here is the result, we finnaly got the timeline of the chart.  (V23_5s)


--------------------------------------------------------------------

Drag from the first day to the last day to clone the format of the cell.

Select multiple cells, 

then merge them

and change the cell to January

Do similarly to other months

----------------------------------------

Change the format of the cells a little bit.

------------------------------------------

Change the format of the cell.

--------------------------------------------

In the "Days" column, I will count the number of actual days for each task.

In order to do it, I will use COUNTIF function.

Select the range, 

select the condition.

Then drag from the first cell to the other cell to copy the function and format of the cell.


Creating Timeline for the Project Plan
04:33

When the project is go on track. We will want to know "Which day is it today", so that we can know "Which tasks are undergoing on today?" by looking at the timeline chart. (V1_17s)

In order to do that, I will highlight the current day, which means today, so that it'll become easier for the manager to track and control the time aspect of the project.  (V2_15s)

First of all, select all the days of the year.  (V3_4s)

Then, go to Home tab, choose Conditional Formatting, create a New Rule.  (V4_9s)

Click to "Format only cells that contain".  (V5_4s)

Choose "Date Occurring", choose "today".  (V6_5s)

Click to "Format" button, then choose the fill color to make it stand out.  (V7_7s)

In here I will use Red color.  (V8_3s)

With this setting, when the cell is equal to today, it will automatically change the color of the cell to Red color.   (V9_11s)

Click OK to finish the Conditional formatting.  (V10_4s)

Here is the result.   (V11_2s)

Remember to make the condition valid, you have to set these cells to "Date" format as I have set in the previous lecture. (V12_11s)

Highlight the Current day
02:03

In this video, I will guide you how to group days in the same month.  (V1_5s)

Firstly, select from second day to the last day of the month, keep in mind that select from the second day, not the first day.  (V2_11s)

Then go to Data tab, choose "Group" button. Now the columns have been successfuly grouped. (V3_9s)

But let's edit a little bit.  Here you can see you can click to the plus-minus button to expand and colapse the group. But I want to put this plus-minus button at the beginning of the month, not at the end of the month like this.  (V5_20s)

To do that, go to Data tab, click to the small button under outline section.  (V6_7s) 

There are options for you.  "Summary rows below detail" and "Summary columns to right of detail" are automatically selected. Uncheck the box "Summary columns to right of detail" to see the result.  (V7_19s)

Now, the colapse-expand-button is placed at the beginning of the month. (V8_7s)

Continue to do the same thing to other months of the year. (V9_5s)

After grouping all months in year, the timeline will look like this. Here is the group level.  (V10_9s)


When you click to 1 button, Excel will collapse all groups.  When you click to 2 button, Excel will expand all groups.  This is a shortcut for us to collapse-expand groups without doing one by one. (V11_22s)



Similarly,  If you unchecked the tick box"Summary rows below detail", the plus-minus button will be at the top of the data if we group rows.  (V12_14s)

For example, group the Ininitating to one group, Planning, Controll etc each to one group.  (V14_11s)

Then go to go to Data tab, click to the small button under outline section. (V16_6s)  

Then uncheck the tick box "Summary rows below detail".  (V17_5s)

Now expand-collapse button is at the top of the rows group.  (V18_6s)


Grouping days in the same month
03:00
Quiz 3: Microsoft Excel Quiz
3 questions
+ STEP 3: Define COST
2 lectures 03:04

One of the key things we need to know about project is the budget of its. Manager has to know about the whole budget for the project and divide it into small divisions. (V1_14s)

In this video lecture, I will show you how to add cost to the project management plan.  (V5_6s)

First of all, insert new column to the the gantt chart table, (V6_4s)

then name the header "Cost".  (V7_2s)

After that, change the format type of the data cell to "Currency" .  (V8_5s)

You can choose the currency type by click on the Symbol List, then click to the type of currency that you need.  (V9_8s)

In "Decimal Places" field, the number that you input in here is the number of decimal number.  (V10_7s)

For example, if you input 2 in the decimal places, when you input 1.234 into the cell, Excel you round the number to 1.23 (V11_16s)

Finally, after change the format type of cells, you can input values to these cells. (V12_8s)

Adding budget for each Task
01:52

I also add a field Cost to the header of the project plan. This will calculate the total number of money needed for this project. In order to to this, I will use SUM function. (V1_14s)

Number 1 is the place of the first cell of the row or column that you want to sum,  (V2_7s)

number 2 is the place of the last cell of the row or column that you want to sum. (V3_7s)

In this case, we want to sum the number from cell G11 to G31.  (V5_6s)

So, we will input G11 and G31 to the function.  (V8_6s)

Excel will calculate the total number for you.  (V10_3s)

Don't forget to change the format type of the cell to Currency.  (V11_5s)

Calculating Budget for the whole project
01:12
Quiz 4: Microsoft Excel Quiz
2 questions
+ STEP 4: Define HUMAN RESOURSE
1 lecture 02:28

Working under one project may be more than one person. To monitor and control the in-charge person of the work, I will add column "Responsible" to record the people or group who are responsible of each task. (V1_16s)

So, right click to the column right next to the column that you will create, then click on "Insert",  (V3_8s)

change the Column name to "Responsible" or "In charge",  (V4_4s)

then change the Format cell to Text or just leave it "General".  (V6_5s)

The different thing between "Text" format cell and "General" format cell is that:  (V7_6s)

When you set the format cell to "General", if you fill the number value to the cell, Excel will automatically consider the cell in number format. The numeric value added into the cell will be right aligned. Other format is automatically left aligned except you change the alignment by hand.  (V8_25s)

But when you set the format to "Text", even when you add number value to the cell, Excel will consider the cell as text format, so it will auto right align the value. (V9_13s)

Edit the format of these cells a little bit to make them distinguish with other columns. (V10_6s)

Preview 02:28
+ STEP 5: Control PROGRESS
2 lectures 06:17

When the project is go on track, the important thing to monitor are the status of each task.  (V1_7s)

You definitely want to know if this task is started yes or not, that task have completed , or if these tasks is under construction. (V2_11s)

So, besides the information of Scope, the work breakdown structure, Time, the start date, end date, duration, Cost, the budget of tasks, I recommend you to add a new column named "Status".(V4_18s)

Now, I am going to add a new column. (V5_3s)

Name it "Status". (V6_1s)

Then, create Data list for this column. I will add 4 types of status: Not Started, In Progress, Completed and Skip. (V7_12s)

To do this, select all cells under the Status column, then go to Data tab on the ribbon, select "Data validation". (V8_10s)

Change "Any value" to "List", then type all values that you want in the data dropdown list. In here, I will add "Not Started, In Progress, Completed and Skip", each value is separated by a comma.  (V10_178s)

Click OK to see the change. (V11_2s)

Now, under Status column, we can choose a data from a list by just clicking from the drop-down list. (V13_8s)



To make them more colorful, I also add Conditional Formatting for the cells under this columns.  (V15_7s)

I will create the conditions that if the cell's value is "Not Started", the color of this cell will change to Light Orange. If the cell's value is "In Progress", the color of this cell will change to Red. If the cell's value is "Completed", the color of this cell will change to Ocean Blue. And if the cell's value is "Skip", the color of this cell will change to Gray.  (V16_29s)


In order to do this, select all cells under the "Status" column, then go to Home tab on the ribbon, select "Conditional Formatting", choose "New Rule". (V17_13s)

In this box, we have to input each conditional rule to Excel. We have 4 condition sentences which are "Light Orange for Not Started, Red for In Progress, Ocean Blue for Completed and Gray for Skip". That means we have to input 4 New rules.  (V18_21s)

Now let try to add Rule for "Light Orange for Not Started".  (V19_5s)

Select "Format only cells that contain", choose "Specific text", "Containing", type the value of the cell, in here is "Not Started".  (V21_12s)

Click on "Format" button to change to format of the cell if the condition is matched. Click to Fill tab, then choose the color that we want, in here we choose Light Orange to reminds the manager the priority of the task.  (V23_17s)

You can also choose the text and border of the cell by editing them in "Font" and "Border" tab.  (V25_7s)

Finally click OK.  (V26_2s)

That's it. You have created new conditional rule for the "Status" column. Do similarly to "Red for In Progress, Ocean Blue for Completed and Gray for Skip". (V29_12s)


Adding Status for each Task
04:24

Besides the Status of the tasks, I also add one more column to track the progress of the tasks. When the task is started and go on track, you will want to know the percentage of completion. (V1_16s)

To present this, I will add a column name "progress".  (V2_5s)

To add new column, right click the the column, then choose "Insert".  (V3_6s)

Then change the name of the Header column.  (V4_3s)

Next, change the format cell of this column's data cell to "percentage".  (V5_6s)

Then fill the percent of completion to each task.... (V7_4s)


To make the project management plan look more attractive, I will add some colors to it. Select Progress column except the header, then go to Conditional Formatting, then choose Data Bars, click on the color that you like, in here I will choose Green. (V8_23s)

And here is the result, the length of bar is upon the percentage of each task.  (V11_6s)

Whenever you change the percentage of completion, the length of the bar will change (V12_7s)

Controlling Progress of each Task
01:53
+ Finalizing your Project Management Plan
4 lectures 05:04

In this video lecture, we are going to add some general information of the project plan. I will put some information at the top of the project plan such as Project Name, Start date, end date, status of the project, total cost and summary of the project. (V1_21s)

To change the color of the cells that we going to input the data, select these cells, then go to the Home tab on the Ribbon, in Font block, choose the color that you need. (V2_13s)

In order to select multiple cells, just hold the Ctrl key on the keyboard while select multiple cells. (V3_8s)


To change the name of the project, just simply click to the cell and edit the name of the project.  (V4_8s)

Start Date and End date, this is the date format. So I will change the format cell of these two fields into Date format. To do that, like I have said in the previous video, just right click to the cell, choose Format Cells, then change the format to Date. Click OK. (V6_23s)

Status of the project could be: Not started, On Track and Close. So I will keep the format cell as General or Text format. (V9_11s)


Summary of the project is the short description of the project. Just like Status, I leave it as text format. (V13_9s)


Besides of these information, you can add other information that you need such as Project Manager, Number of staff and so on. (V15_10s)

Editting the header of Project Plan
02:02

In this video, I am going to show you how to Freeze the pane. (V1_5s)

This function is often used to lock rows and columns. Especially in Data table, when there are two many data rows, and you want to lock the header of the data table. (V2_12s)

To freeze rows: Select the row below the row(s) you want to freeze. In our case, we want to freeze header row, Row number 10, so we will select the row BELOW the row number 10, that means row number 11. (V4_17s)

Then Click the View tab on the Ribbon, Select the Freeze Panes command, then choose Freeze Panes from the drop-down menu. (V5_9s)

The rows will be frozen in place. You can scroll down the worksheet while continuing to view the frozen rows at the top.  (V7_8s)

Similarly, To freeze columns: Select the column to the right of the column(s) you want to freeze. In our case, we want to freeze column L, so we'll select column right next to it, that means column M. (V11_15s)

Click the View tab on the Ribbon, Select the Freeze Panes command, then choose Freeze Panes from the drop-down menu. (V12_9s)

After that, we got the freeze columns. (V13_3s)

In order to freeze both row and column. (V16_3s)

Select the cell that is the INTERSECTION of the row BELOW the row you want to freeze and the column RIGHT NEXT to the column that you want to freeze. In our case, that cell is the INTERSECTION of Row 11 and Column M, that means cell M11. (V22_18s)

Select cell M11, Click the View tab on the Ribbon, Select the Freeze Panes command, then choose Freeze Panes from the drop-down menu. (V24_13s)

Now you get both column and row are freezed. (V26_4s)


Freezing the header of Project Plan
02:24

In this video, I am going to show you how to unfreeze the pane.

After freeze the pane, you probably want to unfreeze it.

In order to do that, go to View tab, then choose Freeze Panes button, then click to Unfreeze Panes.

After that, the pane is no longer freezed anymore.

So simple, right?

Unfreezing the header of Project Plan
00:35
Final Project Management Plan
00:03