Advanced Skills Search Results

How To: Use the Mail email app on an Apple iPad

If you want to send and receive email on your Apple iPad, unless you're an advanced user, you'll most likely want to go through Apple's official Mail app. Fortunately, it's easy to use. So easy, in fact, that this guide can present a complete, step-by-step overview of the process in just over three and a half minutes' time. For detailed instructions, and to get started reading and composing email on your own iPad, take a look!

How To: Do a yoga flow into a handstand with Tara Stiles

Despite common misconception, yoga is extremely intensive and a challenge for core stability and muscle stability, especially when you encounter poses like handstands. Not easily done by even the most experienced yoga experts, handstands are a true test of your yoga prowess and ability to say "ohm" with two feet up in the air, arms aching and trembling.

How To: Install the Window Seal Onto a VW Bug Window

Restoring any car can be a difficult task for even the most advanced mechanics. It takes time and patience to turn an old pile of junk into something new and beautiful. So in this tutorial, you'll find out how to install new window seal and trim onto a classic VW Beetle Bug. It's fairly easy to do and in the end, will result in a great looking vehicle. Good luck and enjoy!

How To: Adjust the brightness on your Android phone

Some people like their screens to be dim while others like theirs to be bright. Some like brightness to automatically adjust, while others like a constant level. 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 will show you how to adjust the brightness of the d...

How To: Map a walking route with MapMyWalks on Android

Take walks for exercise, to roam around your neighborhood, or just to get outside? Want to know how far you walked? Well, it's easy to do with MapMyWalks and Google Maps! 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 will show you how to map out your walks us...

How To: Manage running services on your Android phone

With some mobile devices you can't be certain exactly what's running and it can be difficult to stop programs. Not true on your Android device. You can easily look at running services and stop them if desired. 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...

How To: Use location and security settings in Android

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...

How To: Extract email extensions with filters 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 338th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the REPLACE and FIND functions in a new column to extract e-mail extensions, and then use Filter or Advanced Filter to Extract records according to e-mail extension.

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: Build a mini fridge

In order to build your own mini fridge, you will need the following supplies: a heatsink, a cardboard box, a petier unit, popsicle sticks, standoffs, an AC adapter, scissors, and on/off switch.

How To: Do hip pushups

In this Fitness video tutorial you will learn how to do hip pushups. This one is for advanced body builders and not for beginners. You can use push up stands or use towel to cushion your fists while doing hip push ups. This is not to be done with palms open. Keep your elbows on your sides and you will be pushing from your hips. Stretch your body with the weight on the fists and toes. Keep your torso straight, abs flexed tight, then go down slow and come up slow. The body should be straight. D...

How To: Apply cologne properly

In order to apply cologne properly, you will need to choose the best cologne for you in advance. The cologne will need to mix well with your own natural scent. It is important to avoid overuse. Stick to a three (3) spray rule: never exceed 3 sprays. The distance from the body is important. Therefore, you should spray a distance from your body.

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: Do the "air chair" in breakdance

Have you mastered the beginning break dancing tricks and are looking for something a bit harder? Try the "air chair". To do the air chair in breakdance, you'll need to already know how to do a chair, because the air chair is an advanced version of the chair. Get the air chair down with help from an expert.

How To: Group duplicates & extract unique records 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 577th installment in their series of digital spreadsheet magic tricks, you'll learn how to use SUMPRODUCT and the join symbol (&/ampersand) to group duplicates and then see how to use advanced filtering to extract a list of unique records.

How To: Create a daily Gantt Chart in Microsoft Excel

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 two-part Excel tutorial from ExcelIsFun, the 564th installment in their series of Excel magic tricks, you'll learn how to create a cell chart using conditional formatting with Logical TRUE FALSE formulas to create a Gantt Chart. Functions used include WORKDAY, AND, NOT, NETWORKDAY.

How To: Use VLOOKUP with multiple lookup values in Excel

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 488th installment in their series of digital spreadsheet magic tricks, you'll learn how to use VLOOKUP with multiple lookup values. You'll also learn how to add an extra column with a unique identifier to data set using ampersand concatenate.

How To: Find the percentage of total from a DB set in Excel

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: Summarize data from multiple sheets in Microsoft Excel

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 506th installment in their series of digital spreadsheet magic tricks, you'll learn how to summarize data from multiple sheets. For example, you'll see how take checkbook register data from multiple banks accounts and summarize it based on account names.

How To: Make date & time calculations (sans weekends) in Excel

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 533rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula to calculate the difference between start date/time & end date/time excluding holidays and weekends. This is accomplished with recourse to Excel's NETWORKINGDAYS and MOD functions.

How To: Format dates with the WEEKDAY function in Excel

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 534th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the OR and WEEKDAY functions to create a logical true/false formula that will automatically apply formatting to dates that are either weekends or holidays.

