Free Project Management Tools - Tutorials,Ebooks and Setups

In this video tutorial, let us learn how to easily generate serial numbers in excel data range. This is very quick and easy to perform. This is the auto generated serial number system in excel. ROWS and ROW function have been used for this purpose, which gets automatically updated. 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/2jH38PR You Can Connect With Me at G+ :  http://ift.tt/2kAOpa6  Twitter :  https://twitter.com/dptutorials15  Facebook :  http://ift.tt/2kfRnDi  Blogspot :  http://ift.tt/2kB14dh

In this video tutorial, let us learn how to apply copy formatting from any chart and apply the same to other unformatted charts in Excel. This can be done using the paste special option to copy and apply formats. This is superb easy trick with which we can save lot of time and efforts. 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/2jH38PR You Can Connect With Me at G+ :  http://ift.tt/2kAOpa6  Twitter :  https://twitter.com/dptutorials15  Facebook :  http://ift.tt/2kfRnDi  Blogspot :  http://ift.tt/2kB14dh

In this video tutorial, let us learn how to apply borders to a table in MS Excel. I Prefer this method which makes our data speak out because sometimes the table borders lead to distraction. 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/2jH38PR You Can Connect With Me at G+ :  http://ift.tt/2kAOpa6  Twitter :  https://twitter.com/dptutorials15  Facebook :  http://ift.tt/2kfRnDi  Blogspot :  http://ift.tt/2kB14dh

In this tutorial, you will learn how to clean the excel data in to right matrix. sometime when you copy paste the data from other sources, all the pasted data comes into a single column. Now let us see how to arrange the data into correct columns using the formula. 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/2jH38PR You Can Connect With Me at G+ : http://ift.tt/2kAOpa6  Twitter : https://twitter.com/dptutorials15  Facebook : http://ift.tt/2kfRnDi  Blogspot : http://ift.tt/2kB14dh