Loves Daily 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: Form a tomato rose salad and food decoration

Tomatoes have long been salad staples, but never have they adorned your salad quite like this before. Turn your daily salad from ordinary to sexy fabulosity by cutting and folding up this beautiful tomato rose. Excellent as a garnish on most food dishes as well as a bowl of salad, this tomato rose is easy to make and impressive in show.

How To: Make informal and formal commands in Spanish

In this video, we learn how to make Informal and formal commands in Spanish. When you speak in first person singular, you will say "yo" when you speak in plural, you will say "nosotros". These are both informal or familiar forms of the word. When you are speaking to someone that is a elder, you will want to speak in formal instead of informal. Use informal mode when you are talking with friends, family, children, and anyone else you talk to in a daily basis. Pay attention if you are talking a...

How To: Make a blog website on Blogger

In this video, we learn how to make a blog website on Blogger. First, go to Blogger and set up your account. Make sure to enter in all the correct information, then at the end you will be sent a confirmation e-mail. Once you verify your e-mail and information, you can get started with your blog. You can set up a layout and change the font and colors as you prefer. You can start to type in all your daily blogs and have other people start to bookmark yours. You can also watch other people's blo...

How To: Reduce and prevent stretch marks with argan oil

In this video, we learn how to reduce and prevent stretch marks with argan oil. This is great to keep the skin elastic and is enriched with antioxidants. First, grab your 100% natural argan oil and almond oil. Mix one part argan oil with one part almond oil, then add in a couple drops of rose oil. After this, stir it all together until combined. Use this on the area with stretch marks twice a day, in the morning and at night. This has such rich properties, it will keep the skin firm and help ...

How To: Add an IMDB search function to the Chrome web browser

Looking for a quicker way to use IMDB in Chrome? On today's Tekzilla Daily, Veronica shows you how to use GoToIMDB for the best way to look up films with a single click.This clip will show you how it's done. It's simple! So simple, in fact, that this home-computing how-to can present a complete, step-by-step overview of the process in just under two minutes. For more information, including complete, step-by-step instructions, take a look.

How To: Make raspberry chocolate cupcakes

These chocolate-raspberry cupcakes dessert may look intimidating, but don't let that stop you from making this yummy chocolate and raspberry treat. Plus, in addition to getting your daily fill of chocolate, you can also claim that eating one of these cupcakes counts as a serving of fruit (it does!), which means you're being health conscious as well. Sort of.

How To: Wire wrap beads, crystals, and stones for beginners

Learning how to wire wrap jewelry is one of the most important skills you need to learn on your way to achieving jewelry making enlightenment. Wrapping with wire, whether it's attaching a stone to a pendant with an intricate, flowery wrap or adding a head pin to a crystal, allows you to attach adornments to your necklace or earring, something you'll be doing over and over again as a jewelry maker.

How To: Get sun-kissed, beachy summer hair

Summer is beach season, but that doesn't mean you have to hit the beach daily to get that characteristic sun-kissed, scrunched up beachy hair look. Even if you're going to be sitting at your office desk for most of summer, you can still look like you spent a day at the beach by watching this tutorial, which teaches you how to get bohemian waves.