Setting Deposit Search Results

How To: Use AGGREGATE instead of SUBTOTAL in MS 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 664th installment in their series of digital spreadsheet magic tricks, you'll learn how about how the new Excel 2010 AGGREGATE function that can calculate these 19 different functions depending on what number you put into the 1st argument of the AGGREGATE function. This is an improvement over the SUBTOTAL function wh...

How To: Adjust notification settings on an Apple iPhone 4

Not happy with your current notification settings? Whether you're the proud owner of an Apple iPhone 4 or perhaps just considering picking one up, you're sure to benefit from this free video tutorial, which presents a complete overview of how to adjust the phone's various notification settings. For more information, including complete, step-by-step instructions, take a look.

How To: Access all Windows 7 settings at once

In this video tutorial, viewers learn how to access every Windows 7 setting at once. Users will need to download the Windows 7 in a Box program provided in the video. Once downloaded, simply click on one of the functions (Functions, Folders, Internet Settings, Programs, Tools and Settings) on top of the window and select the option that you wish to use. This program will organize all the Windows 7 settings into an easy to comprehend layout. This video will benefit those viewers who use a Wind...

How To: Burn fat with a plyometric weight loss routine

How do you amp up your current cardio/strength training routine to make sure you burn extra calories and shed extra fat? By jumping. Though jumping sounds easy, after you try this routine and repeat it a few times we'd be surprised if you weren't completely winded and sweaty. Do these exercises after your usual routine to really kick things up:

How To: Set up a hydroponic herb garden on your rooftop

Setting up a hydroponic herb garden might sound like a dauntingly big project but, as this clip demonstrates, it's much more manageable than you might expect. It's so straightforward, in fact, that this gardener's guide can present a complete and thorough overview of the process in just over three minutes' time. For more information, and to get started setting up your own rooftop hydroponic flower or vegetable garden, take a look!

How To: Set a passcode on your Apple iPhone

Thwart would-be snoopers by protecting your Apple iPhone with a passcode. Learn how to set one up with this clip. It's easy! So easy, in fact, that this free video tutorial can present a detailed, step-by-step overview of the process in under a minute. For more information, and to get started setting up a passcode on your own iPhone, take a look!

How To: Import, manage & export 16:9 footage in Final Cut Pro

In this video tutorial, viewers learn how to import, manage and export 16:9 footage in Adobe Final Cut Pro. Begin by opening the Log and Capture.Then configure the Logging, Clip Settings and Control Settings. For the Control Settings, set the Device Control as Fire Wire NTSC and the Capture/Input as DV NTSC 48 kHz Anamorphic. Then scroll through the sequence setting of the footage and check Anamorphic. To export, click on File and select Export. Click in Options set the the size to Compressor...

How To: Change your NAT settings to OPEN on a PS3

This video shows how to change the NAT type on a PS3. Go to connection settings>network settings>internet connection settings>OK>custom>wired connection>auto detect>manual. Choose an IP address that is different from your router, any other consoles, etc. Click right>automatic>do not use>enable. Press x to save settings, and test your connection. In this example, NAT type is 2. Now go to your PC and open IE. In the address bar, input router IP address, username and password. Go to Firewall Rul...

How To: Get to know your DSLR camera

This video gives viewers an overview on how to use the manual settings of your DSLR camera. Aside from the Auto setting, your DSLR camera has the P-mode which is the program mode, S-mode which is the shutter priority mode, A-mode which is the aperture priority mode and finally the M-mode which is the complete manual mode. P-mode or program mode is more like the Auto-mode in your camera. You can't control your shutter speed and f-stops (aperture) however; you can manipulate the other settings ...

How To: Set up a handheld Zacuto Letus35 Elite on an HVX200

In this demonstration, you will see how to build an HVX200 up with a Zacuto Letus35 Elite DOF Baseplate and Backfocus kit in a handheld setup. These three videos will show you how to build the HVX200 setup from nothing, start to finish. The first step to setting up the package is the baseplate, just like most cameras. If you want, you can even add a monitor to the setup to see what you're doing when filming.

How To: Design an icon set in Adobe Photoshop and Illustrator

This software tutorial takes a look at how to design an icon set in both Photoshop and Illustrator. An icon set is a set of icons that you can integrate into a number of different projects, like a website or a company letterhead, logo and identity set up. Having an icon set readily available for all your project needs will make your workflow faster and simpler. So watch and see how to make an icon set first in Photoshop and then in Illustrator.

How To: Set up a distribution list for your iPhone using Group Text

With the Group Text app, you can easily set up a distribution list so you can send out text messages to large numbers of people at once. You can also set up form templates, which are useful if you tend to send out a similar text message each time. This short tutorial shows you how to set up the distribution list, and how to get the most out of your Group Text. You can even set up multiple distribution lists for different topics or texts!

How To: Record HD widescreen in Camtasia

