Microsoft Search Results

How To: Use USB memory stick with your Xbox 360

If you're looking to expand the storage capacity of your Xbox 360, you should look no further than a USB memory stick. And, this video will show you how to do it. You can store games, profiles, basically anything that's stored on your Xbox 360 game system. Microsoft recently added a patch to the game system to make this process really simple and easy to do. So, get a memory stick and start bulking up today! Oh, all that video game glory!

How To: Turn a Ctrl + Shift + Enter formula into an Enter array formula in 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 and Mr. Excel, the 52nd installment in their joint series of digital spreadsheet magic tricks, you'll learn how to use the INDEX function to turn a Ctrl + Shift + Enter array formula into just an Enter array formula. Avoid Ctrl + Shift + Enter by using the INDEX function and a blank as the row argument.

How To: Add a hyperlink into a PowerPoint document using Leo from Kryon Systems

Forget fumbling around in Microsoft Office for help. When you really need to solve a problem, you can never find any answers, even when it comes to performing menial tasks, such as adding hyperlinks. Seems easy, right? With Leo it is. This video demo will show you how to add hyperlinks in PowerPoint using the Leo help application from Kryon Systems. Learn. Evolve. Operate. That's what Leo stands for, and in PowerPoint, getting things done is no longer a chore. Leo can do it for you! It's a ne...

How To: Compare a list of numbers where one group is entered as text in Excel 2010

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 719th installment in their series of digital spreadsheet magic tricks, you'll learn how to compare two list of numbers and see what happens when one list is numbers is aligned right and the other list is numbers as text.

How To: Create a data validation drop-down list from a table with duplicates in 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 608th installment in their series of digital spreadsheet magic tricks, you'll learn how to to create an expanding data validation drop-down list from table with duplicates using a number of different tricks.

How To: Create a bibliography with MS Word 2007

In order to create a bibliography with Microsoft Word 2007, you will need to access the reference tool bar, at the top of your screen. Click on references. Open your document. Put your cursor where you want to make the entry. Then, click on Manage sources. Fill in the pop-up that comes up. This will ask you for all of the information needed for the type of citation you are using. Click OK.

How To: Boot up your computer faster with boot defragment

This video tutorial is in the Computers & Programming category which will show you how to boot up your computer faster with boot defragment. Boot defragment places all the boot files together in the hard disk making it easier for the booting process to start. Click on start > run, type in 'regedit' and click OK. This will launch the registry editor. Here you double click on hkey_local_machine to open it. Then you double click on software > Microsoft > dfrg >BbootOptimizeFunction Click on 'ena...

How To: Disable uac on Vista in less than a minute

In this video tutorial, viewers learn how to disable User Account Control in a Windows Vista computer. Begin by clicking on the Start menu and select the Control Panel. Then type in "user account" in the search box and click on "Turn User Account Control on or off" under User Accounts. Now deselect the checked box and click OK. Finish by clicking on Restart when the Microsoft Windows window pops up to reboot the system for the changes to take effect. This video will benefit those viewers who ...

How To: Insert movie files into a MS Word document

In order to insert movies into Microsoft Word 2007, Click on Insert. For AVI, go to Object, Create From File, and select the location of the file. Then, click on Insert. It will now appear on your document. The video should play. The video can be repositioned or adjusted. It can be saved with your document, although this is not true for other movie formats.

How To: Hide files inside .jpgs

This tutorial will show you how to hide files on your computer using an image file. The first step is to get an image file and edit it with Microsoft Paint or Adobe Photoshop. The next step is to save the image file as a jpeg file. Now create a WinRaR archive file and copy the files that you want to hide in the archive. The next step is to open Command Prompt: Click the Start button and click Run. Now enter "cmd" and hit enter. Now just enter the same commands from the video and hit Enter. Fo...

How To: Open .zip files

In this tutorial, we learn how to open .zip files. First, go to the start menu and search for "regedit.exe", then press enter. After this, a new window will pop up, open the computer icon, then open "current user", "software", "Microsoft", "Windows", then "current version". Now, click on the explorer folder, then the "file exts" folder and ".zip" folder. You should now see three different folders, right click on "user choice", then delete it. Exit this program, and now return to your zip fold...

How To: Use a macro to arrange a data set in a column in 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 644th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a recorded macro that uses formulas to rearrange a proper data set to one listed in a column.

How To: Detect all computers connected to your wi-fi network

In this tutorial, we learn how to detect all computers connected to your Wi-Fi network. To begin, go to the website, http://msdn.microsoft.com/en-gb/netframework/aa569263.aspx. Once you are on this site, download and install the program. Once it's installed, open the program and then look for the MAC address. Once you find this, go back to the website and enter this into the MAC address line. After you do this, you will be able to see what computers are listed on your network. If you see any ...

How To: Run Windows 7 on a Mac using Parallels

In this Computers & Programming video tutorial you will learn how to run Windows 7 on a Mac using Parallels. First you got to download Windows 7. For this you will need Firefox browser. Open the browser and go to www.microsoft.com/windows/windows-7/download.aspx. Scroll down and under the 32 bit download link, select English and click GO. If you have a windows account, type in your email and password and sign in. You will get the download link in the email. Go to the link, it will have the pr...

How To: Install XBox 360 memory unit drivers on your PC

The XBox 360 memory units were never very popular and have become even less so since Microsoft enabled the use of flashdrives with the XBox in the last firmware update. If you haven't updated your firmware or still want to make use of your memory units for modding, this video will teach you how to install drivers for your memory units on a PC so that they can access them and you can modify the contained data however you see fit.

How To: Find APR, EAR & amortization for payday loans in 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 623rd installment in their series of digital spreadsheet magic tricks, you'll learn how to see the pain that pay day loans inflict on people using Excel. Learn how to calculate APR (Annual Percentage Rate), EAR (Effective Annual Rate), an Amortization Table and the EAR for a loan that takes a fee out up front. Learn ...

How To: Make a bootable system repair disc in MS Windows 7

There may come a time when your computer just won't boot. With a bootable system repair disc you can access and perhaps fix your computer. This guide will show you how to create a boot disk for Microsoft Windows 7. It's easy! So easy, in fact, that this home-computing how-to from the folks at Butterscotch can present a complete, step-by-step overview of the process in just over two minutes' time. For detailed instructions, and to get started creating your own system repair discs, watch this f...

How To: Sum and average statistical data within MS 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 532nd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AVERAGE, STDEV, MAX, MIN and SUM function to add statistical data. Specifically, this video lesson discusses how to sum and average evidence in an age discrimination case.

How To: Sort numbers with a formula in 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 and Mr. Excel, the 12th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create formulas that will take an unsorted list and sort smallest to biggest or biggest to smallest using the MAX, LARGE, SMALL, ROW and ROWS functions.

How To: Count Mondays between 2 dates in 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 and Mr. Excel, the 44th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to count the number of Mondays between two dates using the WEEKDAY function or the TEXT function wrapped around the ROW and INDIRECT function.

How To: Create random dates within a set range in MS 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 and Mr. Excel, the 26th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create random dates between upper and lower dates using the 4 different formulas that use functions such as RANDBETWEEN, RAND, INT and DATE.

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 the concatenate function & ampersand in 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 166th installment in their series of digital spreadsheet magic tricks, you'll learn about the relative advantages and disadvantages of the ampersand symbol and the CONCATENATE function (both join two [2] or more elements together into one text string).

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: 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: 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.