Loves Commonplace Search Results

How To: Make an origami shirt out of a dollar bill

Is your love of money surpassed only by your love of miniature dress shirts? Boy, are you in luck. This video tutorial presents complete, step-by-step instructions on how to make a shirt from a folded dollar bill. For more information, and to get started making your own money shirts, watch this free arts-and-crafts how-to.

How To: Work around the 1-rule data validation limit in Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 144th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to work around data validation's one-rule limit by creating a second shrinking list that looses values as they are used in the data validation area.

How To: Update inventory records by formula in Microsoft Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 348th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to build a formula that will take invoice information for inventory quantity sold and update inventory records to show correct amount on hand (in stock).

How To: Use the UPPER & EXACT functions in Microsoft Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 82nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the UPPER & EXACT functions to create a TRUE/FALSE formula to determine whether or not uppercase text has been entered into a cell.

How To: Extract records with an advanced filter in Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 95th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the OR, AND, NOT, & COUNTIF functions and Excel's advanced filter tool to extract records from a table of data. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

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: Clean up a bad data set for a pivot table 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 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.

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: Convert a text formula/function to a number in Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 44th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn use 4 different tricks to convert a text formula or function to a number. Also see how to convert text to numbers. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

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: Hide columns and select only visible cells 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 34th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to hide columns, select visible cells only, and then copy and paste just those visible cells (all with and without the use of formulas). Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Sort and extract by cell color in Microsoft Excel 2007

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 33rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to sort by color in Excel 2007 as well as how to use the copy and paste tools to extract records. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Make cheesy tortellini primavera with only three ingredients

If you love pasta, such as tortellini, but don't love the time it takes to cook, then you'll love this video recipe from Woman's Day Magazine. It's a time-saving, super clean version of tortellini primavera, which requires only three ingredients. Those are one package of cheese tortellini, one bag frozen sugar snap stir fry, and one jar of creamy Alfredo sauce.

How To: Say "I love you" in Korean

In this tutorial, we learn how to say Korean Travel Phrases #8 - I love you. Saranghamnida is how you say "I love you" in Korean. You will want to make sure you have the right pronunciation when you say this. If you don't say it correctly, you will be saying a completely different phrase and words. This is great to learn if you are traveling to Korea and want to learn common phrases that people say all the time. If you want to point at someone at tell them you love them, you would say "Dangsi...

How To: Play "Skinny Love" by Bon Iver on the guitar

Want to learn how to play guitar like Bon Iver? In this how to video you can learn how to play "Skinny Love" by Bon Iver on the guitar. The tuning for "Skinny Love" is CGEGCC. This lesson is geared towards intermediate to advanced guitarists because it assumes some prior knowledge of guitar playing. With this how to video you will be able to sing and play "Skinny Love" by Bon Iver on the guitar.

How To: Play "Let Me Love You" by Mario on the ukulele

Want to play "Let Me Love You" by Mario on soprano, concert or tenor ukulele? Learn how with this video tab, which presents a complete breakdown of the song's component sections, chords and strumming & picking patterns. For all of the details, and to get started playing "Let Me Love You" on your own uke, watch this free video ukulele lesson.

How To: Play "She Will Be Loved" by Maroon 5 on baritone ukulele

Want to play "She Will Be Loved" by Maroon 5 on baritone ukulele? Learn how with this video tab, which presents a complete breakdown of the song's component sections, chords and strumming & picking patterns. For all of the details, and to get started playing "She Will Be Loved" on your own baritone uke, watch this free video ukulele lesson.

How To: Say "I love you" in 55 different languages

In this tutorial, we learn how to say "I love you" in 55 different languages. If you want to learn how to say this wonderful phrase in another language, this is the video for you to see! It runs through a ton of different ways to say "I love you." Whether you want to say it in French, Finnish, Greek, Hindi, Hungarian, Icelandic, or more! To help you learn how to say it better, try to get familiar with the dialects and the accents that are used when these words are said. Enjoy saying this phra...

How To: Write and say "I love you" in Mandarin Chinese

In this video, we learn how to write and say "I love you" in Mandarin Chinese. Start out by saying "wuh" then "I" and then, "knee". Say each of the different parts individually at first. Then, say all of them together in one entire word. From here, you will have said "I love you" in Chinese! To write this, follow the writing that is on the screen and learn how to write out the different symbols that are included in this language. Once you understand this, you can start to learn more basic con...

How To: Say "I love you" in 100 languages

In this video we learn how to say "I love you" in 100 languages. The best way to learn how to say "I love you" in a number of different languages is to learn how to say the correct accent first. Take a look at all the different spellings of each of the phrases and then practice saying the vowels and the words together. For example to say the phrase in Arabic you would say "Ana behibak" or "Ana behibek" to a female. To say the phrase in Bulgarian you will say "Obicham te". No matter what langu...