Dating Tips Search Results

How To: Talk to girls

Everybody needs a little dating advice, especially the men… or boys! Alec Greven, the nine-year-old author of "How to Talk to Girls" shares some of his successful tips on talking to girls. And surprisingly enough, this dating information can be applied to all ages. Are you smart enough to take over a girl's heart? See how to talk to girls!

How To: Make a Scorpio fall in love with you

Playing hard to get doesn't work with a Scorpio; they only respond to slavish devotion. So drop everything and dedicate your time solely to the Scorpio in your life. Learn how to use astrology advice in dating, by watching this how-to video. Pick up tips on making a relationship with a Scorpio work.

How To: Create random dates within a set range 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 and Mr. Excel, the 26th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create random dates between upper and lower dates using the 4 different formulas that use functions such as RANDBETWEEN, RAND, INT and DATE.

How To: Extract dates and times from a database field 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 312th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the DATE, MID, LEFT and TIME functions to extract dates and times from a database field that stores dates and times as a text string.

How To: Create date labels with YEAR, DATE & TEXT 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 300th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the YEAR, DATE and TEXT functions and the ampersand (concatenation) to create a date label that adds leading zeros appropriately.

How To: Conditionally format dates & weekends 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 137th installment in their series of digital spreadsheet magic tricks, you'll learn how to apply custom number formatting as well as how to conditionally format dates and weekends using a TRUE FALSE formula with the AND and WEEKDAY functions.

How To: French kiss

This instructional dating video demonstrates how to improve your French kissing skills. Pay attention to these tips to formulate the perfect kiss. Keep your eyes closed, watch your hand movements, and pick a side of the face to aim for. Make sure to do a little lip locking and kiss that lovely person's face before moving in for a serious French kiss.

How To: Make an Aries fall in love with you

The Aries man or woman can be tough to figure out, but this video shows how to push all the right buttons. To trap an Aires you will need a love of athletics, a go with the flow attitude and a thick skin. Learn how to use astrology advice in dating, by watching this how-to video. Pick up astrology tips on making a relationship with an Aries work.

How To: Make an Aquarius fall in love with you

Aquariuses have high standards, but anyone with the right drive can meet them. Use your creativity, knowledge of art and music, and good social skills to trap that Aquarius. Learn how to use astrology advice in dating, by watching this how-to video. Pick up astrology tips on making a relationship with a Aquarius work.

How To: Make a Sagittarius fall in love with you

It’s easy enough to reel in a Sagittarius, but it’s nearly impossible to keep one faithful. Learn how to use astrology advice in dating, by watching this how-to video. Pick up tips on making a relationship with a Sagittarius work. The best advice for dating a Sagittarius is to be a good audience. A Sagittarius loves people who are always willing to be quiet and listen to their problems, and this video also advises you to love the outdoors and work on that non-possessive nature.

How To: Use Excel's VLOOKUP with dates to retrieve the season

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 353rd installment in their series of digital spreadsheet magic tricks, you'll learn how to make date calculations with Excel's VLOOKUP formula (e.g., finding approximate matches and returning a season for a date within a given range).

How To: Do date calculations 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 12th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate the time between 2 dates like invoices past due. Learn how to calculate a loan due date or how many days you have been alive!

How To: Count dates within a given month 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 220th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula with the SUMPRODUCT and EOMONTH functions that count the dates in each month for a given range of dates.

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: Work with date functions (TODAY, NOW, DAY) in MS Excel

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 12th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the TODAY, NOW, DATE, YEAR, MONTH, DAY and EDATE functions.

How To: Seal the deal when flirting with someone you like

In this clip, you'll learn how to ask someone you like on a date when flirting with him or her. As a general rule, when flirting with someone, it's important that you be confident and natural. But, if you're feeling nervy, there's little shame in doing a little prep work with silly videos like this one. For more information, and to get started using this tip for yourself, take a look.

How To: Count dates falling within a given year 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 632nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula using the SUMPRODUCT and YEAR function to count instances of the year 2009 or 2010 from a list of dates with different years.

How To: Highlight dates falling within a given year 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 633rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create conditional formatting that will highlight the dates within a given year using the Year Function and Mixed Cell References in a logical TRUE-FALSE formula.

How To: Use Microsoft Excel's undocumented DATEDIF function

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 151st installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate the days, months or years between two dates using Excel's undocumented DATEDIF function.

How To: Have a long distance relationship

Professional Matchmaker, Samantha Daniels gives advice about how to date someone long distance. Long distance relationships are the most difficult relationships to have because you don’t have the easy and spontaneity of a regular relationship. However, if the person is worth it, you can make a long distance relationship work. Watch and let Samantha give you some simple tips for navigating and succeeding in your long distance relationship!

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: Talk to a stranger and ask them out on a date

Asking someone out on a date can be very intimidating, especially if you do not know them that well or if they are a complete stranger. This guide helps you learn how to confidently ask a stranger out on a date by introducing yourself, finding common ground, learning about the stranger, and then asking them out. Sometime's asking someone out is as easy as initiating a conversation.

How To: Juice up your online dating profile

Things a little quiet on the online dating front? Need some online dating advice from the experts? Maybe you're looking for love with all the wrong adverbs and dating SEO. SEO is short for search engine optimization. Take a little time to soup up your profile and those dates will start a'rolling in with this how to dating video.

How To: Cure acne prone skin naturally with ten tips

Acne sucks, and don't we know it. Our prom would have been ten times better had we not developed that continent-sized cystic blemish right at the tip of our nose (no concealor invented as of yet can cover up that monster), and the only thing more horrendous than going on first dates is going on first dates with a face full of stress pimples.

How To: Count Mondays between 2 dates 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 and Mr. Excel, the 44th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to count the number of Mondays between two dates using the WEEKDAY function or the TEXT function wrapped around the ROW and INDIRECT function.

How To: Fix poorly set up data 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 507th installment in their series of digital spreadsheet magic tricks, you'll learn how to take badly setup data (not in database/table format) and summarize it by date and shipping name into table format report.