Skip to main content

Posts

Showing posts from 2013

How to use "RANK" Function in Excel

This Function calculates the position of a value in a list relative to the other values in the list. It can be very much used while ranking to be done. Syntax: =RANK(NumberToRank,ListOfNumbers,RankOrder) Example: Back to MS Excel>>

How to use "RAND" Function in Excel

This Function creates a random number between the given two numbers. The Number will change each time the worksheet recalculates or when your press F9 Syntax: =RAND() or =RAND()*10 or =RAND()*(100-5) Back to MS Excel>>

How to use "QUOTIENT" Function in Excel

This Function calculates the number of times a number can be divided by another number. It ignores any remainder. Syntax: =QUOTIENT(Numbertobedivided,divisor) Example: Back to MS Excel>>

How to use "PROPER" Function in Excel

This function converts the first letter of each word to uppercase, and all subsequent Letters are converted to lower case. Syntax: =PROPER(Text to convert) Example: Back to MS Excel>>

Sample Scheduling Specification

Before implementation of any schedule, It has to be reviewed, modified to ensure compatibility with the requirements. The following attached document is the sample scheduling specification where issues,Methods, terms Regarding the Scheduling have been illustrated. Download Here

Critical Path Method

Find a Paper on Detail Critical Path Analysis Published in  journal Download Here

Project Management Techniques

Two Fundamental Techniques are used throughout the Project Management: 1.Breakdown Complex items into Simple Parts, Solve Them, Roll them up: Break the Project Down into the Five phases. Break the Scope down into manageable size deliverables. Break the Deliverables down into individual activities 2. Do one thing at a time to avoid Thrashing: List all the possible Stakeholders first, then you decide how to Communicate with them. List all possible risks first, then shortlist them and quantify them. Build the schedule first, then resolve any resource conflicts.

How to use "PRODUCT" Function in Excel

This Function multiples a group of numbers together. It is the same as using 2*3*4*5, which results the product of the four numbers. Syntax: =Product(Number1,Number2,........Number30) or =Product(range of Numbers) or =Product(Number1,Range,Number2,....) Example : Back to MS Excel>>

How to use "POWER" Function in Excel

This Function raises a number to a user specified power.It is same as using the 6 Operator, Such as 2^5, which results as 32. Both the Power() function and the ^ Operator are the same as using 2*2*2*2*2. Syntax: =POWER(Number to be raised, power) Example: Back to MS Excel>>

How to use "PERMUT" Function in Excel

This Function calculates the maximum number of permutations given a fixed number of items. The Internal order is Significant. so AB and BA will be considered as two possible permutations. It could be used to calculate the possible number of 4 digit passwords from the digits 0 to 9. Syntax: =PERMUT(PooltoPickfrom,Itemsingroup) Example: Back to MS Excel>>

How to use "ODD" Function in Excel

This Function rounds a number up to the next highest odd number. Syntax: =ODD(number to be Rounded) Example: Back to MS Excel>>

Causes of Project Failure

Ranked Caused of Project Failure: Incomplete Requirements Lack of User Involvement Lack of Resources Unrealistic Expectations Lack of Executive Support Changing Requirements & Specifications Lack of Planning Didn't Need it any Longer Lack of IT Management Technology Illiteracy Source: PMBOK

How to use "NOW" Function in Excel

This Function Shows the Current Date And Time. The Result will be updated each time the Worksheet is opened and Every time an Entry is made anywhere on the Worksheet. Syntax: =NOW() Example: Back to MS Excel>>

How to use "NOT" Function in Excel

This function performs a test to see if the test fails. (A type of reverse logic). If the test fails, the result is TRUE. If the test is met, then the result is FALSE. Syntax: =NOT(TestToPerform) Example: The following table was used by a library to track books borrowed. The date the book was Taken out is entered. The period of the Loan is entered. The date the book was returned is entered. The =NOT() function has been used to calculate whether the book was returned within the correct time, by adding the Loan value to the Taken date. If the book was not returned on time the result Overdue is shown, otherwise OK is shown. Here is the video tutorial of the same for clear understanding. Back to MS Excel>>

