Enhanced Data Search Results

How To: Create a quantitative freq. distribution in MS Excel

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 24th installment in his "Excel Statistics" series of free video lessons, you'll learn how to create quantitative data frequency distributions with pivot tables. See how to create the correct unambiguous labels ...

How To: Create a distribution for categorical data in MS Excel

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 12th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use Advanced Filter 'Unique Records Only" to extract a list of unique items from a data base, and then use the COUNTI...

How To: Build a simple Core Data application in Mac OS X

Core Data is a powerful data-management framework introduced with Mac OS X v10.4 Tiger. When you take advantage of Core Data, it slashes the amount of custom code you need to write in order to manage application data. Opening, saving and undo management can all be handled by Core Data, freeing you to concentrate on creating unique features for your application. This video tutorial, which presents a general introduction to using Core Data, will walk you through the process of building a simple...

How To: Use Chromakey to enhance your videos & photos

See how to use Chromakey to enhance your videos and photos. Chromakey is the process of removing one color and replacing it with another but it most often refers to removing green screen or blue screen backgrounds and replacing them with composited videos or images. This lesson uses Pinnacle software for the final video editing, but any editing software can be used - it's more about the principles of the process and setting up the cameras that you'll learn from this video.

How To: Group quantitative data in Microsoft Excel

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 32nd installment in his "Excel Statistics" series of free video lessons, you'll learn how to group when the quantitative data are whole numbers, integers or discrete data and how to group when the quantitative ...

How To: Create a two-variable data table in Microsoft Excel

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 255th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a two-variable data table in Excel for what-if analysis. See the PMT function and learn about the formula equivalent to a data table.

How To: Enhance the color of photos in Photoshop

Photoshopuniverse teaches you how to enhance the colors of photos using Adobe Photoshop. You get a photo and duplicate that layer. Set the blending mode to Soft Light. You repeat that step, only the blend mode should be Lighten. The shadows are now darker. You can change the blend mode opacities to 60%-70%, but both layers should have about the same opacity. Also make sure that the white values are not to white and that details, like faces, are still OK to see.

How To: Enhance color with automation in Photoshop

A lot of photos look fantastic when you first take them, but you start to notice some issues with the image when you get a good look at them on your monitor. The color will be nice, but there is noticeable room for improvement in the raw image. You can enhance the color in your image by using automation in Photoshop. This video will take you through the necessary steps to make your final image livelier and more vibrant in Photoshop.

How To: Batch automate in Photoshop

This how-to video produced by Photoshop Universe gives step-by-step instructions on how to batch automate a process in Adobe Photoshop. With this tutorial you'll be able to learn to correct white balance, enhance colors, resize, and save for the web whole folders' worth of images in one go. The first step to doing this is to open up one of the images in your folder and correct the white balance, enhance the colors, resize the photo and save. The next thing you want to do is to record all of t...

How To: Use a luminosity mask in Photoshop

This video is about using a luminosity mask in Photoshop. The luminosity mask is used to enhance the color and contrast in photos that lack each of these. The color is enhanced or punched up. Choose the manipulation tool: channel and RGB. To choose RGB, touch control and then select RGB. Select the 100 % white or light parts of the photo, it will not select the darker or black images. Copy the light parts of the image by using control J. Choose to copy the lightest parts by selecting overlay ...

How To: Use worksheets in Microsoft Excel: Mac 2008

Data can be troubling, especially if there's a ton of it plaguing your Excel worksheet. But Excel 2008 for Mac makes life a little easier and less confusing thanks to a few worksheet tips and features you can utilize to work with your data in worksheet cells. The Microsoft Office for Mac team shows you just how to work with worksheets in this how-to video.

How To: Add spreadsheet snippets in Microsoft Excel: Mac 2008

Not every client or coworker likes to mine through a spreadsheet to find all the important data. So, with Excel 2008 for Mac, you can easily share that data without sending the entire Excel spreadsheet. To do this, all you need to do is to use the "copy as picture" option. The Microsoft Office for Mac team shows you just how to insert a spreadsheet snippet in this how-to video.

How To: Conserve the data usage on your iPad

Thirty dollars a month may be a little steep for an unlimited data plan for iPad users. To cut down on your data usage, you can download the Offline Pages app to browse articles or blogs offline. InstaPaper is another account you can use as well, and both will cut down on your data usage per month.

How To: Create a histogram using data analysis in Excel

A histogram is a summary graph showing a count of data points that fall in various ranges. Histograms are used in statistics and other forms of mathematics. In this video, learn how to create your own histogram using data analysis on the computer. This tutorial will show you how to create a frequency distribution, a cumulative frequency distribution, a histogram chart and an ogive chart with the data analysis add-in.

How To: Enhance the audio in your Camtasia Studio 5 videos

In this video, we learn how to enhance the audio in your Camtasia Studio 5 videos. First, set your video to 640x480 and then choose the option to zoom yourself. Now, click the zoom in button to zoom in on the time line with your audio. Then, right click the audio and go to "audio enhancement". Once here, click the first option under background noise removal, then click the remove background noise button. Now, when you play back your audio, you will hear a huge difference in what you just play...

How To: Shape, groom, and enhance your eyebrows

We're all for natural beauty, and we think you look great with or without makeup, but there's one thing we are a stickler about: eyebrows. There's no girl out there with the perfect set: they're either perfectly shaped but too sparse, thick enough but evocative of Groucho Marx, or too light for anyone to see.

How To: Use data validation with a list in Excel

This video shows you how to idiot-proof a data set in Excel pretty much. It demonstrates how to enable data validation in a cell, so that when you type something in it must be in a predetermined list or will not work. Start by typing in your data table in a second tab. His example is a date, then information about certain employees based on that day. To enter the data validation menu, click the cell you want to use and then hit ALT+D+L to bring it up. Go to settings, then under the Allow menu...

How To: Calculate standard deviation

Looking to find the standard deviation of your set of values? Standard deviation quantifies how diverse the values of your data set are, and is useful in determining how different your numbers are from each other.

How To: Kirigami a dragonfly pop-up card

If you enjoy arts and crafts, pop-up, scrapbooking and origami, you will enjoy these craft projects too. Like origami, kirigami is the craft of paper, with the added technique of paper cutting. Kirigami will enhance any origami, pop-up and scrapbook projects and scrapbook and origami techniques will enhance kirigami. Kirigami pop-up blossoms, butterflies and puppets make unique gifts or cards for any occasion and the recipient will enjoy seeing their gift, card or pop-up take form before thei...

How To: Plot data with Microsoft Excel's REPT & COUNTIF tools

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 27th installment in his "Excel Statistics" series of free video lessons, you'll learn how to create a quantitative data dot plot chart using the REPT and COUNTIF functions.

How To: Cross tabulate categorical data in Microsoft Excel

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 16th installment in his "Excel Statistics" series of free video lessons, you'll learn how to cross tabulate & do percentage cross tabulation for categorical data using a pivot table (PivotTable).

How To: Cross tabulate categorical data with formulas in Excel

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 17th installment in his "Excel Statistics" series of free video lessons, you'll learn how to cross tabulate & do percentage cross tabulation for categorical data using formulas rather than pivot tables.

How To: Work with nominal, ordinal & interval scale in Excel

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 10th installment in his "Excel Statistics" series of free video lessons, you'll learn how about data sets and the nominal, ordinal, interval and ration scales/levels of measurement and see two Pivot Tables that...