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 and Mr. Excel, the 627th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create, edit and otherwise work with FREQUENCY array functions.
Excel is great, and if you're a Mac user, Excel 2008 for Mac has a lot of new and useful great features you can use to maximize efficiency in your spreadsheets. Excel doesn't have to be the boss anymore, you can! The Microsoft Office for Mac team shows you all the great features in this how-to video.
Learn how to pair a phone through Bluetooth with a 2010 Prius in simple steps. 1. You can connect your phone to the vehicle through Bluetooth without using any wires. 2. Press the 'Info Phone' button on the right side of the display screen, press 'Phone' now and press 'Yes' when prompted. 3. Now enter the pass code when prompted on your phone to pair it successfully. 4. You can pair more than a single phone by using the same process but you can use only one at a time. 5. You can also transfer...
In this Microsoft Word tutorial the instructor shows how to add a drawing or a free form shape to a document. Using the canvas in the Microsoft Word 2007 can be very helpful in adding graphical content to your document. Adding shapes and special effects like shadows, 3D will give a rich look to the document. To do this open a document in Word 2007. In the tool bar go to the Insert tab and in that select the Shape button. Now you are presented with plenty of predefined auto shapes. First at th...
Own a BlackBerry Curve 8330? Need a custom ringtone? Best Buy has answers. The Best Buy Mobile team explains how to set custom ringtones for contacts in your address book on the BlackBerry Curve 8330. There are many different ringtones to choose from and you may set a different one for each one of your contacts.
Windows 7 is the hot, new operating system replacing the past XP and Vista systems. Windows 7 is the most simplified, user-friendly version that Microsoft has developed - ever. Get acquainted with your new version of Windows straight from Microsoft.
You may or may not know that Facebook has several keyboard shortcuts you can use to quickly navigate around the site without using a mouse.
In today's day of mobile devices and improved technology, anything of yesterday can be considered retro— even a freakin' slingshot! Yes, that's right— forget fallen down tree branches. A rubber band and tree limb ain't going to cut it anymore. These days, kids need accuracy, and Kipkay has the knowhow.
In this video from MegaByteTV we learn how to set up a Gmail account in Mozilla Thunderbird. First go to your browser and download Thunderbird from the Internet. Once downloaded, go to the Thunderbird application. Go to New and Account. Click on Gmail and enter your name and email address. Click Next and check off download messages now and click Finish. Your messages should now appear there. The first time you do this, all of your messages will look new but you can change that. If you'd like ...
Want to make a phone call on an iPhone 4 running Apple's iOS 4.1, but don't know its passcode? Not a problem. In this clip, we learn a simple trick that will allow you to bypass the lock screen entirely and permit you to view the phone's contact list and place phone calls to any number you like. This glitch has been fixed with iOS 4.2, so treasure this hack while it still lasts! This will let you unlock someones password on an ipod or iphone touch.
Who is the hottest animated female character of all time? We're sure there are lots of differing opinions on that, but we think Jessica Rabbit must be at the top of the list of viable options. With curves so, well, curvy, that they enter the room before she does and eye-catching red hair, the seductress is one hot lady.
You can create a free website using HTML. HTML is hyper text mark up language. Create a folder "my webpage" with all of the images and information for the webpage. Use notepad to write the HTML for the website. Notepad plus is the best which can be found on Sourceforge. Open the browser and the notepad and begin to construct. These codes will help in the creation of the page: <html> opens instructions </html> closes instructions. These are called tags. One opens the commands or instructions a...
If you're looking for a great game, but at a low price check out the Xbox Live Arcade section for a great list of games. One of the more popular and talked about games is Monday Night Combat. It's a third person shooter game that features different classes like Team Fortress 2. It's a fun addicting game that is sure to attract many gamers.
In this video tutorial, viewers learn how to set custom sound volume for different applications in a Windows 7 computer. This task is very easy, fast and simple to do. Begin by simply clicking on the speaker icon in the system tray and select Mixer. There users will have access to the master audio mix on the left and each application listed individually, with their own volume bar. Just adjust each volume bar of the applications to your liking. This video will benefit those viewers who use a W...
We all make mistakes and in this tutorial, learn what to do if you decide to go back and change a word after you've already typed it. Fixing a word with Swype - the fastest way of text messaging - is super easy and won't slow you down at all. So, if you've typed that rambling, soul baring text message at 3 am and want to go back and change a few choice words save yourself with this feature.
There are some words that Swype has trouble with. While Swype will still be able to recognize these words, it will make you choose from a list of options. For example, you will run into this problem with the words "put" "pit" and "pot" because on a QWERTY keypad the letters "TYUIOP" are all in a line. In these situations, you may want to "hop" so that your texting stays up to super speeds. Check out this clip for an explanation of "hopping" from the makers of Swype and keep on texting!
In this video tutorial, viewers learn how to get perky pecs and get rid of "side boobs". This video lists several exercises for viewers to do. Users will need a pair of dumbbells for some of these exercises. The exercises in this are: chest fly, dumbbell press and a variation of push-ups (narrow, wide, knees). Do 3 sets of 10 repetitions for each of these exercises. This video also provides 2 isometric exercises. The first exercises to press the hands together. The second exercises is the sid...
As good as Swype's word prediction software is, sometimes we all make mistakes. If you are wondering how to go back and fix something that isn't right in your text messages, check out this tutorial. Fixing words with Swype is just as fast as texting with this lightening fast application.
Bobby pins have been integral tools in a girl's makeup case since the 1920s, when bobby pins were used to secore the fashionable hair bobs of the Jazz Age. They've also recently been used by young boys and hackers to pick open locks. And now you can add one more fun use to the list.
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 12th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use Advanced Filter 'Unique Records Only" to extract a list of unique items from a data base, and then use the COUNTI...
When it comes to earning high scores in a web game like Crazy Taxi or Crazy Cabbie, sure, you could, like, actually play it — but where's the fun in that? Cheat your way to the top with this hacker's how-to.
This video demonstrates how to suggest a friend to join your Facebook page. First you find the fan page by typing the name in the search bar at the top of the page. Choose the right result. Then click on suggest friends on the left hand side the page, just under the picture. A box will pop up with all of your friends listed. You can then choose which friends that you would like to suggest to become a fan of the Facebook page. Existing fans will be grayed out so you cannot choose them again. C...
In this Electronics video tutorial you are going to learn how to magnify to edit text on an iPhone. This video is a part of a series of tips on iPhone finger tips. This is very simple and easy to do and takes practically no time to complete. If you wish to add something to a list or change an email, go to the springboard and click on the ‘mail’ icon. Then scroll and find the text you want to edit. Now simply touch and hold your finger on the text. This will bring up the magnifying glass. Now ...
brian13311 the shows us how to use the music controls feature on an iPhone. With iPhone you can touch your music while a song is playing. You can tap the album picture/art on the screen and it will show you the controls. It will show you shuffle, repeat and the scrubber in which you can forward or rewind. Tap again to hide them. Tap the list button to see other songs on the album. Tap a song to play, of course you can rotate iPhone to the landscape orientation any time to view your albums and...
In this Computers & Programming video tutorial you will learn how to add photos to Facebook using Picasa. The video is from Help Me Rick. Log into Facebook, go down to the lower left corner and click ‘Applications’. Click ‘Find More’ and in the search applications box, type in ‘Picasa’. You will get a list of Picasa applications. Select the Picasa by Alan Lundeen. Here you click ‘go to applications’ -> install now -> OK -> Yes -> Facebook -> Add -> OK. Now you will get a Facebook icon on the ...
This video is meant to teach you how to beat a speeding ticket. First you must try and not get a ticket. This video lists several things that will help you avoid paying a ticket. After you try that your best bet is to try and talk your way out of it right then when you get it. Be polite and careful with any quick moments. Try and convince the police officer that they are wrong and be confident. Imagine the police officer holding a baby. Do not try and plead with them. Don't kiss his ass. Don'...
Installing a peephole in your home's front door can give you and your family a sense of security knowing who comes to your door before they enter. In this video Barbara K will show us exactly how to install a peephole on your door.
Trevor4Ever595 teaches you how to hack mini tower defense using Cheat Engine. Start the game in your internet browser and then pause it. Start Cheat Engine and go to your process list - the little computer icon in the top left corner of the window. Select your browser and then change the value type to 4 bytes. Take the money you have, multiply it by 8 and then add 6. So for 300 you get 2406. Search for that in Cheat Engine. Build a tower and if you have 200 left, you will get 1606. Search for...
Improve your acoustic and electric skills with this special Delta Blues piece. Watch the full video lesson to learn how to play Muddy Waters' "Can't Be Satisfied" on your blues guitar.
Are you interested in parties and cocktails? Let's make a Jagermonster cocktail. Start with a rock splash and ice it up a little bit. Next, get another glass for an ice mixture, one ounce of Jagermeister, and a little bit of grenadine. Then, add 4 ounces of orange juice. Shake it up well for a good mixture, get rid of the previous ice in the glass, and pour it in. This will provide a variety in your list of cocktails.
Gigafide explains that with so many different social networking sites, it is hard to keep information up to date on all of them. He first introduces TweetDeck, an amazing desktop application that allows a user to update information for their Twitter, Facebook, MySpace, and LinkedIn accounts. If you don't want to go through the hassle of installing TweetDeck on your computer, there is HootSuite, a web application that allows you to do this and if you're interested in keeping track of much more...
Host Brenda Lo, from Lowe's Creative Ideas demonstrates, in this informational video, how to create an outdoor water fountain. Brenda details the entire process, listing the tools and supplies you will need to complete this great do-it-yourself project in just one afternoon with easily obtainable materials. This video is great for the DIY beginner or experienced professional looking for a new project idea for your outdoor garden. do-it-yourself, and save time and money with these great tips.
In this video from theXBox360GameReview we learn how start and join an Xbox Live party. Once signed into Xbox live, scroll to the friends channel, and select the friend you want to have your party with and press Y. Now that you have a party going, you can play some Halo wars. If you want more friends to join the party go to your friends list using the guide button and tap X to select who you want to invite. If you want everyone in the party join in, select Party and choose Invite Party to gam...
Learn how to set up Internet on iPhone clones with this video. *First thing you need to do is to make an AT&T GPRS data account.
Looking to get into the weird world of circuit bending? In this four part video tutorial geared towards beginners, learn in thirty minutes how to circuit bend. Tools you will need include a soddering iron with innerchangeable tips (thin pencil preferred), thin sodder, hook-up wire, a wire cutter, a wire stripper, a drill with drill bits, plyers (needle nose included), and screw drivers of various small sizes. Other useful tools include cresent wrenches for toggle switches, jewelers files, & a...
Hack Click Challenge! v2. Click your way to the top. You just need your computer mouse and your hand, but watch out… this clicking flash game can cause arthritis if you're not careful!
Have you ever found yourself calling up a company, only to be denied due to not calling from the number listed on your account? Thanks to a website called Spoofcard, this is no longer an issue! SpoofCard let's you spoof the number you are calling from, as well as modify your voice (Male -> Female or vice versa). Best of all, it all looks completely legitimate.
Learn everything you could possibly want to know about the internet, multiplayer game Evony with tutorials from EvonyTutorials. Watch this video tutorial to learn how to play Evony: Resource millionaire and beginner's protection. See exactly what the game Evony is!
This is a LEGO Indiana Jones walkthrough on how to unlock the secret level. What you basically need are most of the characters and at least one level in each chapter having 10/10 artifacts. You might not need all of the artifacts to play the Young Indy and Ancient City level, but you will definitely need them to play the last level though.
Right out of the box, iPhone is incredibly easy to use. If you want to get the most out of every feature, you’ve come to the right place. This video tutorial straight from Apple will teach you how to make calls and use voicemail on the Apple iPhone 3G. The iPhone redefines what a mobile phone can do.
