Youtube Expertise Search Results

How To: Calculate how much you'll need for retirement in Microsoft Excel

As you might guess, one of the domains in which Microsoft Excel really excels is finance math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, part of his "Excel Finance Class" series of free video lessons, you'll learn how to use the PV and PMT functions together to decide how much you need at retirement and how much you should deposit each month during your working years.

How To: Export in HD in iMovie '09

In this tutorial, we learn how to export in HD in iMovie '09. First, open up your iMovie, then go into "share", then "YouTube". If the HD is not checked, you will need to check it and then click "next" and "publish". That is the quickest way to export to YouTube. To do this from iDVD, click on the "share", then "iDVD" and then it will go to iDVD and you can export it in HD. You can do this for any of your movies by simply clicking on the share menu, and making sure your settings are changed t...

How To: Render Sony Vegas clips in 1080p HD for use on YouTube

Want to export a movie from Sony Vegas Pro to YouTube while preserving its quality? This clip will teach you what you'll need to know. Whether you're completely new to Sony's popular nonlinear editor (NLE) or are a seasoned digital video professional simply looking to pick up a few new tips and tricks, you're sure to be well served by this free video software tutorial. For more information, including detailed, step-by-step instructions, take a look.

How To: Hear the vuvuzela sound in back of any YouTube video

can't get enough of the vuvuzela, the traditional horn that sounds like a swarm of bees at every game of the 2010 World Cup? Check this out! YouTube has added a mini-app to all of their videos that will allow you to push one button and turn on the sounds of the horns in the background of any clip! If you can't wait to watch your videos like you are sitting in the stands at the big game - today is your lucky day! Enjoy!

How To: Moonwalk for beginners

Moonwalking is one of the most recognized and popular dance moves that was made popular by Pop King Michael Jackson. It seems like a difficult dance that is hard to perform, but with the right teacher and practice can be done easily.

How To: Find mean, median, & mode (averages)

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 34th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use MEAN, MEDIAN, MODE. These measures give us a typical value, a measure of central tendency one value that can repr...

How To: Find outliers using the Z-score method

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 49th installment in his "Excel Statistics" series of free video lessons, you'll learn how to find outliers with the +/- 3 Z-score rule and the ABS function. See how to do a box plot by hand and in Excel. For th...

How To: Calculate simple and compound interest in MS Excel

As you might guess, one of the domains in which Microsoft Excel really excels is finance math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 2nd installment in his "Excel Finance Trick" series of free video lessons, you'll learn how to use the FV function. See the math formula for calculating future value and for calculating the effective interest rate. Also see long hand how c...

How To: Use database functions in Microsoft Excel 1997-2003

Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 3rd installment in his "Excel Formula Efficiency" series, you'll see how the Excel 2003, 2002, 2001, 1997 Database D functions (DSUM, DAVERAGE, DCOUNT) are much faster than SUMPRODUCT and SUM array formulas.

How To: Speed up calculations with helper cells in MS Excel

Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 7th installment in his "Excel Formula Efficiency" series, you'll learn how to use a helper cell to remove a time-consuming (expensive) section of your formula to speed up calculations.

How To: Use helper columns with concatenated fields in Excel

Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 7th installment in his "Excel Formula Efficiency" series, you'll see how a helper column with concatenated fields can dramatically reduce the time a formula takes to calculate.

How To: Calculate running total by formula in Microsoft Excel

Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 9th installment in his "Excel Formula Efficiency" series, you'll learn see two running total formulas, one that is faster than the other.

How To: Create fast formulas for huge Excel spreadsheets

Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 10th installment in his "Excel Formula Efficiency" series, you'll learn how to use Manual Calculation for huge spreadsheets so that recalculation only occurs when you want it to occur.

How To: Find confidence intervals without a sigma 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 84th installment in his "Excel Statistics" series of free video lessons, you'll learn how to construct confidence intervals when the sigma is NOT known using the Descriptive Statistics data analysis add-in.

How To: Format whole & decimal numbers in Microsoft Excel

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 8th installment in his "Excel Business Math" series of free video lessons, you'll learn how to work with whole and decimal numbers. See how to write words to represent numbers (for checks). See how formatting can hide decimals.

How To: Solve markup & markdown math problems in MS Excel

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 32nd installment in his "Excel Business Math" series of free video lessons, you'll learn how to solve simple markup (mark-up) & markdown (mark-down) business math problems.

How To: Use the RANK and PERCENTRANK functions 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 38th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use the RANK and PERCENTRANK functions as well as the Data Analysis add-in's Rank & Percentile tools.

How To: Use names and wildcards with Excel's COUNTIF function

Looking for a primer on how to create and work with names in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 6th installment in his series of Excel name tricks, you'll learn how to use the Names & Wildcards with the COUNTIF function. Specifically, see how to search through a list of addresses and count just the ones on Birch Street in this free video lesson.

How To: Group quantitative data into classes 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 20th installment in his "Excel Statistics" series of free video lessons, you'll learn how to take raw quantitative (numerical) data and figure out how to group it into classes so that you can have categories an...

