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...
If you're a novice looking to learn how to use Microsoft Excel, a video series from digital spreadsheet guru ExcelIsFun is a great place to start. But which of his many series should you choose? The one titled "Excel Basics," that's which! This free video MS Excel lesson, the very installment in said tutorial series, covers the following topics:
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.
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 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...
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 530th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the OR, SEARCH and ISNUMBER functions to see if the descriptions in a data set contain a given value (in this case, "Repair" or "Rework").
In order to Find, Replace, and Sort, using MS Excel, become familiar with your home tab. When you click on Sort, it will give you the opportunity to sort in different ways: e.g. alphabetically. If you accidentally shift your table, you can undo it by using Ctrl + Z. Custom Sort will allow you to be very specific in the way you want your data sorted. You can add or remove a filter with the same drop down menu, in order to be even more precise.
In this how-to video, you will learn how to connect a USB hard drive to your Xbox 360. This will be useful if you want storage for additional media and do not have enough space for it. First, turn on your system and then go to disk management and delete the partition. Back up any data before doing this. Next, create a new partition on the drive. Set it to FAT32 and enter a name for the label. Your USB drive will now be used on your Xbox 360. This video shows how easy it is to connect a USB ha...
In this Computers & Programming video tutorial you will learn how to format/partition an external hard drive on a Mac. This is really very easy and simple to do and takes practically no time. Click on spotlight search and look for disk utility. That will bring up the list of hard drives. Click on the external hard drive and click ‘erase’. Then on ‘security options’ select ‘zero out data’ and click OK. This will remove everything from the hard drive. Your external hard drive is now...
First, open the Excel worksheet you have previously created that you would like to create a table for. Click on any of the cell that contains data for your table. On the menu found on the upper portion of the application, go to the Insert Tab. Find and click Table. Your entire worksheet will now be selected. When a prompt window appears, click OK. Your table should now be created automatically.
Log in to your account. Go to settings, then go to Forwarding and POP. Then, check in the box for enable POP for all mail. Next, save the changes. Then go back to the settings page and check the first box (to include the mail that has already been downloaded). Save your changes again. Next, select tools>account. In the box that pops up, select POP for the account type and hit OK. Name the account and fill in your email address and POP address. For the SMTP server, put in smtp.gmail.com. Then,...
In this video tutorial, viewers learn how to burn a CD or DVD on a Mac computer with the Burn application. Burn is able to create data, audio and video discs. The Inspector window allows users to edit extra information about the disc. To open Inspector, press the Command and I button. It is also able to create disc copies. To burn a disc, name the disc and select a format. Them simply drag the file(s) into the program and click Burn. This video will benefit those viewers who have a file on th...
In this how to video, you will learn how to sort columns in Excel with the Excel Experts. This is great if you want to learn the basics of sorting in the program. First, you must have Excel installed and running. Open up a spreadsheet that needs columns to be sorted. Select the column. Go to data and sort. Click options and select left to right. Choose the row you want to use and select the order. To undo this, go to sort and change the sort order. This video offers straight forward advice fo...
This video is for XBox owners who are experience the "open tray" problem. This is when you insert the disc, a few seconds later, it'll ask you to open tray again, and then it won't even acknowledge that there's a disc in the tray. Assuming you know how to open up your XBox, you'll be able to see the parts of the disc drive. It consists of two parts, the part where the disc spins on, and the laser, which reads the disc and it sits just a little bit away from the middle of the drive. The proble...
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 298th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT and MOD function to add up all hours in one cell worked by employees when time in and time out data are entered as time values.
This how to video will show you how to jail break the iPod Touch or iPhone to the 3.0 firmware with Redsn0w. First, download Redsn0w and the firmware. Open the file and double click the program. Click browse and navigate to the firmware. Open it and let it load. Once this is done, press next. Let the data load and then make sure Cydia is clicked. Click next and then turn off your device and plug it in. Click next and then hold the power button for 3 seconds. Without releasing the button, hold...
Chances are if you've used a computer in the last decade or so, you've probably used Microsoft Office at some point. Activating Microsoft Office standard 2007 will give you access to functions you might not have even known existed that can increase your productivity and improve your work flow. This video will show you to activate Microsoft Office standard 2007.
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 240th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic range with the OFFSET function and a named formula when new records are added at the top instead of the bottom.
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 158th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the VLOOKUP function to retrieve data and the OFFSET function to look at just part of the desired table.
Some savings plan pays interest 365 days in a year but you make deposit monthly. You can use Excel functions to calculate the maturity value of the of the monthly plan. To do this you have to use the nominal and effect functions before using the future value functions. First enter the know data like the monthly payment, the number of years of payment, the number of days in a year, and the annual percentage rate. First take the nominal rate and calculate the effective rate with the help of eff...
Namuoc demonstrates how to create a line chart in Excel. To create a simple line chart in Excel 2007, first highlight the cells in your worksheet that you would like to include in the chart. Then, select the insert tab on the top of the worksheet toolbar. Next, click on the line option. Select the two dimensional line graph option from the given choices. Move the chart to a new sheet. Label the new sheet in the appropriate field and click the OK button. Your line chart will now be created usi...
Encryption is the process of converting you data in to other obscure form so that no one can read it. Encryption can also be done using batch files. Batch files are scripting programs in windows which can be used to program small automatic operations. To do this open a notepad to write the batch program. First turn of the echo by inserting the command '@echo off'. Now write the rest of the program as shown in the video. Now save the image as a bat file. Now you can encrypt this batch file. To...
If your iPhone has frozen and you're not sure why you're in luck because there is a way to reset it. The first thing you're going to want to do is load up iTunes do a normal reset but don't turn it back on, then plug your iPhone into the connector for your computer but don't actually connect it to the computer yet. Hold down the home button then while holding it plug the connector into the computer. While still holding the home button and have plugged in the connector wait for your iTunes to ...
In this Computers & Programming video tutorial you will learn how to track Google's trends features. This will help you find some powerful micro niches and great keywords to create content and get top rankings in search engines. Any trend on the internet first starts with an event. For example ‘mega millions’ gets lot of traffic when someone wins a jackpot or a big lottery draw is coming up. Similarly, ‘July 4th’ traffic spikes around that event and dies down. If you want traffic from this ev...
This video is about how to reset your iPod. The first thing that you will need to do is to make sure your iPod is turned on. Then the next step that you have to do is to hold down the sleep or off button and the home button at the same time until the screen changes. Then an image of a CD and the charger appears. Make sure that your iTunes is on your screen. Then the next step is to click on your iPod on the devices area. Once you have clicked on the iPod on the devices area, just simply click...
Torrents are a wonderful technology to share your files over the internet. If the data that you are sharing is confidential you may need to encrypt these files before sharing. To encrypt torrents in Azereus, go to tools and select options. From the left hand side menu select the connection option. Select the 'Transport Encryption' option from the connection sub menu. This section is intended for intermediate mode or higher and it is not available in beginner mode. So go to mode and select the...
In this video tutorial, viewers learn how to use Remote Desktop on Windows Vista to connect to another computer over a network connection, specifically Windows XP. You can get access to your Vista applications or data stored on a remote computer from your XP PC.
Thinking of switching to a Mac using an external hard disk, you'll need to format it so that the Mac can recognize it. In your Mac, go to finder, then applications. Scroll down to where it says disk utility and then select it. Here select your hard disk and press the partition button in the screen that comes up. Make two partitions and rename them to whatever you want. After that change the format of the partition to Mac OS extended. Now just press the apply button to apply the changes, be su...
Want to access your Linux partition on your hard drive using Windows 7? With a little program called Vmware Player. So, check out this video tutorial to see how to see all of your Linux files on Windows 7 from your hard drive.
This video describes how to install SSH into your iPhone. It explains the benefits of using SSH to tether instead of Wi-Fi, as Wi-Fi tends to be less stable. The presenter recommends using the iFunbox software instead of the Win-SEP software, and further states that, as opposed to Wi-Fi, USB does not require VNC configuration. It shows how the iFunbox enables you to pull videos, photos, wallpapers, ringtones and other data directly to your computer, as per the usual SSH abilities. According t...
Nick from Greyscale Gorilla demonstrates how to use the ever-useful CS Tools plug-in (Daylight) for Cinema 4D. This feature enables you to fine-tune your key light and other precise ambient settings.
Learn to play one of Robert Johnson's best songs, "Kindhearted Woman Blues", on the guitar. This blues guitar songs from Johnson is a great song to start learning the blues, and is structured in a typical 12-bar blues in the key of A. "Kindhearted Woman Blues" was written in the late '20's, early '30's.
This Software video tutorial shows how to organize images in Lightroom with multiple cameras. Kerry Garrison will explain how to do this by adjusting the time offset of all of the images from one camera. You can take a shot in the beginning and synchronize the rest of the images. There is a tool in Lightroom to accomplish this. Select the live drawing mode, then go to the grid mode and the meta data bar should be displayed on top. The different cameras used in the shoot are listed there. If y...
In this video you will learn from Dave Andrews how to organize and navigate through the files and folders in Windows XP. Every computer has files and folders with stored data. The folders may contain other folders and they are stored on the Hard Drive. To access the Hard Drive you need to click the Start button and click My Computer. In My Computer you have the "C Drive" which is the Main Drive and other secondary drives. In each drive you have folders and subfolders. You will learn in the vi...
This video is an instructional guide about Graph Linear Equations presented in algebraic form. It is an easy to follow, step by step guide to solving such equations using the graph intercept formula. The first example equation is Y = 2x -1 over y = mx + b. The video then shows you how to breakdown the equation into manageable sums using fractions to represent the data, and then presents the formula for interpreting the answer from these sums onto the graph co-ordinates. The second and third e...
This six-minute tutorial shows you how to use the logical IF function with letter grades in Excel. The video features a sample table with a sample assigned grading scheme ranging from A to F, which is a common application of the logical IF statement in Excel. After the data is added to your Excel table, use the IF function in the respective cell or column by inputting the logical test, the value if the test is true, and the value if the test is false. In addition to showing you how to use the...
You can use the vlookup function in MS Excel to create a dynamic table in your document. Creating a new dynamic table and a new dynamic lookup area enaables you to add new data or new columns to the lookup table. You can also create dynamic named ranges by using offset, vlookup table and the match table. This function is very useful to businesses working on Excel. This video will show you to create a dynamic table for vlookup in Excel.
In this video tutorial, viewers learn how to unzip and zip files. The ZIP file format is a data compression and archive format. To unzip a file, right click on the file and select "Extract All". Continue by pressing "Next" and wait for the file to extract. To zip a file, right click on the file, select "Send To" and click on "Compressed (zipped)" folder. This video contains voice narration and a visual demonstration for viewers to easily understand and follow along. This video will benefit th...
Recuva is a freeware data recovery program. Recuva recovers files deleted from your Windows computer, Recycle Bin, digital camera card, or MP3 player. Begin by downloading and installing Recuva. Open up the program and select the type of file you wish to recover. Input the information that is asked and start the scan. It will the provide a list of the files. Simply select the file and click Recover. This video will benefit those viewers who lost or deleted old files and wish to recover them u...
mybigleftnut90 teaches you how to burn Wii backup games for Mac. After you get a backup game for the Wii, you need to make sure the DVD you'll be burning it too is DVD-R as these work best. Also make sure that the size of the backup game is not larger than the blank DVD you have. Right click on the image and click on "Open with-Disk utility." In the new program window, you click your image file name and click the button "Burn" at the top. Your speed should be 2x or 4x. Unclick verify burned d...