How to use "NETWORKDAYS" Formula in Excel

This function will calculate the number of working days between two dates. You can simply use the  subtraction method but the  Benefit of this Function is, It will exclude weekends and any holidays. Syntax: =NETWORKDAYS(StartDate,EndDate,Holidays) Example: Here is the video tutorial of the same for clear understanding. Back to MS Excel>>

How to use "N" Function in Excel

This function converts a numeric entry to its mathematical value.Anything which will not convert is shown as 0 zero.Excel does not really need this function, due to the fact that Excel calculates in this way naturally. The function is included for compatibility with other spreadsheet programs. Syntax: =N(NumericEntry) Example: Here is the video tutorial of the same for clear understanding. Back to MS Excel>>

How to use "MROUND" Function in Excel

This Function Rounds a number up or down to the nearest multiple specified by the user. Syntax: =MROUND(NumberToRound,MultipleToUse) Example: Here is the video tutorial of the same for clear understanding. Back to MS Excel>>

How to use "MONTH" Function in Excel

This Function Extracts the name of the Month from a complete date Given. Syntax: =MONTH(Date) The Result will be in the number format. This has to be formatted to show the actual month by using the custom formatting using the code mmm or mmmm. Example: Here is the video tutorial of the same for clear understanding. Back to MS Excel>>

Project Phases

There Will be 5 Phases in any Project.  They are as Mentioned Below: 1. Initiation 2. Planning 3. Execution 4. Monitoring and Controlling 5. Closing After the Phase-1 a Review Should be done to improve the accuracy of estimation of scope,time,cost and Risk about +/- 50%  to +/- 10% for management approval before proceeding to Planning Stage After the Phase-2 a Review Should be done  where stakeholders will present the feedback on plan. and after adjustments, plan should be updated to maintain the accuracy in estimation to +/- 10%.

How to use "MOD" Function in Excel

This function calculates the remainder after a number has been divided by another number. Syntax: =MOD(Number,Divisor) Example: Here is the video tutorial of the same for clear understanding. Back to MS Excel>>

How to use "MIN" Function in Excel

This Function Results the Lowest value of the data given. Syntax: =MIN(Range1,Range2,Range3... through to Range30) Example: In the following example the =MIN() function has been used to find the lowest value. Here is the video tutorial of the same for clear understanding. Back to MS Excel>>

10 Tips for Project Management

These are the Ten Tips for prospering in the Project Management 1.Break down the Project Details in to minute detail 2.Know the Project and Team Requirements 3.Be a Good Project Leader 4.Keep all the Communication Lines open 5.Identify the Critical Project Milestones 6.Attain Pertinent Documentation 7.Manage Project Risks 8.Avoid Scope Creep 9.Test the Deliverables 10. Evaluate the Progress of the Project.

How to use "MID" Function in Excel

This function picks out a piece of text from the middle of a text entry. The function needs to know at what point it should start, and how many characters to pick.If the number of characters to pick exceeds what is available, only the available characters will be picked. Syntax: =MID(OriginalText,PositionToStartPicking,NumberOfCharactersToPick) Example: Here is the video tutorial of the same for clear understanding. Back to MS Excel>>

How to use "MAX" Function in Excel

This Function picks the highest value from the given list of values. Syntax: =MAX(Range1,Range2,Range3... through to Range30) Example: Here is the video tutorial of the same for clear understanding. Back to MS Excel>>

How to use "MATCH" Function in Excel

