Since when did everyone think that smokey eyes HAVE to be brown/black/silvery? While we love the way a murky brown smokey eye looks, there are so many more options out there if you want to do a smokey eye look but are bored of the usual colors.
In this tutorial, we learn how to create summary tasks in MS Project 2007. First, put a task into your project and use the fill option to create more tasks. Fill in the duration and start time of your tasks as well. Now, write the subject at the top and then highlight the tasks that have to do with them, and click an arrow to indent all of these tasks. You can have up to nine levels of indenting and tasks, but this can make your project look far too complicated. When finished, save your proje...
Battery life on all cell phones is a problem. There isn't a cell phone on the market today that can satisfy everyone's power needs, but there are a few tips and tricks to making sure you have total control of your battery's lifespan on Droid smartphones.
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 662nd installment in their series of digital spreadsheet magic tricks, you'll learn how to add or average while ignoring values in hidden rows. In addition you can ignore both Hidden Rows and Error Value.
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 to make a calculation on a column of values that contain subtotals that you do not want to include in the calculations. The AGGREGATE function will ignore nested SUBTOTAL and AGGREGATE functions when making calculations.
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...
This video tutorial belongs to the software category which is going to show you how to convert a Word document to a password protected PDF file with NovaPDF. Go to NovaPDF and download the program and install it. It is a paid program. Select the word document that you want to convert and select print option. Under the name of the printer you will find novaPDF option. Select this and click 'preferences'. Now click on 'security' and select high level encryption. In the document permissions, sel...
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...
An easy way to view your CSS code of your website is through the Firefox plugin called Firebug. It's really helpful, especially if debugging your code. Just remember, you cannot save anything with Firebug, it's only for viewing code and adding codes for previewing webpages.
Talk about taking one for the team. If you're an eco-friendly earth muffin who refuses to use anything chemical-ridden on yourself and the environment around you, then there exists a gnarly - though effective - approach to killing a tent worm infestation that you may want to try out if you're not squirmy.
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...
This video discusses the basic steps necessary to start an online business. The first thing you need is a name for your business. Keep it simple, easy to spell and remember. Once you have your name, register it with the government. Next, find a good hosting company for your website. He recommends Godaddy.com. Also a good web designer is a necessity. They will meet with you to discuss your ideas, and your website should be ready in about a week.
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 from Act2Scene5 we learn how to convert movie files to DVD player playable video using ConvertXtoDVD. All you have to do is take a movie file and drag it into the interface. The program will import it into the program. Once it's in the application, you have several options you can do. You can change the name of the DVD so you can name it. You can also set the DVD to auto start. You can use loop playback where the video will restart after watching it through. Another option is to...
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...
This video from scrapwow shows how to unzip a file in Microsoft Windows XP.Firstly, open Windows Explorer application and navigate the file you want to unzip. Once you've located the file, double click on it. A new window will open. Here you will have Extract all files option which you can choose from menu to the left.Clicking the button allows you to extract a single file or a zipped folder, containing a number of files. In this case Extraction Wizard will open, leading you through the extra...
ruffdeezy shows how to create ringtones for the iPhone from regular MP3 files. ruffdeezy begins by importing the desired file into the iTunes library. Accuracy of the file's info can be confirmed by selecting "get info" on the song title. Under the "get info" page, go to the "options" tab. Under this tab is a "start time" and a "stop time" option. Choose the desired start and end time of the ringtone. Do not make it longer than 30 seconds. Next, right-click the song and select "convert to AAC...
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.
Pilates is fantastic exercise. If you are a beginner, though, it can be confusing to choose the right type of class. Check out this tutorial before you head to the studio and ensure you get the most out of your exercise routine.
