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 315th installment in their series of digital spreadsheet magic tricks, you'll learn how (and when) to use the SUMIF & SUMPRODUCT 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 488th installment in their series of digital spreadsheet magic tricks, you'll learn how to use VLOOKUP with multiple lookup values. You'll also learn how to add an extra column with a unique identifier to data set using ampersand concatenate.
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 480th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate a percentage of total from a database data set when the variable of interest is text (word). This is accomplished with recourse to the COUNTIF, SUM & COUNTA 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 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 533rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula to calculate the difference between start date/time & end date/time excluding holidays and weekends. This is accomplished with recourse to Excel's NETWORKINGDAYS and MOD 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 534th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the OR and WEEKDAY functions to create a logical true/false formula that will automatically apply formatting to dates that are either weekends or holidays.
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 477th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a Gantt cell chart using conditional formatting. This is accomplished with recourse to the WORKDAY.INTL, AND, NOT & NETWORKDAYS.INT 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 tutorial from ExcelIsFun, the 474th installment in their series of digital spreadsheet magic tricks, you'll learn how to conditionally highlight every last value in a data set or each value which differs from the value preceding it.
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 video, it demonstrate how to check and configure Windows firewall. In order to check to see if firewall is enable or not. You would click on start which locate bottom left corner of the screen. Then you would click on control panel. On this screen you would see an option for firewall, and click on it. When you click on firewall, it will let you view all the description about firewall configuration. There are also many other option which locate on the left hand side. If you are an adva...
The video explains how to change the background color of objects using Photoshop in a simple manner. This way is better quick mask mode, because this way is more efficient and more advanced. First you click control G, Image control color and then you take the Image samples. The tutorial shows how the oranges are changed from their original color into a reddish color. Then it shows you how it adjusts the shadows of the oranges and the color of the leafs. The video is quick and it explains full...
De-fragmenting a hard drive improves the performance of a hard drive and it is recommended to de-fragment your hard drive from time to time as shown in this video. In Windows 7 you can use the Disk De-fragmentation tool. To do this go to the start menu and open the Control Panel. In the right column select the Performance Information and Tools. Now in that window in the left hand column select the Advanced tools option. In that new window scroll down to the Open Disk De-fragmenter link. Click...
The first operations you will need to know when learning to use algebra to solve for an unknown variable “x” will be using addition and subtraction. You can check you work by checking the balance of the equation when you are done.
This is another HelpVids.com technology video. This video will teach us how to sort table contents in Microsoft Word 2007. The video starts out with a Word 2007 document with a sample table. When you click on the table, you will see the Table Tools tab appear above the ribbon. Click the Table Tools button, then click Layout and finally the Sort Button. The sort dialog box allows you to choose which column to sort by, which direction you would like to sort, and any secondary sorting you would ...
This video is an acoustic guitar lesson from yourguitarsage. In this video, he teaches you how to play the song "Band on the Run" by Wings & Paul McCartney. He begins by playing the song for more advanced players to watch and learn from. Then follows up by showing you which chords you need to know to get started on learning the song, and demonstrates them for users who may be still learning. He then moves on to the progression of the chords through the song, teaching you the intro, verse, bri...
Halloween is just around the corner and this spooky paper bag album you can really create a masterpiece. If you love scrap booking this project would be a blast for you. All items were bought for less than a dollar at the local dollar store and the detailing is quite manageable from intermediate to advanced scrap booking. So if you have time and patience to make this then get ready to create an album ready for any Halloween adventure. In this video you will learn how to make a spooky Hallowee...
This video is an acoustic guitar lesson from yourguitarsage. In this video, he teaches you how to play the song "Use Somebody" by Kings of Leon. He begins by playing the song for more advanced players to watch and learn from. Then he follows up by showing you which chords you need to know to get started on learning the song and demonstrates them for users who may be still learning. He then moves on to the progression of the chords through the song. With the help of this video you will be play...
In this video from Tiffany0x we learn how to change your profile background on youtube. First she goes to google, then clicks on images and type in whatever image you're looking for for your background. Then copy the image's link in your browser. Then go to youtube. Click My Account. Then you'll see Channel Settings. Click that, then click Channel design. In Advanced Customizations you'll see a place where you can put in a Background URL. Paste the URL into that box. Once you have done that, ...
This video is an acoustic guitar lesson from yourguitarsage. In this video, he teaches you how to play the song "Can't Buy Me Love" by The Beatles. He begins by playing the song for more advanced players to watch and learn from. Then he follows up by showing you which chords you need to know to get started on learning the song, and demonstrates them for users who may be still learning. He then moves on to the progression of the chords through the song.
PerformanceBikes will show you how to install a bicycle computer. Whether you have a simple computer or a more advanced computer you be able to see the basic instructions. Start by reading the instruction, install the handle bell mounts, install the wireless transmitter. You then install your spoke magnet, then calibrate your computer for your wheel size. Make sure you have read your own particular directions. If its not working, make sure you re-read your instruction, check your set up or ch...
In this three-part video tutorial, a HTML/CSS expert shows how to build a web page from scratch with a case study example. He begins with a basic text web page and advances up through graphics, CSS, and more.
In this five-part video tutorial, learn how to double crochet intarsia using a graph or chart. Intarsia knitting is an advanced knitting method, used to knit with several colors of yarn. The simple heart chart used in this video is available here.
Learn all there is to learn about yarn from Naztazia... watch this video tutorial to learn how to crochet spiral scrubbies with a pattern.
Homemade bone stock, onions, sugar, garlic, white wine are the key ingredients to make a delicious French Onion Soup. The simple recipe in this clip is from the BBC cookery series Delia Smith's Cookery Course.
Delia goes through her recipe for a tasty smoked haddock chowder in this classic BBC clip. Learn how to make smoked haddock chowder.
Chef Keith Floyd prepares a delicious Lagoustine and tomato recipe and a mussel, steamed clam and spinach gratin in this classic video from BBC cookery show 'Floyd on Fish'.
Chef Keith Floyd is in Cornwall to cook a portuguese dish al-fresco at a Naval Base. Delicious meal idea using pork, bacon, mussels, scallops, prawns, and cockles from BBC vintage cookery show 'Floyd on Food'.
Chef Keith Floyd cooks with red meat in this great easy to follow recipe video from BBC cookery show 'Floyd on Food'.
Keith Floyd, favorite British chef, talks through a traditional Alsace recipe for liver dumplings in this classic video from BBC food show 'Floyd on France'.
Keith Floyd cooks a Perigord-inspired feast of fat bacon soup, sweetbreads made of pancreas of veal with truffles and foie gras, and a goats cheese and walnut salad. Interesting recipe ideas from classic BBC cookery show 'Floyd on France'.
This two part step by step video will show you how to custom paint an Xbox 360 Controller with Racing Stripes.
This is a 2 part Step by Step video that helps you learn how to paint an ADVANCED camouflage design Xbox 360 controller.
Need a hobby? The yo-yo is the perfect to for anyone in need of a hobby to keep them busy. Did you know that it's also one of the oldest toys around, and that modern yoyo's have been born and perfected in Santa Barbara, California? Did you know there's millions of tricks out there for your disposal, for your fun, for your arsenal? In this video tutorial, learn how to do the "Pac-Man" yo-yo trick. The Pacman is a great advanced trick.
Need a hobby? The yo-yo is the perfect to for anyone in need of a hobby to keep them busy. Did you know that it's also one of the oldest toys around, and that modern yoyo's have been born and perfected in Santa Barbara, California? Did you know there's millions of tricks out there for your disposal, for your fun, for your arsenal? In this video tutorial, learn how to do the "ladder escape" yo-yo trick. The ladder escape is a great advanced trick.
Need a hobby? The yo-yo is the perfect to for anyone in need of a hobby to keep them busy. Did you know that it's also one of the oldest toys around, and that modern yoyo's have been born and perfected in Santa Barbara, California? Did you know there's millions of tricks out there for your disposal, for your fun, for your arsenal? In this video tutorial, learn how to do the "bee sting" yo-yo trick. The bee sting is a great advanced trick.
Need a hobby? The yo-yo is the perfect to for anyone in need of a hobby to keep them busy. Did you know that it's also one of the oldest toys around, and that modern yoyo's have been born and perfected in Santa Barbara, California? Did you know there's millions of tricks out there for your disposal, for your fun, for your arsenal? In this video tutorial, learn how to do the "magic knot" yo-yo trick. The magic knot thing is a great advanced trick.
How to prepare a thermocouple for attachment to a printed circuit board (PCB) for profiling a reflow or wave soldering system. This is advanced PCB circuitry and you need to watch all videos in the series to understand all the steps of wiring a printed circuit board entails.
If you like cards, and you like tricks, you've come to the right spot to learn how to do some amazing card tricks. You're probably not a magician, but that doesn't mean you can't perform any magic, especially with a deck of cards. Just watch this magic revealed... see how to make some card illusions.
Liquid Pop Collective put this video out some years ago; adding digits to your Liquid makes it far more stylish and sophisticated than just relying on the old hand-chasing alone. This is an advanced hand-chasing technique.