How To: Create dynamic sub tables in Microsoft Excel

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 538th installment in their series of digital spreadsheet magic tricks, you'll learn how to create dynamic sub tables based on master sheet array as well as how to create array formulae quickly with the Drill-Through method. All this is accomplished with recourse to the COUNTIF, IF, ROWS, INDEX, SMALL, ROW functions.

How To: Create an Excel Gantt Chart by conditional formatting

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 477th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a Gantt cell chart using conditional formatting. This is accomplished with recourse to the WORKDAY.INTL, AND, NOT & NETWORKDAYS.INT functions.

How To: Extract records that meet certain criteria in Excel

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 186th installment in their series of Excel magic tricks, you'll see how to extract records that meet two conditions (criteria) and list them in order with no extra rows between records as well as how to create a formula to extract part of a table from a larger table based on two criteria. (All of this is accomplished through us...

How To: Configure & check the firewall in Windows 7

In this video, it demonstrate how to check and configure Windows firewall. In order to check to see if firewall is enable or not. You would click on start which locate bottom left corner of the screen. Then you would click on control panel. On this screen you would see an option for firewall, and click on it. When you click on firewall, it will let you view all the description about firewall configuration. There are also many other option which locate on the left hand side. If you are an adva...

How To: Change the color of any object in Photoshop

The video explains how to change the background color of objects using Photoshop in a simple manner. This way is better quick mask mode, because this way is more efficient and more advanced. First you click control G, Image control color and then you take the Image samples. The tutorial shows how the oranges are changed from their original color into a reddish color. Then it shows you how it adjusts the shadows of the oranges and the color of the leafs. The video is quick and it explains full...

How To: Defragment the hard drive in Windows 7

De-fragmenting a hard drive improves the performance of a hard drive and it is recommended to de-fragment your hard drive from time to time as shown in this video. In Windows 7 you can use the Disk De-fragmentation tool. To do this go to the start menu and open the Control Panel. In the right column select the Performance Information and Tools. Now in that window in the left hand column select the Advanced tools option. In that new window scroll down to the Open Disk De-fragmenter link. Click...

How To: Sort table contents in MS Word 2007

This is another HelpVids.com technology video. This video will teach us how to sort table contents in Microsoft Word 2007. The video starts out with a Word 2007 document with a sample table. When you click on the table, you will see the Table Tools tab appear above the ribbon. Click the Table Tools button, then click Layout and finally the Sort Button. The sort dialog box allows you to choose which column to sort by, which direction you would like to sort, and any secondary sorting you would ...

How To: Play "Band on the Run" by Wings / Paul McCartney

This video is an acoustic guitar lesson from yourguitarsage. In this video, he teaches you how to play the song "Band on the Run" by Wings & Paul McCartney. He begins by playing the song for more advanced players to watch and learn from. Then follows up by showing you which chords you need to know to get started on learning the song, and demonstrates them for users who may be still learning. He then moves on to the progression of the chords through the song, teaching you the intro, verse, bri...

How To: Make a spooky Halloween paper bag mini album

Halloween is just around the corner and this spooky paper bag album you can really create a masterpiece. If you love scrap booking this project would be a blast for you. All items were bought for less than a dollar at the local dollar store and the detailing is quite manageable from intermediate to advanced scrap booking. So if you have time and patience to make this then get ready to create an album ready for any Halloween adventure. In this video you will learn how to make a spooky Hallowee...

How To: Play "Use Somebody" by Kings of Leon on guitar

This video is an acoustic guitar lesson from yourguitarsage. In this video, he teaches you how to play the song "Use Somebody" by Kings of Leon. He begins by playing the song for more advanced players to watch and learn from. Then he follows up by showing you which chords you need to know to get started on learning the song and demonstrates them for users who may be still learning. He then moves on to the progression of the chords through the song. With the help of this video you will be play...

How To: Change your profile background on YouTube

In this video from Tiffany0x we learn how to change your profile background on youtube. First she goes to google, then clicks on images and type in whatever image you're looking for for your background. Then copy the image's link in your browser. Then go to youtube. Click My Account. Then you'll see Channel Settings. Click that, then click Channel design. In Advanced Customizations you'll see a place where you can put in a Background URL. Paste the URL into that box. Once you have done that, ...

How To: Play "Can't Buy Me Love" by The Beatles on guitar

This video is an acoustic guitar lesson from yourguitarsage. In this video, he teaches you how to play the song "Can't Buy Me Love" by The Beatles. He begins by playing the song for more advanced players to watch and learn from. Then he follows up by showing you which chords you need to know to get started on learning the song, and demonstrates them for users who may be still learning. He then moves on to the progression of the chords through the song.

How To: Install a bicycle computer

PerformanceBikes will show you how to install a bicycle computer. Whether you have a simple computer or a more advanced computer you be able to see the basic instructions. Start by reading the instruction, install the handle bell mounts, install the wireless transmitter. You then install your spoke magnet, then calibrate your computer for your wheel size. Make sure you have read your own particular directions. If its not working, make sure you re-read your instruction, check your set up or ch...