First open up the Camtasia studio and click on the link make a recording. It will open up the Camtasia recorder but before you start the recording you need to click on the tools, options and make sure the "save as AVI" is selected in file menu. Then click on video tab and select the "manual" in "video configuration", 30 in frame rate and click ok. Now download and install the software called "free sizer". Now we need to set the recording area to 1280x720. To do that, right click on the maximi...

How To: Set up your AppleTV with a standard definition TV

You don't need a high definition television to take advantage of AppleTV! This tutorial shows you how to set up your Apple TV to function with a standard definition television set. You'll need an HDMI to DVI cable anda VGA to DVI adapter, and use the yellow composite video cords. Then adjust your settings, and you're ready to start watching your new Apple TV!

How To: Set up textures as a template background in 3DS MAX

This video will explain to you how to preform one of the more fundamental but confusing tasks in 3D Studio MAX: setting up textures as a template background for you models. Doing this will make sure that your models are displayed in front of the proper background and that said background will function properly. If you need a little help setting the scene for your 3D modeling, watch this video.

How To: Solve number set problems in intermediate algebra

From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just finish your homework or study for that next big test). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to unpack and solve number set problems in intermediate algebra.

How To: Set colors and fonts for a full workbook in Excel 2007

See how to use themes to set color, font and effects settings for a Microsoft Excel 2007 workbook. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with this particular iteration of the program, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, watch this free video guide.

How To: Set the ringer volume on your Android phone

Set your Android smartphone's ringer volume while leaving other volume settings untouched. One of the salient advantages of a Google Android smartphone over, say, an Apple iPhone, is the inherent extendibility of the open-source Android mobile OS. There are a seemingly infinite number of settings to tweak and advanced features to discover and use. This free video tutorial will show you how to adjust the ringer volume on your Android smartphone.

How To: Change the notification sound on your Android phone

Tweak notification setting on your Android device. One of the salient advantages of a Google Android smartphone over, say, an Apple iPhone, is the inherent extendibility of the open-source Android mobile OS. There are a seemingly infinite number of settings to tweak and advanced features to discover and use. This free video tutorial, in particular, discusses how to change the way your Android phone notifies you in the Sound and Display settings menu.

How To: Set an alarm on an iPhone with the built-in clock

With all of the technology available today, which do you use to be your personal alarm clock? You can have a huge, bulky alarm clock, you can use your computer, and you can have one of those small, portable analog clock, but why use them if you have an iPhone? The iPhone has a built-in alarm clock that's perfect for cutting down on the bulk of life. So, how do you use it? Best Buy has answers. The Best Buy Mobile team explains how simple it is to set an alarm on an iPhone with the built-in cl...

How To: Set up an email account on an Android cell phone

If you just got a new Android mobile phone, then chances are, the first thing you're going to want to set up is your email account, so you have instant access to your emails all the time, everywhere and anywhere. Setting up your specific email account or accounts is actually not hard. Best Buy has answers. The Best Buy Mobile team explains how simple it is to set up an email account on an Android cell phone.

How To: Pair your bluetooth headset with the HP TouchSmart PC

HP TouchSmart is a powerful PC with innovative features. Using the HP TouchSmart Recipe box you can set up the blue tooth headset. The recipe box provides an easy way to work with you recipes using voice commands. You can set up your blue tooth head set to use the voice command feature of the recipe box. This gives the freedom to walk around your kitchen while cooking. The microphones embedded in the TouchSmart can also be used for this purpose but the blue tooth head set gives a better voice...

How To: Set up an Element Tattoo power supply

Steve of Element Tattoo Supply demonstrates how to set up a tattooing power supply, specifically the Silver Bullet model. It has a voltage switch on the back. If in the US, set the power supply to the 115-volt setting. Outside the US, switch to the 220 volt setting. There are two power plugs in front for tattooing equipment (such as a foot pedal), and a dial for adjusting the power. The relative power is displayed on a LED display.

How To: Change your keyboard & mouse settings in Windows Vista

Clearinfo.com helps us how to change the keyboard and mouse settings in windows operating system. The video actually shows us the tutorial in windows vista but this can be applied also in windows xp. First go to Start button then click on control panel and on the Control panel Home view, select Hardware and Sound where you will get the mouse and keyboard setting options. Under the Classic view there will be keyboard and mouse option. Under the Keyboard options, it will show various settings a...

How To: Calculate standard deviation

Looking to find the standard deviation of your set of values? Standard deviation quantifies how diverse the values of your data set are, and is useful in determining how different your numbers are from each other.

How To: Set up audio & MIDI recording on a PC in SONAR 6

This audio production software tutorial shows you how to set up audio and MIDI recording devices on a PC using SONAR 6 Home Studio. See how to plug-in cables, and set up audio and MIDI for optimized recording and playback on a PC. This video shows the process in SONAR Home Studio 6, but the concepts can be applied to most Cakewalk software.