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 199th installment in their series of digital spreadsheet magic tricks, you'll learn how to apply conditional formatting to a vertical histogram based on a frequency distribution in Microsoft Excel 2007.
Ever hear of Swag Bucks? It's an online portal dedicated to helping you earn digital dollars called "Swag Bucks", which can be redeemed for exclusive swagbucks.com merchandise.
A guide to hunt the Yian Garuga on Monster Hunter Freedom 2. Walkthrough for Monster Hunger Freedom 2.
Backing up your digital photos with Apple iPhoto while running Mac OS X can give you peace of mind of knowing that you will not accidentally lose your precious photos. In this video tutorial, you'll learn how. For more, or to get started backing up your own photos in Apple iPhoto, watch this how-to.
Has your Windows PC grown increasingly sluggish over time? In this how-to, Digital Connector James Vargas (recalling a young Jean-Pierre Léaud) guides users through speeding up and optimizing a Windows PC. Take a look. Whether you run XP, 2000 or Vista, you're certain to benefit from this tutorial.
This tutorial will show you how easy it is to create panoramic images from your photos in Windows Live Photo Gallery for Windows XP or Vista. All you need is a digital camera and a PC.
Check out this Blender video tutorial all you wannabe digital animators out there to see how to use paths and dupliframes in your 3D modeling.
This is one of the ways that artist Merrill Kazanjian makes his caricatures. He shows the viewer how to make a traditional/digital hybrid (tradigital) collage portrait. Look for interesting eyes, noses and mouths from different photographs. Make an oval for the head and paste down the facial features. Watch to learn more.
Learn how to get started in Photoshop Elements by importing digital photo files from your files and folders or off of CDs.
Learn how to paint digitally in Photoshop over a sketch.
Bre Pettis explains and shows you different microphones and lets you listen to them too. From lavelier mics to shotgun mics, you'll learn the tips to get the best sound you can.
This video gives you a tour on the NRV10 by M-Audio. It shows you how to use it as a mixer, an interface, and to use it in a studio or live. It is also compatible with ProTools M-Powered 7.3.
This tutorial shows you how to create a 3D sketch using points and then how to use the sweep tool to create the final shape in Autodesk Inventor, a digital prototyping software. Knowing the interface of the software will be helpful so you can find the exact tools being used.
Hand coloring black and white photographs was a common process prior to the advent of color photography and created a unique visual aesthetic. This video demonstrates how to digitally create this style for digital black and white photography.
iMovie allows the average computer user the ability to quickly make movies out of your digital video footage or home movies. This is not the most professional way to color correct your footage, but it should be sufficient for the average Mac user. Follow along and see how to adjust color using iMovie.
Are some of your most precious memories stored on pictures that look too dark? This video demonstrates how to brighten digital pictures and photos using Adobe Photoshop.
Some people believe that art makes artists immortal, and now one of the best known performance artists on the planet is working on taking that immortality into the realm of augmented reality.
Amazon Prime Video is undoubtedly one of the best services out there for streaming and downloading movies and TV shows to your iPhone. If you try to buy or rent a movie or show in any of Amazon's iOS apps, however, you'll notice that there's no apparent way to do so. No buttons, no links, nada. What gives, and how can you buy and rent content from Amazon on your iOS device?
Coinbase is the primary go-to for many users when it comes to investing in Bitcoin (BTC), Ethereum (ETH), Litecoin (LTC), Ripple (XRP), and more, due to its user-friendly interface. But before you join them, know that the ease of use comes with a price. Coinbase charges fees for each transaction, and your bank might even add charges on top of that. Plus, there is some fine print to be aware of.
When you have an infection, a doctor prescribes antibiotics to make the bacteria that causes it disappear. Sounds like a good idea, but the disappearance of microorganisms that have inhabited humans for millennia could be driving rising numbers of serious illness and debilitating conditions.
Enjoy this relaxing video and use it as a path to meditation. Forget your problems for 3 minutes and let you mind wander in the clouds. The digital enhancements applied to some of the skyscape scenes will allow you to see all kinds on shapes as your mind is let free to interpret.
Historically, battery life has not been a strong suit for machines running Windows. Poor decisions by hardware manufacturers combined with the resource-hogging behavior of Windows are to blame. However, Microsoft is trying to resolve this issue, once again, with the release of Windows 10.
AMERICAN LIFE (not so) STEREOTYPE
You don't need to be a robot to be overly concerned with battery life, especially if we're talking about Terminators, which have nuclear or hydrogen fuel cells that keep them running for years straight. It will be a long time before smartphones get that upgrade, so in the meantime, we have to figure out how to make them last more than a couple hours in a single charge.
What's the meaning of life? That's the age-old question; but can it ever really be answered? I mean, isn't life just a big game anyway? Perhaps, a game of inches?
When was the last time you bought a CD? Most of us listen to music through a number of digital channels—MP3s, Internet streaming services like Pandora and Spotify, and satellite radio, to name just a few.
The Minecraft 1.9 update introduces a very dangerous and scary option--the ability to play Minecraft in hardcore mode. Hardcore mode provides you with one life, meaning that dying in the game will completely delete the world and force you to restart. Find out how to turn on hardcore mode in this tutorial.
Photoshop remains one of the coolest digital editing tools of all time, and if you're a user, you're likely discovering new tricks every day. One of the most helpful tricks is removing a shadow from an object, such as a face, a car, a cat, a dog or like this tutorial, a child. This excellent tutorial walks you through each and every step to show you how to use Adobe Photoshop to make those shadows vanish. Check it out and clean up your photos today!
Oscillators are basically just machines that make waves, but they are used everywhere in modern life and if you want to know electronics you should understand them as well. This video will teach you how oscillators work, what they're for, and how to make some simple circuits with sine and square wave models.
If you're working with a capacitor and wondering whether it's working or not, this video will help you find out. You're going to need a multimeter, available at any good electronics store. This device is capable of testing many different electric devices, and capacitors are one you can test. Set the dial, hook it up and see if things are working! These multimeter devices are essential in the world of home electronics, so put one in your tool kit today!
The iPhone is an indispensable part of it's owners lives, and very fragile. If yours has broken and you don't want to shell out the cost of the phone again to have it fixed, watch this video for an easy guide to repairing a broken screen and digitizer (touchpad) using parts you can order for cheap on eBay.
This video will show you what you'll need to know to hack a digital electric meter. You'll need 2 magnets, one much bigger than the other, an AC adaptor that you'll cut into pieces, or some speaker wire, distilled water, electrical tape, a knife, some plastic wrap, and a plastic cup. Remember, this is illegal, and shown only for educational purposes.
In a survival situation making cordage out of plants can enable you to construct apparatus you never would have been able to otherwise and save you life. This video will teach you how to make a meter of cordage out of 2 leaves from a Spiked Aloe plant.
WHen above ground in Minecraft finding true North is relatively easy. But just like in real life, figuring out what direction you're going underground isn't easy. This video will show you an easy way of figuring out which way is North underground in Minecraft.
Smartphones are becoming pocket computers, jammed full of data essential to our personal and professional lives. With AT&T's 360 Backup app you can protect your important information with the push of a few buttons.
Men and makeup have long had an awkward relationship. If you're man enough to admit that makeup would probably make you better looking, or want the man in your life to come to that conclusion, watch this video for a guide from the illustrious web beauty guru Michelle Phan on how to apply subtle, natural-looking makeup on a guy.
FL Studio is one of the biggest names in digital music-making software, and Korg the biggest in physical gear. Unfortunately, FL Studio and the Korg nanoKontrol USB controller don't get along out of the box, and the transport buttons on the Korg won't work with FL Studio. That is, until you perform the steps in this video that will lead to a blessed union of software and hardware.
Yiruma is one of the biggest names in contemporary piano composition. His song "Kiss the Rain" is guaranteed to make any listener reflect honestly on their life in a way that few songs ever have been, and in this video you'll learn how to play the whole thing on piano. It's not easy, but you can do it!
Nowadays digital and analog synthesizers can produce a nearly infinite number of sounds, and many of them sound terrible to most people. If you find yourself more in the Trent Reznor music camp though and love making dystopian, harsh sounds in your music, watch this video. It will teach you how to make a really harsh, dissonance filled lead synth track in Reason 4. Great for glitch, industrial, and other abrasive electronic styles.
NBA 2K11 is finally breathing some life into the long-stagnant world of basketball video games, introducing new elements and bringing back old ones that people missed. In this video, you'll learn how to use the isomotion dribbling system to do freestyle dribble moves with greater control and score more points.
