Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the nth installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to do basic statistical analysis in Excel. Specifically, this video covers the following topics:
Want to play "Bye Bye Blues" on your ukulele? Learn how with this free video ukulele lesson from Ukulele Mike. Whether you play the ukulele or bass kazoo, there is no better way to improve your chops than by learning to play your favorite songs. Not only is it more fun and much easier than running drills or memorizing a chord book by wrote, it's obviously also a wonderful way to build your repertory of songs. For more information, and to get started playing the jazz standard on your own uke, ...
Want to play "When You're Smiling" on your ukulele? Learn how with this free video ukulele lesson from Ukulele Mike, which presents a complete breakdown of the song and its chords. Whether you play the ukulele or bass kazoo, there is no better way to improve your chops than by learning to play your favorite songs. Not only is it more fun and much easier than running drills or memorizing a chord book by wrote, it's obviously also a wonderful way to build your repertory of songs. For more infor...
Want to play "My Blue Heaven" by Walter Donaldson and George A. Whiting on your ukulele? Learn how with this free video ukulele lesson from Ukulele Mike. Whether you play the ukulele or bass kazoo, there is no better way to improve your chops than by learning to play your favorite songs. Not only is it more fun and much easier than running drills or memorizing a chord book by wrote, it's obviously also a wonderful way to build your repertory of songs. For more information, and to get started ...
Want to play "Bye Bye Blackbird" by Ray Henderson and Mort Dixon on your ukulele? Learn how with this free video ukulele lesson from Ukulele Mike. Whether you play the ukulele or bass kazoo, there is no better way to improve your chops than by learning to play your favorite songs. Not only is it more fun and much easier than running drills or memorizing a chord book by wrote, it's obviously also a wonderful way to build your repertory of songs. For more information, and to get started playing...
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 15th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMIF and COUNTIF functions to add and count above some limit.
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.
This video explains how to force flower bulbs to bloom. The instructor first takes a pot and fills the bottom of it with gravel, which then the bulbs are placed right on top of the set gravel. The rest of the bowl is filled with polished show rocks mid way up the bulb to set them properly inside the pot so they are unable to move freely. The instructor then explains that using the gravel and rock filling forces the bulbs to bloom faster then with standard potting soil. The instructor explains...
Learn how to use a 'do while loop' in your Java programming. 1. Set up an 'int' variable named 'counter' and assign it a '0' value. 2. Set up a standard 'do' loop. Make sure to add a counter, so the loop will end 3. Then write the 'while' condition. Make sure that you set the condition to the same variable name that you used in the counter from step 2. Set the variable to '=' 10 (or any number desired)
Need a new prank or trick to play on your friends? Well this video is your solution. All you need a non-transitive dice and to follow this video and you will be cheating your friend in no time. The idea behind this video is to use dice that are non standard, which means instead of having from 1 to 6 on the sides, they have other numbers. By playing with what numbers go on the faces, the viewers can skew with the probabilities of what number comes up. With this idea, the viewers can make dice ...
YourTango presents relationship expert Rachel Greenwald, who breaks down why he didn't call you back. She takes us through the process of learning why men do not call women back after first dates. Find out if you are the type of woman who is at risk of not getting a call back, and it begins with "the blahs", a woman who gives the one word answer to standard questions. Next, see if you suffer from iPod repeatability, the Oprah eyes, or how men call it the Park Avenue princess. If you follow th...
This how-to video is about how to remove a hickey with a battery. This is useful if you want to hide it from your boss, your mom, or even your girlfriend (shame on you, really).
If you want to make some electrodes for electrochemistry, titanium strips are the way to go. It's rather interesting metal, and it's really hard, but can be cut with standard metalworking tools. Titanium filings are highly flammable, just like iron filings. But not everything is what it seems… this quick video on titanium and passivation electrochemistry tells why it makes it a bad anode if used without further treatment.
Perhaps you've already learned how to make the standard origami ninja throwing star, and you want to take it to the next level. You want something that really flies, and has enough heft to knock over lamps in your living room and cause other sorts of property damage. Well, the ninja star frisbee - or super shuriken - is the project for you. Made of six small throwing stars folded together into one big flying lump, the super shuriken is origami with a bad attitude. It is also potentially dange...
This tutorial series shows you how to put up an Adobe Air Flex 3 Encryption System. One of the weak points of Adobe AIR and Flex is there is no encryption system built in, making your data and applications vulnerable. But that's ok, because this tutorial will show you how to remedy the problem by adding an AES encryption system.
In order to make crossword puzzles, you have to have an extensive vocabulary, and that doesn't mean including vulgar words into your crossword puzzle, except maybe boner. Your puzzle design must be symmetrical, of course, and perhaps the standard grid size of 15x15.
In this video tutorial, Chris Pels shows how to create a custom profile provider to store and retrieve data associated with a user profile in SQL Server tables separate from the standard ASP.NET membership provider’s aspnet_Profile table. The principles covered in this video will apply to creating profile providers for other databases like Access and Oracle. After learning how to create the custom profile provider we learn how to install the provider in a web site and see a demonstration of l...
Learn the differences between limit and no limit Texas Hold'em. Understanding the differences allows you to play two different ways and will help you determine which game is more suited for you, no pun intended.
The Files app received a big update in iOS 13. Before, it was limited to local and cloud-based files, but now you can access data from external storage devices, including SD cards and USB drives. But before you try to connect your favorite card or drive to your iPhone, there are a few things you need to know.
With the first pop-up showroom for North's Focals smartglasses opening its doors next week, customers are now able to purchase the smartglasses at a drastically lower price tag.
Open TikTok, and you might find yourself spending hours watching video after video. While each video is usually pretty short, it's highly possible to binge-watch hundreds at a time. It's even more fun to create your own. But as a parent, you may not want your children falling into this same trap, and it's easy to limit how much time they spend watching TikTok videos on their iPhone.
Back in July, Google rolled out a new design for the web version of Gmail. The rollout included new features alongside the visual changes, one of which being Confidential Mode. This new privacy-centric feature has now finally arrived on the mobile app version of the service, and here's what you need to know.
Thanks to their partnership with Tidal, over 30 million Sprint customers can access Hi-Fi audio on the go. And the Jay-Z-owned music service isn't limited to just Sprint customers — for $19.99/month, anyone can listen to lossless audio from their favorite artists. But streaming uncompressed audio files uses a lot more data than standard quality, so how do you use Tidal without hitting your data cap?
Mobile data is expensive. The internet connection that comes with your cell phone plan is generally limited to a certain amount of gigabytes that can be downloaded before your monthly cap kicks in, at which point you run the risk of incurring costly overage fees.
According to the American Osteopathic Association, "1 in 5 teens has some form of hearing loss," and some experts believe it's because of an increase in headphones use. While I understand that music, movies, and video games help keep children preoccupied, there's no reason why they can't be entertained at a healthy hearing level.
To be honest, these Christmas ornaments look more like sea urchins than stars to us. Either way, these festive ornaments are beautiful and cheap alternatives to purchasing standard ornaments at the store. Give each ornament character by using a different color or pattern paper.
If you want to get more out of your AppleTV, Boxee is the way to go. Dave Mathews from Boxee— no, not "Dave Matthews"— shows you how to get the HTPC program installed on your Apple TV.
In this video, we learn how to tailor your resume for foreign countries. When you are writing the resume, you need to keep in mind the: length, content, demands, passport, and hobbies. You should make sure the content is descriptive and you focus on your accomplishments. Don't focus on the family and references, these are not required on the resume. The recruiter wants to know more about your professional life, and if you have a passport to travel. Depending on the country you are traveling t...
There exists a small set of makeup skills that is essential for your fashionable survival in the lipstick jungle: How to do the perfect red lip, how to shape and drawn in your brows, and how to do the perfect smokey eye. With these skills you'll be able to create a makeup look to suit any occasion, and we guarantee it.
In order to make the side step Christmas card, using Cricut, you will need the following: card stock, cutter/trimmer, adhesive, rhinestone, ribbon, and a bone folder.
Justin Bieber has just become the newest Proactiv spokesperson, showing that no matter how many people are looking at you (he performs for crowds of thousands), you never want acne on your face. While you may head back to your classes with fewer people paying attention to your face, pimples can still be quite the pain in the ass.
Want to play "Pearly Shells" by Edwards & Pober on the ukulele? Learn how with this free video ukulele lesson from Ukulele Mike. Whether you play the ukulele or bass kazoo, there is no better way to improve your chops than by learning to play your favorite songs. Not only is it more fun and much easier than running drills or memorizing a chord book by wrote, it's obviously also a wonderful way to build your repertory of songs. For more information, and to get started playing this great tropic...
In order to make a miniature baby doll bottle to be used in a dollhouse, you will need the following: orange paint, white paint, a paintbrush, and a light bulb from a string of white Christmas lights. The light bulb must be a standard light bulb. It can't be a replacement bulb, because it needs to be clear. The wires do not need to be removed.
In this Autos, Motorcycles & Planes video tutorial you will learn how to install a Borla exhaust on a Ford F150. For this you will need a 15mm and a 10mm wrench, a 15mm deep socket, a 10mm standard socket, a ratchet, safety goggles and work gloves. First remove the spare tire and the heat shield. Using the 15mm wrench loosen the nut on the clamp on the muffler. Unbolt the hangers from the vehicle and remove the kit by turning it counterclockwise. Next put the new exhaust in place, take the sh...
Yanik Chauvin teaches us how to safely pack photo equipment for travel in this tutorial. First, remember to have good insurance on all your equipment, just in case something does break. To pack your things, use a backpack that is specifically made for cameras. Also, arrange for the lens not to be attached to the body of the camera while traveling. If you have to have it attached, make sure there is something under your lens to protect it from any additional shock. If you don't have a backpack...
In order to prepare Rice Pudding without Eggs or Custard, you will need the following ingredients: 1 liter of milk, 1 lemon rind, 1 cup of pudding rice, 1 cup of caster sugar, and rose water (or other flavorings).
Anything a baby wears is cute, but when your little babe slips on this adorable fuzzy bumblebee sweater. With a bright yellow yarn body and striped black arms, all you really need to add is bumblebee wings and your kid will be the most adorable thing on the block.
This clip covers the confusing array of buttons and controls in Blender that are used for the different functions. Specifically, it talks about context and sub-context buttons, presets for TV broadcast (and the different standards for those) in HD or high-definition broadcast. 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 vid...
The Matrix had all sorts of stunning visual effects that have become standards in film since its release in 1999. This video will teach you how to create just one of them, the film's iconic titles, using the Adobe Premiere Pro editing suite.
Interested in putting a linear equation in slope-intercept form? See how it's done with this free video math lesson. Need help finding the 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 finish your homework or study for that next big test). With this installment from Internet pedagogical superstar Salman Khan...