Free Project Management Tools - Tutorials,Ebooks and Setups

If we want to make a copy of any sheet, we generally right click and select move or copy. By doing this, we can move to other workbooks. But here, if I want to have in this same sheet, hold down the ctrl key and start dragging the sheet away, you will see the + sign in it.   So if you move now towards the leftward or right side you will notice a little black pointer, if you release mouse first, we get a copy. I'll do it again. Get the Control key held down drag to the right, and release the mouse to make a copy. For Personalized detail learning, write to  dptutorials15@gmail.com If you found this video valuable, give it a like. If you know someone who needs to see it, share it. Leave a comment below with your thoughts. Add it to a playlist if you want to watch it later. *************************************************************** Read my full article on this:  http://ift.tt/2kB14dh *************************************************************...

We know it is easy to copy and paste the data, but there is a technique to enter data in multiple cells so quickly. Select the range of cells, where you would like to enter a value. Holding the CTRL key, click on any cell and then type the value as per your wish, say “DP”.   And don’t press enter now, instead press Ctrl+Enter and then you will get the entire series with the same name DP. This works with the numbers as well, it doesn’t have to be in the same row or same column. Let’s see, if I want to type 100 in these 4 cells, I simply select these 4 cells by pressing Ctrl key and selecting a cell of these and I type 100 and press Ctrl+Enter. So, you can use this trick for numbers, text and also for formulas. Let’s see an example for using the formulas as well.   Here, I have got some numbers and let us find the sum of all these columns. First, let me select all the cells here, type the formula as = Sum (select the range in the first column) and press...

  In order to see a formula in a cell, we generally double click a cell.   But sometimes, we may want to see all the formulas at once. To do that, there is a key stroke shortcut and also a menu command that will allow you to display all the formulas. The key below the Esc key on your keyboard having the Tilde & accent grave can be used along with the Ctrl key as a key stroke shortcut now. So, let’s try now by pressing the Ctrl+` key on your keyboard to see that all the formulas in the sheet, getting displayed and columns width has been increased. If you press the Ctrl+` again you will be back to the normal display. You can also find this feature from the menu bar, Go to the Formulas tab and select the option called show formulas Now, let’s see the other trick of highlighting all the cells that contain formula Go to the Menu bar and in the extreme right, you will see the Find & Select button, click it and choose formulas and then all cells th...

How To Change The Data Without Using The Formula In Excel || MS Excel Tricks And Tips If you found this video valuable, give it a like. If you know someone who needs to see it, share it. Leave a comment below with your thoughts. Add it to a playlist if you want to watch it later. In this example, I have some numbers 1 to 10 in this column and if I suppose to multiple each cell by 2, what would everyone generally do? Using formula in the next column, we multiple each cell by 2 but let’s see how we can do this without using the formula. I type 2 in a cell and then copy the cell.(CTrl+C) now select the entire range which needs to be changed and then press CTRL+ALT+V and under operations select the multiply option and click OK, you will see the result getting exactly the way u wished. Let us see one more example, here you will notice that using the formula is no better than using our new feature. Here I have targets for 4 regions by month wise and what if your boss ask...

·          Flash fill is the most powerful tool that has been introduced in MS Excel 2013. Using this feature, we can combine multiple columns and separate the data from a column. Now let’s see with an example. ·          In the first column, I have Full names (First name separated by last name) and if I would like to reverse the order of first name and last name, we generally do that by using the Text to columns / concatenate functions. But using this new feature of flash fill, we don’t’ need to do this anymore. ·          In the adjacent column, I type the last name of the first entry, comma and type the first name and then go to the menu bar and go to the Data tab and click on flash fil (either u can press Ctl+E as a shortcut) and you will notice that the names populated as per your wish. It’s nice right. ·        ...

In Excel, from any particular cell if you would like to move to last row, we generally press Ctrl + Down arrow and to move to last column, we press Ctrl + Right arrow . Similarly for first row and first column, we press Ctrl + up arrow & Ctrl+ left arrow respectively. This is all we knew til now. But there’s a shortcut even for this?? Let’s see how it is now. Go to any cell and from here if you would like to move to the last row, simply double click the bottom edge of the cell. Similarly double click on right edge of the cell to move to last column. You can try with other two edges to move to the first row and first column.  Similarly to select the entire column, go to the first cell, hold shift and double click the bottom edge of the cell. You can do the same logic for selecting entire row as well. For Personalized detail learning, write to  dptutorials15@gmail.com If you found this video valuable, give it a like. If you know someone who needs...

How To Change The Shape Of Comment Boxes In Excel | Insert and Edit Comments in Excel. ·          When you go to any cell in Excel and upon right click, you will be seeing the option called “ Insert Comment ”, by clicking this you can insert your comment for that particular cell. ·          Once you are done with the inserting of comment into the cell. Now, whenever you place the cursor on the cell, you could notice that the comment is becoming visible. ·          If you would like to reshape this comment box, right click on the cell and choose edit comment, then hold any corner of the box and drag to make it wider, taller to adjust the content. ·          But, sometimes you would like to even have different shapes altogether. So, in order to do this, we need to activate a feature that is not availa...

Hello Friends, Welcome to dptutorials. In this video, let's learn about one of Excel's most powerful and creative tool that is called as Pivot Table, when you work with large amounts of data, i.e list type data. Pivot table is great for coming up with quick summary information. Watch this video completely for better understanding of the awesome new trick which will make you more productive and efficient. In this example, I am considering a small amount of data for clear understanding. I am going to create a Pivot table based on this data now. It has got some multiple rows of data that we are tracking sales, amount, customer count, population by state and region wise. Generally we go to insert tab in the ribbon and create a pivot table in excel. but I would suggest you a new trick of using the new feature called " Recommended Pivot tables" because sometimes the layouts that you see here might be the exact or at least close to something that you want. ...

Are you still using Vlookup? This Microsoft Excel tutorial will teach you how to use the INDEX and MATCH functions, which can provide a better solution. If you found this video valuable, give it a like. If you know someone who needs to see it, share it. Leave a comment below with your thoughts. Add it to a playlist if you want to watch it later. For Personalized detail learning, write to  dptutorials15@gmail.com If you found this video valuable, give it a like. If you know someone who needs to see it, share it. Leave a comment below with your thoughts. Add it to a playlist if you want to watch it later. *************************************************************** Read my full article on this:  http://ift.tt/2kB14dh *************************************************************** Subscribe for more Awesome Tutorials:  goo.gl/4T8ePc *************************************************************** Support The Channel via shopping:  http://ift.tt/2j...

Watch this video to learn the excel Shortcuts for Formatting the data. these are very useful and helpful in formatting which saves lot of time of yours. If you found this video valuable, give it a like. If you know someone who needs to see it, share it. Leave a comment below with your thoughts. Add it to a playlist if you want to watch it later. For Personalized detail learning, write to  dptutorials15@gmail.com If you found this video valuable, give it a like. If you know someone who needs to see it, share it. Leave a comment below with your thoughts. Add it to a playlist if you want to watch it later. *************************************************************** Read my full article on this:  http://ift.tt/2kB14dh *************************************************************** Subscribe for more Awesome Tutorials:  goo.gl/4T8ePc *************************************************************** Support The Channel via shopping:  http://ift.tt/2jH3...