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...
If you want to be serious about using Adobe Illustrator, then learning how to use type is an essential part of your skill set. Type can help you with a wide range of assignments, from designing logos to image building and much more. There are a number of settings and functions when using Type, so it's important to know all of the options that are available to you. This video tutorial will teach you how to use the area type tool in Illustrator.
Want to change your YouTube Channel type? YouTube user webduncetv shows you how. After signing into your YouTube account hover your mouse over user name and click on the word "Account" from the drop down list.
There are tons of apps to help you create unique and compelling posts and stories on Instagram, but you already have the tools you need to make something eye-catching. You can insert line breaks in captions, create translucent overlays for photos, rainbow-up your story font, and even add a 3D text effect to your stories.
HoloMaps, an application by Seattle-based Taqtile, is available for free on the Windows Store. Taqtile, whose Vice President of Product Management was Microsoft's former Director of Business Development, is one of the few partners currently in the Microsoft HoloLens Agency Readiness Program. This interactive 3D map they have created, powered by Bing, offers more than just a top-down view of the world on the HoloLens.
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.
The fill tool will allow you to alter the appearance of objects in your web design document and can be very useful for marketing purposes. The fill tool can be used to give objects one solid color for simple designs.
There are two basic types of launchers you can use to play Beyblade: light launchers and Beylaunchers. They are both effective but play rather differently, so watch this video for a rundown of the differences and different strategies for each launcher type.
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.
In this how-to video, you will learn how to choose a dress that flatters your body type. Jazmin Whitley, the designer for Li Cari, will help you with this. There are three body types in this example: long and lean, curvy, and small and curvy. If you are lean, you should accentuate the waist line. A waist band will help. For a curvy figure, look for an empire waist and materials that have flow. For the last body type, clothes should accentuate the waist line and bring balance at the top. This ...
In this tutorial, Scott Atkinson shows us how to identify different types of bulbs. Common types of bulbs are: tulip, daffodil and lily. These are most easily identified but there are many that appear in flowers. A core looks similar to a bulb but it is a solid tissue and doesn't have an leaves, just a hard core with a protective covering. There is also tubers which are what potatoes and other foods grow from. These cause eyes to form and create different types of things to grow. You will now...
This video shows how to hack the computer password for Vista. We can change the computer password without knowing the actual password. First go to Start menu. Type in the Search "cmd". Then right click on that folder and run as administrator. Then we get a pop up. Type in their net users. Pick the user that we want to hack into. After picking the user type in net user the username and then * . After typing this hit enter key and it should say the command completed successfully and we have to ...
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.
New to Ubuntu Linux? This computer operating system could be a bit tricky for beginners, but fret not, help is here. Check out this video tutorial on how to install Frozen Bubble 2 on Ubuntu Linux.
Get it at: http://www.facebook-bots.com Download it now and beat your friends!
Check out this video on creating type areas and paths in Illustrator. This uses more than just text boxes. You can adjust the font, color and area using the area type tool.
In this how to video, John W. Nixon from Eagle Lake Woodworking demonstrates how to build an Arched-Top keepsake made from Cocobolo. This unique arched-top keepsake box is an eye catching item with a unique feature on the inside, a place to frame a picture. The process for making a dovetailed box is detailed in this video, as well as, the procedure for shaping the arched lid. Watch this how to video and you can create an arched top keepsake box to give as a gift or keep for yourself.
Learn how to airbrush three basic lines types.
The unique Havel Armor in Dark Souls is well hidden, but if you follow these steps from Giant Bomb, you should be able to find the different pieces of the Havel Armor including Havel's Leggings, Havel's Gauntlets, Havel's Greatshield, and a Dragon Tooth.
The profile pages on Google+ allow you to represent yourself in unique ways to other Google+ users. If you want to edit the information displayed on your Google+ profile, such as the title that appears under your name or who is visible in your circles.
Killzone 3 is the biggest shooter to hit the PS3 in quite some time, and one of it's few awesome unique IPs. This video will teach you how to not be a n00b in this awesome game while using the Marksman (hint: spawn trapping), Infiltrator (stabby stab), Engineer (helps Marksman with ammo for more spawntrapping), Medic (revives Marksman for more spawntrapping), Tactician (spawn-point seizing) classes. Spawn
A big part of the fun in Minecraft is figuring out all of the different things that you can craft and how to craft them. Sometimes you just want to make the damn thing though, and to that end this video will show you how to make many of the game's better and more complex to craft blocks. You'll learn how to craft the following blocks:
Beyblade is a fun game from Japan that is very similar to Spinjas but much more complex. If you're new to the game or just ant some expert advice watch this video to learn about the four mains types of Beyblade (attack, defense, stamina, balance) and how they can each be used to play better Beyblade.
The Eldar are the Elves of the Warhammer universe, and like Elves they have all sorts of crazy pseudo-magical powers to destroy their enemies. Their tank is called the Fire Prism, and it is somewhat hard to use since it only has one unique gun. Watch this video to learn the proper tactics for using a Fire Prism in an Eldar army to crush your enemies.
Light shows are one of the best parts of raves, bringing people together to participate in a whole new type of social interaction. Gloves have become the most popular tools of the lightshow trade, and this video will teach you how to make your own custom set exactly how you want them. It discusses types of lights, batteries, and everything else you need to know to make your first set of gloves.
There is no mistaking Lil' Wayne for any other rapper on the scene right now. His look is unique and classic. If you think you can rock being a female Lil' Wayne for Halloween, watch this video to learn how to recreate the amazing Lil' Wayne costume the girl in this video has created.
In this tutorial, we learn how to run a command prompt as administrator (Vista or 7). First, you will click on the start menu, then search for the term "prompt". Launch the command prompt, then a window will pop up with a black window. Type something in to see if it tells you the operation needs elevation. Now, click the start menu and type in "prompt" again. Then, click on the command link, right click, then click "run as administrator". Now, the new window will pop up that says "administrat...
The beautiful game, Football (Soccer for those of you in the US) is full of all sorts of unique and advanced techniques that you can use in FIFA 11 to defend with! Things such as a Secondary Press, Jockeying and even Running Jockey. If you're still getting scored on and are looking for more advanced techniques to try, check out this video for some advanced tactics for defending.
As a guitar player, you will be faced with various challenges in your career, and one of those are being able to blend in with your rhythm section without stepping on anybody elses toes. One way is playing inversions of triads to give a fresh and unique sound to your rhythm and lead guitar playing. In this video you will learn about rearranging triad shapes to make inversions.
The Moog is the original and arguably still the king of the analog synthesizers. It looks like an old phone switchboard, and can create a dizzying variety of unique, warm sounds. This video will show you some advanced features of the Moog, including how to use the sequencer to add filters to your tones.
Head isolations are a type of hip-hop moves where the head moves separately from the body or vice versa, which is central to many popular types of dancing including popping and tutting. This pair of videos offers great step-by-step instructions on how to do different types of head isolations and incorporate them into your dance combos.
