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 532nd installment in their series of digital spreadsheet magic tricks, you'll learn how to count blanks in a dynamic range using the COUNTIF, INDEX, MATCH, COUNTA and OFFSET functions. Learn about the difference between an empty cell and a blank. Also see how to create dynamic ranges with INDEX and OFFSET (Index:Index).
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 389th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a ctrl-period keyboard shortcut to quickly move the active cell in a selected range.
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 4th installment in their series of digital spreadsheet magic tricks, you'll learn how to add data or a formula to a range of cells by using the Excel's ever-useful ctrl+enter keyboard shortcut.
Everyone dreams of hitting the high notes as a singer, right? With all of the competition out there today, it makes sense that artists would want to 'out-belt' the others.
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 165th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a logical formula to extract values associated with dates occurring in the next two weeks.
In this video the instructor shows how to graph a piecewise defined function. A piecewise defined function is a function that is defined in separate pieces. In these kind of functions, for different ranges of the value of x, you are given different small functions, all of which together make the whole function. This means your equation of the function is given in the form of smaller functions. Now to graph these kind of equations all you have to do is graph the individual equations in the sam...
How to use the Transfer Case manual lever on a 2010 Toyota 4Runner with a few easy steps: The manual transfer case offers three drive modes: two wheel drive high range, four wheel drive high range, and four wheel drive low range. Shift the transfer case from the two wheel drive high to four wheel drive high while in motion. To shift from four wheel drive high to four wheel drive low, come to a complete stop, shift the transmission into neutral and move the transfer case lever to the four whee...
If you want to manage what sort of data is entered into your Excel spreadsheet, data validation will help you to accomplish just that. In this Excel tutorial from ExcelIsFun, the 549th installment in their series of Excel magic tricks, you'll learn how to use data validation to full effect in your Microsoft Office projects.
This video shows you how to use the transfer case electronic dial on the 2010 Toyota 4Runner Limited. This 4 Runner has 3 transfer case settings.4 wheel drive high range free, 4 wheel drive high range locked, and 4 wheel drive low range locked. To change from 4 wheel drive (H4F) to the 4 wheel drive locked mode, you must come to a complete stop, depress the dial, and turn to the (H4L) position. To shift into 4 wheel drive low you must come to a complete stop, shift the transmission into neutr...
Need to use your XBox 360 as a wireless router to tether your other digital devices? While tethering itself is pretty much to the point, what about being able to tether from further distances than ever before? You can actually increase the WiFi range of your XBox 360 by making a few tweaks.
Name ranges of data to make formulas a bit easier to read and write when working in Microsoft Excel.
Chuck Gaskin at Dorchester Shooting Preserve teaches young teen girl the basics of shotgun shooting on skeet range. Watch and learn!
Want to play "Home on the Range" 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 this American folk song (and th...
Make sure you're getting the best experience from your Blu-ray movies on your PS3 by optimizing your PlayStation 3's audio, video and display settings. Scott Lowe for IGN, shows you step-by-step, the exact process for an enhanced Blu-ray experience.
dekePod, a tutorial show on computer graphics and digital imaging from O'Reilly Media, Inc., shows us how to fake an HDR (High Dynamic Range) portrait in Adobe Photoshop. What's HDR? An HDR image packs more pixels than normal into a picture creating billions of color variations and razor-sharp detail. Think your camera can do that? Well, it's possible with special software, but here's how to fake it (good) equipped with only your drab jpeg image, Adobe Photoshop, and this tutorial.
Tony Stark is a smooth talking, genius billionaire playboy that occasionally saves the world... what's not to like? The Marvel films starring Robert Downey, Jr. have grossed well over a billion dollars in the U.S. alone, so it's needless to say that Iron Man is a very popular superhero.
Summer is here, and temperatures are rising. Instead of shelling out for an expensive new air conditioning unit, why not build one yourself with a few bucks worth of old computer parts?
Learn how to do dumbbell regular 21 curls to preacher curls. Presented by Real Jock Gay Fitness Health & Life.
Here's a fun experiment you can do that will demonstrate the effects that pressure has on the freezing point of a liquid. You will amaze your friends as you do what seems to be impossible, turning water into ice without sticking it in the freezer.
Watermelon is not only a refreshing treat but is full of nutrients and energy. Prepare for a summer you will never forget by starting a watermelon patch today. From seeding to watching your plants grow, this is a fun project for the whole family.
Here is a great idea for gifts for absolutely any holiday, give the gift that everyone likes, delicious homemade chocolate chip cookies! Make these cookies with the whole family and then package in a decorative tin.
Nike has launched an augmented reality design tool at its Niketown store in London that lets shoppers customize sneakers and see their designs on a real product.
The world of gaming has never been cooler thanks to Apple's ARKit. From AR arcade games to giant god battles to Pac-Man, we've seen our fair share of awesome and innovative games.
Companies are already clamoring to figure out strategies for integrating augmented reality into their advertising platforms. AR is going to become a huge asset to marketers, and Apple's ARKit is only going to help that along. Mixed reality producer Bilawal Singh Sidhu has given us a sneak peek of what the world of advertising could be with the ARKit.
When my Nexus 5 received the Lollipop update, one of the first things I noticed was how subtle and quiet the new lock and unlock sounds were. Sure, this is a minor quibble, but it's also an easy fix.
Google Earth is the cheapest way to travel the world, i.e., virtually. Their super satellites give us unbelievable access to images from pretty much any place around the globe, turning us all into would-be world explorers. Plus, these images make for stunning wallpapers.
I don't know anyone that likes going to the dentist—few things are more uncomfortable than having someone else's hands in your mouth. But outside of that, not only can the pain of certain procedures be unnerving, the drugs used to numb those pains can be just as uncomfortable. Not being able to feel your mouth for hours on end is a disconcerting feeling. But all that could soon be a thing of the past, thanks to virtual reality.
Using Shazam has quite literally spared me hours of searching the internet for the name of a song I briefly heard for a few seconds. At WWDC, it was announced that iOS 8 now has Shazam technology integrated into Siri. What makes it even cooler is that you don't even need the Shazam app on your device.
We softModders come from all walks of life, and sooner or later, our devices begin to reflect who we are. Maybe you've followed one of our guides on customizing your Nexus 7, such as getting the exclusive Google Experience Launcher or hiding the navigation buttons for more screen space, or maybe you used one of the various Xposed mods we've covered.
Apple is extremely strict when it comes to modifying your iPad, iPhone, or iPod touch. For example, let's look at the dock on iOS 7 devices. You've only really got two options for the dock background, either the default frosty translucent one, or the dark gray version. That's it, and the dark one will also change the look of other things on your device.
Mac laptops, especially the older PowerBooks, often can become very hot when doing processor intensive tasks like movie rendering, YouTube videos streaming, database lookups, or just gaming. Often just lifting the machine from the surface is enough to cool it down without the need of expensive hardware or software tuning.
Smartphones are almost completely controlled through touchscreens now, but most of them still rely on physical buttons to turn it on or adjust volume. When those buttons stop working, you've got trouble (especially if it's your Home button).
There are several ways to send pictures to others on your smartphone—picture message, email, Bluetooth, and even by bumping phones together. Now there's an even more unique way to transfer pictures from one Apple device to another—with sound. Chirp for iPad, iPhone, and iPod touch
You can take some really awesome photos of water droplets if you've got a fast enough camera (and flash), but water drops aren't just spectacular as photographic subjects—you can also make them a part of the photographic process by using a water drop as a DIY projection microscope and even a macro lens for your iPhone. But as useful as a water drop can be, it's still way cooler when they're in front of the camera (as the subject). Recently, researchers from the National Autonomous University ...
Need some creepy visual effects for your alien flick, but don't want to spend a bunch of money? With some pretty basic materials, you can turn an empty aquarium into a "cloud tank," which can be used to create several different atmospheric effects. Before Hollywood started using CGI, cloud tanks were used for scenes in a lot of famous movies. Remember this one? Besides Raiders of the Lost Ark, cloud tanks also helped make some wonderful non-CGI effects in Independence Day, Close Encounters of...
What can you do with a hair dryer besides dry your hair? Lots. You can remove stickers from clothing, clean up crayon marks, and mold your plastic eyeglasses for a better fit. But how about something a little more fun? Well, you can levitate things. Ping pong balls, to be exact.
Earlier this month, Adam Cudworth, 19, launched a camera attached to a weather balloon into the edge of space. Battling tough winds, freezing temperatures, atmospheric pressure and tumbling speeds, the teenager from Worcestershire, England was able to capture these amazing pictures of the Earth's upper stratosphere. How to Send a Camera into Space
Hello! Today I would like to share the process of making your own natural marigold cream. The product does not contain any (artificial) chemical elements and therefore can be called natural. Step 1: Ingredients
How do you make a 1950 Studebaker even cooler? By installing an iPod Nano in the dashboard, of course! The folks over at MAYA Design hacked their way to a touch-controlled sound system with this project they've dubbed the "Nano-Baker" (or "Stude-iPod") using a pair of Apple ear buds, a USB cable, a voltage regulator and a set of speakers. Here's how they pulled it off.
One of the most famous and repeated chemistry experiments involves money. Some would say this is more of a trick than an experiment, but you can be the judge of that. No one can just turn pennies into silver or gold coins, but someone with a few chemicals can. So, if you want to cooler cents in your pocket, try out this chemistry trick yourself. Nurd Rage (Dr. Lithium) shows you how to turn pennies into silver and gold coins using zinc.
