Indexing Social Search Results

How To: Use Social Engineering to Hack Computers

Today I am going to teach the various ways that you can use social engineering to hack a system. For those of you that have followed my past tutorials, you know that social engineering can unlock a world of possibilities. This is because no matter how many firewalls, no matter how many patches there are on a server, the password is kept in the minds of people...and people, are not as smart as computers.

How To: Retrieve the cell address of the minimum value in a column 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 730th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that will retrieve the cell address of the minimum value in column. To accomplish this, you'll use the ADDRESS, MATCH, INDEX, MIN, ROW and LOOKUP functions.

How To: Find, download and use an FTP client

Select an FTP client that allows you to connect to the webserver. Download a free Core FTP Le software. Install the program. Use the site manager to name the internet site. Create a host/url, a user name, password and a connection. Connect to the web server. Create an index file to make files viewable. Open the Core FTP LE software. Drag files from the desktop (left side of the dialog box) to the internet server (right side of the dialog box.)

How To: Create a dynamic frequency table & 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 636th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic frequency table and histogram chart using defined name formulas for dynamic ranges that use the INDEX function. See other formulas that use the COUNTIF, IF and ROWS functions that help to make it fully dynamic....

How To: Do reverse lookups with VBA code 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 and Mr. Excel, the 7th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to complete a reverse lookup (find value inside table and then retrieve column and row header). Mr. Excel uses Excel VBA code (macro) and ExcelIsFun uses a formula with the INDEX, IF, SMALL, MATCH, TEXT, CHAR and...

How To: Retrieve data from many tables on many sheets in Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 77th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to do a complicated payroll formula when tax data must be retrieved from multiple tables. See how to use the INDEX, INDIRECT AND MATCH functions in one big formula to retrieve tax data from multiple tables on multiple sheets. Learn to love digital spreadshe...

How To: Calculate variable commission totals in MS Exce

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 46th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the DOLLAR, VLOOKUP, INDEX and MATCH functions and a previous bracket commission formula trick to calculate total commissions when you have variable commissions paid out. Learn to love digital spreadsheets more perfectly with the tricks outlined in t...

How To: Hold your guitar pick for different types of chords

In this how-to video, you will learn how to hold your pick in different ways for certain styles of guitar playing. You must have a pick and guitar. Hold the pick between your index finger and thumb. Feel free to modify the way to hold it so that you are comfortable with it. For strumming, keep your picking hand loose. This will allow you to comfortable strum up and down. For picking chords, relax your picking hand and allow the pick to be slightly more perpendicular when picking. For shreddin...

How To: Return a row's first non-blank cell 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 364th installment in their series of digital spreadsheet magic tricks, you'll learn how to create an array formula using the INDEX, MATCH & NOT functions that will return cell content from the first non-blank cell in a row.

How To: Return every tenth value in an Excel spreadsheet

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 278th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the INDEX and ROWS functions to write a formula that will return each 10th value and place them all in a column.

How To: Create a dynamic break-even chart 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 576th installment in their series of digital spreadsheet magic tricks, you'll learn how to add a point and a dynamic label to a break-even chart that marks the breakeven point using INDEX and MATCH functions. This point is dynamic and will change if data is changed.

How To: Extract the three largest values from a list in Excel

New to 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 Excel tutorial from ExcelIsFun, the 162nd installment in their series of digital spreadsheet magic tricks, you'll learn how to deal with duplicates with the MATCH function by using the COUNTIF function. This is accomplished with recourse to Excel's IF, OR, LARGE, ISERROR, MATCH, INDEX and COUNTIF functions.

How To: Use an array formula to filter data in Excel

New to 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 Excel tutorial from ExcelIsFun, the 574th installment in their series of digital spreadsheet magic tricks, you'll learn how to streamline filtering when you have categories of criteria using an array formula that uses the functions COUNTIF, VLOOKUP, ROWS, IF, INDEX, SMALL, and ROW. Also see how to put OR criteria into the IF function as well as how to do an OR coun...

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: 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: Spin a magic card trick

Place the card in the center tip of your middle finger. The card should balance on your finger and you can test this by wobbling the card on your finger left and right without it falling off of your finger. Try to spin the card with your other hand. If it falls off your finger it may have been off center. Next, use your thumb, placed on top of the card to stabilize the card. Raise your thumb above the card. With your index finger, lightly pull the card toward your palm and generate a spinning...

How To: Wrap your hands for boxing like a gym rat

