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 169th installment in their series of digital spreadsheet magic tricks, you'll learn how to randomly select an employee from a list using the INDEX and RAND and INT functions (also RANDBETWEEN).
In this how-to video, you will learn how to create a dual-booting system with Ubuntu and Windows. First, go to the Ubuntu website and download the latest Desktop Edition of Ubuntu. Once it is finished, burn the download to a CD. Once this is completed, place the CD in the drive and restart. Boot using the CD and select English. Now, click forward and select your time zone. Click forward, select your keyboard type and click forward again. Now, you can adjust the partition sizes for your hard d...
gjtfreak demonstrates a new free tip for the iPhone 3G on how to get free ringtones on a Windows Vista environment in this video. Firstly go into the start menu open control panel option and from that open folder option. Click on view and find a box that says hide extensions for known file types and unclick that box click apply and then OK. Secondly open up iTunes and pick the song you want to use and go into the preferences column at the top left of the iTunes window. Make sure that the ring...
This is a great and easy step by step video on how to fix a simple leaky faucet. It even shows you what tools are needed to complete the job. Barbara K shows you faucet fixing is not just for men anymore!
Not sure about all the functions and abilities of Microsoft Excel? Luckily there are free video tutorials out in the world... or better said, the World Wide Web, to help you. In this video, learn how to use the RAND function and sort in Excel to select a random name from a list.
Watch this video to learn how to disable auto-correction on your iPhone. Launch Installer (you should be familiar with this application by now) from your Springboard. 2. Go to Install and scroll down to Tweaks 1.1.1; under Categories. kb_fix_iPhone.jpg 3. Select Kb2 from the list of packages. Install it. Click the Home button, and the iPhone will go to the “Slide to Unlock” screen. 4. Go to Settings General Keyboard and you should see a new option, called Enable Autocorrection. Touch it to tu...
Award winning author Susan L. Reid teaches us how to write a great mission statement for your business. 1. First, write your "purpose statement". This answers what your business wants to accomplish and what problem or need your business is trying to address. Simply state the answer to this question. 2. Write your "business statement'. This describes the activities or programs your business must do to support it's purpose. Ask yourself what you are doing to address the need identified in your ...
In this how-to video, you will learn how to properly study for a test or for homework. The author offers a few great tips. You should avoid cramming and study well before the test date. Make a list of everything that is going to be on the test. Memorize facts and formulas. Make up questions that you think are going to be on the test. Take all the school tools you need in order to complete the test. Lastly, if you prepare well, you will have a great chance of doing well. You should try to stud...
In this episode of Panlasang Pinoy, we are taken through the steps of how to make custard cake. The episode provides a shopping list of ingredients that are easy to find at any grocery store. Each step of the baking process is covered from mixing the ingredients and preparing the 9x13 pan to baking the cake. For an easy to follow recipe and guide to making fresh Filipino-style custard cake, follow the steps in this video.
This particular How-To Video teaches the viewer how to use the existing website www.tvcatchup.com to listen to radio stations online. The narrator scrolls through the part of the TvCatchup website that is brand new and has a listing of radio stations available for free to listeners in the U.K. The video offers a short tutorial on how to access the site and gives a description of what the user will find.
In this installment of home improvement do-it-yourself videos, brought to you by Lowe's, host Mike Kraft, one of Lowe's home improvement experts, demonstrates a landscaping technique that shows you how to create a retaining wall with interlocking wall blocks, that features a raised planter bed. Mike gives you a list of all the tools and materials you will need to create the retaining wall, and offers some tips on creating curved lines when laying out the wall.
Pastryparrot1 shows you the perfect recipe to make the most savory meatloaf with breadcrumbs that will leave your family begging for more. This instructional cooking video takes you through the simple process of making this meatloaf, providing you with the list of ingredients and methods to create this simple recipe. It shows you the right way of mixing the ingredients and at what temperature you should bake and for how long. This easy meal is sure to be a crowd pleaser.
In the following video, "Beef with Broccoli" the viewer is thought, how to prepare from scratch an Asian style beef with broccoli. The chef on the video lists and shows all the required steps as well as all of the required ingredients for the said dish. The video by "Panlasangpinoy" is a very quick as well a convenient way for any beginner on the kitchen to learn by example, how to prepare a tasty home made Asian style beef with broccoli.
This how-to video explains how to copy and paste text in the browser in a Motorola Droid phone.
Do you dread tackling those wallpaper remodeling tasks on your home maintenance list? Many homeowners choose to let professionals deal with the removal of their old wallpaper, but this can be an expensive choice. Learn how you can remove even the most stubborn wallpaper and wallpaper accent trim with a little white vinegar, a spray bottle and a paint scraper in just 7 minutes. Find out, too, how you can make this project a fun, family challenge by involving the little ones.
WaysLinn demonstrates how to play "Use Somebody" by Kings of Leon, in this acoustic guitar lesson. This video is easy to follow, as she lists the chords used in the song, and demonstrates three different chord progressions that can be used, so you can choose the style that is easiest for you to play, making this lesson a great choice for beginning guitarists, and experienced players alike. With her help you'll learn how to play this song in just a few short minutes.
Take a folder and organize documents based on the actions required. Actions:
Add another web game to your list of what to do on a bored evening... Bejeweled Blitz! In this video, learn how to play Bejeweled Blitz on the web for free. To play this online game, go here.
What do you do when someone you love is a horrible kisser? It can be difficult to confront someone with the bad news their kiss is not on your list, but luckily YourTango has some advice for those of us not wanting to tell them, but SHOW them how to kiss. An easy out, without bruising any egos.
Are your fish starving? If they are, you need to do something about it, and quick. Well, there's no quicker solution to feeding your fish than hacking Happy Aquarium with Cheat Engine.
Windows 7 is awesome, and here are four super cool secret tips to make it look even better. Say hello to your new operating system! Learn how to use aero shake, jump lists, libraries, and more. Watch this video and learn how to use some of the new features on Windows 7.
This might be an old hack for Happy Aquarium, but for some of you it may still work. Most of you will not be able to do this, but it's always worth a shot, right? It's a cheat from 9/29/09 (wow!—retro hack) for which you need Cheat Engine 5.4. Newer versions of Cheat Engine should work, too.
In this episode from Household Hacker, you'll see how to put video ringtones on your cell phone for free. Check the full list of compatible mobile phones over at Vringo to make sure it will work for your cellular phone. This is a really cool alternative to the normal ringtones for mobiles phones!
Is your child a gimme monster? Put a lid on demands and tantrums with these tips. You Will Need
This is a video tutorial on how to assemble K'Nex quad or ATV vehicle. He gives you the list of different Knex parts you need with quantities. This is a simple assembly, with a time lapse of how to put each piece together.
This video demonstrates three different hip hop streetdance moves. If you like Chris Brown, you might like this dance tutorial video. The dancer demonstrates and provides text explaining each hip hop dance move. He does not list any of the names of the dance moves.
In this tutorial, Gary Rosenzweig of MacMost.com lists his favorite iPhone tips, including some typing and browsing tips. You also check out MacMost.com for free iPhone ringtones, iPhone games, and a guide to the iPhone.
This video tells you what keywords are and where to find them. You will learn how to effectively use keywords in your resume in the form of a list and to build your summary of qualification section. It also shows you how to present the keywords creatively. Watch this video resume-writing tutorial and learn how to use keywords for making a good resume.
In this tutorial, Gary Rosenzweig looks at how to pull in an updated list of photos from Flickr or an RSS feed and use them as your Mac screensaver in OS X. Watch and learn how to create your own dymanic, self-updating screensaver.
In this tutorial, Gary Rosenzweig of MacMost.com shows you the basics of using the Terminal application. Learn how to navigate, list files, rename, copy and delete. Also learn some shortcuts that experts use.
If you're new to Microsoft Office PowerPoint 2007 and just want to pick up the basics, watch this tutorial and learn how to get started fast. You'll see how to create your own slides for a show and add headings, bulleted lists, and pictures. Use built-in layouts to organize your slide content. And see how the new Preview feature helps you choose theme colors and background design, minimizing the guesswork and giving you a polished result.
If taking a soothing bath is high on your list of favorite activities, then making one of these fizzy bath bombs will be worth your while. See how to mix and assemble bath soap bombs.
If putting up a new fence or mailbox is on your to-do list, chances are you'll need to use a post hole digger. Watch how to properly dig a hole with one.
An American English teacher lists modal verbs and briefly explains their use.
Learn how to make iodine with readily available materials with Phil Torrone in order to avoid being on the DEA's list.
No need to sift through your contact list to change a friend's name. Tekzilla will show you how with one easy step.
While the ingredient list may look a bit long, homemade meatballs are a very easy to make, and since we skip the very messy step of pan-frying these before they hit the sauce, it becomes downright simple.
Use alginate to make a mold and cast of an arm. Watch this video for a detailed list of needed ingredients and step by step instructions on how to do it yourself. This is a good technique for sculpture or special effects.
A fantastic "do it yourself" project, the folks at Progressive Farmer magazine show you how to build a fire pit in just one day. Clear step-by-step instructions and material lists help make this project both fun and easy.
Sometimes the frame size on a bike isn't listed for whatever reason. Learn how you can accurately measure the frame size of a bike. It's easy so long as you can recognize the seat tube and the crank.
