In this video, we learn how to learn keyboard shortcuts in MS Excel 2007. First, hit the "alt" key and then you will see numbers and letters at the top of the screen. Now you will see all of the pages of the keyboard shortcuts. Go to the page layout tab and hit "p". Now, you will get the keyboard shortcuts for everything on the page layout tab. Continue to do this on all the different tabs for this and you will be able to memorize the ones you use most, so you can more easily navigate MS Exce...
In order to format graphs and charts using Microsoft Word 2007, click on Chart Tools. The tabs at the top of the screen provides you with your options. You can change the type of chart or graph by clicking on Change Chart Type. If there is a particular type of chart that you would like to use again and again, then you can save it as a template via the Save As a Template icon. You can edit the data in your chart of graph by clicking on Edit Data. You can modify the chart layout by clicking on ...
If you find yourself recharging your HTC EVO from Sprint more than once a day, you might find these tips from CNET more than helpful. In this video, CNET shows you how to maximize the battery life on your HTC EVO running the Android software. These tips can also be applied other smartphones running Android. Basically, you just need to stop programs from running constantly, like WiFi, Bluetooth, and GPS. And dropping the screen brightness can help, too. See all the tips to a bigger and better ...
In this video tutorial, viewers learn how to use the Nokia N97 phone. The power button is located on the top of the phone to turn on/off the device. The menu key will open a list of applications for use. The call key will allow the users to make a phone call. The end key will bring the user to a previous screen or end a call. There is a headphone jack at the top of the device. One the side there is a Micro connector, and lock key. This video will benefit those viewers who are just using the N...
Alex shows us how to make a duct tape iPod holder in this tutorial. This will prevent damage and is also waterproof! You will first wrap four piece of duct tape around your iPod with the non-sticky side first. Stick one piece on top of each other so it covers the iPod completely. Don't make it to tight. Next, use the sticky side to tape the last two pieces onto the other pieces of tape. When finished, you will have a unique iPod holder that protects your iPod and is a cheap alternative to cos...
In this tutorial, we learn how to use card view on the Palm Pre. To use this feature, you want to flick up or press the center button on the phone. After you do this you can move between cards by sweeping left to right. Maximize an application by flicking down and return to card view by pressing on the center button again. To reduce the size of cards, tap while holding the screen. To reorder the cards, drag them to different destinations along the card line up. doing this will help you work y...
One of the few technical advantage the Nintendo Wii has against its high-tech rival the XBox 360 is that it allows users to browse the web on their console. Trying to do so using only a Wiimote, however, is impractical. Did you know that you could use a USB keyboard instead? This video will show you how to connect a USB keyboard to your Wii, making it MUCH easier and more practical to use the Opera web browser available in the Wii Store. Now can surf the web on a giant screen while reclined o...
In this video, we learn how to create a free flash website using Wix. First, log online and go to "www.wix.com" and either create a screen name or log into your account. Now, click on "create" and choose a premade template or make one from scratch. Now, change the background to a color you prefer, then add in a frame and different media to your page. You can also add a title to the website by clicking on the "text" section. You can play around with the different effects and additions, making ...
In this video, Paul Louis, a professional puppeteer and puppet builder discusses the difference between puppets intended for theater and television and how they are different both in appearance and operation. For a puppet on stage, stitching is acceptable to be seen on the outside of the puppet and large, exaggerated movements for the puppet are acceptable and encouraged for easier viewing by your audience. For a puppet which is shown on a television shown, the puppet should be cleaner and th...
Some people like their screens to be dim while others like theirs to be bright. Some like brightness to automatically adjust, while others like a constant level. One of the salient advantages of a Google Android smartphone over, say, an Apple iPhone, is the inherent extendibility of the open-source Android mobile OS. There are a seemingly infinite number of settings to tweak and advanced features to discover and use. This free video tutorial will show you how to adjust the brightness of the d...
In this how-to video, you will learn now to dismantle an iPod Nano 3rd Generation. First, run a plastic tool on both sides of the device. Once this is done, remove the back cover with your fingers. Next, unscrew the six screws on the circuit board. Store them in a place where they will not be lost. Next, remove the click wheel ribbon cable from the jaw connector. Lift the jaw connector with the tool and use a pair of tweezers to gently remove the cable from the jaw. Next, remove the small met...
Magicinwords teaches viewers how to change their facebook network! First, you will want to log onto Facebook.com. When signed in, go to the settings tab on the right of the screen. Under this, click on 'account settings'. Under account settings choose the tab that reads 'networks'. Here, you can click 'change your region' and then you can update it. Be sure this is right though, you can only change your regional network twice every 60 days. Under this same tab, you can also join any other net...
In this Electronics video tutorial you will learn how to Email photos from your iPhone. This is really very easy and simple to do and takes practically no time. On your iPhone go to the camera icon and tap on it. Then find a picture that you want to email. Then tap on the little icon on the lower left of the screen as shown in the video and then select email photo. Then you put in you want to send the photo to, type in a subject and add some text if you want. And the final step is to tap ‘s...
In this video tutorial. viewers learn how to change the size of text and icons in a Windows 7 computer. Begin by clicking on the Start menu and open Control Panel. In the Control Panel window, click on Appearance and Personalization. Then click on Display. Now users are able to select the size of text and icons to Smaller - 100%(default), Medium - 125% and Larger - 150%. If users select one of the larger sizes, some of the items will not fit on the screen. Once users have select the setting, ...
This video illustrate us how to build a drip irrigation system. Here are the following steps: 1. To build a drip irrigation system you need a pipe, hydro cyclone, screen filter, Pressure building pump and micro filter.step 2: Connect the pipe to the water source and let it pass through the hydro cyclone to settle down all the sand. 3: Now from the hydro cyclone pass it through the pressure gauge for building up the pressure ant then this pipe passes through the network of horizontal and verti...
The instructor of this video shows you how to completely hide the ribbon, or the menu, in Excel. If you only want to partially hide the ribbon, you can use the shortcut control + F1. To completely hide the ribbon, though, go to the Visual Basic screen, hit Alt + F11. Then, go to insert, then module, and type in the macro "sub (Your name for macro)" then hit enter, then type in the code "application.executeExcel4macro''show.toolbar(""Ribbon"", false)''". To set up the code to show the ribbon a...
This video tutorial will teach you how to use the onscreen keyboard on the HP touch smart. Very informative video that goes through several steps including teaching you how to add an event to your calendar. It starts by showing you how to add the event and then takes you through the keyboard and teaches you how to capitalize your words using the shift key as well as caps key. It demonstrates the input panel tab and how to move your panel as well, teaching you all the techniques for good use o...
This is a "Southwest Yard and Garden" episode that details the proper selection of gardening tools for fighting seasonal weeds. Horticulturist and host Curtis Smith takes us to meet with Ron Jobe, an Albuquerque Master Gardener, to discuss the options available for such a task. Ron covers the various conditions a gardener is faced with, including the soil and the weeds themselves. Some suggested tools are: the Wing Hoe, Skimming Hoe, Raker, Pointed Hoe, and Stirrup Hoe. The use of each is off...
In this video tutorial, viewers learn how to change the lock pattern on an Android phone. The lock pattern allows minimum security on the phone to prevent other people from tampering with your mobile files. Begin by going into the Settings and click on Location & security. Under Screen unlock pattern, select Change unlock pattern. In order to change the unlock pattern, users will have to type in the current unlock pattern. Now type in the new unlock pattern and press Continue. Then retype the...
In this video we learn how to use the AutoCorrect function found in Microsoft Excel 2007. This video is the second part of the Microsoft Excel 2007 tips series. The video shows on screen and the host explains how to find the AutoCorrect function and gives an address to download the example spreadsheet from their TeachExcel website. AutoCorrect is a nice function but it is not personalized, and if you often misspell a word it can be handy to add it to AutoCorrect to catch it every time. Unlike...
This video by Butterscotch shows viewers how to uninstall a program in Windows 7. To begin, click on the start button at the bottom-left of the screen. Click 'Control Panel' in the boxes that pop up. Click 'System and Security'. On the left side of the window, there will be a link marked 'Programs'. Click on it. Click 'Uninstall a program' beneath the 'Programs and Features' heading. Highlight the program you want to uninstall, then click the 'Uninstall/Change' button near the top of the wind...
The speaker in this video will show you how to find basic computer information of your computer. In this video, he is using a computer with Windows XP. You begin by clicking on the "start" button located at the bottom left corner of the screen, then highlight "settings", and then click on "control panel". A window will then pop up. Double click on the icon labeled "system". Under the general tab, the basic computer information for your computer will show up. You will see various information s...
In this video, it is demonstrated how to get rid of a "FEE" error message on a Nikon DSLR camera. The solution is fairly simple and quick to do. First you will want to turn your camera on to where you see the "FEE" error message on the LCD screen. Next, you will set the camera's aperture ring to the highest number available. After this, the last step is to lock the aperture ring by using the switch. After doing this step, your camera should return back to normal working order and the "FEE" er...
In this video tutorial, viewers learn how to install the Installous application for the iPhone or iPod Touch. Users will need to have their iPod device jailbroken before installing. Begin by opening Cydia and select manage. Click sources and select edit. Add this source: Select your new source (Hackulo.us) and install AppSync for your device's firmware, Then install Installous. Return to your home screen and run your new application (Installous. Now users are able ...
In this Software video tutorial you will learn how to make a book cover in Photoshop. Go to file -> new. Give it a name, set width 900, height 1200 and resolution 300 and click OK. You can change these settings if you like. Go to your paint bucket tool and paint the background black. Then go to layer -> new ->new layer -> OK. Now select the elliptical marquee tool and holding ‘shift’ drag from the top left hand corner and make a circle. Go to your paint bucket tool and paint the circle with a...
Adding domains to your GoDaddy hosting plan can be done by following the steps Ken Applebee outlines in this video tutorial. Once at the GoDaddy main home page, click on My Hosting Account under the Hosting tab at the top of the screen. Log in and go to your account with the hosting on it. Click on Your Domains and you will see your domain in there. On the right side you can choose to add a subdomain or you can just click on the Add Domain tab for a completely separate domain. This allows vis...
In this video the instructor shows how to change views in Microsoft word 2007 and navigate around the documents. In Microsoft word 2007 in the ribbon there is a view tab to the extreme right. Open the tab. Now in that bar the default layout selected is the Print Layout which is 'What you see is what you get' layout. Next to it the full screen reading option and clicking on it, the documents opens up as a two page book with all the other tool bars hidden. The next is web layout which is ideal ...
Classroomnext describes how to create a Google form with your own custom colors and designs to give it a personal touch. Once you are logged into the Google Docs main screen, click on the button that says "New" and choose the option "Form" from the dropdown menu. Once your new form appears onscreen, type in a simple test name in the title field and a placeholder question. Save the document. Click on the button that says "Theme" and you will be shown a variety of styles to choose from. Save th...
This video shows you how easy and convenient it is to use the Office clipboard in MS Word 2007. Go to the "Home" tab. Then click on the little
This video shows you how to use Window Defender on your computer. Go to the start button on the screen and click it. Next, select the control panel. At this point you can type in the word ‘Defender’ or find the icon in the control panel. Once the Windows Defender page comes up you should be able to see whether or not the program is active. If it isn’t active then simply activate it. This program should be run because it helps protect you against spyware and other unwanted activity on your com...
This is a video from HelpVids.com that discusses how to set and adjust tab stops and indents in Microsoft Word 2007. The video starts off with a Word 2007 document open on the screen. First the presenter shows how to show and hide the rulers. This is accomplished by clicking on a small icon above the vertical scroll bar. Tab Stops are only applied to text that has been selected and not the entire document (unless you select the entire document). The sliders on the ruler control the amount of ...
You can customize and select your preferred monitor settings to improve the clarity of your monitor display. First open the start menu and go to the Control panel. In the Control Panel select the Display link. In the Display option window to the right hand side there are a few options available. Select the screen resolution option from them. Now there are many options present in there like Display, resolution, orientation etc., Using the display option you can select the monitor you want to m...
The new Windows 7 layout is streamlined for the occasional user to the head of human relations for Microsoft. Wall papers, system sounds, and resolution settings were covered in the instructional how to video. The evaluation specialist was knowledgeable and articulate. Transitions into new areas of the operating system were appropriately placed. To make a text more readable, you should change the screen resolution. Choose your picture library to start a slide show for your weekly conferences ...
This video is from HelpVids and describes how to change the axis titles on charts in Microsoft Word 2007. To access the chart tools, select the chart and the tools will appear above the ribbon. There are many different design options that you can preview on the screen to make your final selection. To change the chart title, click on the Chart Title button which is located on the Layout ribbon. You can then select where you would like the title to appear. Once you select the location you can t...
This is a tutorial video on uploading HD quality video onto YouTube. The video is simply a screen shot view of the YouTube home page. As the narrator goes through the steps the cursor moves and clicks on what you should click on. He advises to click on upload; he clicks to choose a video. The video must have a certain resolution to be assigned HD video. He indicates that YouTube will accept a variety of file formats to upload. You must use the 44.1 kHz frequency rates to get the best resoluti...
Follow along as we are shown how to set a password for a new user in Windows 7. -First, go to the Start menu.
This video will show you how to use the map function on your iPhone. Follow these steps to use the map function on your iPhone: From the Home screen, tap 'maps' to open the Map window. Use your finger to navigate and scroll around the map. Pinch your fingers apart and you will zoom in to the location, pinch your fingers together and you will zoom out. You can use your GPS to track where you are by tapping the Tracking icon. If you wish to search for a location, simply tap on the Search field ...
In Part 1 of this electric guitar video lesson, brought to you by GuitarJamz, host Marty Schwarz will teach you how to play "Sir Duke" by Stevie Wonder. As you follow along with him, he teaches you the intro of the song, breaking it down slowly so that you can follow along with him. Then he moves on to the progression of the chords used in the song, breaking down each part of the song, teaching you the chords and explaining the strum pattern and picking of the guitar riffs. You will learn the...
Do you want to add some 3D effects in your 2D designs? Open illustrator and draw an oval tool holding shift key. Then draw an ellipse with a different color and place it on the oval. Take blend tool,then click on ellipse shape and then oval one for a gradient effect. Draw another oval with a gradient and give it screen. Your glossy sphere is ready. Adding gloss, specular highlights as well as shadows adds some realism to one's art work.
Want to create some cool effects in illustrator? Create a new layer. Draw the ellipse tool and add radial gradient, then go to transparency and select screen. Then create the star tool and deselect stroke. Drag and place the star shape on ellipse and group them. Then duplicate that layer to make multiple sparkles on different layers. Resize other sparkles by holding down shift key. One can change colors of other sparkles. This will help you in making a good background.
