If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 33rd installment in his "Excel Statistics" series of free video lessons, you'll learn how to use the AVEARGE, MEDIAN, MODE, PERCENTILE, QUARTILE and PERCENTILERANK functions to measure location.
If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 4th installment in his "Excel Statistics" series of free video lessons, you'll learn how to create a frequency table and percentage frequency table using a Pivot Table (PivotTable).
This video describes how to make an asparagus dish. First, a frying pan is put on the stove over medium high heat. Secondly, olive oil is added to the pan. Next, pieces of prosciutto ham; the speaker suggests that other types of ham will do just fine in this dish. After a couple minutes of cooking, the asparagus is added to the pan and rolled around to coat in oil. The asparagus is cooked for awhile before water is added and the dish is covered for one minute to steam. Afterwards, the lid is ...
In order to prepare and decorate a Wildlife Safari Cake, you will need to pre-prepare royal icing and a pre-made cake.
While big parts of copyright protection are applied automatically to creative works like songs and beats (hence the need for orginizations like the Creative Commons), registering your work with Copyright Office is useful to the extent that it can allow you to seek greater damages in the event of an infringement. For more information, including how to register your own songs with the US Copyright Office, watch this free video tutorial.
Whether you're new to Adobe's Creative Suite or a seasoned graphic design professional 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, Terry White discusses his five favorite features of the newest addition to Adobe's CS, Flash Catalyst, an application which allows you to create dynamic web pages without coding. Learn how to create dynamic scrolling content and functional Flash buttons ...
In this video tutorial brought to you by photoshopuniverse, you will learn how to apply mood lighting to images in Photoshop. This is achieved by applying an adjustment layer, called a gradient map, which allows you to adjust the color of the light in an image. You will learn how to access the gradient map from the adjustment layers menu, how to apply the gradient map, then overlay the new layer and fine tune the gradient to create more dramatic looking images.
Cassettes take up quite a bit of space, and can sometimes start showing wear, which can affect the sound. This video shows you how to take this information from your cassettes, and move them on to a CD. Detailed instructions, and photos in this video, will have you transferring analog information into a digital format within just minutes. This allows you to be able to use the audio recording on your computer, as well as being able to listen to it in a regular CD player.
Use this rigged game to cheat your friends twice in a row! The game functions just like 31, only this time you'll always win if you follow the instructions in this video.
If you're a geek, then this power pack will give you a total techgasm. The power pack allows you to charge pretty much anything you can fit into a 12 volt power jack in your car (where the cigar/lighter receptable goes). The power pack is a portable battery, so no need for charging your gadgets - like your cell phone - at home first before you head off to work.
A lag switch allows you to cheat in online games or on XBOX LIVE by disabling the flow of data to your console or PC. We will show you how to build one.
This software tutorial shows you how to use Magic Bullet Frames plug-in. The plug-in is available for After Effects, Final Cut Pro,k Premiere Pro and Motion. Magic Bullet Frames allows you to take interlaced video and get the 24p look of film, right from within your editor — at high speed and high quality. Get started with Magic Bullet Frames in this After Effects tutorial.
Watch this instructional painting video to paint a hot red peony with watercolors on Chinese rice paper. This fluid style of painting takes lot of practice and does not allow for mistakes. Every brush stroke counts. Get out some newsprint to practice painting these beautiful peony flowers.
Watch this instructional painting video to paint a dragon with India ink and watercolor on Chinese rice paper. Use negative space to create a ghostlike effect. This fluid style of painting takes lot of practice and does not allow for mistakes. Every brush stroke counts. Get out some newsprint to practice painting these majestic dragons.
Watch this instructional painting video to paint a Boston terrier with India ink and watercolor on Chinese rice paper. This fluid style of painting takes lot of practice and does not allow for mistakes. Every brush stroke counts. Get out some newsprint to practice painting these cute terrier dogs.
draw a rooster India ink and watercolor on Chinese rice paper. This fluid style of painting takes lot of practice and does not allow for mistakes. Every brush stroke counts. Get out some newsprint to practice painting these majestic roosters.
The Bridge tool in modo 202 is a phenomenal modeling tool for any workflow. This video will get you a quick ramp up to the full power of the Bridge tool in modo. The bridge tool allows seamless stitching between discontinuous areas of a mesh. See how to use it for any type of 3D modeling within modo.
Watch this instructional blacksmithing video to forge a high carbon steel striker for flint and steel. The flint and steel striker served as the original portable lighter. Flint and steel lighters are also used on outdoor trips to light camp fires. These detailed instructions will allow you to begin the craft of metalsmithing and forge a useful tool.
Watch this instructional drawing video to draw and color a cartoon. Use a calligraphy pen to draw think lines and thin lines with a single pen. This allows you to draw expressions quickly and decisively. With a clean brush, dampen the paper where you want to add color. Mix marker colors with water to mix a quick watercolor palette.
Learn how to draw cartoons faces and expressions with a few simple lines. A professional comic strip in a book or a newspaper carries an idea across using a minimal amount of lines. Use a calligraphy pen to draw thin lines and thick lines with a single pen. This allows you to draw faces expressively and quickly.
Donnie Hoyle sizes himself up against some old memories. Size yourself up too by learning how to not suck at Photoshop and use the measurement log. The measurement log in Photoshop allows you to click and drag from point to point and take the measurements of things. In this example, you learn to use the measurement log to compare similarities and differences in the faces of a dad and his son.
Databases allow you to store data in a systematic and organized format, making it easy for you to search, sort and edit.
This how-to video shows you how to open your above ground pool after it has sat there all winter. Make sure to remove water on top of the cover, any debris, and tubing securing the cover. Open your above ground pool and get it ready for summer. Check the skimmer, filter, and pump before allowing anyone in. Don't forget to install the diving board properly.
This how-to video shows you how to open your in-ground pool after it has sat there all winter. Make sure to remove water on top of the cover, any debris, and tubing securing the cover. Open your in ground pool and get it ready for summer. Check the skimmer, filter, and pump before allowing anyone in. Don't forget to install the diving board properly.
Simple Syrup is used in many drinks as a sweetner and is incredibly easy to make. Ingredients: 1 glass sugar
Watch this ceramics tutorial video to learn how to throw a large soup bowl using 2.5 pounds of clay and a pottery wheel. The detailed instructions in this helpful how-to video will allow intermediate potters to easily make large soup bowls.
Watch this winds tutorial video to learn several different ways to play sharps and flats on your pan flute. You can push the flute into your lip, tilt the instrument, lower your jaw, or push your top lip out to cover part of the opening. These four methods allow even beginners to easily play sharps and flats on the pan flute.
With Apple's MobileMe, you can easily allow your visitors to download beautiful, full quality photographs from your MobileMe Gallery. Check out this video tutorial for all of you newbies out there on sharing your pictures with friends and family, from the Internet. All this can be done, from the safety of your Mac or PC, with the world wide web.
Alison and Lloyd, the hosts of My Home 2.0, have created a Twittering Teddy Bear by performing surgery on an animatronic toy bear, adding a text-to-speech implant allowing the bear to speak real-time Twitter updates.
The tether command allows you to tether your camera to your Mac and capture images directly into Aperture. It's fast, easy to set up, and gives studio photographers immediate full-screen feedback while they shoot.
To help you compare and manage groups of similar shots or of images shot in a rapid sequence, Aperture provides stacks, an organizational tool that allows you to group related images.
iMovie '08 allows you to directly access your Aperture library to add still photos to your movie.
When you're ready to review your movie, there are various ways you can play it to see how it looks. iMovie allows many easy ways to make sure your movie is exactly what you want.
A new feature of iMovie HD 6 is themes. Themes allow you to add professionally produced scenes that incorporate your video, photos, and text.
With a MobileMe account and iPhoto, you can publish albums to the internet and allow your friends and family to subscribe to them using photocast sharing. Then, as you add new photos, iPhoto automatically updates the published albums for your subscribers. NOTE: MobileMe is the replacement for .mac accounts.
If you want more control of your book's layout and design, you can make layout decisions yourself manually. iPhoto allows you to deviate from its provided template.
Authorization allows you to copy your music store purchases to other computers and burn them to CD and protects the artists. Each computer you use to play your purchase must be authorized using your music store account. You can authorize up to 5 computers; yours is automatically authorized.
With iTunes, you can easily DJ a party by using the party shuffle playlist. This playlist selects a few songs from your library at random and allows you to rearrange upcoming songs.
With comments, your blog isn't just your journal, but a place for friends, family, and others to communicate. Use iWeb to allow comments on your blog.
After you've assembled your clips in order, you can fine tune your sequence by trimming the edit points between each clip. This video explains the many tools you can use to make trimming videos easy and precise, including the ripple and roll tools. These tools allow for seamless editing.