Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 85th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to isolate unique records with the OR 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 251st installment in their series of digital spreadsheet magic tricks, you'll learn how to create a unique list of customers within a unique list of sales reps using a series of standard formulas in tandem with a few array formulas.
After you've jammed with your song for a while, you can record your guitar part as a real instrument track with your guitar connected to your Mac and a real instrument track selected.
In this video, we learn how to create a realistic looking cut using cinema makeup. Start out by using silicone putty on the face to help make the cut on the face look more real than ever. Use brushes and a spatula to help mix colors together and apply to your face flawlessly. Also make sure you have fake blood with you so you can apply to the face to make look more realistic. After you have let the silicone dry, start to apply the red, dark red, and black colors onto it and blend to create a ...
Augmented reality gaming pioneer and Pokémon GO mastermind Niantic is putting the pieces on the gameboard to prepare developers and gamers for the launch of its AR cloud platform.
The game wizards at Insomniac take pride in diving deep when it comes to world-building, and the same is true for the studio's latest title for Magic Leap One called Seedling.
Inhabiting the microgravity environment on the cusp of the world's atmosphere has to be filled with some of the most unique experiences in the world. Astronauts eat, sleep, and work just as we do, except that their lives are filled with the added dangers of extreme temperatures and possible life-threatening malfunctions, all while being 240 miles up in the sky. Well, now's your chance to ask a handful of astronauts anything you ever wanted to know about life on the International Space Station.
We're tired of imitation foods. From the "substitute cheese" in our elementary school pizza to imitation crab, we're wondering where all the real food went and just what all those preservatives and genetically modified ingredients are doing to our bodies.
In this video, JulieG shows you how to create a unique and artsy nail look. Why bother with plain old red nails when you can get a unique nail look with hot pink butterflies? Bring your childhood back and bring out the art supplies. JulieG will walk you through each step of the way, until you have gorgeous nails to show off!
Your guests will be very impressed with all the effort you put into these origami invitations. In this clip, learn how to make a totally unique invitation for your next event. These origami letters will set the perfect tone for your next gathering. Have fun!
This clip presents on a guide on integrating CG with real-life or real-world images using the basic capabilities of Blender: nodes, and sequencer. Whether you're new to the Blender Foundation's popular 3D modeling program or a seasoned graphic artist just interested in better acquainting yourself with the application, you're sure to be well served by this free video tutorial. For more information, including detailed instructions, take a look!
In this clip, learn how to create a unique hummus dip with Dede. Dede loves adding interesting twists to her dips and this one is especially exciting. This hummus is made with white beans and prepared with parmesan and basil for an interesting and unique taste. Follow along with this clip and serve this with chips, pita, veggies or even on a sandwich. Enjoy!
Learn how to texture splat in real time with the help of GLSL shading.umetric clouds when working in Blender. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial. For more information, and to get started doing real-time texture splatting yourself, take a look!
These guys make pennies change color in class. No, it's not real gold, and by the way - no, it's not real gold. Just watch and see how to do real alchemy, like you would in chemistry class.
The long and slow road toward the actual release of the Magic Leap One appears to be accelerating, with a couple of new demonstrations of how the system works revealed in this week's creator's portal updates along with the company's developer documentation.
Speakers have been an integral part of smartphones since the beginning. Razer's concept Project Linda even uses the speakers from the Razer Phone to power the faux laptop's audio system. But what if Google's next Pixel phone didn't even have speakers? What if it didn't need them in the first place?
The conversation around augmented reality has largely been focused on apps and gaming, and how AR can be used as a marketing tool. However, a new exhibit at France's Scène Nationale Albi is using AR for more artistic expression.
In this tutorial, we learn how to make a cute Thanksgiving card using stamps. First, cut an oval shape with an oval template. After this, you will stamp the image from the harvest home stamp set on watercolor paper. After this, outline the image with SU markers and color the image in with an aqua painter brush. From here, scallop the edges of the design to make it look more unique. Then, glue the stamp to the card stock and use it as the front of a card for the holidays! Experiment with diffe...
Urgot is a unique champion who can deal out high amounts of damage early in his game, and eventually evolves into a tank/assassin hybrid who can be sent after important enemy targets. Here's a guide for building and leveling Urgot to take advantage of his capabilities to help your whole team.
If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 12th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use Advanced Filter 'Unique Records Only" to extract a list of unique items from a data base, and then use the COUNTI...
Looking for an incredibly unique gift? In this video, learn how to make a cool, long lasting ring out of a coin! All you need is the coin (whichever size is best suited for your finger), hammer, file, emery cloth, saw and a hand drill. With this method, you will be able to see the writing on the outside of the ring, so everyone will know how unique it is. This would make a perfect gift, fashion statement or even wedding ring!
Origami is simple and fun and our host proves that right off by displaying how little we actually need material wise, to make something unique and pretty. Just two swathes of patterned paper, put flush together and a paper clip. First folding your little construction into the shape of a tiny kite It gets very precise from there. Incorporating smaller and smaller folds, but with a close-up view and a step by step explanation, this video will ensure success. After creating your unique abstract ...
If you prefer plastic Christmas greenery over real, we totally understand. While PVC isn't exactly renewable, it is eco-friendly in the sense that you don't need to unnecessarily chop down young evergreen trees and sprigs each year, only to throw them away after a week of use.
There are several different ways to find Maria in Fallout: New Vegas, and this video outlines one of them. Maria is a unique 9mm pistol that handles pretty well in a fight, and it's definitely a weapon you'll want to pick up.
In this video we learn how to make a unique paper rose. First, grab a square piece of paper and fold it into quarters while maintaining the fold. Then, fold along the diagonals and fold lower in half twice and the top in half twice. Then, fold the halves in half and repeat the previous steps. After this, follow the folds that you created, rotating the paper as you continue to fold. After all of the lines are lined up and you have folded it, it will become a unique paper rose that you made! En...
Take the original duct tape wallet idea to the next level with this version! In this video, learn how to craft a complex duct tape wallet sure to impress all your duct tape maniac friends! Show off your unique talent at school with this unique wallet!
Why buy a brand new wallet when you can make one? And out of duct tape! Take the original duct tape wallet idea and kick it up a notch with help from this tutorial presented by Seasonal Science on how to make a multi-colored duct tape wallet. Show off your unique style at school with this unique accessory!
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.
These real easy to grill BBQ Pit Boys "Bad Boy" cheese stuffed bacon hotdogs, and stuffed sausages will be real popular at your next Barbecue. Be sure to make up a bunch for the grill. Watch this how to video to learn those tips and tricks on how to make some real great tastin' grilled bacon hot dogs and stuffed sausages.
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.
As the stigma of online dating fades and swiping potential suitors on your phone becomes the new norm, one very real issue that you may have to deal with is catfishing: the act of being deceived by a fictional online persona. Although dating apps do their best to weed out fake accounts, a few of them slip through the cracks and take advantage of innocent people just looking for a connection.
With barely a whisper of augmented reality during the first day of its developer's conference, Samsung came out swinging on day two with the introduction of its version of the AR cloud and a partnership with Wacom that turns Samsung's S-Pen into an augmented reality magic wand.
The HoloLens team is finally beginning to realize that to truly engage the mainstream, augmented reality needs to make its way out of the lab or factory floor and onto the streets.
The crime procedural show is the perhaps the most direct path to the average TV viewer's heart. Could the same hold true for augmented reality games?
We've seen a number of unique mashups of augmented reality with other bleeding edge technologies, but somehow it took until 2018 for someone to come up with a now obvious complement to AR: 3D printing.
It appears that the new AR app from LEGO is inching closer to release.
Paranoid Android has always been one of the most popular custom ROMs because of the inventive features its developers add to Android. Two of the biggest draws in particular have to be the "Halo" notification bubble, and the "Pie" navigation buttons, which can both fundamentally change the way you interact with your device.
