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...
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).
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 234th installment in their series of digital spreadsheet magic tricks, you'll learn how to convert between degrees and radians in Excel with trigonometric functions and formulas. Rad!
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 315th installment in their series of digital spreadsheet magic tricks, you'll learn how (and when) to use the SUMIF & SUMPRODUCT functions.
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.
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 506th installment in their series of digital spreadsheet magic tricks, you'll learn how to summarize data from multiple sheets. For example, you'll see how take checkbook register data from multiple banks accounts and summarize it based on account names.
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 533rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula to calculate the difference between start date/time & end date/time excluding holidays and weekends. This is accomplished with recourse to Excel's NETWORKINGDAYS and MOD functions.
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 534th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the OR and WEEKDAY functions to create a logical true/false formula that will automatically apply formatting to dates that are either weekends or holidays.
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 538th installment in their series of digital spreadsheet magic tricks, you'll learn how to create dynamic sub tables based on master sheet array as well as how to create array formulae quickly with the Drill-Through method. All this is accomplished with recourse to the COUNTIF, IF, ROWS, INDEX, SMALL, ROW functions.
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 477th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a Gantt cell chart using conditional formatting. This is accomplished with recourse to the WORKDAY.INTL, AND, NOT & NETWORKDAYS.INT functions.
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 tutorial from ExcelIsFun, the 474th installment in their series of digital spreadsheet magic tricks, you'll learn how to conditionally highlight every last value in a data set or each value which differs from the value preceding it.
Make sure you have the appropriate lens for your digital camera. Look for markers on the lens that correspond with any mark on the camera body. Different brands have different markers. Some have square dots while some have red dots. Line these marks In one hand, hold your camera body firmly pointing to you. While holding it, push the lens button. Firmly hold the bottom of the lens (where the lens meets the camera body), and twist. Some cameras let you twist clockwise, others counterclockwise....
In this episode of Digital Photography 1-on-1, host Mark Wallace goes in depth on the subject of light metering and flash balancing. Making use of a Sekonic light meter, Mark shows how to read the light levels in a room, and explains how to interpret those readings in order to adjust flash levels, ISO levels, and alternative light source manipulation. Mark also goes over the important roles that aperture settings and film speeds play when attempting to successfully balance flash and ambient l...
Dr. Bob Sears explains to parents the difference between a child's fever that may be serious and one that isn't. Only when the child's fever is high and any efforts to bring it down have failed, should you seek medical attention. This means the child could have a serious infection. A temperature of 103 or more is considered high, 101-102 is medium, and 99-100 is typical. Dr. Sears recommends using a regular digital underarm thermometer to check the child's temperature. Hold the thermometer un...
Fractions are vital to mathematics and essential in everyday life. As such, it's good to know how to multiply and divide them. This video demonstrates the process. For detailed, step-by-step look at multiplying and dividing fractions, watch this mathematics how-to.
Learn how to use depth of field with help from this photography tutorial. Although it may seem that depth of field is a confusing factor in photography, it's actually quite easy to understand & adjust once you've gotten the hang of it. Depth of field (or, DOF) is a great way to experiment with your photography & improve your skills as a beginner photographer. When taking your photograph using DOF, it is imperative to remember that the shutter speed and aperture (or F-stop) need to change at e...
Have a passion for photography but know nothing about the basics? This video might be a great place to start on the topic of shutter speed. Shutter speed is the amount of time that the film, or your digital sensor, is exposed to the light. Whether it be outdoors, at night, or low indoor light, the shutter speed allows your camera to take a photograph with the correct amount of exposure in reference to how much light is readily available in your setting.
This how-to video is about how to enable the commenting tools in the free Adobe Reader using Acrobat 9 Pro and Acrobat 9 Pro Extended.
In this culinary video tutorial from Guy Fieri's Big Bite, you'll learn how to prepare smoky grilled, tender lamb chops, simply seasoned and served with a fragrant, spicy Morroccan charmoula sauce, a delicious herb and onion mixture that will take your grilled meat to the next level.
This is video is a tutorial on how to save more money in your daily life. The video says that budget professional suggest that we need to set a goal. Decide why you're saving your money. Save your money to where if there were an emergency you could comfortably use your savings. The video suggests taking advantage of your employer's retirement fund. Last but certainly not least, we are told that saving sooner is better than saving later.
Back with another great how to tutorial for your home, Ron Hazelton, from Ron Hazelton's House Calls, and ronhazelton.com is here to bring us another great tip to save us time and money on our household projects. In this video Ron shows us a great way to waterproof the inside of your outdoor planters, which will protect them from water, provide a longer life-span, and help your plants to be healthier, in a quick and easy to understand manner.
A great special effect for any film or movie is the space warp effect, like this bleach bypass effect. It's a little tricky to make, but once you know, fairly simple. Learn how to create a bleach bypass effect in Sony Vegas.
What every indie filmmaker needs is a little program called After Effects. After effects does wonders for any film requiring a little special effects that would normally be too expensive to make "real". Like this glowing eye effect. See how to make an eye glowing effect in Adobe After Effects.
Sadly, you can't really slow down time and dodge bullets like Neo. But the wall flip is one "Matrix"-style parkour trick you can do in real life. All it takes is a lot of practice... And the willingness to risk slipping up and landing in the hospital with a busted skull.
If you were lost in the forest, how would you shelter yourself from the elements? In this video, Reggie Bennett from the Mountain Shepherd Survival School teaches us how to build an A-frame structure in the woods, even if you don't have standing trees or cord available. You never know, this info might just save your life someday!
Windows 7 is the hot, new operating system replacing the past XP and Vista systems. Windows 7 is the most simplified, user-friendly version that Microsoft has developed - ever. Get acquainted with your new version of Windows straight from Microsoft.
It's a Chinese tradition to eat long noodles on New Years Day, ensuring a long, healthy life. Try these cold sesame noodles.
Check out this video from Sessions on using the color wheel. Better understand color relationships, color schemes and color theory. This is a great lesson for designers, artists, stylists and decorators. Create color harmony using the color wheel. Tutorial video from Sessions Online Schools of Art & Design's "Color Theory" course. Part of Sessions' Graphic, Web, Digital Arts, Marketing, and Multimedia Arts Design certificate programs.
Feeling calmer and happier is at the tip of your nose: It’s just a matter of using your common scents. Check out this Howcast video tutorial on how to use Aromatherapy's Essential Oils to improve your life.
Whether you want to juggle two wives or keep you alter ego separate from your day job, here are the precautions you must take. Learn how to lead a double life.
This is a video walkthrough of the "Prologue: Financial District" level in Mirror's Edge for the Xbox 360.
This is a video walkthrough for Chapter 1: Flight (PT. 1/2) in Mirror's Edge for the Xbox 360. The game has a realistic, brightly-colored style and differs from most other first-person perspective video games in allowing for a wider range of actions—such as sliding under barriers, tumbling, wall-running, and shimmying across ledges—and greater freedom of movement, in having no HUD, and in allowing the legs, arms, and torso of the character to be visible on-screen.
This is a video walkthrough for Chapter 2: Jackknife (PT. 1/2) in Mirror's Edge for the Xbox 360. The game has a realistic, brightly-colored style and differs from most other first-person perspective video games in allowing for a wider range of actions—such as sliding under barriers, tumbling, wall-running, and shimmying across ledges—and greater freedom of movement, in having no HUD, and in allowing the legs, arms, and torso of the character to be visible on-screen.
This is a video walkthrough for Chapter 2: Jacknife (PT. 2/2) in Mirror's Edge for the Xbox 360. The game has a realistic, brightly-colored style and differs from most other first-person perspective video games in allowing for a wider range of actions—such as sliding under barriers, tumbling, wall-running, and shimmying across ledges—and greater freedom of movement, in having no HUD, and in allowing the legs, arms, and torso of the character to be visible on-screen.
Got a case of the Mondays? Why not blow off the cubicle life and try dropping out of society? Try living in nature, giving up worldly possessions, squatting, and rambling. Watch this video motivation tutorial and learn how to drop off the grid.
If you're an electrical engineer, you needn't worry about this educational video, but if you aren't...
In this Adobe Photoshop tutorial Bert creates reflections from scratch with the help of the distortion filter. Learn how to make realistic reflections for your Photoshop artwork where you have glass in front of objects and other real life situations.
This Adobe Photoshop tutorial teaches you how to change the color in different images with a variety of colorization methods. Bert shows us how to change colors on shirts, on cars and in our lives, through colorization in Photoshop.
This Houdini n9 software tutorial covers a very simple lighting and rendering scene to show the basic workflow for generating a PBR render. We use a digital asset to quickly establish a group of geometry to light. In the lesson we also add an area map so that we can extract the lighting information from it. There are two .rat files to experiment with, the seashadow.rat file simply provides a pattern. The st.peters_cross.rat is an HDRI image from the Debevec site. Watch and learn how to set up...
