Guidelines Listed Search Results — Page 9 of 115

How To: Hide Friends List on Facebook

We know that Facebook is a very useful social media sites. This video will help you how to hide friends list on Facebook from others.

How To: Make Vegan Latkes Potato Pancakes

Just in time for Hanukkah! my easy vegan latke recipe (potato pancakes). You can find the full printable recipe here or you can watch me make them on YouTube in the video below. You'll find the ingredient list below the video.

Digital Tinfoil Hat: How to Block the Government & Other Privacy Invaders from Connecting to Your Nexus 7 Tablet

The NSA's massive internet spying efforts will continue. In President Obama's latest press conference, he went public to (in so many words) say that the NSA's spying efforts will continue uninterrupted. This, coming just weeks after the Amash Amendment which would have defunded the program, was narrowly defeated in the House (you can check if your congressmen voted against it here).

How To: Select different items in Finder in Mac OS

In this video, Gary from MacMost demonstrates how to select items on a Mac computer. He explains that there are different ways of selecting items, both with the mouse and with the keyboard. Click to select a single item, and click an empty space to clear the selection. Hold Command or Shift to add to a selection or remove items from the selected group. Drag around an area to select multiple items, and use Command and drag to add more areas. To select items in a list, click to select a single ...

How To: Fly stand-by

Need to leave town earlier or later than planned? Flying stand-by is not as simple as it used to be. Learn how to fly stand by - you never know when it may be necessary.

How To: Extract inconsistent name & e-mail data from a one-column list in Excel

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 712th installment in their series of digital spreadsheet magic tricks, you'll learn how to take bad data set up in one column and make a proper table of data for a mail merge as well as how to extract name and e-mail data from a list in one column where records are entered inconsistently.

How To: Copy a directory's listing to the clipboard in Windows

In this video tutorial, viewers learn how to quickly copy a folder's content list in Windows. Begin by clicking on the Start menu and open the Run program. Then type in "cmd" to open the Command Prompt window. Now navigate the desired folder and type "dir | clip" beside it. Press Enter and it will automatically copy the directory to the clipboard. Essentially, it is a tool that will the command prompt command to the clipboard. This video will benefit those viewers who use a Windows computer, ...

How To: Extract the top 5 values from a given list in MS Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 40th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the filter and advanced filter tools to extract the top 5 values from a list. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Use the WORKDAY & WORKDAY.INTL functions in Excel 2010

This video tells us the method to use the WORKDAY & WORKDAY.INTL functions in Excel. These functions are used to find a workday after a finite number of workdays in the future. WORKDAY uses Saturday and Sunday as off days. Its syntax is WORKDAY(start date, days, [holidays]). 'days' refers to the number of days in the future and holidays is the list of holidays written below each other in the same column. If Saturday and Sundays are not your off days, use WORKDAY.INTL. Its syntax is WORKDAY.IN...

How To: Get rid of chapped lips

This video involves beauty tips on how to get rid of chapped lips. The video starts out by listing items needed to take care of chapped lips; the first item listed is chap stick. The video specifically recommends a chap stick that has SPF protection. The other items needed are a tooth brush and a clean towel. The video next explains to rub chap stick on your lips. Next, a tooth brush is used on the lips in circular motions to remove dead skin cells. The purpose is to allow your lips to heal m...

How To: Determine whether a given item in a list in MS Excel

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 119th installment in their series of digital spreadsheet magic tricks, you'll learn how to determine if a particular item is in a list of items using two formulas: a ISNUMBER & MATCH function formula & a COUNTIF function formula.

How To: Use partial text matching in Microsoft Excel

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 309th installment in their series of digital spreadsheet magic tricks, you'll learn how to check to see if an item in first list is second another list, even if there is text before or after the item using the LOOKUP, SEARCH and ISNUMBER functions.

How To: Extract a unique list from a huge data set in MS Excel

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.

How To: Uninstall Internet Explorer 8 from Microsoft Windows 7

If Internet Explorer 8 is being a nuisance in Windows 7 watch this video to learn how to uninstall it! Start by clicking your Start Menu, then to Control Panel and then to Programs. From there click Uninstall Programs. It will bring you to a list of all the programs that are currently on your hard drive. Next click Turn Windows features on or off. From there another list of programs will appear, but these programs are all Windows programs that come with Windows 7 Operating system. Watch the r...

How To: Pack your luggage efficiently

Rafael and Zappos How To demonstrates how to pack your luggage efficiently. First, make a packing list to determine what you will need to bring on your trip. Go through your day in your mind and add things to the list accordingly. Don't forget your toiletries. Ideally bring one pair of shoes and coordinate your wardrobe accordingly. Lay out everything you will be packing and group them by like items. Don't put piles in your suitcase. Instead, roll your garment to prevent wrinkles and save spa...

How To: Build a compost pile for dummies

The video starts out with the narrator explaining the benefits and uses of a compost pile. He then begins to demonstrate the steps to start a compost pile. He lists the ingredients and demonstrates how to mix it up with a pitchfork and shovel. He advises to put brown organic matter such as wood chips, leaves, sawdust, etc. as the first layer in the pile. Then add a layer of green organic matter such as grass clippings. A layer of kitchen scraps or manure can be added. He then shows how and wh...

How to Use Logic Pro: Arrange Window

