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 665th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function to make calculations on filtered data. The SUBTOTAL function only has 11 functions, whereas the AGGREGATE has 19 plus options to ignore errors, hidden rows and nested SUBTOTAL or AGGREGATE functions.
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 669th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function in Microsoft Excel 2010 and later. This new function is better than SUBTOTAL function because 1) the options argument set to 18 will calculate Percentile and 2) AGGREGATE can handle arrays. See how th...
In this tutorial, we learn how to watch TV on your iPhone with Joost. First, you will need to download this application to your phone. After you do this, click the icon that is on your phone. Once you are on this, you will be directed to a page with different options. Click on popular to see what the most watched shows are, then click browse to find different shows to your liking. You can also click on search if you are looking for something in particular. There are thousands of different sho...
In this tutorial, we learn how to use a USB flash drive. First, go to "my computer" through your desktop. Next, you will see a device that says "flash drive", which is in drive "d". When you unplug your USB device, the drive will disappear. When you plug it back in, a new window will appear asking what you want to do with drive "d". Now, go to your documents folder and if you want to copy one of these files, right click and choose the copy option. After this, you will be able to paste your fi...
In this tutorial, we learn how to use the zoom feature in Mac OS X Leopard. First, go to system preferences, then universal access. Find the zoom category, then turn it on of off. You will also see the keys that you can press which will make it appear. If you go to the options menu, you will be able to maximize or minimize the zoom. Test this out by zooming in on a page and holding the control key along with the tracking ball on your mouse. When you do this, everything will become far more zo...
In this tutorial, we learn how to use a calendar for future projects in MS Project 2007. First, go to the "tools" menu, then down to organizer. Choose the calendar tab and then change what the calendars are available in. Choose ABC Limited, then click on "copy". Now, click on "close" and open up a new project. From here, go to "project" then "project information", and you will be able to change to the other calendar. Remember to change the default under the options so you have the correct tim...
Have you ever secretly pined away for a career in interior design, even though you're currently stuck in law school because, well, your parents forced you and gave you no other option? Because law school can be a bit rigid in terms of what you learn (pretty much it's just facts and figures and learning sound logic), it's important to indulge your creative side ever once in a while.
Are you hosting a party soon but can't decide what to give out as party favors? With options at stores being limited and often expensive, you could save yourself lots of money while tossing guests a memorable gift by simply making your own favors.
We all have our reasons for erasing personal data from a phone. Whether you just ended a bad relationship whose face you never want to see again (lots of text messages) or just want to restore your privacy on the cell phone, erasing may be your only option.
In this next woodworking tutorial, you'll find out how to make a favorite game using, of course, wood!
In this tutorial, we learn how to set up a group on Facebook. First, log into your Facebook, then click on "groups", then click "create a new group". Now, give your group a name, description, news, email address, and contact information. When finished, click on "create group". Now you will be able to customized your group by adding images. Once you do this, you can add a website and change your different options. Allow only instructors to upload photos, because students may decide to upload i...
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...
Photoshop lets you modify your view of an image using a variety of tools, commands, and options. But you don't need a single one of them. Learn a few navigational shortcuts and you'll be working at maximum efficiency in no time. Whether you're new to Adobe's popular raster graphics editing software or a seasoned professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well served by this video tutorial. For more information...
Deke gets things started with a pair of options that can clean out Photoshops plumbing when things get clogged up: Reset and purge. Whether you're new to Adobe's popular raster graphics editing software or a seasoned professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well served by this video tutorial. For more information, including detailed, step-by-step instructions, watch this free video guide.
In this clip, learn how to make an absolutely delicious dessert for summer: frozen lemon souffle. This dessert is refreshing for a hot day by the pool and adds a wonderful zing to the end of any meal. Follow along with this tutorial from the TLC Discovery Channel Cake Crew and get started. You will also get a ton of options for garnishing the souffle like a professional chef. Enjoy!
There are many ways to enjoy books on your Nook. One of these options is through Adobe Digital Editions. Digital Editions is a way to buy and transfer real life books onto your computer and then your e-reader. You can do this with rented library books as well. Check out this clip and learn how to transfer a DRM book to your Nook fast and easily.
In this video tutorial, viewers learn how to use Spotlight to find files in Mac OS X. To activate Spotlight, click on the blue magnifying glass icon in the top right corner. Then type in the term to search. Spotlight will display all the documents and files that match your search. If you click on Show All, you will have more options in Spotlight. In the Spotlight Preferences, users are able to select the categories for Spotlight to search in or not search in. This video will benefit those vie...
Short hair makes care and upkeep easy - a 2 in 1 shampoo and conditioner and you're ready to go - but also limits your styling options. Increase the vocabulary in your short hairstyle lexion by watching this video.
If you've spent a ton of money on your newest smartphone, you will want to make sure it's secure. In this tutorial from the experts at PCWorld, learn exactly how to activate safety mechanisms on your Android. With these options you can set a complicated passcode (so that anyone who does find your phone won't be able to access your files) and you can also set up a locator. By using the location app, you can text your phone from anywhere else and set off a search alarm so you will be able to fi...
If you have not used your eRecovery system in a long time and have forgotten the password, have no fear. This video is here to help you retrieve your details and use your program again. In this clip, learn how to recover any lost passwords with Acer's eRecovery Manager for Linux.
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...
Engadget shows iTunes users how to make use of Home Sharing in iTunes 9 in this video. Using screenshots and video tutorials on-screen, Engadget shows the full interface of iTunes 9 to show you exactly where to start. Through several examples you can see how the transfers work and what viewing options and filters you can use to make the sharing feature quick and easy, including automatic transfers of your iTunes purchases or apps, so it's not just for your music library. Even though it's impo...
In this how-to video, you will learn how to remove the vocals on songs using Ableton. First, open the tracks you want to remove the vocals from. Go to utility and select the preset difference. Drag it to the audio track. This will remove vocals.
In this video you will learn how to setup a Bluetooth mobile phone in OS X. To do this go at system preferences select Bluetooth click on Discoverable, Open Bluetooth Setup Assistance and Show Bluetooth Status in the menu. Then click Sharing and mark all the options. Now go at devices, select set up new device, mark mobile phone, click continue, wait until the device will find your mobile device, click continue and you will get a pass key. Enter that passkey. A window will pop-up where you ca...
This video shows us several types of ornamental grass that can be used in landscape projects. Although none of these grasses are appropriate for use in lawns, they are great options for those who are concerned about water conservation. Ricegrass is a bunch grass with long stems and silver heads. It is a cool-season grass and will go dormant in hot weather. Little Bluestem grows quickly in the Spring and is known for its variety of colors including blue, green, and yellow. Giant Sacaton is a g...
In this video tutorial, viewers learn how to create high definition videos in iMovie. Begin by importing the video into the program. Click on Share and select Export using Quick Time. Set the Export to Movie to Quick Time Movie and then click on Options. Under Video, select Settings. Change the Compression Type to MPEG--4 Video, leave the frame rater at Current, Key frames to Automatic and Quality to the Best. Click OK and then click on Size under Video. Set the Dimensions to 1280 x 720 HD. T...
Modern Warfare 2 Look Ma Two Hands Trophy Guide Video. The Akimbo weapons in two hands and the trophy associates the guide during rushing in bomb squad and the gun has 10 rounds after that press and hold a control key for a new automatic weapon. The Akimbo hand guns really prevent and protect to move forward and the options will automatically ask for the good pistols and weapons. Machine guns and sound are added to the special effects for this trophy warfare game. Finally this game must provi...
lyndapodcast teaches you how to apply conditional formatting withing Microsoft Access 2010. You click View - Design View. Click the Total tab and you'll notice some highlighted options above. Click Format and then Conditional Formatting. This where you will create rules. Click the new rule button. Now you will see the conditions with drop-down menus. Type in the numbers you want and then select the formatting you want when the rule is true. The preview below will show you how the numbers will...
In this video Darci Larocque of Swirl Solutions is demonstrating how to quickly switch between callers on your Blackberry. Often if you are talking to a person and someone else calls, you need not hang up the call. You can simply use the Flash feature to switch between the two calls without hanging any of them. While you are on a call , you can just click on menu and you will get a flash option. This will flip you between two callers. This is a great tip for Blackberry users.
This video tutorial by photoshopuniverse shows you how to create a postage stamp in Photoshop. First take a suitable image and decide the shape of the stamp. Corp the image to suit the shape of the stamp by selecting the area and choosing corp and increase the canvas size as shown in order to create the perforated cutout. Transform the image into a regular layer and once again increase the canvas size to create a back ground with an appropriate color as shown. Add a layer mask, chose the brus...
On GetConnectedTV, Darci Larocque, Blackberry Expert, explains how to change fonts on your Blackberry. Have you ever wanted to change your Blackberry font and perhaps make it bigger? From the home screen, scroll to the wrench and hit options. Then, scroll down to the screen and the keyboard. Where it says, "font family" and "font size" you can change it. Hit the space bar and the phrase "the quick brown fox" changes. Press escape and save and you'll see that your font is different.
The author shows how to identify the IP address of a email. He shows how to check the 'Show Original' options in Gmail and in that content how to identify where the email came from and exactly its IP address. Now we can take that IP address and go to any of the many IP lookup websites and trace the original geographical location of that IP address. By following the steps in this tutorial you can easily trace out the origination IP address of an email from which you can extract a lot of useful...
Photoshopuniverse shows how to remove JPEG Artifacts in photoshop. It's simple. Sometimes it happens that, you get the best picture which is related with your work, but unfortunately its low quality or small. If you zoom in a small picture it will pixilated. You will see some blocks. Luckily there is a way to remove it from photoshop. Go to- filter, then noise, then reduce noise. There will be an options of removing JPEG artifact. Check that. After watching the video you can remove JPEG artif...
this cocktail is called Lady Joy. Its a cocktail for new years eve parties. it is a blue colored cocktail which consists of lemon rum, blue curacao and champagne. First take a champagne glass and fill it up with 3 oz. of lemon rum. Then add another 3 oz. of blue curacao which will give the drink a blue color and an orange flavor. Finally add champagne as to fill up the glass and top it up with some lemon zest. Its a more fancy option of serving drinks at your party.
This informative video tells you how to use the variations panel in Adobe Photoshop to correct color issues in your photo. Too much yellow in your picture? Learn how to use the variations setting to instantly fix this with the corresponding opposite color. With simple clicks and easy preview-able pictures, you can correct color over-exposures with a click of the mouse. First go to the Images drop down and select the variations option. The original photo on the top can be clicked to revert you...
In this Photoshop tutorial the instructor shows how to change the dark hair color to blond. To get this accomplished you need to use a couple of very special techniques. First use the selective adjustment layer and select the outline of the hair. Now use the selective color option and change cyan and magenta settings to about minus forty. Now changing the other yellow color to achieve saturation and black colors to achieve the effect with shadows. Now next change the colors of black so that t...
In this Do-it-Yourself video, presented by Lowe's, you will learn step-by-step how to Cook Fruits and Vegetables on your Grill. Cooking utensils needed: Tongs, a Spatula, Skewers, and a Basting Brush. It also gives the option for printing the instructions at Lowes.com/Videos. It explains how to cut the vegetables and sear them until they are tender, giving them a smoky flavor. It then explains how to cut and grill the fruit so that the fruits natural sugars are caramelized, giving them a swee...
Adjusting the color of specific objects within your images in Photoshop is crucial. Sometimes fine tuning the color of just one component in an image is required. While an image may be adjusted globally at once, this approach lacks flexibility. This tutorial will show you the proper steps from the creation of an adjustment layer to the appropriate and functional calibration of the hue and saturation options. Get the most out of these tools and maximize your productivity in Photoshop.
In the GetConnected TV show BlackBerry expert Darci Larocque from Swirl Solutions gives an easy tip on how to call voicemail directly with one (1) key. This option can be seen in other cell phones also, but in a BlackBerry you can set a password for this. Hold the green button or call log , go to menu - Voice Mail, set your password, click escape and save. Now when you dial No.1 or hold it down you go directly to your voicemail.
This video will show you how to make a birch holiday wreath step by step. The best part is that there are two options for this project. One for inside and another for outside. The projects focus on using items that you can find your backyard making finding supplies easy and accessible. By following these easy and simple tips you can create a wonderful wreath display for your home during the holidays. All these tips are shown by Terrain staff.
