This video tutorial belongs to the software category which is going to show you how to merge & center a cell in Microsoft Excel. Highlight the area that you want to merge. Press the "Merge and Center" button located in the tool bar at the top. The cell will be merged. Then, type in what you want to type and click on the cell that you merged. Right click on it. Next, select "Format Cells" and click on "Alignment" tab. Click on the drop box, select "Center" and click OK. Your text inside the me...
In this video, we learn how to train legs to avoid failure using post exhaust training. First you will do a hack squat, which is where you will hold dumbbells and place your heels on a step, then squat down through the heels. Keep your chest up while doing this and you will work your butt, hamstrings and lower back. The next exercise you can do is a front lunge, which includes you lunging to make a 90 degree angle alternating between legs. The last exercise you can do is to hold a bar and squ...
In this tutorial, we learn how to link two workbooks and cells in Excel. First, save both of the files that you want to link together. Make sure you only have one Excel window open, then double click the other Excel file, don't open separately. Next, type in the equals sign into the "A" column, then to go the window menu and you will be able to see all the Excel files currently open. Now, click "link" and you will be taken back to the original worksheet. Now, you will be linked to the other n...
In this tutorial, we learn how to begin a new project in MS Project 2007. First go to your start menu, then click on "Project 2007". When this opens, you will see a panel on the left hand side, which is a project guide. Once you are in this project, you can open up a stored one that you were previously working on, or continue with a new one. You will have different task bars that correspond to the information you type in. Click on each individual task to see the information for each one. Ente...
In this tutorial, we learn how to fix security mode for nds Wi-Fi. First, open the command prompt in Windows. Next, type in "ipconfig/all" in the black window that appears. After this, copy your default IP the screen just gave you, then type it into your address bar online. After this, you will be able to log into your security account and make default changes you prefer. Change different station accesses and any other security preferences you want to change. After this, you can change your p...
In this Food video tutorial you will learn how to make hazelnut chocolate chip cookies. First you got to toast the hazelnuts by popping them in the oven for about ten minutes. Now take toffee bars and chop them in to small pieces. Pre-heat your oven to 325 degrees. Assemble all the dry parts. First take the chopped oats, add corn powder, salt and baking soda and blend them together. Pour sugar and brown sugar in to the blender add some butter and blend. Now add a few eggs and vanilla extract ...
In this video tutorial, viewers learn how to find their I.P address in Windows 7 and Vista. Begin by clicking on the Start menu. Then type "cmd" into the search bar and press Enter. When the command prompt window opens, type in "ipconfig" and press the Enter button. Now search through the list and find a line that says "I.P address" or "IPv4 address". The numbers will be divided by periods. Another way is to open Control Panel and select Network and Sharing Center. Then click on your local ar...
In this tutorial, we learn how to increase your Wi-Fi signal with a coffee can. Materials you will need are : a knife, a coffee can, tape, USB Wi-Fi adapter, and marker. First, measure 1 inch from the bottom of the coffee can then trace your USB around that mark. Now, cut a hole in that shape in the can. Next, cover the hole with your tape. Next, hook your USB up to your cable adapter, and then place it in the coffee can. Now, plug your USB into your computer and you should have more signals ...
In order to get add-ons and plug-ins for Google Chrome, you to go to Chrome Plugins. Type the address into your browser. Then, press Enter. Scroll down the list. Choose and add-on that you want: for example, Click & Clean. Click on the one that you would like to choose. Find "Download Latest Version" and click on it. Wait for it to download and click on it. There are lots of options. Click & Clean allows you to clean your browser with only one click. Session Save allows you to save the sessio...
In this video tutorial, viewers learn how to type in special characters. Begin by opening System Preferences and select International under Personal. Then click on the Input Menu tab and check Character Palette and Keyboard Viewer. Now check "Show input menu in menu bar" and click OK. Then click on the flag icon on the top of the screen and select Show Keyboard Viewer. This will allow users to type or mimic the actions of the keyboard. Users are also able to change the character by selecting ...
In this video tutorial, viewers learn how to get a six icon row on an iPod Touch or iPhone. Users will need to have their device jail-broken. Begin by opening the Cydia application and click on the Search icon. Type "Six" into the search bar. Then scroll down the list and select the Six Rows tweak. Now click on Install and click on Confirm to continue. When it has finished downloading, click on Restart Springboard and wait for the device to reboot. This video will benefit those viewers who ha...
This video tutorial is in the Software category which will show you how to insert clip art with Microsoft Office Word 2007. Open a word document and click on 'insert' tab on the navigation bar and then click on 'clip art'. The task pane will show up on the right side of the page. Here you type in the subject of the clip art you are looking for in the 'search for' box. For example, type in 'tiger' and then click 'Go'. A list of images is displayed. Click on the one you like and it will be disp...
In this video tutorial, viewers learn how to reboot their tethered jail-broken iPod Touch or iPhone. Begin by opening the jail-broken application and click on Search Then type "summer-board" into the search bar and select the Winter-Board application. Now click on Install and Confirm to continue. When the reboot window opens, click on OK. Then connect the device to your computer and redo the jail-breaking process. This video will benefit those viewers who have a jail-broken iPod device, and w...
In this Software video tutorial you will learn how to use tool shortcuts in Final Cut Pro. To change opacity and the volume limit, click the little mountain button on the bottom and you will have two lines in the clip representing audio lines of two mono tracks. And you also have opacity located above the audio lines. With the help of the slide bar you can set the opacity. To get the pen tool press 'P'. To get out of any tool, press 'A'. To delete the entire audio track, select it, lock, dele...
This quick clip demonstrates how to use the toolbar feature in QuicKeys to automate menu bar items in an application. QuicKeys toolbars are a great way to add more functionality to an application. Whether you're new to Startly Software's popular macro and automation application or are merely looking to pick up a few new tips and tricks, you're certain to be well served by this free video software tutorial. For more information, including detailed, step-by-step instructions, watch this video g...
In this software video tutorial you will learn how to use Form Tracker in Adobe Acrobat 9 Pro. The forms tracker window can be opened by clicking on the 'forms' on the toolbar, or 'forms' in the menu bar or, if Acrobat is not open, by double clicking on the notification button in the tray. Here you are taken to the latest update category. On the left hand side, you will find the response file location. Check its status; whether it is active or not by clicking on 'view responses'. This will gi...
In this video tutorial, viewers learn how to mix beats as a DJ. When beat matching, a DJ usually uses headphones. Start by just listening to one song. Figure out where the beat of the song is and find the first beat of the bar (the beat count). To sync the two songs together, adjust the pitch controller. Some pitch controllers have a high pitch range than others. When the beats are properly mixed, it should sound like one complete song, almost like a remix version. This video will benefit tho...
If you've ever suffered from acne you've probably also suffered from choosing an acne product that actually works. Some cleansers and moisturizers are too drying, others are harsh and stinging, and some feel good on skin but just don't work. But if you've ever stumbled upon tea tree oil, then you know that this natural oil both moisturizes and helps relieve acne with no unpleasant side effects.
If you're a frequent visitor at a local sports bar and restaurant, you've had to have been introduced to those little bite size pieces known as jalapeno poppers. These tasty treats contain jalapeno, cream cheese, and sometimes others ingredients and are the perfect finger food when watching any sporting event. Well in this tutorial, you'll be finding out how to make your own jalapeno poppers, but in pizza form. Sure, it may not be small, but you'll have more ingredients to enjoy and with the ...
If you're a beginner bass player, sometimes the best way to learn is to watch others play. Also, learning from books and virtual bass websites can be frustrating and confusing, but this video makes it all simple. It's a beginner bass lesson for "Tush" from ZZ Top. It's basically a 12-bar blues, and there are 2 different bass lines to this format— either the verse or what's played under the guitar solo.
Carrie Bradshaw of Sex and the City never looks anything but flawless. No matter where she is - whether it be the middle of the dessert on a camel or the middle of Manhattan on a bar stool - Carrie always brings style.
If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 49th installment in his "Excel Statistics" series of free video lessons, you'll learn how to find outliers with the +/- 3 Z-score rule and the ABS function. See how to do a box plot by hand and in Excel. For th...
If you're a novice looking to learn how to use Microsoft Excel, a video series from digital spreadsheet guru ExcelIsFun is a great place to start. But which of his many series should you choose? The one titled "Excel Basics," that's which! This free video MS Excel lesson, the very installment in said tutorial series, covers the following topics:
In this how to video, you will learn how to load a kayak on a vehicle. Doing this properly will mean both the kayak and vehicle are safe. A simple upright system is fine for your kayak. You want to look for J and V bars with padding to transport your kayak. To lift the kayak on to the roof, first check to make sure the straps are working. Hold the kayak with both hands and a straight back with your knees. Lay the kayak in a strong position on its side. Secure the kayak with the straps. Thread...
Just because you are not at home is no reason to abandon your healthy eating lifestyle. In this tutorial, you will learn all about planning healthy meals and snacks while you are on the go. Discover how to pack your backpack with the right, lightweight snacks and maintain proper nutrition when out and about. Of course, when planning caloric intake and healthy eating for a backpacking trip, it's important to create a backup plan in case something doesn't go according to plan. Learn about carry...
This video shows us the method to use Blackberry email more effectively. Firstly, let us go to the place for typing your emails. Click on the leftmost icon at the bottom of the home screen. Now press the button on the left side of the track ball and choose 'Compose Email'. Now, if you want to enter your phone number in the body of the email, type in 'Mynumber' and then the press the space bar. You will now see your mobile number in the body of the email. Enter 'Mypin' for displaying your Blac...
This video illustrate us how to use automatic word completion in pages'09.Here are the following steps:
In this how to video, you will learn how to convert a flash video to an AVI file. First, download the Pazera Converter program. Open the program. At the left hand corner, click add files and find your flv file. Next, select and open it. Once it is imported, go to output directory and choose which folder you want the new file to be placed. Go to output file format and click AVI. You can also choose MPG instead if you want. Now click the convert button at the top. You will see a progress bar. O...
Insert DVD containing Mac OS software into system drive. Reboot system. Confirm installation and agree with license. When prompted to select drive, select disk utility from menu bar. Select hard drive and click on erase button. Select Mac OS extended file system. Confirm erasing all data. Once drive formatted, close disk utility. Select to install in hard drive that was erased. After installation completes and system reboots, select Language and Keyboard for your country. When asked if alread...
This video shows how to secure a wirelees internet connection on your Zyxel P-660hw-t1. For this, first click on Start button and open Internet Explorer(or any other browser). On the address bar of the browser, type in the IP address of your router. On the next page, enter your password and on the next page, either change the password or ignore. On the next webpage, under Advance setup, click on Wireless LAN. On the next page, click on 8021xWPA. Select authentication required and then click a...
In this Fitness video tutorial you will learn how to get lower abs with a hanging knee raise. This video is from www.fitwithmitch.com and here Mitch explains how to do the hanging knee raise and a few variations to this routine. Hang from the overhead bars, bend your knees and curl up from the waist till the thighs are horizontal. Do this as many times as is comfortable for you. Make sure while doing this your body should not swing. If the body starts to swing, stop and restart. As a variatio...
This videos is a tutorial for using custom FBML coding on facebook fan page.The video begins by logging into facebook account.Then go to the search bar at the upper right hand corner and tpe "static fbml" and hit enter.This takes to the application page and click on "add to my page" below the default fbml picture.A window opens up showing a list of user pages and after selecting the page click on "add to page".Close the window and go to your fan page and click on "edit page".This shows a list...
In this video, we learn how to use PhotoShop to change hair color.. First, select the mask tool inside PhotoShop. Now, zoom in on your picture and brush the hair that you want to change the color of. Zooming in and using smaller or bigger brushes will help you be more precise. After this, zoom out and press on the mask tool to create your selection. Then, select the marquee tool and right click and choose "inverse selects". Now, click on "image", "regulations", then "tonality/saturation". Now...
In this Electronics video tutorial you will learn how to multi task on your Blackberry. This video is from www.myblackberrytv.com. From the home screen, while holding down the Alt key, press the back key. Each time the back key is pressed, a different item will be selected on the top bar. All the icons represent the entire range of applications that are open on the blackberry. Select the ‘map’ application. Once you finish with the map application, you can switch back to the home screen by...
Ever had router trouble? Got router trouble? Well don,t worry the people over from quickcert.com have made this video to help! More specifically a linksys 802.11g router. All new routers come with a standard Ethernet cable, which must be plugged into one of the four ports on the router and connected to your computer as well. This is necessary to change settings, using Microsoft IE (internet explorer) when the routers IP is typed into the address bar. It is strong recommended to change the def...
In this video tutorial, viewers learn how to use the full screen view in Apple's Pages. To enter the full screen view, click on the the Full Screen button on the toolbar or click on View and select Enter Full Screen. Users will only be able to see the document on the screen without the tool bars and desktop. If you hover your cursor over to the left side of the screen, you will be able to see the total number of pages in the document. This video will benefit those viewers who use a Mac comput...
In this video tutorial, viewers learn how to use the on-screen keyboard on a Mac OS X computer. To turn on the keyboard viewer, go to Apple and select System Preferences. Under Personal, click on Language & Text. Click on the Input Sources tab and check Keyboard & Character Viewer. The viewer will appear as an icon in the status bar. Click on the icon and select Show Keyboard Viewer. Now place the cursor where you want to start typing and use the onscreen keyboard to type. This video will ben...
In order to transfer files from your iPhone to your mac or pc, you're going to need a little something from www.digidna.net. Open up your web browser and type that into the address bar, here look for DiskAid. Download the version of DiskAid that corresponds to what you want, whether it be for a PC or a Mac. When you've downloaded it, it is time to install it. Once the program is up and running you'll be able to transfer different files like photos and videos from your iPhone or if you wish yo...
In this video, we learn how to make objects transparent in Flash. First, open your object up and convert it to a symbol in Flash. It doesn't matter if it's a graphic or movie clip, just make sure it's a symbol. Next, click on the symbol you just created and go to "properties". Find the section called "color effect" then find the drop down menu. You will see several options, choose "Alpha". Once you do this, you will have the ability to tweak how transparent you want your object to be. Use the...
In this tutorial, Barefoot Contessa shows us how to make chocolate truffles at home. First, take a 1/2 cup of heavy cream and heat it up in a saucepan. Now, chop up bars of semi-sweet and bitter sweet chocolate (6 oz together) and put into a mixing bowl. Now, pour your warm cream into a strainer onto the chocolate. Stir the mixture until the chocolate melts the chocolate all the way. Now, add 1 1/2 tbsp of Frangelico liquer, 1 tbsp coffee and 1/2 tsp vanilla extract and stir. Chill this for a...
