Many applications, especially those found in the Android Market are more effective when they know your physical location; like an app that's going to find the nearest gas station, restaurant or ATM. 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, in particular...
Lighting is very important to photography. The proper lighting can make your subject or scene appear in a totally new way. Whether you are adding, or eliminating shadow, using light to manipulate the way something looks, or just setting up for a flattering portrait, you will need to know some light basics. In this tutorial, Mark will show you how to set up lighting for a fantastic picture. You will learn seven different setups to make sure you have the right arrangement for your particular ne...
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 5th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create horizontal subtotals for a data set using the IF, SUM and SUMIF functions. Also see conditional formatting for non-contiguous cell ranges using a TRUE/FALSE logical formula with the NOT symbols.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 70th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to clean up a bad data set with the TRIM function before building a pivot table (PivotTable) to calculate an average. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
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, Chef Steve Ricci shows how to prepare a recipe called grilled polenta with wild mushrooms the easy way. The ingredients for the recipe are polenta, vegetable stock, butter, mascarpone cheese, parmesan, balsamic vinegar, mushrooms and olive oil. The polenta is added to boiling vegetable stock. To this is added butter, mascarpone and parmesan. The mixture is allowed to thicken and then refrigerated. Saute the mushrooms in a pan with some olive oil till its cooked. The set polenta...
If you just purchased an Android enable mobile device with Bluetooth, then one of the main objectives you'll have on your to-do list is to set it up in your vehicle for hands-free dialing and phone calls. Activating Bluetooth inside your car is easy, and all you need to remember is a little number called zero. Actually, you need to remember it 4 times — Best Buy has answers. The Best Buy Mobile team explains how simple it is to activate Bluetooth settings on an Android cell phone.
In this video, we learn how to roast garlic. Roasted garlic is a grea thing to have for several different recipes that adds an extra something to anything! To do this, grab a saucepan and place raw garlic into it, then pour some olive oil over it. You will now put the garlic into a preheated oven at 300 degrees for 20-30 minutes. Once it's done, you will pull it out of the oven and it will be golden brown. If you don't want to use the garlic right away, set it in olive oil and place it into t...
In this video tutorial, viewers learn how to use the Sticky Keys feature in Microsoft Windows 7. To use the Sticky Keys, click on the Start menu and open Control Panel. In the Control Panel window, double-click on Ease of Access and click on Change how your keyboard works under the Ease of Access Center. Then click on Set up Stick Keys and check the option Turn on Sticky Keys. This video will benefit those viewers who have limited dexterity and find it difficult to use complex keyboard shortc...
In this how-to video, you will learn how to set up Windows 7 that system alerts will come up as images rather than sounds. First, go to start, control panel, and click on ease of access. Next, at the top of the window, click replace sounds with visual keys. Check the box that says Turn on visual notifications. You can choose the different types of visual warnings, such as flash desktop or flash active caption bar. Once this is done, click okay to complete the task. Now your computer is set up...
This how to video shows you how to change the voice in the VoiceOver Utility program on a Mac. This will be useful if you want a voice that is more realistic or more understandable. First, open the program and choose the speech pane. On voices, click the drop down menu to choose which of the voices you want to use. At the side of this, you can change the rate, pitch, volume, and intonation. To change the voice settings with just the keyboard, press control option and command together. Use the...
This video teaches how to change Windows 7 accessibility options. Choose Start, Control panel. This opens the Control Panel window. Choose Ease of Access in the control panel window. This opens Ease of Access window. Inside the Ease of Access window, there are various links that allows you to set various accessibility options in windows 7. You can use these settings for options like "Optimizing Visual Display", "Replace sounds with visual cues" and you also have settings to choose how the way...
This video shows us how to use the following functions in Excel: average, count, counta, min, max, and sum. First, start off by create a set of numbers to work with. After that, click on an empty cell that you want to use for the functions. To do an average, click on the functions button on the top right corner of the menu bar, you'll see a list of all the functions that are available. Select average, and then highlight all the numbers that you want to find the average of. Repeat the exact sa...
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, ...
Windows 7 provides the high contrast display feature for the monitors. To use this feature go to the desktop. Right click and select 'Personalize' from the menu. This brings up the Personalization window of the 'Appearance and Personalization' option of the Control Panel. Here you can change the visuals and sounds of your computer. Scroll down in that window till you find high contrast themes. Choose one of those themes. When you select them Windows automatically applies the theme to your com...
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 581st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the advanced filter tool with criteria to extract a unique list of employees for each department from a huge data set with transactional records.
If something happens to your iPod or iPhone and you can't remedy it with a reboot, you will need to restore your device to factory settings. This is not difficult to do and requires only your computer and your device. You should only restore your iPod to default if absolutely necessary, because you will lose all of your files and folders. Make sure you backup your music and photos before you do it! Good luck!
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 97th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AVEDEV function to measure the spread (variation) in a data set. Also see the STDEV function and learn how to measure whether a mean represents its data points fairly.
In your computer you can setup up two monitors on the same screen. This is the dual monitor setup which will give you more space to work with. So if your desktop is cluttered with icons and other program shortcuts, then you can use dual monitors. To setup a dual monitor system, the first thing you will need is two monitors. Now right click no your desktop and select properties from the menu. In the properties window go to the settings tab. If you see two monitor screen pictures over there the...
In this tutorial, Malou and Bob show tips and tricks to use an HP TouchSmart computer. First, you can touch the house button that will lead you to the home page. The computer is so sensitive, it will detect your touch without even having to touch the screen. When you select an object, press and hold it if you want to move it somewhere else, if you move it to the bottom on your homepage it will go into the designated area. If you press and hold your finger on the screen, it's just like right c...
Beauty Newbie suggests determining the shape of your eyes to create dramatic makeup looks using eye shadow. For close set eyes, you'll need to create more space between your eyes. Try applying a light shade on the inner third of your eye. Then, on the outer part of your eye add a darker shade. Its not necessary to always use three shades, although it does enhance the end result. If your eyes are wider set, you'd just do the opposite of the close set eye technique. If your eyes are deep set, A...
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...
Mike Callahan will show you the tricky process of changing the screen timeout on your Android cell phone. While some people like their screen to black out right after they finish using it others prefer it to stay lit for a while. Mr. Callahan shows you how to change the setting regardless of how you like it. First tap on settings. Next, tap on sound and display. Then, you are going to want to scroll down until you get to screen time out. After selecting the screen time out option, you will ha...
Twitter is the latest popular social networking forum. Twitter is used to keep your friends updated with what you are doing using 140 character messages called tweets. In twitter you can follow your friends and you will be notified when ever your friends posts a new message. Similarly other people can follow you on twitter to know what you are doing. In twitter you can customize to send an automatic private response to your new followers. To do this open your twitter account. Go to the notice...
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 480th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate a percentage of total from a database data set when the variable of interest is text (word). This is accomplished with recourse to the COUNTIF, SUM & COUNTA functions.
How To Make Anything demonstrates how to upload YouTube videos in high definition. To upload your video so the HD button becomes available to YouTube viewers, go into your video editor and set your project properties to 1280 x 720 which is the high definition resolution YouTube looks for to give you the HD option. Then, when you render your project, set your rendering parameters to a format like WMV and check to make sure that you're getting the HD image size upon output. Once your video is r...
Here is another video by a woman named Angela on how to make a miniature Christmas log cake for a dollhouse. The first thing she does is roll out a sheet of brown clay with a pasta maker on a setting of 4. Then she rolls out a white sheet with smaller setting of 6. Use a razor blade and cut some straight edges. She layers the brown and white layer and rolls them together. Cutting off the ends she has now created a log cake. Use these ends for slices of the cake for dolls. She then uses a pepp...
In this episode of Digital Photography 1-on-1, host Mark Wallace goes in depth on the subject of light metering and flash balancing. Making use of a Sekonic light meter, Mark shows how to read the light levels in a room, and explains how to interpret those readings in order to adjust flash levels, ISO levels, and alternative light source manipulation. Mark also goes over the important roles that aperture settings and film speeds play when attempting to successfully balance flash and ambient l...
In order to add a nice contrast punch to an image using Photoshop, go to your adjustment layer and click on the black and white adjustment layer. Then go to your "blend modes" and change it to "overlay". If you find that the effect is too harsh you can adjust your opacity settings or you can switch your blend mode to "soft lights". In "overlay" using the black and white adjustment panel you can change your settings to meet your preference. If you are using a previous version of Photoshop that...
In this video from lkobet1 we learn how to curve a soccer ball. It is very useful for free kicks and set pieces. First you need to focus on getting a good position on the ball. Set up the ball on a really good piece of grass. Put your foot where you will land to kick it. Take a few steps back. Kick the ball with the side of your foot, not your instep. Come through the ball and across your body. That's the key to curving it. Coming through the ball when you kick with your leg will make the bal...
Ever have the problem of people messing with your word documents? This guy shows you the solution by telling you how to create password protected encrypted word documents. The process starts with your open file. Clicking on save as... and in the popup window clicking the tools button in the bottom left corner and clicking general options. There it shows you text entry boxes, one for setting a password to open the file, another to set a password for rights to modify the file. Enter your passwo...
This is a Video clip presentation from all3sports guides us on how to check and assemble the unpacked shipping box. The first step to assemble the motorcycle involves inserting the seat lifter to the reasonable depth and tighten the screws. After that attach the handle bars and front brake and make sure that there is an equal amount of gap between the top and bottom of the handle bars. Then, check the brake cables are properly fit. Then, assemble the arm gauge or arm rest with the two sets of...
This video is a tutorial on how to set the screensaver in Windows 7. To start, you need to click on the start menu. Next, click on control panel. Click on the personalization link in the first column. On the next screen, go to the bottom right and click on the box labeled 'screensaver'. It will open up a new window. From that window, you can click on the drop-down menu to select a variety of screensavers. You can see the preview of the screensaver in the animation above the buttons. You can a...
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 ...
Bill D., the tech lead at all3sports.com takes us through the steps involved in unpacking and assembling a brand new bicycle. The first he says is to set up or insert the seat post. He recommends using a work stand if you have one at home. He says not to unpack everything at the beginning, but to just expose the seat pack first. Use a wire-cutter to get rid of the film protection used for packing. He has mounted the frame-set on the work stand. The seat post goes into the frame-set. He asks t...
This video demonstrates how to show and hide the ruler in Microsoft Word 2007, along with working with page margins. The presenter indicates that if you click the small button above the vertical scroll bar, Microsoft Word will then display Rulers. To work with margins you'll need to click on the Page Layout tab to display the Page Layout ribbon. The video shows the different options located on the Margins menu. There are several built in settings for wide, narrow, normal, moderate, and mirror...
In this video from FiveSprockets we learn how to light an interior space while filming on a budget. For this you need two Chinese lanterns which he found for $2.95 each. You need 2 light bulbs which he found for $3.95 each. Make sure you get extra ones. Then get a couple of pan lights. They are day light and mood light. They were $7 and $5. You also need a multi colored gel pack which is $6.00. He uses C-stands to hold the lights up but he suggests coming up with other ways if you don't have ...
Follow along as we are shown how to set a password for a new user in Windows 7. -First, go to the Start menu.
Have a passion for photography but know nothing about the basics? This video might be a great place to start on the topic of shutter speed. Shutter speed is the amount of time that the film, or your digital sensor, is exposed to the light. Whether it be outdoors, at night, or low indoor light, the shutter speed allows your camera to take a photograph with the correct amount of exposure in reference to how much light is readily available in your setting.
David Rivers is back to give us some more tricks on using MS Outlook 2010. In this video he tells us how you can avoid sending email to the wrong person by setting up some email preferences in MailTips. MailTips actually has the ability to alert you when you are about to send an email under certain conditions. Don't worry about sending an email to your boss that was meant for your co-worker. Your MailTips folder contains many options that you can use to restrict some of your outgoing mail and...
