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 536th installment in their series of digital spreadsheet magic tricks, you'll learn how to list all modes in a given multimodal data set using Excel 2010's MODE.MULT function.
This is a video tutorial showing its audience how to relate the information that is displayed on your camera lens to your actual camera. The first step is to grab your camera and begin studying your lens. Next look at the mm reading on your lens and the aperture reading. These settings will assist you with setting your depth of field. Next look for your focus ring. Your focus ring will allow you to focus your photos in manual mode. Next look for the focus reading, this will tell you how far a...
Want to set up a custom email account for a domain hosted by GoDaddy? It's simple. So simple, in fact, that this free video guide can present a complete overview of the email address creation process in just over three and a half minutes' time. For complete instructions, and to start using your own custom email addresses, watch this helpful how-to.
In this video tutorial, viewers learn how to use the Filter Key features on a Windows 7 computer. Begin by opening Control Panel and select Ease of Access. Under the Ease of Access Center, click on Change how your keyboard works and click on Set up Filter Keys, at the bottom of the window. Now check the box beside Turn on Filter Keys. Users are provided with several options for he Filter Keys such as: turn off the Filter key wen Shift is held or 8 seconds, display a warning message when turni...
In this how to video, you will learn how to set up a tone arm on a record player. First, you will notice the counter weight at the other end of the tone arm. Remove this first. Set the dial set to zero and have the lever pushed forward. Slide it on and lift the arm off of its rest. Play around with it until the arm floats. The next thing to do is to balance the cartridge. Many cartridges have different weight requirements. If you do not have the weight set up behind the arm, you cannot use di...
This video teaches how to change Windows 7 accessibility options. Choose Start, Control panel. This opens the Control Panel window. Choose Ease of Access in the control panel window. This opens Ease of Access window. Inside the Ease of Access window, there are various links that allows you to set various accessibility options in windows 7. You can use these settings for options like "Optimizing Visual Display", "Replace sounds with visual cues" and you also have settings to choose how the way...
This video shows us how to use the following functions in Excel: average, count, counta, min, max, and sum. First, start off by create a set of numbers to work with. After that, click on an empty cell that you want to use for the functions. To do an average, click on the functions button on the top right corner of the menu bar, you'll see a list of all the functions that are available. Select average, and then highlight all the numbers that you want to find the average of. Repeat the exact sa...
This HelpVids.com tutorial shows the basic options for setting an alarm on an iPhone. To begin, open the "clock" app. There are four sub-menus in the the "clock" app. Choose the "alarm" sub-menu. To create a new alarm, touch the "+" in the upper right corner of the screen. A new screen appears and the user has different options. A repeat time for the alarm can be chosen. The user can choose the sound that plays when the alarm goes off. The "snooze" option can be toggled on or off, and the ala...
For all you future RC fans out there, if you're having trouble setting the Nitro engine gear mesh up on your RC vehicle, do we have the video for you. This tutorial will give you about 8 whole minutes of how to properly set up this easy task. Although it says it is for Nitro, it can be used with others as well. Enjoy!
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 188th installment in their series of digital spreadsheet magic tricks, you'll learn how to set up headers and footers across multiple sheets.
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 135th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic range when there are blanks in the data set. Learn also how to use an array formula to find the Last row or column used in a data set.
Now that you've installed Microsoft Windows 7 on your computer or bought a new Windows PC, it's time that you made yourself at home. With this official Windows 7 video tutorial from the folks at Microsoft, you'll learn how to apply custom settings as well as how to keep your Windows 7 PC running smoothly.
Before you can alter the settings of a virtual machine, you must first have the machine powered off. Load VirtualBox on your Mac desktop and make sure it is powered off on the left hand panel. Double-click General and a window should pop up allowing the changing of several settings. For example, you can include a description to keep many virtual machines separate, or adjust the size of the drive. You can even add virtual devices through ports if they are connected to the physical machine. The...
Beauty Newbie suggests determining the shape of your eyes to create dramatic makeup looks using eye shadow. For close set eyes, you'll need to create more space between your eyes. Try applying a light shade on the inner third of your eye. Then, on the outer part of your eye add a darker shade. Its not necessary to always use three shades, although it does enhance the end result. If your eyes are wider set, you'd just do the opposite of the close set eye technique. If your eyes are deep set, A...
In this how-to video, you will learn how to compress iMovie files into QuickTime files to make them look really good on YouTube. First, open iMovie. Click Share and click Share again. Go to Expert Settings and click on Share. Click on Options and go to Settings. Change it to h264, current frames per second, and every. Restrict should be set at 5000. Optimize it for DVD and change encoding to best quality. Change the size to NTSC 720X486. Check de-interlace video and hit okay. Change the sound...
Create drums sounds using Reason's Thor synthesizerYou can use the Thor synthesizer to make a kick, snare, hat and clap sound.Kick:Use the analog oscillator with triple wave form octave3. Set the source to mod envelope 45 destination oscillator 1.Use a very short attack to K and release time. You get the short effect of pitch. Try different oscillator types to get different textures.Snare: Use the same basic patch that we created for the kick. We will keep it as the basis for most patches for...
The speaker in this video introduces the concept of macros used in Excel, very simply and lucidly. Two sets of shortcut keys are used, one set to create the macro and the other set to run it. The first shortcut opens up the VBA window (Alt+F11), with a workbook along with the 3 default sheets. This video puts the macro in a module. The procedure starts with typing sub and a name which can be easily recalled. The rules for naming the macro are also covered briefly. After the macro code is writ...
Ubuntu and Windows may have trouble syncing time because when they are dual booted, they both assume that your hardware clock is set to a different time setting. Ubuntu assumes that your clock is set to UTC and Windows assumes that your clock is set to local time. Answers Launchpad has solutions to fix the syncing issues. To correct the issue, configure Ubuntu to be set to local time. Launch your terminal window and click on the description box. In the code string change the UTC default value...
There are a number of items that you will have to use your mouse and click onto in the process of changing your clock, language and religion in Windows XP. Click START-CONTROL PANEL-DATE/TIME/REGIONAL OPTIONS. This will get you to the window that allows you to change any of these settings. To change the date or the time click on Date/Time icon. Here is displayed the current time. If you change the time here, you will have to click the Apply button to enable the new setting. Set to the correct...
Whether you are sharing an internet connection, working together or just playing group video games, you will need to network your computers. Check out this tutorial and learn just how easy it is to create a home network.
Network mapping lets PC users organize multiple computers into a system that provides informational data access. This video tutorial shows how to set file sharing permissions and assign users designated privileges within a network. Establishing a network provides functionality within a workplace and facilitates virtual communication among users.
First, on your computer access your command prompt and type in ipconfig. Find the line called default gateway and write it down for later. Type your default gateway into your internet address bar and it will bring up your router setup page. Find your upnp and enable it, this will open your NAT. Start your XBox 360 and go to system settings on your XBox dashboard, go down to network settings and test your connection. Next go to IP settings then manual then IP settings. You want to change your ...
This is a video from HelpVids.com that discusses how to set and adjust tab stops and indents in Microsoft Word 2007. The video starts off with a Word 2007 document open on the screen. First the presenter shows how to show and hide the rulers. This is accomplished by clicking on a small icon above the vertical scroll bar. Tab Stops are only applied to text that has been selected and not the entire document (unless you select the entire document). The sliders on the ruler control the amount of ...
This is a fantastic video, which guides us how to adjust auto play setting in our laptops. It shows systematic moving snapshot demonstration of the auto settings procedure of Windows 7. The speaker tells us to go to the start menu and then click on the control panel. Inside the Control Panel click on the Hardware and sound menu, which will open a new window, and then click on the Auto Play option? The window that opens now gives us several options to choose when we insert different types of d...
If you are looking for a healthy and flavor packed meal to change up a boring lunch routine then your in luck. This video will show you how to make a pita hummus pocket. You can make your hummus from scratch.
In this video the instructor shows how to user printer options in Microsoft Word 2007. To do this go to the Microsoft button and click it. Form the drop down menu select the print option. Now you are presented with the three options of Print, Quick Print and Print Preview. Print is used to directly send documents to the printer by selecting the necessary settings. Quick Print is used to quickly send the documents to the printer using the default settings. Print preview is a useful way of seei...
Open your internet browser, type in the address bar 192.168.1.1 and enter your user name and password to access. Look in the right and search for Port Forwarding / Port Triggering. Click on Add Custom Service. Type a name to the service, like XBox Live, now access HushedCasket and scroll down to see the ports you need to open. Go back to the setting and select UDP in Service Type. Put 88 in Starting Port and Ending Port. Go to your XBox and enter in System Settings, go down to Network Setting...
In this video by Click Here Photography, learn about using f-stops, or apertures and how they work. The aperture is the hole or opening within the camera that allows light in. When using your aperture setting it is important to remember that the amount of light traveling through a lens alone will not only give you a great photograph, but a combination of the following three components, which are:
This tutorial video will show you what the purpose of compression is and how compression works through its parameters. Your instructor illustrates a drum beat and a plucked guitar line. Beginning with how to compress the drum beat, take (download) a drum sound pack without compression and to add compression using the software right click on the drum machine, choose create, and then choose combo on compressor. The virtual compressor has all the dials and adjusters found on any basic compressor...
Lifestyle expert Hal Owen teaches us the correct way to set a table place setting. 1. Place the "charger" plate in the middle of the place setting. This is the plate on which you will place all of the other plates. 2. Place your "dinner plate" in the middle of the "charger". 3. Place your "soup plate" in the middle of the "dinner plate". 4. Place your fork on the left of the plate and your dinner knife and spoon on the right, with the soup spoon on the outside. 5. Place your dessert fork and ...
If you ever wondered how to create a buy now button for your website this video shows how to do it using Photoshop. To do this open Photoshop and start with a new file. First draw a rectangle which will be now modified into the buy now button. Set the radius of the rectangle to forty pixels. Fill it with gray color. Duplicate the layer. Open the layer options of the duplicated layer and set the stroke position option to inside. Set its weight to 6 pixels and set its colors to light gray. Now ...
Learn how to set up an Epson printer wirelessly when you bring your new printer home you will want to start by installing the software that came with the new printer. You can set up your printer to work without wires and it will print from all over the house. There are 3 ways to set up the printer including the Epson way, with cables, and WPS. To determine is you need to use WPS, which is more complex, check your router to see if it has a sticker on it that says Wi-Fi Protected Setup. If that...
This how-to video is about how to check and set the tire pressure in the car. The first and foremost thing we need to consider while setting the right pressure in the car tire is looking for the proper inflation pressure for both front and rear tires. We can find the manufacturers specification for tire inflation near the driver side door, where the tire pressure for both the front and rear tires will be mentioned, take a correct look at the tire pressures. In this video the tire pressure req...
This video shows you how to set up an active speaker system with a built-in amp. Move the gain up and have it halfway up on the mixer. The actual volume control should be set to 0 prior to moving the gain up and down. Mess around with the gain, and slowly bring the gain up until you are slowly tapping into the ampere. You can mess with the gain until it sounds right. This will increase the bass on our mixer.
Using specific measurements and settings, this video details how to use a Canon 5D Mark II with a Steadicam Merlin. The Steadicam Merlin is a great, low-budget alternative to larger, more cumbersome Steadicam rigs, but it still gives you a steady, smooth image. Paired with the 5D and you've got a slick, professional looking video.
Bruce Dorn from Canon breaks down the exposure and Speedlite controls on the Canon 5D Mark II. His explanations are especially helpful as he gives certain shooting scenarios in which tweaking these settings will improve your overall image quality.
Learn how to set up Internet on iPhone clones with this video. *First thing you need to do is to make an AT&T GPRS data account.
This is an amazing magic trick that can only be done with a new deck of cards. Watch the video to learn.
An interesting feature of Windows 7 is the ability to run Windows XP in a virtual machine in order to use applications that don't currently work with Windows 7. This is different than using other virtual machine options because in the final version of Windows 7, several versions will ship with this for free as opposed to other options such as purchasing VMWare and an XP license.
Bejeweled Blitz is a Facebook game. Learn how to hack Bejeweled Blitz with tricks, cheats, hacks. Watch this video tutorial to learn how to cheat on facebook's Bejeweled Blitz (07/27/09).
