Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 98th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the ADDRESS function to make labels in templates easier for users to understand.
Nick from Greyscale Gorilla boils down the basics of keyframing. Many beginning users of After Effects try to use too many different keyframes and styles. Fortunately, this tutorial shows you simpler executions of the same concepts.
This video will discuss how to implement color changes in Photoshop editing. This step by step approach will tutor the novice Photoshop user how to utilize the various tools and applications to achieve, colorization in photos, swap select and hue, colors and backgrounds of photos, describes layering using saturation and blend techniques. This video tutorial will describe and demonstrate the correct settings and tool usage for easy application of each editing and color manipulation.
Get your game on and shed pounds, too, just by playing your Wii. You will need Wii Fit, a Mii, Wii Sport, a dance video game, some user tested routines, commitment and optional: a virtual dance partner.
This video includes a disassembly slideshow for the Microsoft XBox. Intended to be instructional in nature, the disassembly guides at http://www.takeitapart.net help users to better understand and maintain their favorite gadgets.
A steadicam can mean the difference between a professional and steady wide shot of Victorian era London or a wobbly, user-generated content-esque portrayal of some old lamps and streets. Having control over how your camera moves is so vital to good film production.
In this video tutorial, viewers learn how to use the noise removal tool in Camtasia Studio. Begin by uploading the audio track into the time line. Then select and highlight the region that contains the noise. Now click on Edit and select Audio Enhancements. Under Background noise removal, users are able to select to automatically or manually remove the noise. Once selected, simply click on the Remove Noise button. Users also have the option to adjust the sensitivity. This video will benefit t...
In this video tutorial, viewers learn how to use volume envelopes in Sony Vegas Movie Studio. Begin by importing the audio track into the time line. Then right-click on the audio control panel, go to Insert/Remove Envelope and select Volume. This will place a purple line through the audio track. Users are able to control the volume by moving the line up or down to increase or decrease the volume. Users are also able to select certain points by creating starting and ending points in the audio ...
Google is the biggest and best search engine on Earth, and if you are a webmaster and want your website to be a big success it would really behoove you to know as much about how it works as possible. The Google Webmasters series of videos and website were created to teach webmasters, SEO professionals, and others how Google works by answering their questions and giving them insights into how they can best integrate and utilize Google's functionality to improve their business. This video will ...
In this video tutorial, viewers learn how to do a 21's workout for biceps. Users will need to use a barbell for this exercise. Users will be doing 21 repetitions of barbell curls. The first 7 reps is just the bottom part of the movement. Then the second 7 reps are the top part of the movement. The last 7 reps are the full movement of a bicep burl. This video also provides a demonstration for viewers to easily follow along. This video will benefit those viewers who are interested in health and...
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...
In this C4D user's guide, learn how to ctrl-drag axes to bypass the object axis tool; how to change a group axis with several selected items; how to set a light to negative values to make darker areas; and how to undo camera (view) moves by choosing "shift-command-Z." Whether you're new to MAXON's popular 3D modeling application or are just looking to get better acquainted with Cinema 4D and its various features and functions, you're sure to enjoy this free video software tutorial. For more i...
In this video tutorial, viewers learn how to align and group objects, and use gridlines. Begin by clicking the Insert tab and select a shape from Shapes. To align the object, go to the Format tab and select the Align menu. From there, users are able to align the selected object in any direction. In the Align menu, users are also able to add gridlines by selecting View Gridlines. To configure the grid-line options, click on gridlines Settings. This video will benefit those viewers who use Micr...
In this video tutorial, viewers learn how to do the "Out of Beverly Hills" glitch on the video game, Tony Hawk's American Wasteland. Users will need to have the low gravity option turned on. There are several ways to do this glitch. Begin by going on top of a roof with a ramp. Then launch off the ramp and then jump off that roof to end up out of the map. Users are also able to super jump and ride an invisible board in this glitch. This video will benefit those viewers who enjoy playing this v...
In this video tutorial, viewers learn how to create tables in Microsoft Word 2007. Begin by clicking on the Insert tab and select Table. Then users are able to create a table by dragging the mouse across the squares to determine he amount of columns and rows. Make the final selection by simply clicking. Another option is to click on Tables and select Insert Table. Then users are able to input the number of columns or rows. This video will benefit those viewers who use Microsoft Office 2007, a...
In this video tutorial, viewers learn how to make shadow puppets. Users will need a good, strong light and good positioning of the light. It is recommended to use white or any bright colored walls. Users learn how to do 2 types of shadow puppets in this video. The first type is a swan. Simply hook the arm out. The forearm will be the neck and the biceps will be the body and feathers. Then flap the 4 fingers and thumb like a beak. The second type can be a variation of animals. Simply stick out...
In this video tutorial, viewers learn how to make windows full screen on a Mac computer. This task is very easy, fast and simple to do. Users will need to download the application, Right Zoom. The link to download this application is: Right Zoom. Once downloaded and installed, double-click on the application to operate it. Now whenever users click on the + on the top of a window to maximize the screen, the window will enlarge to full screen. This video will benefit those viewers who use a Mac...
This clip shows off the Levels command and Spot Healing brush in Photoshop (and, as an added bonus, demonstrates basic animation properties in After Effects and shows two nifty features in Soundbooth). Whether you're new to Adobe's popular raster graphics editor or a seasoned video professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well served by this video tutorial. For more information, including detailed, step-by-s...
This After Effects user's guide takes you from nothing to a finished broadcast slate in 24 minutes? Yes. Along the way, you'll learn about compound blur, shape layers, repeaters and more. Sounds like fun right? Then come on down! Whether you're new to Adobe's popular motion graphics and compositing software or a seasoned video professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well served by this video tutorial. For m...
In this video tutorial, viewers learn how to quickly burn ISO disc images in Windows 7. Users will not need to download any third party software. This task is very fast, easy and simple to do. Simply double-click on the ISO file to Open Windows Disc Image Burner. Then select your disc drive and click on Burn. Users may also right-click on the ISO file an select Burn disc image. This video will benefit those viewers who use a Windows 7 computer, and would like to learn how to easily burn ISO d...
In this video tutorial, viewers learn how to operate a gloved arm puppet. The puppet is operated by the user putting one hand inside the puppets head to operate the mouth, and the other hand into a glove to operates the puppet's hand. Users may have a second puppeteer to the other hand. The puppets are able to use their hands to pick up objects, make contact or show emotion. These puppets require a special amount of skill and patience to be able to operate both the head and hands of the puppe...
In this video tutorial, viewers learn how to quickly switch tabs with the keyboard. Users will need the Fire Mozilla browser to do this. Begin by going to the Firefox Mozilla add-on site and search for "crtl-tab". Then click Add to Firefox to install the add-on. To activate the add-on, simply press the ctrl and tab buttons on the keyboard. It will then open a thumbnail of your 7 most recently accessed tabs. There is also a search bar for users to use to find a specific site. This video will b...
In this video tutorial, viewers learn how to use the Slow Keys access tool in a Mac OS X computer. The Slow Keys feature is located under the Keyboard tab in the Universal Access window. Once Slow Keys is turned on, users also have the option of using key click sounds as additional feedback when a key is pressed . Users are able to set the Acceptance Delay to determine how this feature behaves. The delay of the sound can be set from long to short. This video will benefit those viewers who use...
In this video tutorial, viewers learn how to measure the long-board clearance to determine the correct trucks to use. Users will need a measuring tape. The board clearance is a term used to describe the width of the deck, over top of the trucks. There will be 4 holes that make up the bracket. Users will be measuring the distance in between those holes. Measure both the front and tail of the board. The 3 types of trucks to decide from are: S6 truck, S8 truck and S10 truck. This video will bene...
This HelpVids.com tutorial shows the basic options for setting an alarm on an iPhone. To begin, open the "clock" app. There are four sub-menus in the the "clock" app. Choose the "alarm" sub-menu. To create a new alarm, touch the "+" in the upper right corner of the screen. A new screen appears and the user has different options. A repeat time for the alarm can be chosen. The user can choose the sound that plays when the alarm goes off. The "snooze" option can be toggled on or off, and the ala...
In this Computers & Programming video tutorial you will learn how to change the default Windows Remote Desktop port. It is actually a registry hack. You can check the IP address of our machine by typing ipconfig into the cmd prompt. For hacking into a machine, you should have created a user for the machine and allowed remote desktop to that user. Open up the remote desktop and type in the IP address and it will ask for a login. To hack the registry, click start and type in ‘regedit’ . now go ...
In this video tutorial, viewers learn how to control which games can be played with Net Nanny. Begin by opening the program and select Manage Games under Games. Users will have 3 options on how to block or allowing the games. Users can block by the ratings, games or descriptions. For the ratings, simply drag the slider to which ESRB you want to be allowed. For the games, simply go through the list and click on the game that you want to block. For the description, by checking the content that ...
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 video tutorial, viewers learn how to locate and remove spam accounts from a WordPress blog. Begin by logging on your blog and select the User tab. Search through the user list and look for suspicious email accounts. Some keys that reveal spam accounts are: emails that have .ru, poker, Viagra, pharmacy and accounts with more then one dot. Use your common sense to find spam accounts. Select the account you want to delete. Select Delete and click on Apply. This video tutorial will benefi...
In this video tutorial, viewers learn how to use the Crop-A-Dile to set eyelets. The Crop-A-Dile is a tool that can punch holes and snap eyelets. The sides of the tool allows users to set a measurement for hole punching. This allows for users to make accurate and straight holes. Then put the eyelet on the hole and use the middle part of the tool is set it. Simply squeeze it to bind the eyelet to the paper. This video will benefit those viewers who enjoy making arts and crafts, and would like ...
In this video tutorial, viewers will learn how to change text alignment and formatting in Microsoft Word 2007. To format or align the text, you must high light it first. Once highlighted, users are able format the text in many ways. The formatting options are: font type, font size, bold, italics, underline, strike-through, subscript, superscript and change case. The alignment options are: right align, center, left align and line spacing. Users also learn how to add pictures and position the t...
In this video tutorial, viewers learn how to fix the XBox 360 "red ring of death" using a heat gun. To begin, users must disassemble their XBox 360 console. Users will be doing this procedure on the motherboard-heat each side for 4 minutes. Then let the motherboard cool down for about 6 hours. Finally, add some thermal paste on the GPU and CPU of the motherboard. Once finished, reassemble the XBox 360 console. This video will benefit those viewers who have an XBox 360 and want to fix the "red...
Its a bit of a manual process but Neal walks us through it pretty well. First copy the tweet you want tweeted, than click the reply button, than before the @ symbol type "RT " for Retweet, and than leave a space after the user name and then paste the tweet after the user name. After this all you have to do is update in order to send the Retweet out into your feed. You have to make sure not to go over the amount of characters allowed in the Retweet.
In order to secure a PDF with a password when opened in Adobe Acrobat 9 Pro, press the secure button and go into password security settings. Here you can change on what versions of this software the file will run on, the next option asks which portion of the document is to be encrypted when a password is placed. Further below here is where you actually choose the password, this ensures that only people who know the password will be able to see the contents of the document. Below this is the d...
This video explains how to set up an Aqua Sand gift box. The first step is to place the mold into the tank, and then fill with water. With a half-full bottle of Aqua Sand, by placing the nozzle face-down to the bottom of the tank and lifting upwards, you are able to create colorful towers. You can create multi-colored towers by starting with a wide base, then changing colors as many times as you wish while you move upwards. Users can also fill the mold with various colors of Aqua Sand, add de...
Veronica Belmont shows how to get rid of browser cookies. She starts with explaining what a cookies is, that it is a small file downloaded to the computer from the internet so that the website can remember more information about the users, which she says is quite helpful if you visit a website regularly. She also explains about some malicious cookies which track user actions and report to websites. She now explains how to open options in Firefox browser or settings in Internet Explorer and wh...
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.
Bored of using complicated keyboard shortcuts to zoom in and zoom out of web pages? This simple, yet useful Firefox extension (QuickPageZoom 1.6.2) adds two icons to the status bar and two context menu items that enable quick access to the Full Page Zoom feature (Page Zoom In, Page Zoom Out and Reset Page Size).
Check out this video tutorial to learn more about the Phishing Filter on Internet Explorer 7. Web browsers such as Microsoft's Internet Explorer 7 have become an important part of the computing experience for business and home users around the world. With the popularity of web browsers for accessing information, running programs, and even accessing corporate resources, the browser has become a target for viruses, malware, and phishing schemes that present real dangers to Internet users. Inter...
Before you can get started creating eye-popping videos with After Effects CS5, you'll need to learn how its user interface works. Happily, this guide presents a very thorough overview of all the most important functions, features and filters.
