Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 63.5th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the advanced filter "Unique Records Only" option and the VLOOKUP, COLUMN, IF, ISERROR and IFERROR functions to merge 2 tables.
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 272nd installment in their series of digital spreadsheet magic tricks, you'll learn how to count unique records and duplicate records using the SUMPRODUCT, COUNTIF, COUNT, COUNTA, IF and SUM functions.
Electromagnets are super cool to experiment with. In this educational video, Science Bob teaches us about electromagnets - what they are and how to build one of your own. These magnets are are very powerful and make an extremely neat experiment for the science fair. Electromagnets are unique in the sense that they convert electricity into magnetism. Try this experiment with your kids for a unique science lesson.
There have been numerous chairs made out of recycled or reclaimed cardboard. This week on the GreenerBusiness Podcast, we attempt to build our own unique comfortable cardboard chair.
Learn how to create unique designs and decorations for your clipboard.
Decades ago, Japan rocked the automobile industry with its revolutionary manufacturing and car quality, but today that title seems to be moving over to Elon Musk's electric car company Tesla. Nevertheless, Japan isn't done innovating mass-produced hardware.
The first White Hat Award for Technical Excellence tutorial contest ended last night at midnight! We had many excellent articles submitted, once again re-affirming what an incredible community we have here at Null Byte! We had quite a flurry of great articles in the last few days. Thanks to all of you who submitted such high quality material to our community. Your efforts are appreciated and you have the undying gratitude of our community. We will not forget your efforts. I'll be reading and ...
This tutorial describes how to make a list with unique values in Excel.This procedure makes the defined cells in a column (called as list) NOT to accept repeated values, which makes the list more simple, readable, easy to manipulate when preparing a worksheet.
Do you have a bunch of flawed beads left over after you make your crafts? You know the ones, the chipped, cracked, sharp ones that don't make the cut and usually get tossed in the garbage? Why not make those into something lovely, where the cracks don't matter? In this two part tutorial, learn how to turn your discarded beads into a beautifully shiny wind chime for your backyard. This chime is unique and makes a lovely noise in the wind. Let's get crafting!
Gilder's Paste is what distinguishes a so-so piece of jewelry from a truly dazzling, memorable one. That's because Gilder's Paste, which comes in a wide variety of colors and tints, is a type of colorant for brass that can be mixed and applied for a unique look.
Unlike being a square, being a square knot means you're multifaceted, fun, and unique. Of course, we're talking about square knots in friendship bracelet/jewelry making, in which you utilize two different colors of string to create a tight zig zag knot pattern followed by loops.
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 622nd installment in their series of digital spreadsheet magic tricks, you'll learn about a robust formula for counting unique items in a list using the SUMPRODUCT, COUNTIF and an array formula component. You'll also see an array formula that uses SUM, IF, FREQUENCY, MATCH and ROWS functions to achieve the same.
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 621st installment in their series of digital spreadsheet magic tricks, you'll learn how to write a logical formula using the AND and COUNTIFS functions with mixed cell references in the conditional formatting dialog box to highlight entire row (whole record) in data set (table) when record is unique and matches the s...
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.
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. With this video tutorial from ExcelIsFun, the 368th installment in their series of digital spreadsheet video tutorials, you'll learn how to create and use an array formula that will permit you to count unique items within a column while specifying more than one criterion. This guide uses the SUM, IF FREQUENCY, MATCH, ROW, and ISNUMBER functions (in a somewhat unusual combi...
If you need some sound effects for your upcoming film, you better watch this video! After principle photography in production, you have to get into the editing process in post-porduction, which leads to sound department for ADR, Foley, Sound Effects and Sound Design. If you can't afford a professional sound designer for your movie, you can do it yourself, and this video will help you find sound effects on the Internet for your film.
If you've ever gone Christmas tree shopping before at a Christmas tree lot, then you're probably more than familiar with Noble Firs, Douglas Firs, Grand Firs, and maybe even Blue Spruce and boxwood (used for wreaths). But have you ever considered using other varieties of evergreens in your decorating?
Mar Jennings shows you how to create a unique votive candle holder.
Jewelry made with untreated brass findings and stampings looks just fine, but if you're going for an impressive, interesting piece that stands out and shows personality, then Gilder's Paste is where it's at. Gilder's Paste comes in a large variety of colors and is used to color brass jewelry pieces.
In this Beauty & Style video tutorial you will learn how to cut up your t-shirt and look unique and stylish. Take a loose baggy style shirt and make two marks with scissors just near the shoulder seam. Then cut down the center of the t-shirt about 2inches. Now cut from the shoulder marks up to the center point and on the back just cut straight along the shoulder cut marks. Then cut open the top part of the sleeves little short of the shoulder seams. After this cut off the bottom seam. Then st...
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 581st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the advanced filter tool with criteria to extract a unique list of employees for each department from a huge data set with transactional records.
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 577th installment in their series of digital spreadsheet magic tricks, you'll learn how to use SUMPRODUCT and the join symbol (&/ampersand) to group duplicates and then see how to use advanced filtering to extract a list of unique records.
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 293rd installment in their series of digital spreadsheet magic tricks, you'll learn two cell formulas and a named formula that will dynamically count unique words in a column. As you add new records, the count will automatically update. This is accomplished through use of Excel's MAX, ROW, OFFSET, SUMPRODUCT, ISTEXT and COUNTIF f...
Bartender Gene shows you how to make a unique, healthy, ginger infused cocktail. Simmer 1/2 cup water, sliced, fresh ginger and sugar to make a ginger infused syrup. Remove from heat, let cool, then add 1/2 cup vodka and refrigerate. When your syrup is cool, strain out the ginger and throw it away. Place candied ginger at the bottom of the glass and pour in about a tablespoon of the syrup. Top off with sparkling wine and serve. Follow these easy steps to create a celebratory, unique, good for...
WHERE TO USE THIS CODE: Most videos DO NOT have "View in Higher Quality" links below them like this video does. So by using this code, you'll be able to watch ANYTHING in higher quality! TRY IT! : )
Bored of the same old tie knot? Now, add a little edge to your look with these unique knots that are so easy to make.
Video: . What is an isosceles trapezoid. The video goes over the properties that are unique to an isosceles trapezoid.
It was a chilly but otherwise beautiful night at YouTube Spaces LA—food trucks, ping pong, a photo booth, and the chance to view film school projects created completely with Glass. About a year ago, the Glass Creative Partnership was formed to explore how Glass could be used in filmmaking, with partnerships spanning from the American Film Institute to CalArts and UCLA. On July 16, 2014, the products of that partnership were screened under the Southern California night sky. Three films were sh...
If you're a musician, but can't cover the cost of an expensive recording studio to get your song onto a playable media, then this video is what you need. It will show you how to make your own high-quality home music recording studio on a shoestring budget! If you're trying to get the attention of big music record labels, you need some hgih-quality sounds, but you don't need the high-quality costs! The setup is pretty simple— a microphone, MP3 player, sound mixer, headphones and a good-quality...
You want the best quality photos you can get, and the Canon EOS 7D digital SLR camera makes perfecting your pictures easy. There is a range of technologies to enhance image quality. This video shows you the many options you can use.
Thanks to modern technology, we don't have to visit our nearest Target or Rite Aid to get our pictures professionally retouched and printed. With many printers offering photo-quality ink and paper companies that offer photo-quality paper, you can use your home printer to create professional-grade photos.
In this tutorial, we learn how to grind your own spices. Spices grow all over the world, which can give them all unique tastes. Start off by grabbing the spices that you want to mix together. Use your favorite spices to make your own unique tastes. If you are roasting, you should not roast or toast the spices all together at once, so they don't incorporate smells. After you do this, you will use a mortar and a pestle to crush down the spices. Start pounding on the spices to release the oils a...
In this tutorial, we learn how to write a unique personal statement essay. Personal statement is the heart of the application where you can give voice to your accomplishments, dreams, and goals. You want to stand out from the rest of the applicants, so you need to express what's important to you. You can show them how well you write and show passion, your smarts, and sense of humor as you write. You can do this because you are prepared and you are being true to yourself. Once you understand t...
Your tanks and your tees aren't fitting just right, don't throw them away or toss them in a storage box just yet. Grab some scissors and cut that sucker up, then mold it in a better fitting, unique and cute shirt. The easiest part is simply slicing up the back up the shirt, but then comes the strings. Watch and see for yourself. This is a great way to transform a normal T-shirt or tank top into something more creative.
In this video, we learn how to play guitar: Funk Grooves. First, learn how to slide your finger from the ninth chord using the third bar. As you do this, it will create a groove in your music that is unique and very "funky". Once you learn how to do this, you will be able to make funk groove music easily. Don't forget to mix things up with other chords to make up your own unique sounds as well. Remember to make sure you keep your right hand moving as you play, so you don't create any squeaky ...
Not that we have anything against painting on an aubergine nail polish for a night out on the town, but why not get a little inventive next time you do your nails by creating unique designs? Become a nail Picasso by checking out this nail tutorial for creating nautical-inspired nails featuring ocean waves, jumping fish, and pretty rhinestone air bubbles.
In this crochet tutorial, you'll be guided through how to crochet using one of the most unique and difficult yarns avilable on the market. Known as Pomp A Doodle yarns by Red Heart, these yarns are punctuated with little pom poms and are cute on their own, but great for fluffy projects.
Looking for something unique and beautiful to wear tonight? Check out this video on how to make a chunky crystal drop necklace that works for any occasion.
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 159th installment in their series of digital spreadsheet magic tricks, you'll learn how to solve Duplicate VLOOKUP function problems with a COUNTIF formula that creates a column of unique values for the first column in the lookup table.
To ensure that High Quality videos from YouTube always play in the highest quality available, simply follow these steps:
