Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 56th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use an array formula and the COUNTIF function to count unique records that are greater than a given hurdle (in this case, $30). Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 66th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to pull data from a table on one worksheet to a second worksheet using the VLOOKUP and DGET functions.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 66.5th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll see 3 different ways to hide formula errors.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 52nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to have one workbook look into another workbook using a workbook reference. See also how to update workbook references. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 48th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the VLOOKUP, ISTEXT, ISBLANK, OR and IF functions in one formula to look up a time value. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 106th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use two alternatives to pivot tables.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 102nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to count the number of days between two dates using an array formula.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 51st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use a VLOOKUP function inside a Text Formula to add a variable word (e.g., Annual, Semi-Annual, Quarterly, Monthly, or Weekly).
In this Computers & Programming video tutorial you will learn how to remove the LCD display from a G5 iMac. This video is from powerbookmedic.com. First, loosen the rubber band around the display by inserting a pointed object and freeing it slightly with your fingers. On the bottom, free the lower end of the sheet and lift it up. Now remove the two screws and dismantle the part as shown in the video. Then on the top of the display unstuck the two stick pads and remove four screws from the fro...
In this tutorial, we learn how to make guilt free chocolate truffles at home. Cocoa powder, coconut oil, Stevia, dates, coconut oil and apple sauce are used in this recipe. First, take your sugar free chocolate truffles you created and chill them in the fridge for a few hours, so they are hard. Once your truffles are made, you can now dip them into your choice of toppings. You can choose chopped nuts, coconut or any other topping that you enjoy. Once you're done dipping, you can place into tr...
In this Autos, Motorcycles & Planes video tutorial you are going to learn how to clean your car windows so they are streak free. You will need ammonia solution and a mixing bottle. Mix one part ammonia with ten parts of water in the mixing bottle. Make sure you take sufficient quantity of ammonia. Then get a spray bottle and pour the solution into it. Get a piece of rag and a micro fiber towel. Spray the window liberally with the solution and wipe with the rag. Now wipe with the micro fiber t...
What if you're in the middle of a call before you enter your car? Ford's new SYNC system has a solution. As long as your cell phone is paired with SYNC, you can continue the conversation uninterrupted. See how to use hands free calling with Ford SYNC.
Watch this instructional video to learn how to use Google Hacks. Google Hacks is a collection of software that explores Google's search function. Hacks is meant in this definition. "A Hack is a modification of a program or device to give the user access to features otherwise were unavailable to them. Watch this how-to video and find out how to use Google to access free media.
In this soldering tip video brought to you by BEST, Inc. Norman Mier explains how to converting a lead solder tip to a tip that will be utilized for lead-free soldering.
This is a tutorial on how to free up more space on your hard drive. Some of the issues that take up space include system restore, disk cleanup, wallpapers and personal information.
Cheaply, easily and quickly build an HDTV antenna that outperforms amplified store-bought antennas! This DIY antenna has amazingly good reception for your television. Quit paying your cable company when you can get HDTV for free!
Learn how to get free electricity from your home telephone line just by watching this video. Save money on your power bill, and hack into the electricity coming out of the phone jack. The phone company doesn't monitor electricity usage, so you can probably get away with this con. Check out this video tutorial and learn how to tap into the electrical energy source in your phone line.
Facebook's new Timeline feature has been rolling out gradually since its unveiling in September, but yesterday it finally became available to Facebookers everywhere. It's even available on your mobile device, too. Those who want to upgrade to the radical new profile design can do so by simple logging into their Facebook account and visiting the About Timeline page on Facebook.
With the globally rampant use of such social networking platforms as Facebook, Twitter, and Foursquare, the issue of privacy has become a prevalent concern for many. And for good reason—there's the violation of Facebook employing user names in ads, the Etsy slip-up, and of course, the everyman act of recklessly sharing too much information via common social media outlets: a night of drinking results in morning after embarrassment, or worst case scenario, sloppy Facebook posts and tweets resul...
Enjoy the taste of a summertime potato salad? Then you can't pass up this masterpiece of Southern glory. This video recipe will show you the perfect way to make a delicious, soul food potato salad. This potato salad is creamy with the perfect balance of ingredients and seasoning. It's easy, simple and a real crowd-pleaser. It can easily be customized to suit your liking.
If your cat and you seem a little stressed out, massaging the cat can be good for both of you. Watch this video to learn a little routine sure to please both human and cat.
Botanically, tomatoes are fruits, but an 1893 Supreme Court decision changes that. They were ruled to be considered vegetables, allowing for a higher tax to be placed on imported tomatoes. Seems silly now. Tomatoes are rich in vitamins A, C, and K, as well as lycopene, a cancer-fighter. Enjoy tomatoes throughout the year by canning your summer harvest.
In order to make a Pandora's Box, you first need glossy paper. The paper should basically be in the shape of a square, length 15 cm one side. Then divide the paper into 5ths. Now make 5 such folds on the paper and be sure that every fold is equidistant. Similarly, turn the paper around and start folding it from the other side too, in the same fashion. By doing this you will realize the folds have resulted in equal, similar sized boxes on the paper, 25 in total.
To create glossy or reflective vector image, you will need to know how to use the offset options in Adobe Illustrator and the basics for pathfinder. You will be creating a vector image that can be resized without hurting its quality. To start select you text style, which be glossy for this. You will have first a white layer, a shadow, a radiant layer, a white outline and a shadow going underneath. In this video the Oh Gizmo Logo! is being used as the template. Right click create outlines. You...
Hotels are anonymous and while this is a great thing, you should also be careful about the nameless folks who've used your room before you. Follow this tutorial to make the most of your hotel and ensure a great vacation experience.
This is a tutorial showing how to make a lightening effect on Photoshop. First click on the gradient tools and then click on the colors. Check to see if there is black on one side and white on the other, if there is then click the ok button. Then hold the shift key while dragging the mouse across the screen. This will make a black to white gradient effect on the screen. After that, click on the filter button at the top of the screen, then click render, and then difference clouds. After the cl...
how to create an Ocean in 3DS Max
Nothing says you care like a hand-made card. Show that special someone what they mean to you or just have fun with this cute arts and crafts project. Get your markers and colored pencils. Get your glitter and glue. Get creative.
Watch this video to learn how to make some very delicious turkey burgers. Make them as a healthier alternative to your next tailgating adventure. Share them at potlucks and family gatherings. You'll be surprised at how fast they go!
Professional truck driver, Yesterday Irmani, teaches us how to tie a time honored, weight sustaining knot, for transportation purposes.
Place slip knot on hook. Hold yarn taut with 2 sets of 2 of fingers placed about 1½” apart, with tail in other hand. Create loop that crosses over bottom of 1st strand with loop toward right side. Fold loop over main strand going past tail. Insert hook below at tail strand. Pull up a loop using main strand for this loop. Pull 2 ends of yarn taut while leaving slip knot on hook. In 1st chain work 1 single crochet. Skip 2 chains; work 1 double crochet in 4thchain. Picot stitch by chaining 3 & a...
Getting angry makes you look weak, especially in an argument. Defuse your temper with these helpful tips.
Having a boring Facebook profile is lame! Impress your friends and flaunt your social networking skills by sprucing up your Facebook profile.
Got ballet tickets? Learn to appreciate and enjoy the performance with these steps. You Will Need
If you get looks of exasperation whenever you stammer out a drink order, take this crash course in bar-speak.
You’d like to be strong and supportive for your wife in the delivery room… if only your knees would stop knocking. Keep both of you from freaking out with these tricks. Watch this video to learn how to stay calm when your wife is in labor.
You've got style. You've got class. You've got... No reason to still be wearing a clip-on. Show off your suave side with a perfectly knotted tie. Watch this video to learn how to tie a bow tie.
If it's all you can do to drag yourself through the day, why not increase your stamina with these time-honored techniques. Watch this video to learn how to boost energy naturally.
If things are getting a bit stuffy at your desk, don’t fret. A cool breeze is just a USB slot away. Watch this video to learn how to make a USB fan.
Learn how to massage your dog. Man’s best friend gets stressed, too! A massage can benefit your dog’s health as well as their mood.
