Adobe Photoshop is an amazing digital photo editing tool that let's you do a myriad of tasks. In this tutorial you will learn how to change the color of fabric, like a dress, from the existing color to whatever you wish it to be. You'll be using the magic lasso and playing with the color balance sliders to make it happen. The video is quick, but should be all you need to get your job done. So go for it and make that red green now!
While most of us have mailboxes from which we receive our deliveries, some of us still have small slits in our front doors known as letter box holes. This allows for the mailman to deliver mail straight into our homes, which is convenient for all intensive purposes.
Whether you are pursuing drawing as a professional or as a hobby or you are just a common person, we're pretty sure that you have drawn a tree somewhere in your lifetime. This video merely shows how to do the same in a better way. Though there is no narration (just background music) in this video, it is easy to understand the additive method of drawing. The artist starts off with a broad tree trunk and then starts adding thinner branches to the trunk that spread outwards. Then, even more thin...
Bacon is the cornerstone of many comfort food combinations: Baked potatoes topped with bacon bits, bacon served alongside a biscuit and eggs for breakfast, bacon burgers.
To become a bounty hunter, you will want to first check your state's laws to see if you need to be a licensed private investigator. If you live in Florida, South Carolina, Oregon, Wisconsin, or Kentucky, don't even try it--bounty hunting is not allowed! Otherwise, your first step is to find a client who needs a target to be caught. Bail bond agents employ bounty hunters to track down people who have refused to show up to court. Find out who your target is. Assemble a file, look into any recor...
First download the virtual box, download it for Mac and install it. Now download the Chrome OS and extract it. Now launch your virtual box and click new. A "create new virtual machine" wizard will open, click next, put the name of the OS and choose Linux in operating system and Ubuntu in version now click next. Now give memory atleast 1000 MB and click next. Select "use existing hard disk" and tick the "boot hard disk" and choose the OS file by clicking the folder icon next to it, click add a...
Looking for a quick guide on how to create "stickies" on your WordPress blog? Look no further. Every version of WordPress brings with it new features, new functions and new ways of doing things. Fortunately, the very same technology that allows an open-source blog publishing application like WordPress to exist in the first place also makes it easy for its users to share information about the abovesaid things through videos like this one. Take a look.
In this video, we learn how to install tile in your home using SimpleMat. SimpleMat is a double sided adhesive mat that is designed to set tile on an existing counter top. Adding tile is a very easy way to add value to your home or give it a quick face lift. To apply, first remove the back of the adhesive, then apply it to the surface. Next, you will remove the protective tile and you can start to lay down your tile to the adhesive. Press it down where you want them and adjust them if needed....
'Zipping' is a method of compressing data, such as a music album, into a zipped folder which makes it easier to send. This tutorial shows you not only how to unzip a folder, but how to then load it with iTunes and send it to your iPod or other MP3 player.
There exists a small set of makeup skills that is essential for your fashionable survival in the lipstick jungle: How to do the perfect red lip, how to shape and drawn in your brows, and how to do the perfect smokey eye. With these skills you'll be able to create a makeup look to suit any occasion, and we guarantee it.
Crepes, like guys who go jogging without their shirts on, only exist to make us happy. They're there for us when our sweet tooth urges overpower our diet and when our PMS cravings send us autopiloting toward the nearest bakery and patisserie. And we never thought that crepes, in all their godlike perfection, could ever be improved upon until now.
Faced with an "Unable to create directory" error when attempting to upload an image to WordPress? This clip offers instructions on how to fix it. Every version of WordPress brings with it new features, new functions and new ways of doing things. Fortunately, the very same technology that allows an open-source blog publishing application like WordPress to exist in the first place also makes it easy for its users to share information about its features through videos like this one. Take a look.
Whether they exist or not, people believe in the spiritual power of angels. That's why, if you walk into any Spencer's Gifts or novelty store, you'll always manage to find tiny wallet-sized "guardian angels." You apparently slip these in your wallet to feel guided and protected.
In order to clear the cell content in Excel, using a macro, you will first need to have a table. If you don't already have a spreadsheet, you will need to create one with random numbers. Next, highlight some numbers, by clicking one box and dragging in order to select a number of boxes. Click Alt + F11.
In this clip, learn how to create a camera controller using nulls and user data. This makes animating a camera in a scene much easier. Whether you're new to MAXON's popular 3D modeling application or are just looking to get better acquainted with Cinema 4D and its various features and functions, you're sure to enjoy this free video software tutorial. For more information, and to get started using this trick in your own Cinema 4D projects, watch this 3D modeler's guide.
In this video tutorial, viewers learn how to print the gridlines with a Microsoft Excel spreadsheet. This task is very fast, easy and simple to do. By default, Microsoft Excel will not print a spreadsheet with the gridlines. Begin by clicking on the Page Layout tab. In the Sheet Options box, under gridlines, check Print. To remove the gridlines, do the reverse of this operation. To view the page with gridlines, click on the Office button, go to Print and select Print Preview. This video will ...
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 636th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic frequency table and histogram chart using defined name formulas for dynamic ranges that use the INDEX function. See other formulas that use the COUNTIF, IF and ROWS functions that help to make it fully dynamic....
WordPress 3.0 adds powerful CMS capabilities with a new menu system. This clip walks though this feature and shows what it can do for you. Every version of WordPress brings with it new features, new functions and new ways of doing things. Fortunately, the very same technology that allows an open-source blog publishing application like WordPress to exist in the first place also makes it easy for its users to share information about the abovesaid things through videos like this one. Take a look.
Having trouble with crating a custom page navigation? Your troubles are about to be solved with the menu feature in WordPress 3.0. Learn how to use WordPress 3.0's built-in menu management system with this free video tutorial. Every version of WordPress brings with it new features, new functions and new ways of doing things. Fortunately, the very same technology that allows an open-source blog publishing application like WordPress to exist in the first place also makes it easy for its users t...
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 626th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a Gantt Chart to show the amount of time a project takes during a day.
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the nth installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create and use simple charts in MS Excel as well as see how to use Excel's SUMIFS & AVERAGEIFS functions. Specifically, this video covers the following topics:
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 270000000000000000000000000000000th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use custom number formatting for cells and the TEXT function. Specifically, this lesson covers the following:
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 5th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create seven types of charts — X-Y scatter diagrams, pie charts, column charts, bar charts, stacked bar charts, line charts, and column and line chart combined. ...
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 47th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use the NORMSINV function for critical values and the NORSDIST function for p-values. Compare building confidence int...
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 82nd installment in his "Excel Statistics" series of free video lessons, you'll learn how to construct confidence intervals when the sigma value (the population's standard deviation) in NOT Known using the TINV...
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 very first installment in his "Excel Statistics" series of free video lessons, you'll learn how to get started doing statistical analysis in Microsoft Excel 2007.
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 90th installment in their series of digital spreadsheet magic tricks, you'll learn how to write a formula that will return multiple items when there are two criteria for the data extraction. Also see an INDEX and MATCH functions formula that uses the SUMPRODUCT, COUNTIFS, IF, ROWS, INDEX, MATCH, SMALL, IF, and ROW fu...
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 95th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the OR, AND, NOT, & COUNTIF functions and Excel's advanced filter tool to extract records from a table of data. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
In this how to video, you will learn how to dual boot Windows 7. To do this, first back up your hard drive. Download the Microsoft Windows 7 adviser to see if your system is able to handle the operating system. Next, download and burn the Windows 7 64 bit ISO. Shrink your existing partition to at least 16 GB. Next, insert the Windows 7 CD and reboot. You should make sure that you can boot from the optical drive. Once that is done, you can begin installation of the operating system. When it is...
"Blah, I vant to suck your blood!" One of the most common and overused vampire lines out there! But who could blame them? Vampires are pretty interesting and cool creatures that have been around for centuries. What makes them so unique and different is that instead of preying on victims during the day, they use the night to hunt and attack its prey, feeding off their fear of the dark. Well at least in movies. In real life vampires don't exist. But it doesn't mean you can't dress or look like ...
To remove the lexan paint, obtain a bottle of brake fluid. Make sure you read the Material Safety Data Sheet (MSDS) for its harmful effects, and put on a pair of gloves to avoid contact with the hands when applying the brake fluid. To remove a large area of paint, pour a little amount of brake fluid onto some paper towel, and rub the area in a circular motion until the lexan paint is completely dissolved and removed from the area. A Q-tip can also be used to remove smaller areas. Apply as muc...
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 244th installment in their series of digital spreadsheet magic tricks, you'll learn how to use advanced filtering to extract records from a database (table or list) based on 1 criterion (criteria) and place reesults on a new sheet worksheet.
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 576th installment in their series of digital spreadsheet magic tricks, you'll learn how to add a point and a dynamic label to a break-even chart that marks the breakeven point using INDEX and MATCH functions. This point is dynamic and will change if data is changed.
Teach Excel demonstrates how to make an Excel dynamic named range across multiple rows. Highlight the cells that you want to include in your named range and give it a name. You can then use that name in formulas. But it's not a dynamic named range so it won't account for added information. Ctrl + F3 is the name manager shortcut and the F3 is the paste name shortcut. Use the name manager and highlight the named range. Delete the absolute cell references and type in offset. Then, select the fir...
New to 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 Excel tutorial from ExcelIsFun, the 574th installment in their series of digital spreadsheet magic tricks, you'll learn how to streamline filtering when you have categories of criteria using an array formula that uses the functions COUNTIF, VLOOKUP, ROWS, IF, INDEX, SMALL, and ROW. Also see how to put OR criteria into the IF function as well as how to do an OR coun...
The guy first gives the definition of differential equations. He explains that a differential equation is an equation that contains the derivatives of an unknown function. He then gives some examples of differential equation and explains what the equation's order means. After that he gives an example on how to solve a simple equation. He calculates it and gives examples of graphs. Then he explains what a general solution is and how to narrow down the number of solutions using data from the pr...
New to Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. With this video tutorial from ExcelIsFun, the 329th installment in their series of digital spreadsheet video tutorials, you'll learn how to create a frequency table. Then see how to calculate the midpoint of each category and make a frequency polygon with two or more lines (two or more data sets).
If you don't want to spend an extra $130 to get 3G for your iPad, you can use the app MyWi to tether your iPhone's 3G connection to your iPad. This video shows you the easy way to tether your iPhone's 3G or EDGE Data Connection to your iPad, or any other Wi-Fi enabled device. So skip paying the extra dough and get a 3G connection for free! Be careful, as this can drain your iPad's battery!
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 488th installment in their series of digital spreadsheet magic tricks, you'll learn how to use VLOOKUP with multiple lookup values. You'll also learn how to add an extra column with a unique identifier to data set using ampersand concatenate.
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 480th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate a percentage of total from a database data set when the variable of interest is text (word). This is accomplished with recourse to the COUNTIF, SUM & COUNTA functions.
