New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 241st installment in their series of digital spreadsheet magic tricks, you'll learn how to create a data validation drop-down cell list where the list shrinks as you select values.
In this Computers & Programming video tutorial you will learn how to make a simple CD / DVD cover in Google Picasa. Go to ‘Tools’ and select ‘Options’. In the box that opens up next, click on the ‘Printing’ tab and from the drop down menu, select ‘CD Cover Size’ and click OK. Then on the top left hand corner, go to ‘File’, select ‘Print’ from the drop down menu. On the next page, click on ‘CD cover size’ and you get the print preview. Then all you need to do is to just print that out and you ...
Kyle Hutchens with Live Strong demonstrates how to throw a good curveball. First grip the baseball on the side where the skinny seams come together. Take a normal pitching stance with one leg back, come through, bend your front leg and snap your wrist down through the ball to release it. Snapping your wrist down through the baseball creates the speed and the drop of the curveball. It creates less velocity than a fastball. Create the drop when your arm is between the 12 o'clock and 6 o'clock p...
Tasktutorial.com shows us how to create drag and drop functionality into a flash program. Start off by making a few shapes in flash and then add color to each of them, a different one for each shape in order to differentiate between them. After doing this select all the shapes by dragging the cursor over them, once done distribute the shapes into layers by going into the 'modify' drop-down button at the top, then timeline and there will be the option to distribute. Now we have to turn the sha...
Want to change your YouTube Channel type? YouTube user webduncetv shows you how. After signing into your YouTube account hover your mouse over user name and click on the word "Account" from the drop down list.
Learn how to do Smith machine inverted palms down pull-ups with release/re-catch at top. Presented by Real Jock Gay Fitness Health & Life.
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.
In this tutorial, we learn how to use the main menu functions in Photoshop CS3. All of your main menus are up on the top toolbar. There will be a drop down list for each different tab you select. When you create a new document, you will be prompted with a dialogue box that asks you how you want your page to be set up. Change the preferences to fit how you want your page to look. When you have changed all of your different settings, click on "ok" and you will be brought to your new document cr...
In order to Find, Replace, and Sort, using MS Excel, become familiar with your home tab. When you click on Sort, it will give you the opportunity to sort in different ways: e.g. alphabetically. If you accidentally shift your table, you can undo it by using Ctrl + Z. Custom Sort will allow you to be very specific in the way you want your data sorted. You can add or remove a filter with the same drop down menu, in order to be even more precise.
Eddy Currents are little circles of electricity created when metals are moved by magnets or even when magnets are moved by metals. To understand this practically take a regular piece of cardboard and drop it in between a horse shoe magnet. It drops normally with out being effected by the magnet. This is because the cardboard does not conduct electricity. Therefore it does not cause any eddy currents. But instead if you use an aluminum piece in the same way, it falls very slowly, because alumi...
To sort data in Excel spreadsheets, have each category (for example, first and last names) in a single column. Click on any cell in the column you wish to sort. Be careful not to highlight the entire column, or results will be sorted only in that column. Click on DATA on the ribbon at the top. To sort in descending order, click on the z-a button. For more detail, click on the main SORT button, and you can specify which columns you want sorted and how. For instance, you can sort by descending ...
Ali440134 demonstrates how to make a bootable ISO image or a CD / DVD disk. Making a bootable ISO disk is easy and requires just a few simple steps to complete. First, use the Magic ISO program to make the disk. Open Magic ISO and click your desired file. Then, click the open button. Your Magic ISO panel should then say Bootable which means that you can make a bootable disk. Next click tools and under the tools drop down menu click the burn CD / DVD with ISO option. Then, select your file and...
In this tutorial, Jonathan shows us how to cut and paste on a computer. To do this on a mouse, you will see the left side clicker is the left click and the right is the right click button. To practice, go to a random website and highlight some text, then right click and a drop down menu will appear. Click on "copy". Now, open up a Word program and right click again until you see the drop down menu. Click on "paste" and you will see the text you just copied appear before your eyes! This is a s...
In this video tutorial, viewers learn how to set up Virtual DJ with two separate sound cards. Users may choose to use a proper PCI or USB sound card. Begin by the USB card. The drivers will already be on your system. Now open the Virtual DJ program and open the Settings. In the Sound Setup tab, click on the Output drop-down menu and select HEADPHONES. Next, click on the Sound card drop-down menu and select 2 CARDS. Now click on Apply and OK. This video will benefit those viewers who enjoy mix...
Need to upgrade your bathroom's mirror? Well, first you need to take down the old one! And Eric shows you how it's all done in this video guide from GardenFork. Removing a mirror that's been glued to the wall is tricky, but it's nowhere near impossible to take down. Eric covers the mirror surface with contact paper to prevent broken shards dropping everywhere, then start banging on to break it, so you can take it down in sections safely. Once you get it down, see how to hang the new mirror up...
Learn how to do flat bench dumbbell power press drop set. Presented by Real Jock Gay Fitness Health & Life.
In order to use the bibliography feature in Microsoft Word 2007, you will need to begin by opening your document in Word. Find the place where you would like to add a reference. Place your cursor in that spot. Then, go to the tool bar. Click on "Insert Citation". Click on "Add New Source". When the pop-up opens, enter the information about the periodical or book that you are citing. Fill it in completely. Make sure you choose the type of material you are referencing in the top drop down menu....
This video shows us how to make infant mini clip hair bows.This requires a high temperature hot glue gun.Three ribbons of the length 4",3" and 1.75" are required.Also needed are an alligator clip,sharp scissors and a lighter.Take the ribbons and seal it with a lighter just enough to melt the ends.Insert a 4 inch long ribbon in between prongs of alligator clip.Make sure the ribbon is centered and flat side of alligator clip is down.Quickly fold the ribbon over the top prong and press firmly to...
New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 139th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a data validation list drop-down and the hyperlink function to create a list of links.
New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 94th installment in their series of digital spreadsheet magic tricks, you'll learn how to use and link a currency web query to a data validation cell drop-down list for money conversion.
Save yourself a fortune by making your very own homemade oatmeal facial mask. Place 6 teaspoons of sweet almond oil into a small bowl. Add 2 drops each of pure violet oil, lavender, neroli oil to the bowl. Add enough oatmeal to the mix and make a paste. Pat onto your face and lay down for 20 minutes. Rinse clean with warm water.
This technique drill video shows you how to hit a backhand corner drive in squash. 1. When you're moving into the backhand corner
This is an instructional video of the backhand lob technique in squash. 1. Prepare your racket early to the ball
Apple first added a "Drag and Drop" feature to iPads in iOS 11, but your iPhone can do a little of the magic, too. It's just not so obvious. While you can't drag and drop items from one app to another like you can on an iPad using Split View and Slide Over, you can move things around in certain stock applications. And it works the same whether you're using iOS 11, 12, or 13.
In this video tutorial, viewers learn how to tone and build the back muscles. Expanding the size of the back will help increase the size of the chest. The exercise shown in this video is the lat pull-down. The first part of the movement is to drop the shoulder down and the second is to pull to the chin. All the finger should be one the same side of the bar. Keep your head and chest up. Do not yank or jerk the weight. This video will benefit those viewers who are interested in health and fitne...
In this tutorial, Brian from TruTricks shows us how to delete a cache in a Mac or any Apple computer. This should be performed at least once every week. First, go down to the menu bar and click on "finder". Click on "Macintosh HD", "Library" ant then "Cache". Now, right click on "cache" and then select "delete" from the drop-down menu. Next, click on "users" and then click on your name, then click on "library", "Cache" and right click and select "Delete". Now, go to your trash can and empty y...
Learn how to do alternate dumbbell swims and dumbbell cross punches. Presented by Real Jock Gay Fitness Health & Life.
In this video, we learn how to insulate an attic pull down with Roy Honican. Doing this can help keep your home warmer and more energy efficient. First, measure around the top of the attic so you can build a box that will stand on top of it. To build the box, use foam board that is 1" thick. Cut the size to the sizes you just measured. After this, use foam tape to tape all the pieces together. Once you're done with this, you will have a large box and you will be ready to go back upstairs. Pla...
Learn how to add Google News to your toolbar. - 1st you search for Google Chrome at www.google.com
Retrieve anything you've dropped down the drain with this simple tip. No pipe wrenches or plumbers needed. Family Hack brings you this how to video on unclogging a drain using a vacuum cleaner!
In this episode we cover spry widgets and transitions. Paul Wyatt explains how to use spry widgets in Dreamweaver to customize a drop down menu and create transitional effects without the need for Flash. Learn how to use spry widgets for effects and transitions in this Dreamweaver tutorial.
This video describes the process of tuning the E string on a guitar down to D. The presenter explains this is a great effect for heavy metal and hard rock and makes playing power chords much easier. The method is to listen to the open D string on the guitar and then tune the E string to the same pitch. Since this is the thicker string it will sound one octave lower than the open D string. After the tuning is complete the presenter demonstrates several power chords and how they are much easier...
Mr.G in the episode 3 of "Summer snow fall" explain the experiment for eddy currents and lenz law by using general house hold items like copper tubes of different dia., 2-neo themium magnets attached together and a ball bearing magnet. At first he took the big diameter copper tube and drop the neo-themium magnets, they fall slowly without touching the surface of the copper tube as they are like freely falling from space with less gravity, for the next time he took small diameter copper tube a...
Going, going... gone! Don't let your Windows 7 laptop battery go down on you. With this quick and helpful video, learn how to control your laptop's battery settings via Windows 7's power usage function to ensure you get every last drop of your battery's power.
There's more than enough reason for folks to drink during the holidays. Crazy relatives, too much baking and shopping until you literally drop create lots of stress that one glass of martini usually tapers down.
In this video, you'll learn some neat methods for making hedge trimming an easier chore. Save yourself the back ache and follow the steps in this video. Easier maintenance always begins with the proper tools. Lay down a drop cloth to avoid debris, and make sure you remove wayward branches. Doing the hedge trimming will be a snap from now on!
Lace tights are all the rage right now... Why not get some lessons on how to rock these tights down the street or to your next party with help from this Fashion Elites tutorial. Drop those boring black tights and try something different for a change with lace printed tights!
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 75th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use name, the INDIRECT function and data validation drop-down lists to create DV lists based on DV lists.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 43rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn use a data validation drop-down list to change conditional formatting in a table. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 324th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic list of dates for a data validation drop-down list.
