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
Eric Mayo teaches us how to put together a resume as an ex-offender. Your resume should be a one page paper of all your skills and work experiences. If you don't have a lot of experience writing resumes, get help from friends who have experience. When you write it, add your name, address and telephone number onto it so you can be contacted. After this, you will want to list: objective, work experience, education/training, skills/strengths, and references. Remember not to list your references ...
In this video tutorial, viewers learn how to use Flickr photos in their screen-saver. This task can only be done on the Windows computer. Users will need to download the program from the website provided in the video. Once downloaded and installed, there is an option in the Screen Saver Settings. Users are able to take photos from specific users or groups, or can search through tags and contacts. Further options include selecting the size of the photo and delay between switching the photos. U...
In this video tutorial, viewers learn how to upload large files online for free. The website recommended in this video is Load2All It does not host any files, but it provides a interface to upload the file to several other sites at once. If the file exceeds the limit for any given site, Load2All will automatically split the file into RAR files, upload it into several mirrors and provides one download link. This video will benefit those viewers who have a large file...
This video is part of an instructional series on salsa dancing. In this particular video, instructors Anthony Persaud and Julie Merrill indicate the proper way to execute windmill dance moves in salsa. These moves involve structured turning, with or without a partner. The arm is raised up and outward, turning in a clockwise, then counterclockwise motion to facilitate turning from one way to the other. The name windmill refers to the way the arm turns to allow the move. Anthony provides instru...
Interviewing lighting basic training tutorial provides easy to follow instruction in this step by step video. Set up the interview area to allow the best camera angles. Place your lights in key, fill, and backlight positions. Use back lighting spillover to fill subject area without camera spillover. Check your setup with the subjects and make any necessary adjustments to your camera or lighting angles. Place your crew and your ready for your interview. This scenario using key, fill, and back-...
This video teaches English-language learners how to respond to questions beginning with the words "How do you like". There are two types of questions in English that begin with the words "How do you like". The first kind requires an answer in the form of an opinion. The second requires that the answer come in the form of giving instructions. The video explains the difference, then gives several examples for each to model practice. For example, "How do you like the weather?" is a question whic...
Prime Loops provides exclusive techniques from industry professionals to help enhance your music production, mastering skills & gain exposure. Their tips and tricks through tutorial videos are quick and easy to learn. In this video, they show the user how to add effects automation on beat. This video carries on from a series of previous videos. It goes through basic automation, adding it to the drum beat already made in the first FL Studio Tutorial. This tutorial gives the user the lowdown on...
In this video tutorial, Chris Pels will show how to extend a standard ASP.NET server control and customize it for a specific purpose. Specialized controls provide an convenient way to implement standardized user interface elements for multiple web sites for individuals or teams of developers. In this example, see how to extend the DropDownList control to create a special purpose year selection control. Learn how to add properties for custom attributes that control the behavior of the range of...
This IGN guide provides an overview of the different Strike Packages available in Call of Duty: Modern Warfare 3, including how the death streak and win streak packages work. You'll learn how to use the recon drone, Advanced UAV, and more.
The Titanite Demon boss fight in Dark Souls is pretty frustrating, but this IGN guide makes it easy. You'll want to use range to take him out, so try using your bow and arrow or magical spells. Defeating the Titanite Demon will provide you with the Demon Titanite item. Go figure.
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.
Mirror Mode is a feature provided with the Motorola Droid Bionic that allows you to connect the Android smartphone to an HD TV or computer monitor via an optional HDMI cable. Then, you can watch HD videos and look at pictures you've taken with your Bionic on your TV or computer. This guide will walk you through the process of hooking up the phone to an HD device.
There are many different applications available on the Android market today, and if you want to download and use a lot of them on your Droid Bionic smartphone, you'll need a great way to organize them. Thankfully, Motorola has provided this guide on creating "app groups" which serve to better categorize your apps into folders.
If you have a subscription with Verizon Wireless to use the mobile hotspot feature on the Motorola Droid Bionic Android smartphone, you can provide internet access to any nearby device with a WiFi connection by accessing the mobile hotspot application on your Bionic. This guide from Motorola will walk you through the process, but be careful because the hotspot feature will drain your battery!
The second boss fight in Deus Ex: Human Revolution can be a tricky one. Take a look at this guide from Giant Bomb on how to beat Yelena Federova, the Mantis quick and easy. Make sure that you listen to the AI throughout the fight as well. It will be providing you with some tips of its own.
If you're playing Deus Ex: Human Revolution on the Xbox 360, you can unlock the 'Ladies Man' achievement during the Corporate Warfare side quest. You will need to have the social enhancer augmentation to obtain the achievement. This guide will help you sweet talk the woman character until she provides you with the information you need.
For an easy way to lookup and connect with people and companies across the web (and all of its many social media outlets) check out the Firefox extension Tabble. Tabble provides you with access to all of an individual's relevant online information and can even show you relevant e-mails in your Gmail account if applicable.
If you're interested in learning how all of the defensive moves and attributes function in Fight Night Champion, take a look at this video that provides information the defensive functions of the game. If you're enjoying it on the Xbox 360, you'll be able to learn what buttons allow you to block and play defensively.
Learn the basics of video editing in this funny and informative clip from Vimeo's excellent Video 101 series of tutorials. This video provides a handy overview of the steps involved in editing video, including transferrring footage, organizing clips into video bins, editing using the timeline, trimming the footage & using transitions, saving frequently, and exporting videos to be viewed on various sites with various compression settings.
The Assault class in Battlefield Bad Company 2: Vietnam is a nice simple class that can kill people quickly and support your team by providing them with extra ammo packs. This video will teach you some strategies for dominating as the Assault and also analyze the different weapons you can choose for the class.
Find which airlines Google is providing free Wi-Fi on this holiday season, fix shutter lag on digital cameras, wipe your hard drive for free, improve your Wi-Fi router performance, adjust your television and monitor for accuracy, choose the best 1080p projector, use a single server that can handle OS X, Windows & Linux simultaneously, and use the best audio encoding system for Windows Media Center and Zune.
The Roland TB-303 should be a part of every electronic musicians arsenal, but cannot be because of it's scarcity. If you have a MicroKorg, however, you can make a patch that provides a decent approximation of the 303 sound, and this video will teach you how to program it.
Need an introduction to Excel's useful TODAY & NOW time functions? You're in luck as this clip provides just that. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the Excel 2007 workflow, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, take a look.
The Contacts application on Android-powered cell phones provides a powerful way to manage your address books and keep in touch with friends and family. You can even add and manage multiple accounts from various sources. Watch these tips from Google to learn who to get the most of the Contacts Android app.
The Quick Search box on your Android-powered cell phone allows you to search the web and your phone directly from the home screen. It provides suggested results from the internet, even while you still type! Easily search both your phone and the web with the Quick Search box! Google shows you how in this video tip.
This "chest workout home edition " was designed to provide an easy and fun professional workout for everyone. These exercises are designed to tone main pectoral muscles (upper, major and minor pectoral muscles) and you can workout wherever you want: at home, in the park, on the beach or at the gym.
Creating great-looking animation is what Flash CS4 was made for. This video tutorial explains how to animate vector graphics in Flash using the classic motion tween and a simple mask. It provides step-by-step, detailed instructions that should allow you to animate any image you want quickly and effectively.
If you're thinking about venturing into the world of using Camera Raw in Photoshop, you've come to the right place. The camera raw function in Adobe Photoshop provides easy access to raw image formats produced by many digital cameras. In this video, learn all about how to get started using the Camera Raw Utility plug-in for Adobe Photoshop.
Avocados provide you with some of the healthiest fat you can out into your body. If you want to find a way to add more avocado to your diet without then this video from The Food Network has good some flavor coming your way. This video will show you how to make two awesome avocado dishes.
Unlike cooking Chinese food, martini-making requires more than just throwing in whatever you happen to have lying around your countertop and shaking it up.
Because of its large, high-resolution screen, the iPad is well suited for watching web video (provided said video is delivered by an HTML5 player). With this official video guide, you'll learn how to use the free YouTube app to watch clips from the popular video sharing site on your Apple iPad.
Built from the ground up just for the Apple mobile device, the iPad Keynote app makes it easy to create beautiful and dynamic slide presentations—provided, that is, that you know how to use it. Learn how to use Keynote iPad application to create your own presentations with this helpful video guide from Apple.
Check out this short video tutorial from Rouxbe on how to peel tomatoes. This video will support your cooking experience and will provide you with additional relevant information during your culinary time peeling skin off tomatoes.
Check out this short video tutorial from Rouxbe on how to pit and dice an avocado. This video will support your cooking experience and will provide you with additional relevant information during your culinary time pitting and dicing avocados.
One of the advantages of shooting in RAW format is that you can often recover overexposed or blown highlights. Aperture provides two easy to use controls for restoring detail to areas in a RAW image that have been overexposed to complete white.
The enhance controls in Aperture's adjustments panel provide a number of tools for refining your tonal adjustments, controlling saturation, and for correcting color casts.
Aperture's levels adjustment provides a refined level of control over your tonal corrections.
Aperture's highlights and shadows adjustment tool provides an easy way for you to brighten or reduce the brightness of highlights and shadows without affecting other aspects of your images.
This video provides an introduction to building 15mm scale buildings for Warhammer or miniature dioramas. Simulate roofing shingles and with small pieces of cardboard. Create a haunted scene with real spider webs. Preserve tiny spider webs with a protective spray or make miniature spider webs out of milkweed. Build small scale grapevines with toothpicks, wire, and painted leggy moss.
