Non Filing Search Results

How To: Use AGGREGATE instead of SUBTOTAL in MS Excel 2010

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 664th installment in their series of digital spreadsheet magic tricks, you'll learn how about how the new Excel 2010 AGGREGATE function that can calculate these 19 different functions depending on what number you put into the 1st argument of the AGGREGATE function. This is an improvement over the SUBTOTAL function wh...

How To: Model with files from Adobe Illustrator in Cinema 4D

In this C4D user's guide, you'll learn how to import and model from images generated in Adobe Illustrator. 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, and to get started using this trick in your own Cinema 4D projects, watch this 3D modeler's guide.

How To: Pull the refrigerator handle switch prank

Pranks are the world's favorite pastime. Everyone loves a good prank, and there's nothing better than keeping someones stomach empty. Imagine the pain and suffering one would endure if he or she could not eat because the fridge will not open. Most refrigerators allow for reversing the door swing. Normally you also switch the handle. But not if you want to thoroughly confuse the victim of this practical joke.

How To: Create transparent PNGs from opacity maps for Blender

This tutorial shows how to create transparent PNG files from opacity maps to use in Blender. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial. For more information, including step-by-step instructions, take a look!

How To: Append nodes in Blender

Appending nodes allows you to reuse node trees from previous files. This can be a huge time saver, particularly when working with complex setups. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial from the folks at CG Cookie. For more information, including step-by-step instructions, take a look!

How To: Save files for the web when working in Illustrator CS5

Save your Illustrator CS5 illustrations for the web. This clip will show you how it's done. Whether you're new to Adobe's popular vector graphics editor or a seasoned graphic arts professional interested in better acquainting yourself with the new features and functions of Illustrator CS5, you're sure to benefit from this free software tutorial. For more information, and to get started using this trick in your own Illustrator projects, watch this video guide.

How To: Conform and quantize audio in Pro Tools 8

Learn how to use Pro Tools 8's time warp features to conform and quantize your audio files. Whether you're new to Digidesign's popular DAW or a seasoned audio pressional just looking to better acquaint yourself with the Pro Tools 8 workflow, you're sure to be well served by this video tutorial. For more information, and to get started conforming and quantizing audio clips in your own Pro Tools projects, watch this free video guide.

How To: Reduce camera raw noise in Adobe Photoshop CS5

Learn how to take advantage of Adobe Photoshop CS5's new noise reduction capabilities. Whether you're new to Adobe's popular image editing software or a seasoned graphic design professional just looking to better acquaint yourself with the unique features of Photoshop CS5, you're sure to find something of value in this video tutorial. For more information, and to get started denoising your own raw image files, watch this video lesson.

How To: Open Word documents on Mac or PC

If you're one of the many people who work with Macs and PCs, the odds are you work with file formats that are more often than not incompatible with the other computers. This can be a major problem if you run into it with your Word documents. This tutorial will show you how to open Word docs on either computer.

How To: Play "Lua" by Bright Eyes on the ukulele

Want to play Bright Eyes' "Lua" on the 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 indie folk song on your own ...

How To: Automatically add to iTunes 9 with new easy import

A new feature that comes with iTunes 9 is the ability to import files automatically into your iTunes folder. This process makes importing much faster and easier. In this tutorial, learn how to automatically add to iTunes using this easy import method. Luke will show you how to adjust your preferences and take full advantage of this new feature.

How To: Add color to the garden with perennials

Southwest Yard and Garden featuring John White, Dona Ana County Extension Agent, hosts a 6 minute clip with co-host Master Gardener Valois Pearce both of Dona Ana County, New Mexico host a short web show featuring plants that can easily survive on smaller amounts of water over typical plants. They begin by discussing the full sun Ice Plant, which comes in many species and colors as well as their hardiness, but unfortunately are easy targets for wildlife. They then move onto the Gopher Plant, ...

How To: Choose fruit trees

Doña Ana County Extension Agent John White and Master Gardener Benny Knudsen look at stone fruit trees on their tour of the "Garden of Weeden". The Mariposa Plum, the dwarf Stella Sweet Cherry, Elberta Peach, Tilton Apricot and the almond tree (which also belongs to the stone fruit family) are featured in this segment of Southwest Yard and Garden series. The suitability of these trees for a small garden is mentioned. Besides this, also discussed is the problem of late frost and its effect on ...

