Repeating a task using a For...Next loop : Excel: VBA in Depth from lynda.com Watch the entire course at http://www.lynda.com/home/DisplayCourse.aspx?lpk2=62906&utm_source=youtube&utm_medium=viral&utm_content=youtube&utm_campaign=youtube
Stuffed bell peppers can be prepared in an infinite number of delicious ways. Whole peppers, half peppers, red or green peppers, meat or vegetables or both? The debate will rage as long as chefs like to talk, and that's not going to change any time soon. This particular recipe calls for beef sausage and rice as the principal elements of the stuffing, and halved green peppers for the shell. As always, the dish is easy to prepare, takes quite some time to cook, but yields a delicious, hearty re...
This is a quick little video showing you how to import creatures online into your Spore Creature Creator. With a simple drag and drop, you'll find yourself being able to customize thousands of different pre-made Spore creatures created by others.
Welcome to a tennis lesson from FuzzyYellowBalls, the the best place to learn how to play tennis online. Our free video tennis lessons teach you how to play the game in a new way that combines technical analysis, visual learning, and step-by-step progressions.
The first video introduces the basic electrical quantities of charge, current, voltage, and resistance. The concept of quantities and units is explained. The units of Coulombs, Volts, Amperes, and Ohms are described. The three basic formulas of Ohm's Law (E=IR, I=E/R and R=E/I) are also introduced.
Snapchat is making it easier for developers and creators to build augmented reality effects in Lens Studio with a slew of new features, including seven face templates.
If your fortress is pretty big and advanced, watch this video. It will give you some advanced tips on building a nearly complete fortress, then show off the creator's beautiful, 20-tutorials-in-the-making fortress.
In this tutorial, we learn how to design custom flyers using Easy Flyer Creator. First, start a new deign in the software, then delete all graphics so the page is blank. Next, add in a background to the flyer and resize it to fit onto the entire page. Now, right click on the picture and choose 'set as background'. Now, add another picture on the page, then move it to your desired location to fit on the bottom of the page. After this, you can edit the picture further, if needed. When you are d...
This video explains to the viewer the advantages of replacing washing machine hoses. As well as, rather more importantly, explaining how to complete the process. According to the creator the rubber hoses that are standard to most washing machines are subjected to high pressure water for many years. As they are only made of rubber they are apt to break and start leaking. This can cause many thousands of dollars worth of water damage. The creator recommends replacing the rubber pipes with reinf...
Check out this instructional language video to learn how to express possession in the genitive case in Russian. Learn basic Russian grammar with Viktor Dmitriyevich Huliganov in his 8th lesson. He introduces a whole new way of tackling the tricky area of possession. The next lesson in the series introduces Russian's non-verbal way of having or possessing something. Watch this tutorial video that is great for language nerds and advanced Russian speakers who need to polish their skills or looki...
Check out this instructional language video and learn about the irregular Russian verb "khotet". Learn Russian with Viktor Dmitriyevich Huliganov in his 13th lesson. He introduces a whole new way of tackling the tricky area of conjugating irregular infinitives in Russian. This time he looks at the highly irregular conjugation of "khotet'", to want, and introduces the instrumental case of personal pronouns. Watch this tutorial video that is great for language nerds and advanced Russian speaker...
iOS 5 introduces an incredible feature that isn't very well known called "Shortcuts." It allows you to use automatic text expansion for whatever abbreviations you want. This is a great way to type several letters into your iPhone, iPad, or iPod touch and have them immediately expand into whatever phrase you want. Find out how to configure text expansion in this guide.
In earlier versions of Minecraft, Ender Pearls only allowed you to scare off Enderman. Thankfully, Minecraft 1.9 has introduced new functionality to those pearls--the ability to teleport around the map by tossing them in a direction. Take a look at this guide to learn how to teleport using Ender Pearls.
The Minecraft 1.9 update introduces a very dangerous and scary option--the ability to play Minecraft in hardcore mode. Hardcore mode provides you with one life, meaning that dying in the game will completely delete the world and force you to restart. Find out how to turn on hardcore mode in this tutorial.
If you're interested in creating your own GUI button in Minecraft, take a look at this tutorial to find out how to create and add one to the game using the ModLoader and MCP utilities. This is a bit of an advanced tutorial for Minecraft mod creators.
Minecraft 1.9 introduces animal breeding to the game, but it's not such a simple process. You'll need to make sure you have some wheat which is extremely useful in getting the animals to attract to you. After that, you'll be able to start breeding the Minecraft animals--now if only we could get them to fight like Pokémon!
The upgrade to Minecraft 1.8 introduced the abiltiy to create giant mushrooms in the different environments of the Minecraft world. They are so big that you can literally live in them. After adding a ladder, you can build a portable shelter inside of them.
Want to learn how to build all of the new Minecraft blocks that were introduced with the Minecraft 1.8 update? Learn how to craft everything from fence gates to glass panes in this tutorial on all of the new block recipes in the Minecraft 1.8 update.
Minecraft 1.8 has introduced Enderman to tons of blocky servers all over the world. If you're looking for ways to fight against Enderman or just avoid Enderman all together, take a look at this walkthrough on how to do both. Be sure to grab an Ender Pearl so that you can half their attack range!
Check out this free Windows utility that allows you to print files directly from the file system by dragging and dropping them onto an icon conveniently placed on your desktop.
Asking someone out on a date can be very intimidating, especially if you do not know them that well or if they are a complete stranger. This guide helps you learn how to confidently ask a stranger out on a date by introducing yourself, finding common ground, learning about the stranger, and then asking them out. Sometime's asking someone out is as easy as initiating a conversation.
The Call of Duty Black Ops Zombies (that's a mouthful) map Ascension introduced perk-stealing monkey to the bestiary of enemies. They are quite annoying, and this video will teach you how to deal with and dispatch them easily, keeping your precious perks intact for better zombie slaying.
If you want to do your hair like Selena Gomez has it in her ballgown scene in the music video for her song "Who Says", check out this video. It will teach you how to do a similar inspired look with all drugstore products.
Minecraft Beta 1.3 has introduced some awesome elements to the game, foremost among them for all you Redstone heads out there is the Redstone Repeater. It's a new block you can craft that allows you to adjust the delay on the redstone circuit passing through it, allowing more finesse in timing your traps and other Redstone circuit contraptions and allowing you to save space by not making unnecessarily long circuits for the sake of timing.
The Nokia N900 smartphone suffers from a lack of quality games due to Nokia's restrictive OS, but fortunately you can get WebOS games from the Palm Pre loaded onto it pretty easily by following the steps outlined in this video tutorial.
If you're going to really have fun with LittleBigPlanet 2, you're going to need to know the ins and out of the game's logic tools. This video tutorial will introduce you to the basic logic tools, including microchips and the logic gates AND, OR, XOR, and NOT.
If you plan on using a compass as you sole means of navigation in a survival situation, you had better be familiar with magnetic declination and how it affects compass navigation. This video will teach you all about magnetic declination and how you need to take it into account when planning your route on a map with a compass.
RainMeter is an awesome desktop gadget / widget program that lets you put all sorts of cool displays on your desktop regardless of your OS. This video will show you how to install and configure it to get video creator ItzLupo's popular clock widget.
A shuffle LFO (low-frequency oscillator) is a cool effect in many synths that gives bass lines a swing feel to them. In this video you'll learn how to apply a shuffle LFO to any sound that you can access on your computer using NI Massive, a quasi-analog PC synth.
Altair or Ezio? If you've played both Assassin's Creed games you've probably pondered that question yourself, and creators Ubisoft catered to both by including an unlockable Altair costume in Assassin's Creed 2. Watch this video to learn how to unlock that costume and improve your Assassin's Creed 2 play in general.
NBA 2K11 is finally breathing some life into the long-stagnant world of basketball video games, introducing new elements and bringing back old ones that people missed. In this video, you'll learn how to use the isomotion dribbling system to do freestyle dribble moves with greater control and score more points.
Drake is one of the biggest rappers in the game right now, and "Find Your Love" has been one of his biggest singles. This video will teach you how to play a really pretty instrumental cover of the song on piano or keyboard. The creator even posted the notes in written form here.
"Ridin' Solo" by Jason Derulo is a great R&B anthem for anyone who's every broken up with someone to live their life the way they had to. This video will teach you how to play the song on piano, and the creator was even nice enough to make the sheet music available for free here.
Katy Perry is a certified sensation, and if she inspires you to play the piano then she's done at least one good thing today. This video will teach you how to play her single "Teenage Dream" from the eponymous album. You can even check out the sheet music at the creators websites here.
The ukelele is a great little instrument that is easy to learn, sounds good, and is portable. How much better could it be? They work especially well for covering pop songs, since they're very simple and catchy, which is the essence of the ukelele. This video will teach you how to play the hit song "Say My Name" by Destiny's Child on ukelele.
Round lashing refers to a knot that you can use to hold two poles together easily and securely. This is useful for constructing a flagpole, as the creators of the video did here and building a-frames. This video will show you how to use round lashing quickly and easily for your next outdoor project.
jQuery is a very powerful Javascript framework that makes making cool website interfaces much easier. This video will introduce you to the basics of using jQuery from installing it on your computer to creating your first simple element. You'll also learn the function methods that jQuery uses and how to inset jQuery into an HTML document.
Scripting languages, like coding languages, are among the most complicated and daunting aspects of computer use to master. If you can do it, however, they allow you to do nearly anything you want with a computer. This video will introduce you to the popular scripting language Actionscript 3. This language is crucial to using Flash successfully to create games, movies, and websites, so get this stuff down and then go watch our other Actionscript tutorials!
Creating animation in Flash CS4 is the most fundamental thing that you can do using this powerful software. It is also quite confusing to the uninitiated. This video will introduce you to the basics of creating animations in Flash by demonstrating the construction of a small flying line. Very basic, but if you just got Flash CS4 and are a little mystified by what to do next, watch this video!
This video continues to elaborate the titles that the creators started working on in this tutorial on blur in-out effects in Premiere Pro. This time they focus on creating light spots and fast bumpmaps and how these techniques can be used to create even cooler titles.
