Love Dealing Search Results

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: Reduce puffiness under your eyes

Joanna Schlip is a professional make-up artist who focuses on how to deal with puffy eyes. Prevention is always better than cure and making sure that you get enough sleep, staying well hydrated, treating any existing allergies, avoiding known allergens are just a few ways you can avoid your eyelids from getting puffy. In today's fast paced day and age where we don't have time to call up a loved one, let alone get eight full hours of sleep a night, there is precious little one can do to avoid ...

How To: Check In to Businesses on Yelp to Get Discounts, Freebies & Other Coupon-Like Deals

On Yelp, you have the option to check in to a business you're visiting. For you, broadcasting who you're with and where you're at is fun for social purposes, but for business owners, you're basically giving them free publicity. Well, almost free publicity. Since there's incentive to get you to check in, some businesses reward customers with special deals, such as 20% off your first visit.

News: Google's New Project Fi Deal Could Net You a Free Moto X4

There are a lot of holiday tech deals starting to trickle out as Black Friday approaches. We've already rounded up some of the best deals for Android, iPhones, and headphones, but Google just dropped a big announcement for users of their Project Fi MVNO service. Now through December 17, you can earn yourself a free Moto X4 or Chromecast by referring your friends and family to Project Fi.

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: Deal with social anxiety & improve your social skills

This video tutorial is in the Motivation & Self Help category which will show you how to deal with social anxiety and improve your social skills. In this video Momo answers some questions on social skills and gives a few suggestions on what to do when the panic sets in. The panic sets in either because you have nothing to say or you have expectations. Usually it is expectations. You got expectations from your teachers, your parents, your friends or your peers. When you have expectations when ...

How To: Deal with rejection from your father

In this video, we learn how to deal with rejection from your father. Don't let your father change who you are and change how you think about yourself. Know that people in your family are going to have problems, it can't be perfect. The mental warfare isn't worth it, grab the bull by the horns. Try to write him a letter from the heart and really let him know what you are thinking. If that doesn't work, make a video where you are talking right to him and tell him how you are feeling. After this...

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.