How To: Use new features in Adobe Dreamweaver CS5

Whether you're new to Adobe Dreamweaver or a seasoned web designer after a general overview of CS5's most vital new features, you're sure to be well served by this official video tutorial from the folks at Adobe TV. In it, you'll learn about new Dreamweaver CS5 features such as CSS Inspect Mode, Live View Navigation and Dynamically Related Files.

How To: Manage your media in Adobe Bridge CS5

Whether you're new to Adobe's Bridge or a seasoned graphic design professional after a general overview of CS5's Mini Bridge, you're sure to be well served by this official video tutorial from the folks at Adobe TV. In it, you'll learn how to manage your media visually with Adobe Bridge CS5 software, which now offers more flexible batch renaming, support for drag and drop between Creative Suite components, and the ability to access files in the context of what you’re working on by using the c...

How To: Make sweet onion & dolcelatte cheese tarts

In this video chef Jo Pratt demonstrates how to make sweet onion and dolce latté cheese tarts with pear and walnut salad. This is taken from her recent recipe book. The ingredients needed for this is one sheet of regular puff pastry, some caramelized onions, some thyme leaves,250gm dolce latté cheese, two small pears cut into small pieces, two celery sticks finely sliced, some walnuts torn into halves, two tbsp walnut oil and two tbsp balsamic vinegar. To make the dish she firstly unrolls the...

How To: Convert your MP3s to ringtones using iTunes

To convert your MP3s to ringtones using iTunes follow the instructions below. First download and install iTunes and then agree to the terms of use and open the program. Then, click "File" and then "Add to Library." Locate the MP3 file you want to convert and open it in iTunes. Now click "iTunes" at the top of your toolbar and select "Preferences", then click the "Import Settings" icon bar and select "MP3 Encoder" in the "Import Using" bar Click "OK" twice to exit to your iTunes library. Now r...

How To: Apply a pink leopard print nail manicure

The creative Suzy Banyon describes in detail the process of applying a leopard print manicure in this easy to follow step by step video. She details the process vividly, from applying fake nails and filing them into shape, to what type of base to use and how to go about creating the leopard print pattern with the use of a fine point Sharpie pen. This video is great for those of you looking for new and different ways to apply unique nail art at home!

How To: Create comments in PDFs with Adobe Acrobat 9 Pro

Acrobat 9 Pro is an essential tool for creating, reviewing and sharing comments with others you work with. In this video you will learn about commenting PDF files and the methods for including others in your review process with Adobe Acrobat and Adobe Reader. Learn how to use comment tools and review cycles in Acrobat 9 Pro as well as how to collaborate via email or Acrobat.com and share pages.

How To: Create rotating planets and moons in Photoshop

Pixel Perfect is the "perfect" show to help you with your Photoshop skills. Be amazed and learn as master digital artist Bert Monroy takes a stylus and a digital pad and treats it as Monet and Picasso do with oil and canvas. Learn the tips and tricks you need to whip those digital pictures into shape with Adobe Photoshop and Illustrator. In this episode, Ben shows you how to create rotating planets and moons in Photoshop.

How To: Dive into new features of Photoshop CS4

Pixel Perfect is the "perfect" show to help you with your Photoshop skills. Be amazed and learn as master digital artist Bert Monroy takes a stylus and a digital pad and treats it as Monet and Picasso do with oil and canvas. Learn the tips and tricks you need to whip those digital pictures into shape with Adobe Photoshop and Illustrator. In this episode, Ben shows you how to dive into new features of Photoshop CS4.

How To: Create a GIF in Adobe Photoshop and GIFtedMotion

Need a little help with your new Adobe Photoshop graphics editing program? Working with Photoshop can be a bit tough if you don't know what you're doing, so instead of getting out the books, check out this 'no nonsense' video tutorial to learn how to create a GIF in Adobe Photoshop and GIFtedMotion Photo manipulating and editing is always tricky, so just watch to see how to create a GIF file, for beginners.