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...
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...
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...
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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...
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...
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 ...
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...
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...
This video explains how you can watch YouTube movies and videos on your iPod. First of all you need to open your web browser and do a search for Realplayer (in this case Realplayer version 11). Next, click on the link for Realplayer. You will need to download and run the installation file. Once the installation has run you need to accept the default and then load your web browser (Explorer or Firefox). From here you can choose any YouTube video you would like then add "&fmt=18" to the url add...
The placement of your battery on a crawler RC can be a pretty important task that you need to know. This video tutorial gives you a detailed explanation of where to place your battery and how to msximize the performance of your vehicle. Enjoy!
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...
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 ...
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...
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...
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...
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...
Proper car car can extend the life of your vehicle. This instructional video demonstrates how to change the transmission fluid and filters in a 2006 4.7L 4x4 Jeep Grand Cherokee. The process should be similar for other cars, but when in doubt consult a professional. If you're confident under the hood, then save a few dollars and do it yourself.
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 ...
In this video the instructor shows how to upload High Definition HD videos using Camtasia Studio. Here the instructor shows how to upload the videos that you recorded using Camtasia in HD to YouTube. Now to generate a HD video you will need to record in high resolution like 1280 by 800 pixels. Now record the video at full screen. Now after recording you will have your HD video. Open the video in Camtasia and add the clip to the time line by right clicking it and selecting the option from it. ...
Looking to change your YouTube Favorites to an mp3 to carry them with you everywhere? In this video, learn how to do so with the help of a download from dvdvideosoft.com, and this tutorial. Instructions for are listed below as listed by videomaker, vakama380:
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...
Make the most of your YouTube videos! Watch this video tutorial to see how to make the most out of the YouTube player by uploading widescreen video. Here's how to prepare your videos for widescreen viewing:
Depth of field is the term for how much of an area your camera keeps in focus. Moving your camera allows you to keep your subject clear, and make the background blurry. Use this video to get better control of your film making.
By following this tutorial you will learn the concept of selections in GIMP. Whenever he says "layer mask" he really meant "selection mask".
If you want to embed an iFrame into a Blackboard 9.1 page, you'll need to grab the code from whatever source you want (YouTube, Vimeo, Google Docs, etc.) and use the Build Content option in Blackboard. Select "Item" under the "Create" menu and turn off the Text Editor so that you can properly paste the code in. Take a look at this tutorial to see all the steps in action.
You've probably seen tutorials on YouTube before on how to achieve Kim Kardashian curls, or Victoria's Secret waves, or the hair look of the fashionable deviants on "Pretty Little Liars," but why go through so many tutorials when they're all really the same thing?
Not since Lady Gaga's "Telephone" Coke Cans and Madge brow'n'lips has a music video makeup look been so universally dissected and copied by YouTube makeup savant.
Popularized by artists like Son House and Skip James, Delta blues is not only one of the oldest forms of blues music, it is among the most stylistically distinct and technically rewarding to play. In this video guitar lesson from YouTube user deltabluestips, you'll learn how to play Tommy Johnson's "Canned Heat Blues" on the guitar.
Want to know what that foreign YouTube comment says without loading a separate webpage to translate it? Downloading gTranslate, a Firefox addon that translates any text, will help you see what that comment is or any small sentence. Just highlight the text, right-click on the text and go to the translator, the foreign language will be automatically detected and translated.
Aspiring card shark? Sink your pearly whites into this easy, impressive illusion. In this free video magic lesson from YouTube user experthowto, you'll learn how to perform the "slap it" card trick using simple sleight of hand. For more information, including a step-by-step breakdown of the trick, watch this prestidigitator's guide.
