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 707th installment in their series of digital spreadsheet magic tricks, you'll learn how to rank values based on one criteria using the SUMPRODUCT 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 641st installment in their series of digital spreadsheet magic tricks, you'll learn how to create a PivotChart based on a PivotTable in one click.
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 601st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the VLOOKUP & IF functions to make bonus calculations based on the number of years worked.
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 629th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the VLOOKUP, MATCH, DATEDIF, SUMIF, SUMPRODUCT and INT functions to look up salary based the number of relevant years worked.
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 154th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a personal budget based on past data via the SUM function, cell references, subtraction and the VLOOKUP function.
Check out this clip and learn how to take total advantage of your adventures with Grand Theft Auto IV's Ballad of "Gay Tony". This final episode for GTA IV is sure to be a fun one and with these tips you will get the most out of it. This video is a travel guide to base jumping, cage fighting and dance offs. Good luck!
If you love origami and the PlayStation, you're in luck, because this video tutorial will show you how to fold the small bird (or pajarito) from the upcoming PlayStation 3 game Heavy Rain: Origami Killer.
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 673rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT formula to calculate commission amounts based on varying commission rates based on cumulative sales totals for each month.
Bring a little bit of the excitement of Las Vegas to your Minecraft world. Watch this video to learn how to build a working slot machine, based on a random number generator, in your Minecraft map. Luck be a mob tonight.
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 271st installment in their series of digital spreadsheet magic tricks, you'll learn how to use conditional formatting and the DATEDIF function to add formatting to a cell based on the content of a different cell.
Whenever a new project comes their way, many people tend to go out to the store in order to buy all the parts they need instead of checking what they already have. This can be costly and can easily be avoided if they do find certain items lying around the house.
The Flower god gets us all ready for the Chinese New year with a quick and very simple flower arrangement for a table centerpiece. You'll need some good luck bamboo, some ivy, little pieces of ginger and some passion flowers to accent the green. Take some of the ivy leaves and cover the centerpiece base. Cut them short at a sharp angle to cover everything. Next use the good luck bamboo to add height. Cut these at a sharp angle as well so that they will stay secure. The angles help it work as ...
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 339th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT function to add the difference between two columns of numbers based on two criteria.
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 555th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the IF and VLOOKUP functions to make one of two types of commission calculations based on what is put in the referral column.
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 197th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUM and VLOOKUP functions to create a grade book based on a specified total score with weights assigned to different categories.
This video shows you how to easily find the area of a parallelogram and the area of a triangle. The first part of the video teaches you how to find the area of a paralellogram. The area of a parallelogram is BxH, where B is the base and H is the height. The height is obtained by drawing a perpendicular line from one corner to the base. The second part of the video teaches you how to find the area of a triangle. The area of a triangle is (BxH)/2, where B is the base and H is the height. That's...
New to 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 Excel tutorial from ExcelIsFun, the 194th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUM, VLOOKUP and ROUND functions to create a gradebook based on percentage scores that will calculate grade for you automatically. See also how the VLOOKUP and the percentage format can deliver the wrong grade when you dont use the ...
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 199th installment in their series of digital spreadsheet magic tricks, you'll learn how to apply conditional formatting to a vertical histogram based on a frequency distribution in Microsoft Excel 2007.
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 193rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUM and VLOOKUP functions to create a grade book based on a given total score that will automatically calculate grades.
In this knot-tying tutorial, we learn how to fasten a perfect "good luck" knot—a knot so named because it is said one requires quite a lot of luck to tie it properly. Not so, says video creator TyingItAllTogether. For all of the relevant details, and to get started tying this knot yourself, take a look.
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 196th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUM, SMALL and VLOOKUP functions to create a gradebook (or grade book) based on a total score minus the two lowest scores.
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 195th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUM, MIN and VLOOKUP functions to create a grade book based on given total score that drops the lowest score and calculates grades automatically.
In this video you learn how to make a digital pinhole camera. The video begins with an introduction addressing the main themes to be dealt with in the video - tight budgets, photography and specialized lenses. In this video, Kai modifies a photo lens cap by poking a large hole in it. After making this large hole, he makes a smaller hole in a thinner material and lines the hole up in the center. He calculates the size of the hole he needs based on the wavelength he will be photographing. He us...
If you loved the movie Toy Story 3, then you'll have a good time playing the game as well. Aside from all the missions and objectives you have to complete, you can also unlock some easy achievements as well. In this tutorial, you'll find out how to get the Space Ranger Elite achievement in the game.
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 244th installment in their series of digital spreadsheet magic tricks, you'll learn how to use advanced filtering to extract records from a database (table or list) based on 1 criterion (criteria) and place reesults on a new sheet worksheet.
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 506th installment in their series of digital spreadsheet magic tricks, you'll learn how to summarize data from multiple sheets. For example, you'll see how take checkbook register data from multiple banks accounts and summarize it based on account names.
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 538th installment in their series of digital spreadsheet magic tricks, you'll learn how to create dynamic sub tables based on master sheet array as well as how to create array formulae quickly with the Drill-Through method. All this is accomplished with recourse to the COUNTIF, IF, ROWS, INDEX, SMALL, ROW functions.
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 186th installment in their series of Excel magic tricks, you'll see how to extract records that meet two conditions (criteria) and list them in order with no extra rows between records as well as how to create a formula to extract part of a table from a larger table based on two criteria. (All of this is accomplished through us...
In this free video language lesson from Sunny Park of Mahalo, we learn how to say, pronounce and write the Korean words for "good luck." For details, and to get started using this handy Korean phrase yourself, watch this guide for Korean language learners.
If you're having a hard time choosing the right mulch for your garden, then this video may prove useful to you. In the tutorial, you'll find out how to choose and use the best mulch for your garden.
If you've never heard what the lindy hop was, you would probably think it's some interesting type of candy. In fact, it's actually a dance that is based on the popular charleston and was popular during the 1930s and 40s. The dance have a triple step and a rock step incorporated in them. So see if you have what it takes to learn this dance from professional instructor Nina Ortega. Good luck, practice, and enjoy!
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 202nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that calculates the number of vacation days an employee gets based on hire date using the TODAY, YEAR and IF functions.
New to 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 Excel tutorial from ExcelIsFun, the 270th installment in their series of digital spreadsheet magic tricks, you'll learn how to
This video, created by ClearTechInfo, shows you how to easily install fonts in Windows. The tutorial refers to Windows XP and Windows Vista. First thing you have to do is download a font. Usually, you can find license-based fonts or free fonts on Google or any other searching engine. If you have downloaded a ZIP file, containing a font, un-zip it. All you have to do is open the Control Panel, and then the Fonts folder. Simply copy and paste the font to the Fonts folder, and your font is now i...
Watch this instructional origami video to fold a traditional Japanese origami crane. Tsuru is the Japanese word for crane. In Japan cranes are considered a national treasure and regarded as symbols of good luck and longevity. Fold a few origami cranes and give them to your friends as gifts or good luck charms.
Knotmaster JD from Tying It All Together offers us another of his informative and oddly soothing knot-tying instructional videos. This is teaches us to tie a Chinese Cloverleaf knot, a good-luck charm in both East and West that makes up for its lack of practicality with timeless beauty. From the knot-tyer himself:
Apple's keyboard has a set of media controls to navigate the music playing on iTunes, allowing you to play, pause, skip, and replay songs and videos. Unfortunately, these controls are exclusive to iTunes; if you're playing music from Spotify, Pandora, or the myriad of other online web-based services (Amazon, Rdio, SoundCloud, etc.), you're out of luck.
In this video we're making a weather predicting light! Good luck! Video: .
If you want to engage in macro photography and can't afford a close-up lens, you may be in luck. By using a "G" lens (that is, a lens that does not have a built-in aperture ring) it is possible to reverse the lens and take close-up shots with your camera, without having to buy any additional equipment.
The seals in your car had best all be functioning properly if you expect your car to work right. To test the ones in your engine cylinders you'll need an automotive cylinder lead down tester, and if you don't want to buy one, you're in luck because this video contains easy-to-follow instructions on how to make one in your garage.