Thousands of Android users have been disappointed to learn that getting the latest firmware update isn't as easy as it sounds. Some really popular phones like the Samsung Galaxy S III just started getting the Jelly Bean upgrade, with the update continuing to roll out over the next couple of weeks overseas. All of the stateside S3 users will have to wait even longer for Android 4.1.
Want a way to dynamically reference the number of instances of a given word in a Microsoft Office Word document from Excel? Who doesn't, am I right? In this Microsoft Excel tutorial from ExcelIsFun, the 543rd installment in their series of Excel magic tricks, you'll learn how to do just that.
Learn how you can create bouncy, curly hair using a flat iron with this how to video. In this video a Barbar Ionic-Titanium Plate Flat Iron BAR-1300 1.5" is used. This is a great tip so you don't have to buy a flat iron and a curling iron. With this trick you will be able to curl your hair using just one product, a flat iron.
For most instances of red eye, the built in tool that comes with Adobe Photoshop is enough. But in some cases, the tool might not be enough, especially if it changes the skin tone. Here's a good way to get rid of especially severe cases of red eye on your photos.
Convertible dresses are the best, especially when you like the color and general form of a dress but you'd like to give it new life by enhancing your waist rather than your bust line, for instance.
One of the reasons that MMA is cooler than boxing is the abundance of different moves and strategies that can be used in any situation. Take this video for instance. In it Hillary and Joanne of MMA Girls will teach you how to go from a gi collar choke to a fake scissor sweep and then into a triangle choke, hopefully to win the match. Wow.
Starting from scratch, this tutorial for the 3-D modeling software Modo 401 3D shows you how to create low-resolution, low-poly background pieces that nevertheless look professional and polished for your setting. Use multiple instances to populate a background easily and quickly.
Watch this instructional video to begin drawing figures in realistic poses. Ask yourself, what are these people doing? Human figures are constantly shifting balance. For instance, an elbow should relate to a knee. The human expressions do not have to be anatomically perfect as long as they relate to the other objects within the space.
Unity released the Beta 5.6 on December 13 with a bunch of new upgrades in the works, including support for Vulkan, better instancing options, and more improvements to particles—to name just a few that are potentially relevant to the mixed reality community. And today, December 15, Unity has just released the EditorVR that we reported on a few weeks ago as a part of their "Experimental" builds.
Veteran writer Holly Lisle gives good advice on how to become a better writer by eliminating passive voice from your prose. Go through your manuscript, and delete as many instances of the verb 'to be' as you possibly can to tighten up your writing.
There's something about marbling that makes anything it touches more elegant and refined. Marbeled kitchen cuntetops, for instance, look like something out of a Home Depot catalog, while marbled cakes, like the one in this video, are interesting and quite pretty.
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 181st installment in their series of digital spreadsheet magic tricks, you'll learn how to count words (case sensitive) using the SUM and EXACT functions in an array formula.
So you're suiting up for a heroic instance in World of Warcraft, and you're playing an agility or DPS based character - what's the best gear to get? This video shows you all the best gear that doesn't come from loot drops.
This is a very specialized guide for players of World of Warcraft, especially the Cataclysm expansion. The video shows you how to construct an elemental shaman as the perfect DPS machine, making you a valuable addition to any raid or instance.
Sometimes server space can be an issue, especially when you're talking about costly actions such as iteration, file scanning, and numerous queries. In those instances it's often best to cache! This tutorial gives you a simple example which can help your site load faster and take less abuse.
Cho'Gall is the last and toughest boss to kill when you're playing the Bastion of Twilight instance on World of Warcraft: Cataclysm. Here are some great tips and tricks you can use when you and your guild are taking him on.
Functions allow you to repeat particular actions without having re-code them for every instance. This tutorial shows you how to set up and use your own functions when you're writing a program using Python. Make sure all your functions are well defined before you start using them!
Lots of people mistakingly think that red wine can only go with steak dishes, and white wine can only go with seafood dishes. But this is not always the case, as you'll see in this video.
A numeric stepper component is one which you can add to your website to allow users to select numbers or from a list of avaiable items - useful, for instance, if you wanted a webstore which allowed for a quantity function. This Adobe Flash CS3 tutorial shows you how to create and use a numeric stepper component.
One of the new features of Adobe Photoshop CS5 is the content-aware fill feature. For instance, if your photograph was taken at an angle, but you want to level it out without losing any of the image, this tutorial will demonstrate how you can achieve this effect.
Make the texture of a flower petal, porcelain vase or blade of grass really pop in your image! This tutorial goes over the various texture effects you can apply to your Photoshop projects, and a few tips on the best instances to employ them.
In German, nouns will decline, or change their spelling and pronunciation, depending on how the word is used in the sentence. The definite article will decline with the noun, and this video teaches you which of the six forms and sixteen positions is correct to use in each instance.
Sometimes the most common, everyday subjects are also the best for practicing basic drawing methods like drafting and shading and contouring. Just take the truck, people, bridge, and garden in this drawing tutorial, for instance.
If you have a front load washer that won't stop filling, then you have a problem on your hands. Not only can it make the floor slippery, but it can also cause damage to your home as well.
Sure, individually wrapped straws of the sort found at your favorite café, diner or fast-food joint might seem like a colossal waste — and actually be a colossal waste, for that matter — but there's no denying that there's a lot of fun to be had with the straw wrappers themselves. With this tutorial, for instance, you'll learn how to make a cinchy paper inchworm.
There are many instances when you may need to crop an image. Whether you need an avatar for a social networking site, or a specifically-sized image to insert into your website, Adobe Photoshop is an excellent tool to use. Learn how to bring an image into Photoshop and all the various tools one can use to crop the image in this video tutorial.
Apple's web browser, Safari, stores information like web history, Google's search history and cookies from websites. There may be certain instances where you want to keep this information private–for example, if you're on a public computer or have borrowed a computer from a friend, you may want to keep that information to yourself. For a step-by-step guide to using the private browsing feature in Safari, watch this OS X video tutorial.
Draw with a systematic process that combines creative intent with technical ability. Watch this instructional drawing video to cover the key points involved in making a complete looking drawing. A complete drawing is all about intent. For instance, line placement is much more important than line quality. Be aware of the juxtaposition of forms.
Some plugins load 1 instance that can control several patches. This tutorial shows you how to set up multiple out plugins in FL Studio to do just that.
The famous ADSR Envelope (Attack, Decay, Sustain and Release)... It's seen in almost every virtual instrument or software synthesizer from Albino to Halion to SampleTank to Z3ta but do you know what it does?
While there are a variety of privacy-focused search engines available like StartPage and DuckDuckGo, nothing can offer the complete trust offered by creating one's own search engine. For complete trust and security, Searx can be used as free metasearch engine which can be hosted locally and index results from over 70 different search engines.
For the unaware, RED is a company that specializes in high-end cameras and other recording devices. RED's cameras are used to shoot some of Hollywood's biggest films and TV shows. Their modular designs make them ideal for the user who does a lot of mixing and matching — and has a wallet to back their work up (their WEAPON 8K VV starts at $79,500).
I'm sure you've been there—halfway through typing something out, you realize that one word you've been using more than any other has been misspelled. Perhaps it's a single word, acronym, or line of code that you find yourself typing quite often at work, but this one requires complicated hand gymnastics that you'd simply rather not perform over and over again.
NJStar is a program which you may purchase online, and which will allow you to translate individual Chinese characters. This tutorial shows you how to use the software, and explains the limitations of the progam (it cannot translate whole paragraphs, for instance).
We're not saying that we don't like Rihanna's current red fauxhawk, but back when the curvy diva had longer hair she pulled off some major trendsetting hairstyles.
Anticipation is building for the release of the Essential Phone. Andy Rubin's newest creation is expected to be loaded with features like a rear fingerprint reader, attachable 360-degree camera, and an edge-to-edge display. However, a news release from Sprint has just revealed that it may take more than $700 to get your hands on the Essential Phone. The release revealed that the Essential Phone will be exclusively carried by Sprint, so it might be time to switch your wireless carrier.
Restoring data is not always the easiest thing to do when you flash a new ROM on Android. Google can back up your contacts and Wi-Fi passwords, and various tools can back up your apps and data, but the rest is usually lost in-between ROM flashes. This leads to a lot of wasted time getting everything back into place, and it'll take a long time before your new ROM feels like "home" again.
Welcome back, my fledgling hackers! The database is the hacker's "pot-of-gold," as it contains information that is very valuable to both the business and the hacker. In this, the second of my series on hacking databases, we're on the "hunt" for Microsoft's SQL Server. Although far from the most commonly used database (Oracle hold's that title), Microsoft's SQL Server is very often found in small-to-medium sized businesses. Even a few big businesses use it.
Here's a quick and easy video tutorial on how to root any Qualcomm-based U.S. or Canadian Galaxy S4 Android smartphone.
Have you taken a photo that's perfect in just about every sense other than one? Like, for instance, that picture of you and your newly minted husband dancing at your wedding reception with your husband's drunken brother getting freaky with one of the waitresses on the side?
