In this video tutorial, viewers learn how to create drop down menus in Microsoft Excel. This task is very easy, fast and easy to do. Begin by highlighting a desired cell. Then click on the Data tab and click on Data Validation under Data Tools. When the Data Validates window opens, click on the Error tab and deselect "Show error alert after invalid data is entered". Then click on OK. Now simply type in the data into the selected cell. This video will benefit those viewers who use Microsoft Ex...
In this software video tutorial you will learn how to create drop down menus in Excel using Data Validation. This example will show you how to display a list of parts in a drop down menu. Create the list of parts somewhere in your worksheet. Then in the cell underneath the one where you want to display the parts, go to the data validation window and enter the data. For this select the cell and then press 'Alt + D + L' to bring up the data validation box. Here you click on 'settings' and selec...
In this tutorial, we learn how to set up the calendar in MS Project 2007. First, open up your calendar and then click on the "work week" tab. Now, set your working times into the slots for each different day. Make sure you set your start and end times correctly. Now, go to options and change the default start and end times so they match your working calendar. When finished, save this and then start to enter your task information to each different slot. When you enter this, the start and finis...
If you live in an older home with windows that are aged, it's a smart idea to make sure they're sealed correctly. Doing so can not only result in a loss of energy in your home, but prevent cool or warm air from entering your home. It's a great and easy way to save on costs.
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 36th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn most everything there is to know about working with array formulas in Microsoft Excel.
In this how-to video, you will learn how to change the password to your hotmail e-mail account. This will be useful if someone knows your password or it is not unique enough to be safe. First, go to your web browser and log in to your hotmail account. Once you are in, go to the options bar and click more options. Next, go to view and edit your personal information. Click on change next to your password. Enter your old password and then enter your new password twice. Click save to change the p...
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 from MatthewNeer presents how to check your site's or blog's Google indexing.Type in Google word Site, press Space and then enter your site's or blog's URL address.Then press Enter or click Search button.Newly opened Google page will show all the pages from your site or blog which are already indexed in Google search engine.From search Results to the right you can see how many pages from your site are already indexed.According to the results you can reoptimize those pages ...
This video shows you how to idiot-proof a data set in Excel pretty much. It demonstrates how to enable data validation in a cell, so that when you type something in it must be in a predetermined list or will not work. Start by typing in your data table in a second tab. His example is a date, then information about certain employees based on that day. To enter the data validation menu, click the cell you want to use and then hit ALT+D+L to bring it up. Go to settings, then under the Allow menu...
How to pick the right RAM for your computer
CtrlFormula teaches you how to make an animation with a batch file. Before you begin you must know that sending batch files over the internet is risky, so keep that in mind. You create a new .txt file and type in: @echo off. Hit Enter twice and type in: echo loading. Then hit Enter once and type: ping localhost -n 2 >null. Hit Enter once and type in: cls. Copy and paste this structure three times. For each loading you see you have to add another dot at the end, so the animation will slowly go...
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 ...
Learn how to delete your old Yahoo or Yahoo mail account in simple steps. First open your web browser and enter the web address for Yahoo to open it. Now log into your account using your Yahoo username and password. Go the account termination page, confirm your account termination and enter code give. Finally press 'Yes' and enter your password . Now your Yahoo or Yahoo mail account will be deleted.
Learn how to install Aircrack on your iPhone to hack into almost any WiFi network. First download Aircrack from iHackMyi, then follow these steps:
Check out this video tutorial to see how you can make a paper role playing game. This is a fun little fantasy game that you can download and print on your computer, then cut out, assemble, and play! It is called "Enter the Labyrinth and Rescue the Princess".
This sea kayak self-rescue video from Water Walker Sea Kayak shows you how to re-enter and roll.
WHERE TO USE THIS CODE: Most videos DO NOT have "View in Higher Quality" links below them like this video does. So by using this code, you'll be able to watch ANYTHING in higher quality! TRY IT! : )
Learn how to play the intro to the Metallica song Enter Sandman on the guitar.
Concerned with strangers entering your Second Life domicile? Learn how to use the visitor alert system in Second Life to alert you when avatars enter your space.
For the first time since its inception, the famously hidden System UI Tuner has to be unlocked in a new way. No longer can you long-press the gear icon (found in Quick Settings) until it spins and reveals the hidden settings option. With Android 9.0 Pie, there's a new workaround to reveal the menu.
Deep down inside, Android is really just a fork of Linux, the popular open source desktop OS. You can see traces of its roots everywhere, and this lineage still holds a certain appeal with many Android fans. If you're in that boat, you'll love the newest notes app we just found.
Another entrant — Aryzon — has joined the competition to be crowned as the "Cardboard of AR." The Netherlands-based startup launched their Kickstarter campaign Monday (May 29) and the campaign has already surpassed its funding goal. The company expects to ship units to backers in September.
An expert in the driverless market has earmarked Porsche as the company to watch in the automated car race.
The company that pioneered music scanning for mobile devices is moving into the augmented reality advertising arena. Included in an update of their iOS and Android apps last week, Shazam can now scan special codes to immerse users in 3D animations, 360-degree videos, mini-games, and other AR content.
Cortana, Microsoft's personal assistant for its Windows Phones and Windows 10, will soon be released for Android. That is, officially released. It's hard to keep a good thing locked away, and to that end, Cortana for Android has been leaked, thanks to APK Mirror.
While my desktop is usually neat and organized, it quickly fills up with screenshots each and every day. Usually, I end up putting them in a folder or just trash them, but why not make the entire process of taking and organizing screenshots easier by changing their default save location? With the help of Terminal, I'm going to show you how to change the default save location of screenshots to anywhere you want in Mac OS X.
Gmail is a free, advertising-supported email service provided by Google. Users may access Gmail as secure webmail, as well as via POP3 or IMAP4 protocols. Gmail initially started as an invitation-only beta release on April 1, 2004 and it became available to the general public on February 7, 2007, though still in beta status at that time. The service was upgraded from beta status on July 7, 2009, along with the rest of the Google Apps suite.
If you want to enter the police station armory in Detroit while playing Deus Ex: Human Revolution, you either need to have enough credits to afford it, or you need a high hacking skill. This video from Game Front will allow you to skip both of those requirements by giving you the password to the armory so you can take all the weapons you want.
Electronic waste is becoming more and more of a problem for the industrialized world, especially since most electronics are full of precious and rare-earth metals that should be recycled. Even gold! Enter this video. It will show you how you can use chemistry to strip the gold from your old computer and other electronic parts and, well, have more gold! Who doesn't want gold?
Tinder is difficult to come by in the best of conditions, but in a damp wilderness survival situation finding it can be downright impossible. Enter this video. It will teach you how to make solid fuel fire starters out of cotton balls and candle wax, which you can use to start a fire even in wet conditions.
Oil is vital to maintaining the health of your engine, but if it's leaving the areas of the car where it's needed it can cause major damage. Watch this video to learn how to diagnose whether a misfire is being caused by a cracked cylinder head or leaking head gasket allowing oil to enter your coolant and spark plugs.
Those damn Romulus followers and their shrines! Finding all of the shrines in Assassin's Creed Brotherhood is difficult but rewarding. If you're having trouble, watch this video to learn how to find and enter the Palazzo Laterno shrine and get the One-Man Wrecking Crew achievement / trophy.
Most combinations locks like the one you have / had on your locker need to be turned right, left, then right again to enter the combination and open the lock. Or so you thought! Watch this video to learn how you can unlock a lock with turns in the opposite direction by using a different combination.
In this tutorial, we learn how to apply for California food stamps. First, to go the website: California Food Stamps. After you are on this site, you will see a pop up where you can enter in your name and e-mail, as well as more information about food stamps in California. After you enter in your information, you will receive an e-mail with two links on it. One will be for the application and the other will be to find an office near you. Print out the application and fill it out entirely, fol...
In this tutorial, we learn how to block a website using a Linksys Router. First, go to your web browser and type in "192.168.1.1" into the address bar. After this, you will need to enter in your username and password to the pop up window. From here, go to the tab that says "access restrictions" and look for where it says "policy name". Type in 'blocked website' to the bar and then click 'enable'. From here, go down to the bottom of the page and enter in the URL of the website you want to bloc...
In this tutorial, we learn how to configure Outlook 2007 to work with Gmail. First, go to the start menu and then open up Outlook. From here, go to tools and then options. After this, go to the mail setup tab and then click e-mail accounts. Then, click on "new" and then next. Enter in your information in the blank boxes on the screen. Then, enter in your e-mail address and make sure the server is not checked on this screen. From here, you will continue to go through the wizard until it's comp...
In this video, we earn how to make a call on the Samsung Galaxy I7500. From the home screen, tap on the dialer screen, then tap on the dialer tab. From here, enter in the phone number you want to call. Then, press the dial key after the number has been entered. To end the call, press the menu key and then press the end call button. If you wish to call a contact, tap the dialer key and then tap on contacts on the top menu. Tap on your contact that you want to call, then tap on call mobile to c...
In this tutorial, we learn how to text message from the Palm Pre. First, tap the launcher icon. After this, find and tap on the messaging icon. From here, tap on the new message icon and then enter in the name or the number for the person you want to text. After this, tap on the bottom where you will enter in the message. Write out the text for the message, then when you are finished, tap on the send button. This is all you have to do to send a message from the Palm Pre, it just takes seconds...
In this tutorial, we learn how to file for unemployment in Michigan. In the state of Michigan, you can now file online or on the phone without standing in line. First, you will need to make sure you have all of your personal information and information from your previous job. Once you have all of this information, enter it into the phone or the internet when you are asked for the information. When you are finished entering in the information, you will be finished. The state will contact you i...
In this video, we learn how to partition a hard drive in Windows Vista or Windows 7. First, go to your computer and right click on your hard drive. Then, go to the management in the compute rand find disk management. From here, you will see your backup, factory image, and everything else on your computer. From here, right click on the computer and click "shrink volume" It will then pop up a new window where you will enter in the amount of space you want to shrink in MC. Once you enter this, c...