Get to know how to use Logic Pro's arrange page in this short tutorial. Use the arrange area to work with the audio of your song. Change the timeline by choosing a time and beat. Use the toolbar area to do some functions. Use the icons to easily open up media and list areas. Use the bin to store your audio. Use the browser to look for your audio songs. Use the event list editor to edit your MIDI information. Use the inspector to view the channel strips of your track. Use the editors in the bo...

How To: Using aluminum welding techniques in ice carving

This video demonstrates the usefulness of the aluminum welding ice carving technique. The technique allows carvers to easily "Get Outside the Block" and create sculptures that are hardly limited by the dimensions of the ice block.

How To: Set system shortcuts in Max OS X to the hotkey of your preference

If you want to create a shortcut in Mac OS X, or if you want to change the default hotkey for a function on your Mac computer, check out this quick tip from Tekzilla. It will help you learn how to access the system preferences on your Mac and gain access to the full list of keyboard shortcuts, allowing you to remove, add, or change all the hotkeys on your Mac.

How To: Do a dark, sexy Red Riding Hood makeup look

The Red Riding Hood movie by Catherine Hardwicke is a decidedly dark take on the story, which is pretty dark to begin with. This presents great opportunities for dark, sensual makeup both in the film and on your though, should you decide to watch this video and try out this dark, almost Victorian makeup take on Red Riding Hood.

How To: Make a high speed photography trigger with an Arduino

High speed photos are very artistic and look awesome, but taking them without special equipment is nearly impossible. Without this hack and an Arduino, that is. This video will teach you how to use an Arduino and other electronic components to make a DIY high speed photo trigger and take more awesome shots.

How To: Fix a broken back door lock on a Mitsubishi Endeavor

The Mitsubishi Endeavor, like most vehicles, has it's own list of common problems. One of them is the back door locks not working. Watch this video for a guide to diagnosing your door opening problem and, hopefully, fixing it successfully.

How To: Build a Warhammer 40,000 army out of only Eldar Harlequins

The Eldar Harlequins are some of the most charismatic and seldom-played models in the Warhammer 40,000 universe, but did you know that you can make an entire powerful army out of them? You can. Watch this video to learn how to make an awesome 1750 point army list out of Eldar Harlequins.

How To: Apply harder shoulder pressure from half guard in MMA or jiu jitzu

If massive strength is not among your list of strengths as an MMA or jiu jitzu fighter, you need to learn ways to apply harder pressure from the half guard in order to pass better. Watch this video to learn some details that will help with this from MMA Girls Hillary Williams and Joanne.

How To: Use Google Voice on an Google Android, Apple iPhone or BlackBerry smartphone

You don't have to have a smartphone to use Google Voice, but there are certain advantages if you do, including having your Google contact list at your fingertips. In this clip, you'll learn how to install and run Google Voice on most any smartphone.

How To: Create a Sophia Loren screen siren makeup look

Look up "bombshell" in the dictionary, and you're sure to find Sophia Loren listed as example numero uno. The beautiful Italian actresses, who was and is the epitome of womanly curves and sultry bedroom eyes, made waves during her film career with her raw sexuality, beauty, and confidence.

How To: Create a new contact in BlackBerry Messenger

Learn how to add someone to your contact list in Messenger on your BlackBerry. This clip will show you how it's done. Whether you're the proud owner of a BlackBerry smartphone or are merely considering picking one up, you're sure to be well served by this video guide. For detailed information, including step-by-step instructions, take a look.

How To: Create a new contact on your BlackBerry phone

Learn how to add a new contact to the contact list in BlackBerry phone. This clip will show you how it's done. Whether you're the proud owner of a BlackBerry smartphone or are merely considering picking one up, you're sure to be well served by this video guide. For detailed information, including step-by-step instructions, take a look.

How To: Build a PIR (passive infrared) motion alarm with MAKE

Want to build your own infrared motion detector? It's easier than you think! So easy, in fact, that this video tutorial from MAKE can present a complete overview of the build in under five minutes! For more information, including a full list of materials and detailed, step-by-step instructions, and to get started building your own passive infrared motion alarm, take a look.

How To: Use the "word choice window" when texting with Swype

Sometimes there is more than one option for a particular finger Swype. When this happens, Swype will give you a list to choose from so that you can pick whichever word you were hoping to use. Swype is the fastest way to send texts and e-mails available and with a bit of practice you will have it mastered. Just think of Swype as the T9 of 2010 and you will catch on fast.

How To: Make kalua pig (Hawaiian-style pulled pork) at home

Want to make kalua pig for your next backyard luau without going whole hog, so to speak? Never you fear. This free video cooking lesson demonstrates an easy-to-follow Hawaiian-style pulled pork recipe. No imu required. For detailed, step-by-step instructions and a full list of ingredients, watch this tropical culinary tutorial.

How To: Remove the inside rear door panel on a Nissan Altima

In this video richpin explains to us how to remove the inside rear passenger-side door panel on a Nissan Altima. He doesn't explain why you would want to do this, but if you feel compelled to, herein you will find the most detailed instructions you could ask for. Here is a list of the readily available tools that he uses:

How To: Make a dynamic stock price line chart in MS Excel

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 230th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the Excel List Table feature to make a dynamic stock price line chart.

How To: Make a buttermilk substitute

Buttermilk is a great thing to have around in your kitchen. Unfortunately, most of us don't have buttermilk on our regular grocery list, so those buttermilk pancakes will have to wait for another day. Think again! You can easily make tasty buttermilk alternatives with common refridgerator items. This video will show three easy ways to make a buttermilk substitute.