How To: Build confidence intervals given the sigma 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 81st installment in his "Excel Statistics" series of free video lessons, you'll learn how to construct confidence intervals when the sigma (population standard deviation) is known. See how the CONFIDENCE and NO...

How To: Work with skew and histograms 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 23rd installment in his "Excel Statistics" series of free video lessons, you'll learn how to work with skew in histograms for quantitative Data. Learn how to skew left (negative) and skew right (positive) with ...

How To: Create a relative frequency 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 14th installment in his "Excel Statistics" series of free video lessons, you'll learn how to create relative & percent & frequency distributions with formulas for categorical data. See, too, how to create a per...

How To: Make calculations in Excel with formulas & references

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 2nd installment in his "Excel Statistics" series of free video lessons, you'll learn how to make calculations in Excel using formulas and cell references. Learn about the different Excel Math operators and func...

How To: Watch YouTube videos on any PSP without CFW

First of all you have to open your internet browser. Now you have to type in mYouTube. Now you have to type in 'psps3psn' in your browser and then click 'enter'. Now you have to select the first search item. This shall ask you to watch ‘YouTube’ video on your ‘PSP’ (slim or ‘phat’) with an official ‘firmware’. There is no need of computer, only your ‘PSP’ and internet connection are required. Now when you click on to it, the video link shall be opened in a new browser. You have to click on 'd...

How To: Crop, stretch, and increase quality of YouTube videos

CompHelp uses his Mac to show us a new feature that the website has recently introduced. This feature allows people to use a simple code to crop, change, stretch, and even increase the quality of YouTube videos before they are uploaded. He starts out by showing viewers the memo where this information was released, then goes step by step to show interested parties how to use the special codes.He uses one of his own videos as an example, demonstrating what was wrong with it, then using the new ...

How To: Make a cool YouTube intro in After Effects

You can learn how to use After Effects to make an interesting introduction for your YouTube video by following the steps in this video tutorial. You will need to use a preset called Trapcode Particular 2. 0. Once this trial version is downloaded, go into After Effects and select New Composition. Create any name you want for the file and then select HDV/HDTV for the Preset. This video outlines how to create the introduction from the initial layer to the final layer, which is up to you to decid...

How To: Embed a YouTube video in PowerPoint w/ or w/o internet

In this Software video tutorial you will learn how to embed a YouTube video in PowerPoint with or without Internet. You will see two ways of doing this with and without internet access. When you have an internet connection, open up PowerPoint and click on the office circle button on the left hand corner. From there select ‘PowerPoint options’ and check the box that says ‘show developer tabs in the ribbon’ and click OK. Once the developer tab is in your ribbon, select that and go to the area t...

How To: Make a professional YouTube logo in Photoshop CS4

Adobe Photoshop CS4 is a common and popular tool for logo creation. In this video the finer details of using CS4 to create logos, specifically for use on YouTube, are explained. Lighting effects, glossing, and glowing are covered thoroughly with step by step instructions on using layers and shading are provided, and the video carefully demonstrates each process before moving on. Many options are shown, as well as detailed examples of each technique and even the basic tools inherent to Photosh...

How To: Make HD/1080p videos for YouTube in Camtasia

This video lesson will show you how to make HD/1080p videos for YouTube in Camtasia. The simplest way to make this is to record your video in 1920x1080 resolution and render it in that setting. That’s all that you need to do. But, if you have a smaller screen resolution and can’t get 1080p, you can use Camtasia Studio to convert it to 1080p. first add your media to the timeline and change the width to 1920 and the height to 1080 click OK and then close the box. In the preview, you will see th...

How To: Create a YouTube subscribe button in Photoshop

This task tutorial explains how to use Photoshop to create a YouTube subscribe button. First, select the rectangle tool and draw a bar. Select color options and deselect the color overlay. Then, go to gradient. Using the dropper tool, select the first and second color. Open layer options again and select the stroke color using the eyedropper tool. Increase the stroke size and change the position to inside. Click okay. Select type tool, create text field and type in the text. Open layer style ...

How To: Save YouTube videos to your Mac or PC

Chances are that there are videos on YouTube that you wish you could download to your Mac or PC in order to transfer them to your iPod or other media player so you can watch them on-the-go. Whether it be your favorite music video or the new and hilarious comedy skit from your favorite comedians, this video will show you exactly how to do that, simply and safely in just a few steps. The video is only a minute and thirty seconds long, which is nothing compared to how many minutes you could be a...

How To: Play "The Breakup Song" on ukelele

The ukelele is a great little instrument that is easy to learn, sounds good, and is portable. How much better could it be? They work especially well for covering pop songs, since they're very simple and catchy, which is the essence of the ukelele. This video will teach you how to play the YouTube ukelele original "The Breakup Song" on ukelele.

How To: Get iOS 14's Picture in Picture Working for YouTube on Your iPhone

Aside from home screen widgets, one of the most exciting updates to the iPhone with iOS 14 is Picture in Picture mode. With it, you can watch minimized versions of videos on top of other apps so you can multitask like a pro. However, not every service is on board with Apple's new features. YouTube is the primary culprit, but there is a workaround.