In this video tutorial, viewers learn how to wrap the hands for boxing, MMA and kickboxing. Begin by putting the thumb through the loop and bring it under the palm. Wrap it one time around the wrist. The cross it through the thumb and index finger. Wrap around the knuckles 3 times. Now cross it behind the thumb and over. Then go under the wrist and over the thumb again. Then go over the wrist, under the palm and through the pinkie and ring fingers. Roll around it to secure and repeat for othe...

How To: Play "Tears In Heaven" by Eric Clapton on guitar

Ballinguy556 shows you how to play "Tears in Heaven" by Eric Clapton. You need an acoustic guitar to begin. You will be learning the main riff. Take your thumb and play the open E string, hammer thumb on E string and then play the open the A string. Then play the A cord bar. Then pluck E, G, E strings. Move your D cord up a step and low E. Play a F cord together and the base next. Then play an open E the same. Then play a D in the same together, base pattern while lowering your index down a h...

How to Play bass: Two handed tapping technique

This video is a bass lesson that demonstrates how to use a two-handed tapping technique often used by Eddie Van Halen and others on guitar. To do this on bass, you should put your middle finger over the top of your index finger to make a more solid tapping finger, and put your hand up the neck with your thumb on the back of the neck. Land your finger to tap, and pull to pluck the string. He places his left hand on the frets in anticipation of pulling the string with the right hand. He demonst...

Get free redirecting domains: (.co.cc, .co.nr, & .tk)

In this video from VvCompHelpvV we learn how to get a free redirecting domain name which would be any one of these: .co, .cc, .co, .nr, and .tk. This is basically a redirection URL that brings you to the same site but with better words o more professional looking. The first way he shows is and then the next one is [http://www.freedomain.co.nr] and the final one he shows is [http://www.dot.tk]. He recommends using the co.cc domain because those get indexed apparently.

How To: Make fresh rolled sushi

Learn how to make delicious sushi like a real chef. You may think sushi is just raw fish, but you’d only be half right. It’s actually the combination of fish and rice – and how it’s combined is an art form in itself.

How To: Instant zoom on your social network photos

Install this new add-on for Mozilla Firefox and show full-size images from Flickr or Facebook just by hovering over the thumbnail or link. This add-on shows the full-size images in a floating panel without having to open a brand new browser page. Thumbnail Zoom also works on MySpace, Amazon, Picassa, Twitter, LinkedIn, Hi5, Twitpic, deviantART, PhotoBUcket, Tagged, last.fm and Wikipedia. Veronica from Tekzilla Daily demonstrates all the cool features.

How To: Change your Facebook Places privacy settings

Want to know how to turn off Facebook Places? This quick clip from Lifehacker will teach you everything you'll need to know. Whether you're completely new to the Facebook's popular social networking site or simply require a small amount of clarification on how to deal with the Places feature, you're sure to benefit from this helpful video guide. For more information, including detailed, step-by-step instructions, take a look.

How To: Change the web address of your Facebook profile

Looking for instructions on how to change your Facebook URL? This clip will show you how it's done. Whether you're completely new to the Facebook's popular social networking site or simply require a small amount of clarification on how to perform a particular task on Facebook, you're sure to benefit from this helpful video guide. For more information, including detailed, step-by-step instructions, take a look.

How To: Give and accept gifts in FrontierVille (7/3/10)

One of the great things about paying social networking games like FrontierVille is that you and your friends can help eachother win. This video will you show you how to give and accept gifts with your friends and neighbors in FrontierVille, allowing both of you to achieve much more than you could have alone.

How To: Get started on Facebook

In this video, Bea Fields will show you exactly how to set up and use a new Facebook account. Facebook is an awesome social networking utility that can keep you in touch with friends, family and other loved ones. If you have never used this online utility before, check out this video and get started. You will be on your way to thousands of "friends" in no time.

How To: Use Google Buzz on your Android phone

If you have an Android phone it's easy to use Google Buzz. 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, discusses how to access, read and use the Google Buzz social networking/microblogging tool.

How To: Import a Wordpress blog to Facebook

Matthew Loop, DC is a successful chiropractor who has learned how to use social media to his advantage. In this video, you'll learn from Dr. Loop how to import a Wordpress blog to Facebook quickly and easily. Dr. Loop's instructions are simple, and easy to follow. Importing your blog should be a snap! If you've ever been wondering how you can integrate your blog with Facebook, this video is for you.

How To: Display impeccable manners

You’ll probably never have to greet the Queen, but everyone should know some basic etiquette rules. Learn proper manners with this how to video. You will need an appreciation for social niceties and a good memory.