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 670th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function to create a formula for extracting records with one criterion. This is a lookup problem where you want to return multiple records from one lookup value. This formula is not an array formula because it...
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 671st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function to create a formula for extracting records with two criteria. This is a lookup problem where you want to return multiple records from two lookup values. This formula is not an array formula because it...
Could you use some help figuring out how to solve equations involving fractions in basic algebra? See how it's done with this free video math lesson. Need help finding the 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 ...
Before you can work in Word 2010, you'll need to learn how to work with it. See how to join, split and apply formatting to cells within Microsoft Word 2010 with this free video software tutorial. Whether you're new to Microsoft's popular word processor or just wish to get to know Word 2010 a little better, you're sure to find much of value in this video lesson. For more and better information, and to get started working with cells in MS Word 2010 yourself, take a look.
Before you can work in Word 2010, you'll need to learn how to work with it. See how to adjust line spacing parameters within Microsoft Word 2010 with this free video software tutorial. Whether you're new to Microsoft's popular word processor or just wish to get to know Word 2010 a little better, you're sure to find much of value in this video lesson. For more and better information, and to get started changing line spacing settings in the Word 2010 UI yourself, take a look.
Before you can work in Word 2010, you'll need to learn how to work with it. See how to change and style fonts within the Microsoft Word 2010 user interface with this free video software tutorial. Whether you're new to Microsoft's popular word processor or just wish to get to know Word 2010 a little better, you're sure to find much of value in this video lesson. For more and better information, and to get started using custom font settings in Word 2010 yourself, take a look.
Before you can work in Word 2010, you'll need to learn how to work with it. See how to undo and redo actions the Microsoft Word 2010 user interface with this free video software tutorial. Whether you're new to Microsoft's popular word processor or just wish to get to know Word 2010 a little better, you're sure to find much of value in this video lesson. For more and better information, and to get started undoing and redoing actions with ease in Word 2010 UI, take a look.
Before you can work in Word 2010, you'll need to learn how to work with it. See how to generate a new document from a template in Microsoft Word 2010 with this free video software tutorial. Whether you're new to Microsoft's popular word processor or just wish to get to know Word 2010 a little better, you're sure to find much of value in this video lesson. For more and better information, and to get started using tempaltes in MS Word 2010 yourself, take a look.
Before you can work in Word 2010, you'll need to learn how to work with it. See how to use the Microsoft Word 2010 Ribbon interface with this free video software tutorial. Whether you're new to Microsoft's popular word processor or just wish to get to know Word 2010 a little better, you're sure to find much of value in this video lesson. For more and better information, and to get started navigating the Word 2010 Ribbon UI yourself, take a look.
Before you can work in Word 2010, you'll need to learn how to work with it. See how to use the Microsoft Word 2010 user interface with this free video software tutorial. Whether you're new to Microsoft's popular word processor or just wish to get to know Word 2010 a little better, you're sure to find much of value in this video lesson. For more and better information, and to get started using the Word 2010 UI yourself, take a look.
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 621st installment in their series of digital spreadsheet magic tricks, you'll learn how to write a logical formula using the AND and COUNTIFS functions with mixed cell references in the conditional formatting dialog box to highlight entire row (whole record) in data set (table) when record is unique and matches the s...
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 622nd installment in their series of digital spreadsheet magic tricks, you'll learn how to to write an array formula using the SUMPRODUCT, MOD, IF, ROWS, INDEX, SMALL, and ROW functions that will retreive only even row values.
Refining selections and creating masks are unglamorous but utterly essential Photoshop techniques—you've got to master both in order to perform tricky compositing tasks, such as extracting a person from an image and then adding a different background.
This video tutorial demonstrates Photoshop CS5's bristle brushes, which simulate traditional paint brushes—the kind your local art-supply store sells—and its new Mixer brush, which lets you give a photo a painterly look. Along the way, its host passes along a tip for customizing Photoshop's interface—one of those little chores that can save so much time but that so few of us do. Whether you're new to Adobe's popular image editing software or a seasoned graphic design professional just looking...
Have a digital image that's a little bit too dark or otherwise lacking in depth? Your fix is just a few mouse clicks away. This free software tutorial will teach you how to use the new Brightness & Contrast tools within Adobe Photoshop CS5. Whether you're new to Adobe's popular image editing software or a seasoned graphic design professional just looking to better acquaint yourself with the unique features of Photoshop CS5, you're sure to find something of value in this free video tutorial.
With Adobe Photoshop CS5, it's easier than ever to work with HDR or high dynamic-range images. This video tutorial presents an overview of some of the bigger enhancements. Whether you're new to Adobe's popular image editing software or a seasoned graphic design professional just looking to better acquaint yourself with the unique features of Photoshop CS5, you're sure to find something of value in this free video tutorial. For more information, and to get started taking advantage of Photoshop...
This is a fun trick to perform on your friends, anywhere. First, explain to your buddies that your deck of cards is special and acts just like an ATM. They'll naturally be confused and ask you to prove it. That is when you take a low number card from your deck, swipe it, and turn it into a card worth twice as much!
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 602nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a compact array formula that can total sales with 1 criteria when the database does not have a price or total sales column. See how SUMIF can be used to lookup values and simulate a missing column from a database.
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 36th installment in his "Excel Statistics" series of free video lessons, you'll learn how to calculate a trimmed mean, which is used when there are extreme values in the data set that might skew the mean.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 56th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use an array formula and the COUNTIF function to count unique records that are greater than a given hurdle (in this case, $30). Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
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 390th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a column of words and numbers quickly with two different formulas as well a a mouse trick that will allow you to paste special values.
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 582nd installment in their series of digital spreadsheet magic tricks, you'll learn how to understand and fix the nine most common formula errors in Microsoft Excel. Specifically, you'll learn how to interpret and resolve #######, #NAME?, #N/A, #REF!, #VALUE!, #NUM!, #DIV/0!, Circular Cell Reference, and #NULL! errors.
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 156th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that will check two tables and find the values that do not match and then create a new list.
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 274th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate various probabilities for a binomial distribution when there are additional complicating factors. This is accomplished with recourse to Excel's BINOMDIST, NORMSDIST, SUMIF, SUM, INDEX and MATCH functions. See also how to create th...
Learn how to use a 'do while loop' in your Java programming. 1. Set up an 'int' variable named 'counter' and assign it a '0' value. 2. Set up a standard 'do' loop. Make sure to add a counter, so the loop will end 3. Then write the 'while' condition. Make sure that you set the condition to the same variable name that you used in the counter from step 2. Set the variable to '=' 10 (or any number desired)
Photoshopuniverse teaches you how to enhance the colors of photos using Adobe Photoshop. You get a photo and duplicate that layer. Set the blending mode to Soft Light. You repeat that step, only the blend mode should be Lighten. The shadows are now darker. You can change the blend mode opacities to 60%-70%, but both layers should have about the same opacity. Also make sure that the white values are not to white and that details, like faces, are still OK to see.
This video demonstrates the split tone effect in Photoshop. A split tone effect makes a picture look more rustic by changing the tones. First, add an adjustment layer to the picture by opening the channel mixer window. Select Monochrome and adjust the RGB values to create a black and white image to your own personal preference. Next, add another layer by opening the color balance window. Here you can change the colors of the light areas by selecting Highlights and changing the color sliders, ...
The video is basically about how to modify the focal point of the image. When the image has some stuff on the background and when you want the viewers to focus more on one particular area and making the rest of the image darker, you need to modify the light values of the image, which will be taught in this video. This can be done by just selecting the area, which you need to highlight on the image by giving some border and then add curves. In the curves the area is made darker than the rest b...
The PhotoshopUniverse team effectively teaches a method of adding a watermark to an image, as a security feature to make it harder to copy or steal. Instructions are simple and easy to follow, using as an example a photo of two girls that one might have in his or her family album. Using Photoshop, the text that will become the watermark is added, rotated and patterned across the entire image. To finalize the watermark, the opacity is edited to a desired value so that it does not interfere wit...
Learn how to make the hottest trend on appetizer menus across the country: sliders! Ours are vegetarian made with garbanzo beans and spiked with smoked peppercorns and toppped with thick and creamy cucumber and Greek yogurt tzatziki. Follow along with this cooking how-to video and let Whole Food's Market show you how to make these veggie burgers.
In this video tutorial, Chris Pels will show how to create a web service in ASP.NET and then call the service from another ASP.NET web site. First, learn how to create an .asmx component which represents a web service in an ASP.NET web site. When creating the web service learn how to control several aspects of the web service functionality with web service attributes. Next, see how to test the web service in the Visual Studio web service test page. Then learn how ASP.NET allows many .NET data...
It's no secret that the Canon EOS 5D Mark II is being used in low-budget indie films, as well as big blockbuster movies from Hollywood. But it's also become a staple for television commercials.
Oh, boy. A stopped-up drain. It'll inevitably happen with any home plumbing system and your kitchen sink is no exception. That clog won't go away on its own and will require immediate attention to keep any standing water from rising. But you don't have to resort to calling an expensive plumber or using a bottle of hazardous chemicals. Using simple kitchen staples or common household objects, as well as some determination, you can unclog your kitchen sink on your own without paying a dime.
Hack the hex code in Bejeweled Blitz for a higher score! Everyone wants the top score in this popular web game, but it all comes down to how you get it. Do you have what it takes to come out on top? Check out this video tutorial to learn how to hack Bejeweled Blitz (07/24/10).
This masterful drawing session from idrawgirls instructs us how to draw a mysterious girl specifically the facial figure, face, hand and upper body front view. First you will establish, very lightly, the facial shape, direction of the eyes, and the shoulders and upper body. The key here lies in the direction of the eyes, casting the face slightly downwards, creating that ineffaceable mysterious effect. Another important factor specific to the female face is keeping the nose close to the eyes ...
This After Effects CS4 tutorial covers animating essentials. Learn how to animate properties in After Effects CS4 including how to use the stopwatch, move the current-time indicator, and set values. You will also learn how to create, edit, and delete keyframes in this After Effects CS4 animation tutorial. Animate in After Effects CS4.
It’s the cold and flu season – and anyone who has been sidelined by fever, achy joints, swollen nasal passages and sore throats knows first hand the value of prevention. Beat a cold.
There is no shortage of defenses against cross-site scripting (XSS) since it is so prevalent on the web today. Filters are one of the most common implementations used to prevent this type of attack, usually configured as a blacklist of known bad expressions or based on regex evaluation. But there is hope with a wide variety of techniques that can be used to defeat these filters.
Haptic feedback and vibration of our smartphones have come a long way in recent years. These features are much more premium now than they once were, but most users are still unable to adjust the intensity for notifications or phone calls. Most higher-end devices make less noise on surfaces than in the past, but adjusting these values can still come in handy even today.
In the lead up to the Magic Leap One launch, Magic Leap has been coy about what the actual field of view (FoV) is for its first commercial product.
