Free Project Management Tools - Tutorials,Ebooks and Setups

If an Excel spreadsheet is password protected, we are unable to edit the data in the sheet. If you do not remember the password or if you don't know the password to unprotect the excel sheet then just follow this process for unlocking the excel sheet. Step 1:  Open the Excel sheet Step 2: Press Alt + F11 or click on view code on the developers tool Then you would be seeing a sheet like this Step 3: In the above white space, just enter the code as shown below(Just Copy paste) Sub PasswordBreaker()     'Breaks worksheet password protection.     Dim i As Integer, j As Integer, k As Integer     Dim l As Integer, m As Integer, n As Integer     Dim i1 As Integer, i2 As Integer, i3 As Integer     Dim i4 As Integer, i5 As Integer, i6 As Integer     On Error Resume Next     For i = 65 To 66: For j = 65 To 66: For k = 65 To 66     Fo...

Let us learn how to Autofill the Data in the Microsoft Excel 2013. In 2013 it would be very easy to autofill by just entering the data in one cell, placing the cursor at the right corner of the cell and then just dragging the cursor down. Microsoft Excel 2013 detects the format of the data that you have entered and it will autofill in the same format of the cell that you have entered. This can even be done using a shortcut. If you would like to autofill the data in a single columns without dragging the cells, just place your cursor in the cell and by pressing the shift  key select all the cells in the columns upto which you want to autofill the data and then press Ctrl+D. Similarly for doing the same auto fill by Rows, press Ctrl+R . Video Shown here for better understanding. Back to MS Excel>>

Here is a funny geeky trick you can learn in the Microsoft project where the gantt chart can be made walking as shown in the video below. Step 1: Open the Microsoft Project and add two tasks TASK-1 and TASK-2 Step 2: Now add the Duration as " 2 Days ". This trick works with only of 2 duration. So Enter the Duration for the two tasks as 2 days. Step 3: Enter the Start dates for the two task and the finish dates arrive by default based on the duration. you might be aware of this. Step 4: Right click on the Finish Date of Task-1 and Select " Copy cell" Step 5: And now Right Click on the Start Date of Task-2 and select the " Paste special" and choose the Paste Link and click " OK " Step 6:  Similarly Copy the Finish Date of the Task-2 and Paste it as the Paste link option in the Start Date of Task-1 And now observe the funny walking of the Gantt chart instantaneously, This can only be ...

In the earlier tutorial we have learnt How to create a new calendar for a project in Microsoft Project 2010. The problem we generally face is we have to make this all the time when we create a new project as by default we have only three calendars in the MS project "24 Hrs", "Night Shift" and "Standard". So, if you would like to create a new Calendar and add the same into your default list, here is the simple tip you can follow. Let's learn how to make a newly created calendar as a Global calendar by making it default. Step 1: Go to " Project " >> " Change Working Time" >> Step 2: And Click on " Create a New Calendar " Step 3: Name the Desired calendar. Here i am naming it as "6 Days" Step 4: In the Bottom of the window, go to " Work Weeks ">> Click on " Details" and Click "OK" Step 5: In the Details for Default Wizard, selec...

The Default Calendar in Microsoft Project is the Standard 5 Day Week Calendar, and we have the Two other calenders in the Global.MPT which are "24 Hrs" and "Night Shift". You can change the Working Timings to change the calendar.Here is the process for this Step 1:  Open the Microsoft Project 2010 and go to " Project " in the menu bar and then click on " Change Work Time " Step 2: Then in the Wizard "Change Work Time". Click on the " Create a New Calendar " Step 3 :  In the Wizard, Type the Desired Calendar name, here i am typing as the "6 Days Calendar" . and then Click "OK" Step 4: Then in the Wizard, Select the " Work Weeks " at the bottom and click on " Details " at the right side of the wizard. Step 5: Now here, Observe that all the 5 working days will be having the working timings as 9:00 AM to 5:00 PM. So select the 6th day Sat'day and Se...

An S-Curve is the Graph of the Project costs over the time. It can also be typically plotted for the Resource hours over time. S-Curve is the cumulative value of the Project costs on the Y-Axis and the Timeframe on the X-Axis Which takes the shape of the S. S Curves often plotted with Planned values and compared with that of the actuals. At any point of time, looking at the graph one can analyse the Cost variance and the Schedule variance as well. S- Curve will be generally used to understand the trend of the costing and Resource optimization in the Project.

Some times we need to copy the text from an image file and we find it difficult in recreating/typing the text. But this can be done in a simpler way without installing any new software into your system. There is a web service which can be installed as an app for the chrome users, then it would be much more simpler to copy any text from an image, can extract text from any kind of graph with the following tricks. After installing this app in the browser, scroll down and place your mouse on the image where exactly the text is,  right click and then you get the menu items to select Copy text, Select all, Language, translate, options. So to select all the text in the photo, click the select all option. Copy the text and paste wherever you wish to, If you would like to google search the copied text click on the Search option.  If you would like to edit the text in the image itself then click on the translate option and then click on modify text ,  If you want to r...

Till now you might have used the Visio or other MS office tools for making the graphical presentations for explaining the concepts. Now, this can be done with ready made graphic templates through a web service called www.easel.ly . Here you would be finding various designs to select from and customize the design as per your wish and edit the texts even along with the colors.you can insert the predefined object, shapes, backgrounds etc,

This website is very useful for those who relocate themselves very often. In case we get relocated or transferred to a new place altogether, we do have umpteen queries about the new place like Range of House Rents, Do we get  a rented house?, Hotel Tarriffs?, Household Goods availability ??, Traffic Strength?, Taxi Fares??, ...So many questions wander in ourselves for which we need soothing answers to get relieved from all these stuff. if your are in search of answers for these kind of questions, do visit the website www.numbeo.com Browse your place in the Homepage. you can view the detail analysis of any indian city. For viewing the complete details like the prices of the household items to hotel charges, rented housed etc after getting registered in the website. There is even an option of uploading the data from your side. So, just start browsing the complete information through the menu.

www.udemy.com Your place to learn real world skills online, here at www.udemy.com you can search for online courses on web development, yoga,music,musical instruments, photography or anything else. Right now there are around 3 million students and more than 16000 courses available in the site. Learn at your place on any device through apps even. www.coursera.org Take the world's best courses online, for free. There are some 664 Courses from 109 partners. Here you will be even provided by Certificates, but the thing is that one has to work hard as a real time student to get these certificates. Just browse the courses from the Homepage and then chose the medium language. This site has been partnered with top universities and organizations worldwide, to offer courses online for free. www.udacity.com Go through the course catalogue, choose the course online with personalized support. Classes will be in the form of videos, exercises.