Today we are going to learn how to sort data in a Microsoft Excel 2003 spread sheet. We will go over single column and multiple column sorting. In a single column sort you may high light the data or just click on any cell in the column. Once the data is selected look for the sort icons just under the menu bars. There is a sort ascending and sort descending icon. Click on the icon and Excel will sort the list. When sorting multiple columns the data must be in columns next to each other. If the...
In this how to video, you will learn how to make a reflection in water using Photoshop. First, open the image in Photoshop. Select the crop tool and select the whole photo. Click and drag the lower part down. Select the rectangular marquee tool and select the picture. Click on the selection and select layer via copy. Click the move tool and drag the upper point in the picture to the bottom of the document. Go to filter, blur, and select motion blur. Choose a -90 degree angle with a 35 pixel d...
This how to video shows you how to create a nebula star scene in Photoshop. First, create a new image in Photoshop. Fill the background with black. Next, create a new layer and call it stars. Go to filter and select noise. Choose Gaussian and click monochromatic. Click okay to add the noise. Once that is done, go to adjustments and levels. Change the settings so that you have less clutter. Next, make a selection in the middle. Copy and paste it as a new layer. Go to edit and select free trans...
Craig Madox from TubeTutorials shows how to create and put ringtones on your iPhone 3G. If you already own the song, you shouldn't have to pay for it again as a ringtone!
This video shows Nikon Autofocus setting for action. Getting started on setting up the AF for action.
In this Photoshop tutorial the instructor shows how to do retouching to produce undead skin makeup. This video shows how to make a convincing, undead like, vampire skin make up. First open a image of the face which you want to make it look like undead face. Go to the channels panel and make a selection of just the face with the skin and exclude the rest of the head which includes the hair and other stuff. Now open a new adjustment layer and open the color balance tool. Fist select the mid ton...
Save money on prom transportation by turning your parents’ station wagon into a one-of-a-kind limousine.
Make life easier by printing to your nearest PC printer the first time, every time. You Will Need
In this cooking how-to video, Tracy prepares some sorrel. Sorrel is a traditional Jamaican Christmas drink. Follow along with this video cooking lesson to learn how this drink is prepared
As a kid, I was always interested in what was beyond our world. I remember lying down on the top of my dad's car and watching the stars for hour, gleefully excited whenever a shooting star streaked across the night sky.
Rum is no ordinary liquor. If you have a yearning for some rum, you need to know the basics of rum culture, like what rum is (and isn't), what kind of rums are available, and how is rum made. Once you know this information, you'll be a rum master. Rum is available in a wide variety of weights, ages, and blends. If you aspire to become a connoisseur of fine rums, start with the basics.
Shaun will teach us how to create a 3D video game compatible with MAC or PC with no prior programming knowledge. First download Alice, a 3D World program that can be turned into a video game. Open Alice, click on "add objects", click on "more controls" and select your choice of aspect ratio such wide screen. Now you can import your own 3D models that Shaun will show you at the end of the tutorial or choose from a wide selection that comes with Alice. In addition, if you click on "home," "web ...
Here is another cool photo manipulation you can do using Photoshop CS3. You can take a normal photo you’ve taken and really make it look unique by giving it harder edges and some more texture to the shot. Mix up your photos with this effect.
It’s time to celebrate! What better way than with a bubbly brunch? You Will Need
CS3 has a few ways to invert colors or drop the saturation of parts of an image, including selection tools, vector masks, and adjustment layers. Learn how to manage and desaturare colors in this free Photoshop tutorial video.
Color selection is an important part of art. Learn how to plan the colors for your next work of art in this free art lesson series from an art instructor.
It should be simple to select and copy all text on a webpage in Safari, but it won't work as it does in other apps. Usually, you can press-and-hold down anywhere on a page and choose "Select All" from the edit menu, but that functionality is disabled in Safari and WebKit-based browsers by default — including in the latest iOS 14 version. Luckily, there is a workaround to getting a "Select All" button back.
There's a new hidden Safari feature for your iPhone, one that makes it even easier to find words, numbers, phrases, and other text on a webpage.
Chrome's text selection interface is pretty nice, but it could definitely use some improvements. For instance, when you're in Incognito Mode, you can't perform a web search for words you've highlighted. And when you're typing out a forum post or using any text input field, for that matter, there's no option to search or share any of the text you've written.
In this video, we learn how to do a grass silhouette effect in GIMP. First, draw a black mound and then close off your selection. After this, turn the path into a selection and fill it in with a black color. Next, select your smudge tool and use a small circle brush. Set the rate up to 95, depending on the length of grass you want. Now, use your mouse to push up on the mound and you will see wispy pieces of grass form where you are moving your mouse. Cross them over and cover as much of the a...
While holographic Whitney Houston is hitting the road, a new mobile app is bringing volumetric captures of up and coming performers directly to the iPhones and iPads of fans.
Speech-to-text technology can be seen on your iPhone in various places, from the Dictation tool to Apple's new behind-the-scenes, auto-created transcripts for podcast episodes. Your iPhone also has some pretty impressive text-to-speech capabilities. With them, your iPhone can read webpages, documents, or whatever text is on the screen out loud to you — only some of these tools aren't easy to find.
These days, it's easy to cut the cord. Thanks to a new crop of streaming TV apps, you can get the same service offered by a traditional cable subscription at a fraction of the price. After some extensive testing, we believe we've found the absolute best apps for cord cutting.
While certainly faster than writing by hand, manually typing passages from a book or document can be slow and frustrating. But thanks to Google Assistant, this is no longer the case. Whether you need to quote text for an essay or need to win an online argument, all you need to do is point your phone's camera at the paper and tap a few times.
The recently released HTC One M8 and the upcoming Samsung Galaxy S5 are both boasting selective focus features for their camera apps, but with a 13 megapixel camera, the GS4 can take some pretty stellar pictures, too.
There are much better things that can go in your iPhone's status bar besides an always-on indicator displaying what carrier you're shelling out money to every month. While it would be nice to get rid of the carrier name altogether at the top of the screen, an even better option is switching it out with something else to better personalize your iPhone.
Why waste money on color contacts when you can change your eye color on a software program called Photofiltre? Photofiltre is free and you can manipulate your eye color to whatever shade you'd like in a few easy steps.
If you're trying to get somewhere fast, taking a toll road or two can definitely help you do that, but at a cost. When you're not in any rush, that would-be toll money will work much better in your gas tank, especially if it's only minutes that are being shaved from your trip. With this in mind, Apple Maps has a simple way of avoiding tolls to save you money while navigating on your iPhone.
Selecting text on a touchscreen device has always been a major pain point. Those tiny little arrows that let you adjust the selection area are always too hard to actually adjust, making precision all but impossible. Then there's the issue of some apps not even allowing text selection in the first place, so the entire experience is basically a big mess.
Your smartphone has a ton of ringtone options built in, but ringtones haven't really changed much in the past decade, and it's definitely not cool to hear someone in the supermarket with the same lame ringer. While replacing the stock sounds with a song of your choosing is the best way to keep your phone personalized, why not go a step further using a video?
In this Made Fit TV podcast, Jennifer DiDonato provides you with examples of foods that you eat or, should be eating almost everyday of the week. But, she break it down to show you just how many extra calories you may be eating based on portion and selection, and how you can eliminate 3,500 calories - one pound - a week, from nutrition alone. Just don't forget to workout, too! With this you'll start losing weight in no time.
This 3D modeling software tutorial shows you how to use the Flip command in modo 101 and higher. The Flip command is one of those tools you can not live without. It inverts polygon normals on polygonal models and meshes. Combine the Flip command with the modo arsenal for accurate selection and it really is a life saver.
Watch this instructional cooking video to prepare a shrimp mold appetizer. This recipe tastes much better if you can use fresh jumbo shrimp, but you can also prepare this with a more modest selection of shrimp. This English style hors d'oeuvre is easy to prepare with common household ingredients.
Learn a selection of phrases to whisper to your loved one in European Portuguese.
The Paths palette in Photoshohp is used for saving, selecting and duplicating path information. A very cool hidden feature of the Paths Palette... You can convert a feathered selection into a path to remove its feathered edge.
The Gradient Tool allows you to fill the entire canvas or a selection with a color range. You can also choose the direction of the fill. See how in this Photoshop tutorial.
This Photoshop tutorial covers color selection. Part one is about using the Color Picker and part two is about the color and swatches palettes.
Check out this video with Bob Davies to learn how to paint watercolor trees. These videos will cover everything from paint selection, painting distant, winter, and summer trees, and techniques.
Forgot to bring flowers to dinner for your date? This video will guide you through napkin selection and the folding necessary to make a paper rose!
I consider myself a master of emoji, crafting complete sentences and paragraphs using strictly ideograms and smileys. However, everyone seems to have their own interpretation for each little image, so my elaborately clever emoji-only sentences can get lost in translation. But there's an easy way to translate emoji into their exact meaning, as well as decode everyone's mystifying emoji talk.
