Skip to main content

How to Calculate Age in Excel

you can calculate a person's Age based on their birthday and Todays date
The Calculation uses the function DATEDIF( )



Video:


Back to MS Excel>>

Comments


  1. Tag: PM203A52. Let me share all of you about #5 Tips for Project Management Success,, I hope you enjoy it

    1. Plan your day using time management techniques

    As a project manager, time management skills are essential because you are dealing with a wide range of tasks that demand a quick turnaround time. Planning your day will go a long way in keeping you organized and increasing your productivity. Assist your task planning by using project management software which helps you track the work of you and your team.

    If you are not very tech savvy, a simple to-do list can also be a great organizational tool. Prioritize your most important tasks by putting them at the top of the list and less important ones at the bottom. Having a visual plan of your daily tasks helps to keep you on track and aware of time.

    Related post: Free ebook 104 secrets to become a great project manager

    2. Include stakeholders in important project conversations

    While you will have plenty of responsibilities regarding the project, don’t neglect your clients.

    Good communication is essential is keeping both parties informed of project progression, curtailing scope creep, and apprised of changing requirements. Some clients may have different expectations when it comes to communication, so make sure to establish the frequency and type of communication (like emails, phone calls, and face-to-face conversations) at the beginning of your project.

    Establishing communication expectations early helps alleviate stakeholder uncertainty about communication frequency and delivery.

    3. Regularly communicate with your team

    Daily team communication helps keep misunderstandings and unclear requirements under control. Keeping your team informed in every step of the project is essential to project management success.

    For example, a study published by Procedia Technology found that good communication skills were the cornerstone of project management. The study examined over 300 “construction project managers, architects, construction managers, engineers and quantity surveyors” and their successes and failures on various construction projects.

    4. Anticipate project setbacks

    Even the best-laid plans often go awry.

    Remember that even with a high amount of planning and attention to detail, your project may still encounter some challenges. Pay attention to complaints from stakeholders or colleagues, and other warning signs, like a missed deadline or cost overrun, that there may be a problem.

    Preventing a crisis will keep your project running smoothly, save you a lot of time, and keep you, your team, and your stakeholders confident in progressing with the project.

    Unfortunately not every complication can be avoided. Crisis management skills are essential for dealing with the unexpected. Project managers need to be flexible and pragmatic. Improvise and make sharp decisions when needed.

    Related post: 92 free project management templates

    5. Stay focused on the details

    A common problem project managers encounter is having the project aims not aligned with the organization’s objectives. A great project manager will strategize a plan for the project to lead back to the overall success of the business.

    Know your project’s scope by heart and avoid wandering outside of the project’s requirements. It’s too easy to get lost in minor details and forget what your focus is, so a well-planned project scope is essential for success.

    And final, you should use KPI to measure effectiveness of the project, here are full list: 76 project management KPIs



    ReplyDelete

Post a Comment

Popular posts from this blog

Primavera P6 Tutorial : Chapter 2.7 : User Defined Fields

Apart from the in-built fields available in primavera, you can create User-defined fields which enable you to customize fields and values and add them to the project database. For example, you can use them to track additional activity data such as ordered dates, delivery dates, revised budgets, purchase order / work order numbers, vendor names, etc. In this chapter, let us learn how to create User defined fields, how to work with them and how to work with indicators type of User defined fields. How to Create UDFs? For each custom user defined field you create, you can specify any of the following data formats for that field: Text, Start Date, Finish Date, Cost, Integer, Number, Text, and Indicator. To Define: Go to the Menu bar, Choose Enterprise, select  User Defined Fields . Select the subject area to which you want to add a new field, then click  Add . Double-click in the Title column and type a name for the User Defined Field. Double-click in the Da...

Exporting the Primavera data into excel with same color formatting.

In the earlier posts, we have already seen  how to export the primavera schedule into the excel format and then do the  modifications for further usage. Now, let us see how the schedule in excel looks similar to that of the schedule in the primavera. Here are the steps for the same: Step-1: Open the project in the primavera p6. Step-2: Now, the sample schedule in primavera looks like this as shown below Step-3: Now Press Ctrl+A to select all the rows and columns in the primavera schedule  and C opy all the selected data Step-4: Now go to an excel sheet and right click and select "Paste" option to paste the data that has been copied from the primavera screen Step-5: Insert a user defined column "Level" for filtering purpose and apply filters to all the data. and then filter the Column "Activity name" by checking the "Blanks" -This is nothing but we are filtering all the WBS rows and excluding the activities. ...

Top 4 Useful Features, Tricks You Can Use In Primavera P6 || Special features To Learn In Primavera

1. How to Increase the size of icons in Primavera P6?  If you find that the menu bar and command icons are of less visibility, there is a way to increase the size of icons in Primavera P6. Let us see how to do this in this tutorial now. Go to the menu bar and under the view tab, select Toolbars and click on customize. Now a window gets opened like this, go to options tab and tick the checkbox "Large Icons". Click on the Close button and you can see that all your icons now increased in size. 2. How to Animate your Menu Bars in Primavera P6? You know that we have got the option to animate menu bars in Primavera P6. There are 4 animation options in Primavera P6, These are None  Random  Unfold Slide  Fade  You can try any of these if you want a new feel. Follow this steps to Animate Menu Bars. Click on View, go to toolbars, select Customize. Now a customize window will pop up. Go to the options tab, at Menu Animat...