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 334th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the IF function. This video starts with IF function basics and then shows 12 different examples of how the IF function can be used in formulas. Also see how to use AND, OR, SUM, AVERAGE, STDEVP and VLOOKUP functions.
From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just study for that next big test). With this two-part installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to graph a rational function in college-level algebra.
This C++ programming tutorial goes through the use of functions, pointers, how to make fullscreen, and changing colors per line.
As advanced as the Galaxy S9 is, it can still be susceptible to the occasional hiccup. Several factors can cause your smartphone to behave erratically or become unresponsive, such as buggy apps or updates that didn't properly install. Luckily, most of these issues can be easily resolved with a press of a button — or two, to be exact.
The transition from Android KitKat to Lollipop was pretty drastic in the looks department. Google's new Material Design guidelines changed the way many parts of the UI function, like the notification drawer, status bar, and most notably, the lock screen.
The Widowmaker boss in Resistance 3 is fairly intimidating. You'll need to properly locate her weak spots while avoiding getting destroyed by her acid. To beat the Widowmaker, you'll also need to move rapidly through the environment using cover and the zipline in the area. Use this boss fight guide to find out how to take her down.
If you want to embed an iFrame into a Blackboard 9.1 page, you'll need to grab the code from whatever source you want (YouTube, Vimeo, Google Docs, etc.) and use the Build Content option in Blackboard. Select "Item" under the "Create" menu and turn off the Text Editor so that you can properly paste the code in. Take a look at this tutorial to see all the steps in action.
If you're planning on doing some bondage knots, you better learn how to do it right. This video shows you how to properly tie off a titanium suspension ring for use in your bondage activities. This video is clear and straight forward, using a large piece of rope, making it easy to see exactly how it's done. Remember to be careful with your S&M knots, especially if you're suspending someone's weight.
The key to being able to perform yoga properly is in the breath. This tutorial shows you how to get started on breathing the yogic way. Use your entire lung capacity to take slow, measured breaths and focus on your diaphragm.
Time lapse photography is a common film technique to capture subtle processes, such as star movement or sunst. This tutorial shows you all the equipment you'll need, how to set your camera up properly, and how to string it together for a film.
Learn to play "Little Drummer Boy" on guitar for Christmas by following along with this upbeat and lively instructional video of the classic holiday tune. Erich from Your Guitar Sage shows the chords, simplified strumming technique and basic style for properly playing the song.
Learn to play "Silent Night" on guitar by following along with this helpful instructional video of the timeless holiday classic. Erich from YOur Guitar Sage shows the chords, strumming technique and style for properly playing the song.
Your target in level 3-13 of Angry Birds is not so much a pig fortress but a series of pig-defended hilltops. Still no problem for a properly trained bird army. Watch the video for a guide to beating level 3-13 with three stars.
Call of Duty Black Ops manages to be frantically fast-paced and highly tactical at the same time, and strategizing for each map properly will get you many kills. Watch this video for some strategy tips for the Launch multiplayer map on team deathmatch.
Buying a used car is a task humbling in it's complexity, but certain parts of it are still simple. In this video you will learn several easy, effective ways of inspecting a used car you want to buy to make sure it hasn't been in a flood or accident and has a properly working engine.
If you have a still image from Photoshop that you want to use in After Effects, how do you get the file to work properly? This video covers this question, showing you the preparations involved with taking a print design and preparing it for use in Adobe After Effects. Importing as footage and compositions is also covered.
Heart palpitations can be a serious problem if it's not monitored properly. If you're starting to get more and more heart palpitations, or if you've been experiencing them recently, it might be a good idea to watch this video. In it, you will learn what signs to watch out for before going to the doctors, as well as tips and various techniques that you can use to calm them down and keep them to a low frequency.
A Nebulizer machine is a device that allows Asmtha medication to be administered in wet mist form by using compressed air. These devices are slower than a normal inhaler, but very effective. This video will show you how to use a Nebulizer machine properly for the treatment of you or your child's Asmtha symptoms.
The Pulmicort Flexhaler is an dry powder inhaler for administering steroid medications to Asmtha sufferers to prevent their symptoms. They are a little different than a traditional dry powder inhaler, and this video will show you how to use and store one properly to ensure relief and durability.
Are you so good at freestyle soccer that mere crossovers are boring you? Why not try this more advanced combo trick, dubbed the CO-360-CO, or crossover-360-crossover. This video will show you how to do it properly, with the key being mastering the crossover first.
Though rodents may have a bad reputation, a rat can make a great pet for kids. Rats need a good sized cage, lots of toys and regular trips to the vet to maintain their teeth and make sure they don't get sick. Follow these tips to keep your new pet happy and healthy!
Have a formal event on the horizon? Want to put your best fashion foot forward? Looking your best at a prom, wedding or black tie event means wearing a properly tailored tuxedo. Take the proper measurements to ensure perfectly fitted menswear.
In this free video language lesson, you'll learn how to say and properly pronounce the Spanish word for "good." Interested in learning Spanish but haven't got the time to take a weekly class? No problemo! The Internet is awash in free, high-quality video lessons like this one. For more information, and to get started using this phrase yourself, watch this helpful video guide for Spanish students.
If you've been working on a project and need to know how to put up a door using a butt hinge, this video should help. In the tutorial, The Wood Whisperer, will let you know what tools you'll need to determine how to properly install a butt hinge mortise. Installing it incorrectly can result in an off balance door and can be tedious to try and fix. So check out the video for more information, take notes, and good luck!
This next tutorial is going to show you just how easy it can be to check your vehicle's alternator. There isn't really much that you need, just a tester or DVOM and some time.
In this clip, learn how to avoid a messy, crumby, goopy cake by following a few tips. Frosting a beautifully smooth cake is easy as long as you know what you are doing. You don't need to hire a professional to ice that little birthday cake, just use this helpful tips and your creation will look gorgeous everytime!
Blinking is one of the most basic things that mammals do, and making your animated characters do it properly will make them look much more natural and expressive. This Flash CS5 tutorial video will show you how to make an animated character blink using movie clips. Trust us, this is definitely worth doing. People WILL notice if your characters don't blink.
If your iPad's battery is malfunctioning or not performing properly for any reason, check out this clip. In this tutorial, you will learn how to very carefully disassemble and remove the battery from the back of your device so that you can replace it with a new one. Perform surgery on your beloved iPad with help from this video. Good luck!
You may or may not have known, but mowing your lawn can actually help keep it healthy and promotes root growth. It also makes your yard look great and helps it stand out from any other bad looking yards on your block.
In this tutorial, hosted by pet expert Marc Morrone, learn how to care for 'pocket pets' such as gerbils, hamsters and rats. Rodents and other small animals actually make fanstastic pets. In this clip you will learn all about them so that you choose the right one for you and take care of them properly.
Parakeets are small, colorful, friendly and chatty and all of these reasons make them great pets for kids. In this clip, learn how to select and care for your little feathered friends with pet expert, Marc Morrone. You will get the 411 on these colorful critters and learn how to keep them happy, healthy and singing all day long.
In this tutorial, animal expert Marc Morrone shows you exactly how to feed and care for your pet bird so that they live a long, healthy life. Check this out and learn when, how and what to feed your feathered friends.
Reptiles need special food too and in this tutorial, Marc Moronne will show you exactly how to care for your scaley friends. Make sure you give your reptiles the right amount and type of food so they can live a long, happy and healthy life.
Make sure you keep your bike in top shape by tuning it every once in a while. In this video, learn how to properly tune your 3 speed beach bike so that it runs safe and smooth all summer long.
When you adopt a new cat, it is important to make sure you know what is best for their health and happiness. In this tutorial, learn how to get the right food for your pet and feed them properly so they live a long and healthy life.
Rabbits are adorable, furry little friends. If you are thinking of buying a rabbit for yourself or your family, have a quick look at this tutorial. In this pet video Marc Morrone will show you the best way to care for rabbits and find out why they make great pets.
This video features a former bass fishing guide explaining how to use a drop shot rig properly when you fish. The presenter in this video is fishing in February, so his chances of success are low, but his points are valid and should help get you a little closer to catching 700 bass like he did in 2008.
Video game controllers can get pretty grimey. The more greasy hands that come into contact with your Xbox, the grosser your device will get. In this tutorial, learn how to clean your controller using gloves, water and dishsoap. Follow along and make sure you know what you are doing so that you don't ruin your controller.
Dogs are famous for being man's best friend and in this tutorial learn all the basics on taking care of your new little buddy. In this pet video Marc Morrone will show you the best way to care for dogs and find out why they make great pets. Start looking at the world from your dog's point of view with the helpful hints, tips and advice found in this clip.