We all love to share YouTube videos don’t we. Especially with the ever growing number of excellent videos on the world’s biggest video database, we always find something or the other which we would rate as amusing or simply a must-watch. But for some impatient ones like me, we always tend to be really excited about the stuff we share. And we want to share a specific portion of a YouTube video. We often even use YouTube videos for referencing – like a particular portion from a video would help an opinion etc etc. You get it. But how do we achieve it. Well, the usual drill was to mention, please refer the video from 2 mins and 40 seconds onwards blah blah! But not anymore. Techkeyla is here to the rescue. Enter – TubeChop. Not only can you edit YouTube videos, but also share it, embed it, and prove your awesomeness.
So how do you actually do it?
Glad you asked. Just go to TubeChop. The text bar on the site, asks for the YouTube video URL. Just paste your desired URL . For our tutorial, we are using this supercute LOLcat video. Once you paste and hit enter, it will ask you to select the start and end points of the video.
Just drag and seek the start and end position bars as required. Easy peasy!!
Once done, hit the Chop It button. The next page gives you the link, as well as the Embed Code. Howzzat!
The only weakness of this tool is that it does not work with videos which have disabled embedding.
And because you have been so attentive, you get to see this really cute and home-edited version of LOLCATS. Enjoy and happy edited sharing. Cheerio!
In the past couple of months of working on Excel and VBA Macros, I have been exposed to a few challenges which in the course of time, I have overcome. So, I thought I would share them with my beloved readers. This section: Excel Tips aims at sharing the small tips and tricks that I have come across which makes life easier for anyone working with Excel or VBA Macros. Cheers!
Here we’ll be focussing on how to select a range dynamically and perform further operations to it etc.
For e.g. If we have a Sheet “Input” of which one cell is required say column B, and we need to perform some kind of mathematical operation on them – viz. average, sum, etc. we need to do that by selecting the entire range of non-empty values of those two cells.
The problem here is that the number of entries in column A will vary from time to time, but we want a command button which automatically knows the amount of non-empty values and accordingly runs the mathematical operation. This is known as Dynamic Range Selection.
This post should not be considered as just a mere rant. This actually works for job interviews and in my experience of the few that I have attended, it has certainly got the positive attention of the recruiter. So, how does it work? By definition, blogging can be at different levels – personal – which is focussed on personal likes/dislikes etc and hence, is already driven by some niche. The other end of blogging is – professional blogging – which is primarily done by people who earn their bread and butter by means of blogging. Such are writers who majorly write about specific areas – such as Technology, Blogging, Making Money Online, Entertainment, Television, Pop culture etc. They are the next generation of press reporting, and arguably pose a threat to the traditional news reporting. Such is the impact that News reporters and the likes have resorted to Blogging online. So, coming back to the question is how does Blogging add value to one’s resume?
Yes, you read that right. You can download Megavideo videos for free online without any software installations which load bunch of spywares and adwares into your hard drive.
For starters, Megavideo is a video hosting site, which unlike other video streaming websites like YouTube, DailyMotion and the like, has no upward time limit for videos. The range of content on Megavideo has been similar to its parent data sharing website Megaupload – [ if you know what I mean]. The catch here is that Megavideo allows non-premium users to view only 72 minutes of content at once. After this time is exhausted, the video streaming is halted. There are other work-arounds as mentioned in my post here [Firefox Hack: How to watch Unrestricted Full videos on Megavideo]. But if you are one of those, who just want it downloaded on your PC,Mac whatever, just follow the instructions below.