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 39th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how if an array or range is put into a function argument that is expecting a single value, the function becomes an array and delivers an array of values instead o...
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 377th installment in their series of digital spreadsheet magic tricks, you'll learn how to add every other number with the SUMPRODUCT, MOD and ROW functions in one formula.
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 316th installment in their series of digital spreadsheet magic tricks, you'll learn how to count & list unique values as well as how to concatenate a range of values with a separator.
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 189th installment in their series of digital spreadsheet magic tricks, you'll learn how to count all the days except for Sunday using an array formula for a given date range with a specified start and end date.
Paper rolls in a circle to close modem will help to increase the interference WiFi up a lot. This helps to increase your WiFI range and signal strength is low. This is a parabolic antenna to reflect the signal in the direction of your laptop.
The Centauri Knot works well with a wide range of line diameters and should regain around 90 percent of the lines breaking strength. The centauri knot is also fairly easy to tie and is therefor a popular choice by many anglers. The knot is ideal for small hooks, rings and swivels. Watch this video knot-tying tutorial and learn how to tie a centauri not for fishing.
Don't use your magic wand tool. Donny shows you how to create a picture perfect beach scape with a hammock.
OnePlus is on track to deliver Android 8.0 Oreo to its flagship users by Q1 2018. Open Beta 1 was released for the 5T in late December, and we just received Open Beta 2. But this update isn't just tweaks and bug fixes, OnePlus has included a few new features to enhance the Android experience.
Even with today's high-powered devices, battery life is still an issue. We, as users, have to almost habitually check the current battery percentage, because otherwise, we might end up draining too much in the morning, then get stuck with a dead phone at night.
In this cardmaking demonstration I make a really pretty card using a range of pretty papers. The card is a 6x4in card and I go through the layers building up a beautiful card that could be made using any range of papers and any stamps for a multitude of occasions. Step 1: Items Used
One of my favorite things about cocktails is that they're so diverse. They can be sweet or savory, filling or refreshing. And they can take advantage of nearly any ingredient imaginable, including egg whites, smoked ice, flavor cubes, and even beer.
If you're anything like me, your day doesn't start until you've sloughed away your grogginess with a scalding hot shower. That perfectly-heated water can clear stuffed sinuses, relax the muscles, and make pretty much anyone feel squeaky clean. However, a cold shower can do even more for you if you can stand the low temperatures.
It's a small but very real frustration: you want a chilled drink, but you open the freezer only to see nothing but empty ice trays. Fortunately, there's a simple way to make ice cubes quickly—use hot water. Yup, you read that correctly. Hot water freezes more rapidly than cold.
There's only three weeks left until the spookiest holiday of the year, which means stores and costume shops everywhere are bringing out their Halloween inventory full force. So now's a good time to start prepping your Halloween costume—because you really don't want to do it last-minute again, do you?
Check out this video if you are interested in learning about improving your jailbroken iPhone's wireless signal reception. This video explains Wifi booster, an app available in Cydia, which removes Apple's barrier against weak wireless signals, giving you more range.
If you are looking to replace your old microwave with a new one, or making your first foray into the world of microwave cookery, this video can be your guide to installing you microwave in the wall. The Panasonic NN-SD277WR is used as an example.
Wheel pose, also known as Chakrasana is one the most famous poses in yoga. It is well known because it delivers many benefits, ranging from improved strength and flexibility of the back, legs and arms to relief of hormonal imbalances.
Take your cartooning to the next level! This video will show you how you can make your cartoon characters more expressing and emotive with outrageous facial expressions. Watch the artist demonstrate a full range of facial expressions and you will learn how to draw.
Looking for a way to boost your iTouch device's wifi signal at home? The answer is rather simple - all you need is an Asian cooking wok! The shape of the pan functions like a satellite dish, boosting your signal!
Optimize vehicle performance by knowing the differences between the different tires available for your RC vehicle. Each type of tire (commonly referred to by the red dot, blue dot or green dot) is optimized for a specific operating temperature range. Knowing about the different temperatures and what tires are best suited for them could be the difference between first place and second. Find out more in this instructional video.
Multiband processing allows you to apply an effect to only those parts of a track that fall within a certain frequency range. This official video guide from James Bernard of Propellerhead will teach you everything you'll need to know to use multiband processing (like multiband compression) in your own Reason & Record sessions. Whether you're new to Propellerhead's virtual music studio application, Reason, or their newer DAW app, Record, you're sure to find much to take away from this brief vi...
Sniping is a good skill to pick up when playing war games, since it allows you to kill enemies with great accuracy at long range. You'll need to find good spots with decent cover that give you access to enemy targets without revealing your own location.
It's not just for playing video games! Strap a Kinect to a Roomba and wire it together with an embedded wireless-N computer, a range finder, voltage distribution board and an external Li-Poly battery. And voila, you have your own custom made robot!
The boomerang wielding Nomad is good at both ranged stun attacks and crowd control, and can be adapted to fit a variety of play styles. Here's how to integrate Nomad into your own team matches when you play Bloodline Champions.
This tutorial shows you firstly what a boffer spear is (and is not), and then goes over the basic stances and techniques you can use when you're on the battlefield and fighting with a foam spear. Learn how to overcome an entire phalanx with a ranged weapon!
The concept of the Dragon Vein - the ridge of a mountain range - is an important one for Chinese landscape painters. Using a brush made with chicken feathers, this tutorial shows you how to apply a dragon vein to your own landscape art.
This video, from one of the younger pranksters that we've deemed worthy of inclusion on Wonderowto, will teach you how to execute five easy pranks that vary in vindictiveness. They range from swapping someone's shampoo for hair dye to putting ketchup on the bottom of a toilet. All are doable for just about anyone, so try it!
If for some reason, the knobs on your gas range have become damaged or worn out, it may be for several reasons. Buying new knobs can be a pain and cost a pretty penny. This tutorial will show you how to avoid getting your GE oven knobs damaged. It's easy to follow and will ensure that they will last for a long time. So good luck, be safe, and enjoy!
In this clip, you'll learn how to create high-dynamic range images within MAXON C4D. Whether you're new to MAXON's popular 3D modeling application or are just looking to get better acquainted with Cinema 4D and its various features and functions, you're sure to enjoy this free video software tutorial. For more information, including complete instructions, watch this 3D modeler's guide.
The great thing about owning a car is the ability to do whatever you want with it. This ranges from adding a certain type of brake pads to an awesome looking spoiler.
There will never be as many ways to quiet the vuvuzela sounds that buzz out of your TV constantly while you watch this World Cup as there are people bothered by the noise, but there are still quite a few. This video will show you how to use a hardware equalizer to cut out certain frequency ranges, largely muting the sound of the reviled horns. If you have a hardware EQ or are willing to buy one just for this, try it!
If you're hosting a dinner party or get together with friends or family, using ramekins. If you don't know what they are, ramekins are small glazed ceramic or glass serving bowls. They range in different sizes, colors, and sometimes shapes. So in this tutorial, you'll find out how to easily serve veggies using a ramekin. Enjoy!
If you've ever woken up at 5 AM and hopped out to the beach to watch the sunrise, you know that the sky is the ultimate artist, blending an infinite palette of colors that has been the subject of many paintings, including Van Gogh's "Starry Night."
Get that body toned and conditioned for a balanced life with the help of Pilates! In this Pilates tutorial conducted by expert, Ann Arnoult, learn how to use a Pilate Reformer. The Pilates Reformer builds on the idea of mat exercises, adding new levels of resistance with weight-bearing exercises. Improve the quality of movement, posture, flexibility and range of motion with help from a Pilates specialist in this free video.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 58th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the Excel 2007 table dynamic range feature with a data validation drop-down list without using the table name!
A histogram is a summary graph showing a count of data points that fall in various ranges. Histograms are used in statistics and other forms of mathematics. In this video, learn how to create your own histogram using data analysis on the computer. This tutorial will show you how to create a frequency distribution, a cumulative frequency distribution, a histogram chart and an ogive chart with the data analysis add-in.
The slip knot, also called a running knot, is a very diverse knot. It's practical application ranges wildly from crochet and knitting to building a noose. The basic function of a slip knot is to create a flexible knot, with one end tied to the middle for greater mobility. Check out this how to video and learn how to tie a slip knot, because you never know when you might need it.
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about using '$' to prevent excel from changing formulae when copying or filling ranges. For more on absolute cell referencing, watch this Microsoft Excel how-to.
See how to take an HDR photo set (three photos, each with different exposures) using a Nikon D50 digital SLR camera. This how-to video includes a walk through of the settings you should use to take the high dynamic range imaging photo. It pretty much works the same on most digital SLR cameras, so pay attention to this video tutorial.
This medical how-to video demonstrates the proper technique for evaluating a patient's shoulders. Follow along and learn how to do a shoulder physical examination. As with all examinations of the joints it is important to follow a standard routine including range of motion, inspection, and to compare the affected shoulder to the unaffected shoulder. Please note this instructional video is intended for medical professionals.