Mike Callahan with Butterscotch demonstrates how to work with tables in MS Word 2007. Tables are useful for creating information charts and address lists. First, open up Microsoft Word. To create a table, click on the insert tab on the top tool bar. Highlight the elements that you would like to appear in the table by selecting the desired number of columns and rows. Pressing enter inside of a table, it will increase the side of the cell all the way across the table. It will not just increase ...
Teach Excel demonstrates how to make an Excel dynamic named range across multiple rows. Highlight the cells that you want to include in your named range and give it a name. You can then use that name in formulas. But it's not a dynamic named range so it won't account for added information. Ctrl + F3 is the name manager shortcut and the F3 is the paste name shortcut. Use the name manager and highlight the named range. Delete the absolute cell references and type in offset. Then, select the fir...
1.Here 10-50 and 300-400 numbers are taken for example to generate the random numbers within the limit in Excel. We using the command of "randbetween" for generate the random numbers and we won't get the decimal or fraction values.2.Now type "=randbetween(10,50)" which means to generate the random value between the bottom value of 10 and top value of 50 and click enter now we will get 11 as random generated number.3.Do the same thing for 300-400 as "=randbetween(300-400)".You will the 303 wil...
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this tutorial from ExcelIsFun, the 474th installment in their series of digital spreadsheet magic tricks, you'll learn how to conditionally highlight every last value in a data set or each value which differs from the value preceding it.
In this video Tara Stiles gives an introduction to basic meditation. Meditation can be done while doing the physical yoga poses, or really any time when you have a few moments. Even while you are in line at the grocery store you can practice simple meditation by bringing your attention to your breath. Observe your thoughts and focus on breathing in and out. The intent is to bring yourself back to yourself. Tara leads a guided meditation which begins by encouraging the listener to find a comfo...
You can add full iso roms on your PSP to play on the go, for free! This video will demonstrate exactly how to download and enter full free PSP games onto our handheld.
Open Microsoft Office Excel. Across the top notice letters (columns), along the sides are numbers (rows). The columns and rows can be extended by highlighting sections and right clicking and choosing the high of the row. You can also select to add a border, and change the orientation of your cells.
In this video about choosing a web hosting company. The narrator begins by saying that web pages are hosted on servers; the files that make up a web site are hosted or stored on a server. The narrator recommends a service called Host Gator. He indicated they are reliable and provide reasonably priced web hosting services. He briefly discusses the process they charge for their different levels of hosting services. Next he shows the steps to hook your domain name to the host account. He demonst...
In this video tutorial, viewers learn how to make a batch render in Sony Vegas. Sony Vegas is a professional non-linear editing system. Viewers will learn how to use the batch render. At default, it is located on the toolbar. Begin by importing your clips or images into the time line. One of the batch render's features is to render regions. Begin putting regions around the clips by highlighting the clip, press R and press Enter. The add the Add Regions To Event script to automatically set reg...
This is a video about "How to Hack: Demolition City 2" by Travis. This is a flash game. To begin hacking, go to the game and enter the first level. At this point, you do not have any cash. Specify that you are using Mozilla in the cheat engine. After you have completed the first level, write "double" variable in value type and then type the value for the first level, and you can easily notice the game appearance seems to be changed, because the second level of the game consists of first level...
Ever have the problem of people messing with your word documents? This guy shows you the solution by telling you how to create password protected encrypted word documents. The process starts with your open file. Clicking on save as... and in the popup window clicking the tools button in the bottom left corner and clicking general options. There it shows you text entry boxes, one for setting a password to open the file, another to set a password for rights to modify the file. Enter your passwo...
Follow along as we are shown how to set a password for a new user in Windows 7. -First, go to the Start menu.
The video shows how to join a home group on a Windows 7 network by helves shows you how to join a home group on a Windows 7 network of computers. It is approximately one minute thirty seconds long. To join a home group on a Windows 7 network you first go to control panel, then you click on Network and Internet, after that you click on network and sharing center, and finally click join a home group in the top right. You now select what file types you want to share with the other Windows 7 comp...
In this video the instructor shows how to create charts and graphs in Microsoft Word. First, open the Word document and select an area to insert the charts. Now go to the Insert tab in the ribbon and select the Chart icon. The Insert Chart window opens up with various chart templates. There are various categories of charts like Line, Pie, Bar in the left hand side. In the right hand side you can see the sample charts available and you can select any of them that you want. Now it transfers you...
Here you will see how to add a contact to the address book of a Nokia N97. Follow these steps to add a contact to your Nokia M97's address book: From the home screen, tap the "Contacts" icon and then tap "Add New Contact". Enter in the contact information and tap "Done". Tap "Exit" to return to the home screen. To set a contact as one of your favorite contacts, tap "Add to Favorites", and select the contact you wish to add as a favorite. Tap "OK" You can also do things such as add a called ID...
Dana Strauss from Best Buy teaches you how to download Google Maps onto your Blackberry. Press your Menu button, click on "Applications". Find "Maps" and click on it and your Blackberry will pull up Google Maps for you. The application will show you exactly where you are and will allow you to enter the address of your destination. It will also give you exact directions to where you're going.
In this video by Task Tutorial we will learn how to create a simple flash button with sound. The first step is to create a text layer in flash, then convert your text into a button, then double click on the button to enter a sub menu and create a new layer for sound. Then simply add some sound files from your library and assign the sound file. Now you can change the color so you can see when the button is pressed. Then finally go back to your main scene and test your Flash movie. Using these ...
To multiply and divide the two fractions is a single step problems. Just multiply both the numerators and denominator for obtaining multiplication of two fractions, and for the division just multiply numerator of first fraction with denominator of second fraction and keep it in numerator place, and for the denominator place you just multiply the denominator of first fraction with numerator of second fraction.
clipping mask Sponsored by SimpleRetouch.com Start by creating a task with the name Mask, then Choose a color and a font size.
Wondering how to find the Internet Protocol address of a website?
Learn how to watch TV on your computer with Firefox add-on. * Note: You must have a version of Firefox that is older than 3.5.
Instructional video of Buttonwillow Raceway in a stock RSX type S race car. This is on a clockwise track configuration. This Buttonwillow Raceway video shows you how to handle the turns and race the track well. They describe the pit lane as well as the protocol of leaving the pit. Stay on the left hand side when you enter. There are several 90 degree turns.
Use the Excel Vlookup function in Microsoft Excel 2007 to look up data in a table. This tutorial looks up the level and value of a product from a stock list using the Vlookup function in Excel.
Hack the hex code in Bejeweled Blitz for a higher score! Everyone wants the top score in this popular web game, but it all comes down to how you get it. Do you have what it takes to come out on top? Check out this video tutorial to learn how to hack Bejeweled Blitz (07/24/10).
This video tutorial belongs to the software category which is going to show you how to convert a Word document to a password protected PDF file with NovaPDF. Go to NovaPDF and download the program and install it. It is a paid program. Select the word document that you want to convert and select print option. Under the name of the printer you will find novaPDF option. Select this and click 'preferences'. Now click on 'security' and select high level encryption. In the document permissions, sel...
This video demonstrates how to use a Nikon SD-80 Battery Pack with a Nikon SB-800 Speedlight. The first step is to identify the different power adaptors on the ends of the cable leading to the battery pack. This pack is powered with AA batteries. Remove the outlet plate on the SD-80 and insert the power cable into the SB-800 Speedlight. Then attach the communication cord to the Speedlight. Now place the Speedlight in the hotshoe of the Nikon camera and let the battery pack dangle or attach it...
Learn how to set up an Epson printer wirelessly when you bring your new printer home you will want to start by installing the software that came with the new printer. You can set up your printer to work without wires and it will print from all over the house. There are 3 ways to set up the printer including the Epson way, with cables, and WPS. To determine is you need to use WPS, which is more complex, check your router to see if it has a sticker on it that says Wi-Fi Protected Setup. If that...
There are many functions in Microsoft Excel. One function that people rarely use is the Repeat function or REPT. In this video, an example used is a chart of people and their sales of a certain item. Just looking at the numbers, it is hard to compare the different sales easily, but a more visual approach may work better. Next to one of the cells, type in "=REPT(" which is the repeat function. A popup should say "=REPT(text, numbertimes)". For "text", type in *** or anything, really. For "numb...
The passcode, or the four-digit code you enter in order to access an iPhone or iPod touch, was created to ensure security and prevent hacking. But what if you haven't touched your iPhone in a month and you simply don't remember what your passcode is anymore?
Need to browse the web on your new Samsung Galaxy Tab? Well, first you're going to have to set up Wi-Fi on the Android device. This video shows you the complete steps to getting connected! Press MENU < SETTINGS < WIRELESS & NETWORKS < WI-FI SETTINGS and then select WI-FI to turn in on. Next, choose your network, enter the password and press CONNECT. It's that easy.
The first step to create a fax using Outlook 2003 and 2003 server. Using add/remove windows component make sure your fax equipment is properly installed. Under the start menu select the printers and fax option and select the share option. Then under administrator tools/users/new/users/fax to enter your password to turn our fax information transfer on. You must now select fax user and select advanced settings and double check to make sure the fax is able to see the object it needs to send the ...
In this video from sjsharksiPodtouch we learn how to jailbreak your iPhone 3Gs with firmware 3.0 using a Windows machine. With your iPhone plugged it, download the PurpleRa1n file and click make it rain. Then your iPhone will enter into recovery mode. You'll see the PurpleRa1n logo on your iPhone and then it will reboot. Tap the Freeze app, and tap Install Cydia. Once finished, exit and then reboot your iPhone. Now Cydia is fully installed. You will get a message on your iPhone saying Reorgan...
In this video, we learn how to install Windows 7 on your computer. First, place the disk inside your computer and start the installation process. Setup will start, then it will start to copy files, expand files, install features, install updates, and then complete. As it runs through each of these, it will show you a percentage of how far through the process it is. Once it has finished installing, you will be able to set up your user account. After this, you will need to enter in the product ...
In this tutorial, we learn how to password protect your folders on a Mac computer. First, use the spotlight tool to type in "disk" and then click on disk utility on the drop down menu. From here, go to the save as menu and enter in the name for the volume. After this, change the size of the desktop and change the encryption choice. Use the one that is recommended and then click on 'ok'. Form here you will be asked for a password, then you will need to verify that password. From here, click on...
In this tutorial, we learn how to password protect a folder on Windows Vista. To do this, you will first need to have WinRAR downloaded on your computer, you can get it here: http://download.cnet.com/WinRAR-32-bit/3000-2250_4-10007677.html. Next, you will right click on your screen and click "new" and "folder". Then, you will rename your folder to anything you'd like. From here, you will right click and then click "add to archive". Then, go to advanced and set password from the toolbar. Enter...
In this video, we learn how to partition a hard drive in Windows Vista. First, go to your desktop and run computer management. From here, go to disk management underneath the storage section. After this, right click on the D drive and then choose "shrink volume". Now you will see a new window appear with different options on what to shrink the volume to. Enter in the number, then click on the "shrink" button. After this, your partition will be finished on your hard drive. This will help you b...
In this video, we learn how to apply normal maps in 3D Studio Max. First, go to the cylinder button and name it. Then, change the radius and height how you would like them. After this, select "extended primitives" from the drop down menu on the top. From here, enter in the diameter and sides for the round hose and then select the diameter of the cylinder. This will create a cylinder but with the look of a hose instead. Use the bottom toolbar to edit the sizes of the map and then save this whe...
This video tutorial is in the Electronics category which will show you how to unlock your iPhone 3G on jailbroken firmware 3.0. By unlocking your iPhone you can use any GSM Sim carrier in your phone. For example, if you have an AT&T iPhone and you put a ROGERS Sim card from Canada, your iPhone will not accept it because it is LOCKED at AT&T. This is a software to unlock iPhones. Before you can unlock, your iPhone must be jailbroken. Open Cydia and hit manage. Then hit sources. Now select edit...
In this video, we learn how to play a match play challenge game in World Golf Tour. This is where you can challenge other players and earn credits from the other player. Play players that are in the same tier or have similar skill level. To play, select the match play challenge option from the main menu. From the game lobby, select the play for credits option and enter in the minimum or what amount you'd like. From here, click "submit" and then start to play your game. As soon as you finish y...
In this tutorial, we learn how to make Google go bananas. First, go to Google and search for "how to make Google go crazy". Once you type this in, click on the first link that you see. Now, you will be presented with a page that has instructions. Follow the instructions that are listed on this website. Once you finish and hit "enter" you will start to see Google go crazy on you! This is a cool way to have fun with your computer and also it's a great trick to show your friends. Have fun with t...