This function looks for an item in a list and shows its position. It can be used with text and numbers. It can look for an exact match or an approximate match. Syntax: =MATCH(WhatToLookFor,WhereToLook,TypeOfMatch) The Type Of Match  is either 0, 1 or -1. 0 will look for an exact match. If no match is found the #NA error will be shown. 1 will look for an exact match, or the next lowest number if no exact match exists.    If there is no match or next lowest number the error #NA is shown.   The list of values being examined must be sorted for this to work correctly. -1 will look for an exact match, or the next highest number if no exact match exists.    If there is no exact match or next highest number the error #NA is shown.    The list must be sorted for this to work properly. Example: Here is the video tutorial of the same for clear understanding.            Back to MS Excel>>

How to use "LOWER" Function in Excel

This Function converts your Uppercase sentence text into lower case one Syntax: =LOWER(TextToConvert) Example: Here is the video tutorial of the same for clear understanding.   Back to MS Excel>>

How to use "LOOKUP" Function in Excel

This function looks for a piece of information in a list of values, and then picks an item from the last cell in the adjacent row or column. It always picks the data from the end of the row or column. If you would like to pick any particular value in the middle of the table, then you have to use either Vlookup or Hlookup If the table has more rows than columns or if the rows & column are equal in number: the function will look down the left most column trying to find a match for the piece of information you asked it to look for.When a match is found, the function will look across to the right most column to pick the last entry on the row. If the table has more Columns than rows:  the function will look across the top row trying to find a match for the piece of information you  have asked it to look for.When a match is found, the function will then look down to the bottom cell of the column to pick the last entry of the column. Syntax: =LOOKUP(WhatToLookFor,RangeToLook

How to use "LEN" Function in Excel

This Function counts the number of characters in a given word, including the spaces, numbers. Syntax: =LEN(Text of a word) Example: Here is the video tutorial of the same for clear understanding.   Back to MS Excel>>

How to use "LEFT" Function in Excel

This function displays a specified number of characters from the left hand side of a given word. Syntax: =LEFT(OriginalText,NumberOfCharactersRequired) Example: Here is the video tutorial of the same for clear understanding. Back to MS Excel>>

How to use "LCM" Function in Excel

This Function calculates the Least Common Multiple of Given Numbers. LCM is nothing but the Least number which can be divided with the given numbers. Syntax: =LCM(Number1,Number2,Number3... through to Number29) Example: Here is the video tutorial of the same for clear understanding. Back to MS Excel>>

How to use "LARGE" Function in Excel

This function Recognizes the List of Values and picks up a value according to the user specified position of the values arranged in the Decreasing order. Syntax: =LARGE(List Of Numbers To Examine, Position To Pick From) Example: Here is a video tutorial of the same. Back to MS Excel>>

Instant chart in Excel

You can create a Quick Chart in the Excel, without using the Chart Button in the Insert tab on the Toolbar by pressing the function key F11 by placing the cursor inside the range of data. Now Just Place the cursor anywhere inside the Table range and Press F11 to view the instant Chart Here is the  video tutorial for better understanding. Back to MS Excel>>

Technology Updates

Till Now you may have seen many sites on Live TV. But, now for the Tech lovers, there's a Good news. Just Go to www.twit.tv site where you can view the latest live updates on Technology and Even you can watch the Technology shows that took place all over the world. You can watch the latest updates on Gadgets that came into market, Transformations in the technologies will be better illustrated in this site.

How To Download Youtube Videos

In Mozilla Firefox: Here is the Detail Step wise Procedure illustrated for downloading videos from youtube into your system. Step 1: Search for latest Mozilla Firefox Browser and Install it into your system. Step 2: After Installing, Go to Firefox icon on the Top Left Portion in the Browser Window and Select the Addon Button in the Drop Down Menu. Step 3: In the Search tool, type as Youtube Download and you will get the results . And then find the suitable downloader, for instance select the Easy youtube Video Downloader and install it into your addons. Step 4: Once you install it, Whenever you view a video in your youtube. There will be an option visible exactly below the video screen  as a Download Button. If you click on the dropdown menu adjacent to the Download button, You will get several options to select the format in which you would like to download the video. Selct any one of the formats and save it onto your system. and find the Dowloaded file in yo

Pocket Printer

There's a Fancy Smart Phone in your Shirt Pocket. Now you can even have a Printer in your pant Pocket. There is a Portable printer released into market by LG. Using this PD233 Pocket Photo Printer , one can print the photos directly from the mobile device in 2X3 inches and 640 X1223 Resolution. In order to print the photos from other devices, Just connect with the printer through the USB port. Printer Gets Charged with the Batteries. This comes in price of almost Rs 15000/- ($41).

How Stuff Works

Watch Some of the Interesting Videos here Wagon Tippler: Which is used in the Material Handling System   Post Tensed Concrete Slab Building of Empire State Building Heavy Metal High Rise Basics of Post Tensioning Prestressed Concrete

How to Design a Template in Powerpoint

PowerPoint comes with a set of Templates and Themes. In fact, One can design a custom one with the following steps in an easy manner. Step 1:  Open a Blank Presentation Step 2: Switch to Slide Master View, go to View Tab at the top and Select the Slide Master icon. Step 3:  Play with the Background styles, Colors, Fonts, Insert Place holders, Layouts and then add Effects, Graphics and Finally Prepare a customized template that you like.    Similar to the templates that i have Attached. Kindly download the same for ready use. and the Enjoy with the Making of Presentations.

Facts about Construction Productivity

Following are the Few Facts about construction productivity studied by Adrian (1990) Tuesday is the most Productive day of the week. Friday is the least Productive day of the week, in India it is Sunday. 10 A.M is the Most Productive time in a day. The Least Productivity time Frame for Labor is just before the Day Closing Time If the Labor is engaged in Performing the same task repeatedly, there is a chance of low productivity after 60-70 Minutes of performing the same task.

Labor Productivity

Productivity in General expresses the relation between inputs and Outputs. Labor is the basic requirement in the construction industry. Labor Productivity usually relates manpower in terms of labor cost incurred on the Project.So, Productivity has a significance in the construction.In the Construction, Many factors both external, internal effect the productivity of the labor.This factor leads to a variation in the productivity thus escalating the Project Cost.Thus, the Labor Productivity has to be monitored on regular basis and to be ensured that the productivity doesn't fall at any point of time. Even certain Steps to be implemented in order to increase the Productivity with a limited number of Manpower, Which reduces the Labor cost of the Project. Here are Some of the methods of improving Productivity. Training Programs for the Labor- To enhance the Skill Levels Arranging Enough tools in the working place and proper planning. Incentives/Perks in contract for better perform

How to use "INT" Function in Excel

This function rounds the number to its nearest Whole Number. Syntax: =INT(num) Example: The Table has some Numbers, and In the right column find the results of the INT function for the adjacent numbers Video Tutorial: Back to MS Excel>>

How to use "IF" Function in Excel

This function tests a condition / Logic If the condition is met it is considered to be TRUE.If the condition is not met it is considered as FALSE. depending upon the result, one of two actions will be carried out. Syntax: =IF(Condition,ActionIfTrue,ActionIfFalse) The Condition is usually a test of two cells, such as A1=A2. The ActionIfTrue and ActionIfFalse can be numbers, text or calculations. Example: Video: Back to MS Excel>>

How to use "Hlookup" Function in Excel

This function scans across the column headings at the top of a table to find a specified item.When the item is found, it then scans down the column to pick a cell entry. Syntax: =HLOOKUP(ItemToFind,RangeToLookIn,RowToPickFrom,SortedOrUnsorted) The ItemToFind is a single item specified by the user. The RangeToLookIn is the range of data with the column headings at the top. The RowToPickFrom is how far down the column the function should look to pick from. The Sorted/Unsorted is whether the column headings are sorted. TRUE for yes, FALSE for no. Example: Video Tutorial: Back to MS Excel>>

How to use "FREQUENCY" Function in Excel

This function compares a range of data against a list of intervals.The result shows how many items in the range of data fall between the intervals.The function is entered in the cells as an array, that is why it is enclosed in { } braces. Syntax: =FREQUENCY(RangeOfData,ListOfIntervals) Example: Following table records the marks of a student in 3 different months. Frequency function is used to calculate the frequency of Marks scored. Video Tutorial: Back to MS Excel>>

How to use "Forecast" Function in Excel

This function uses two sets of values to predict a single value.The predicted value is based on the relationship between the two original sets of values.If the values are sales figures for months 1 to 6, (Jan to Jun), you can use the function to predict what the sales figure will be in any other month. The way in which the prediction is calculated is based upon the assumption of a Linear Trend. Syntax: =FORECAST(ItemToForeCast,RangeY,RangeX) ItemToForecast is the point in the future, (or past), for which you need the forecast. RangeY is the list of values which contain the historical data to be used as the basis of the forecast, such as Sales figures. RangeX is the intervals used when recording the historical data, such as Month number. Example: Video tutorial: Back to MS Excel>>

How to use "FIND" function in Excel

This function looks for a specific letter in a word and gives the result as number of the position of the letter in a word. If the text has more than one reference of the letter, the result would be the first occurrence. Example: Let's see here in the first row, i am searching for the letter "e" in the word "hello" and the result would be position in number, which is a second position = 2. Here is the video tutorial of the same for clear understanding. Back to MS Excel>>

How to use "EOMONTH" Function in Excel

This function will show the last day of the month which is a specified number of months before or after a given date. Syntax:   =EOMONTH(StartDate,Months) Example: Here is the video tutorial of the same for clear understanding. Back to MS Excel>>

How to use "DMAX" Function in Excel

This function examines a list of information and produces the largest value from a specified column. Syntax: '=DMAX(DatabaseRange,FieldName,CriteriaRange) The Database Range is the entire list of information you need to examine, including the field names at the top of the columns. The Field Name is the name or cell, of the values to pick the Max from, such as "Points Scored" or D3 The Criteria Range is made up of two types of information.  The first set of information is the name, or names, of the Fields(s) to be used as the basis for selecting the records, such as the Name of the candidate or Subject The second set of information is the actual record, or records, which are to be selected, such as Durga as a Candidate's Name, or maths as Subject. Example: Here is the video tutorial of the same for clear understanding. Back to MS Excel>>

How to use "DAVERAGE" Function in Excel

This Function is used to find the average of a particular item chosen from a particular criteria This is a combination of IF and Average Function.Examines a list of information and produces and average. Syntax: =DAVERAGE(DatabaseRange,FieldName,CriteriaRange) The DatabaseRange is the entire list of information you need to examine, including the field names at the top of the columns. The FieldName is the name, or cell, of the values to be averaged, such as "Marks" or D2 The Criteria Range is made up of two types of information.. The first set of information is the name, The second set of information is the actual record, or records Example: Here is the video tutorial of the same for clear understanding. Back to MS Excel>>

How to use "DAY" Function in Excel

This function extracts the day of the month from a complete date. Syntax:  =DAY(value) Example: Here is the video tutorial of the same for clear understanding. Back to MS Excel>>

How to use "DATEDIF" Function in Excel

This function calculates the difference between two dates. It can show the result in weeks, months or years. Syntax:  =DATEDIF(FirstDate,SecondDate,"Interval") FirstDate : This is the earliest of the two dates. SecondDate : This is the most recent of the two dates. "Interval" : This indicates what you want to calculate. These are the available intervals. "d" Days between the two dates. "m" Months between the two dates. "y" Years between the two dates. "yd" Days between the dates, as if the dates were in the same year. "ym" Months between the dates, as if the dates were in the same year. "md" Days between the two dates, as if the dates were in the same month and year. Example: Here is the video tutorial of the same for clear understanding. Back to MS Excel>>

How to use "DATE" Function in Excel

This function creates a real date by using three normal numbers typed into separate cells. Syntax:  =DATE(year,month,day) Example: Here is the video tutorial of the same for clear understanding. Back to MS Excel>>