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...
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.
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.
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.
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.
Most people don't use their cameras to make movies (really bad quality and a sort of user-generated content feel are probably the culprits) but cameras with a record function are great for those impromptu memory-making moments when your dog tries to do a handstand or your grandma unloads the biggest belch ever.
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.
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...
Is your SD memory card getting a little too full? Is it not working? Try reformatting it. It's the first and sometimes last step to troubleshooting card problems. So, if your SD card has become too cluttered, this guide will restore it to a like-new condition with a simple format.
Come see how to master your own music tracks with software by Studio One! Just follow the step by step instructional video. Mastering is done from the project page, which is not available in Studio One Artist. If you want mastering features, please upgrade to Studio One Professional. How to Master a song using Studio One: Adjust song start and end markers: Click on Open Marker Track button. Click and drag start and end markers to the beginning and end of the song. Master a song in a new proje...
Today, on his Tumblr, Notch shared two very odd—and, to all appearances, completely unrelated—fan-produced Minecraft ads.
Type: Digital photography and 2D art Theme: Embracing Our Differences®
Showcased at Mediamatic, the "Untitled Sock Project" is a knitting machine hack by Luís Brandaõ, Fábio Costa, Sean Follmer, and Pol Pla:
Take a picture any time you want, as long as you've got that Blackberry Curve handy. The camera in the mobile phone is equipped with 2.0 megapixels, digital zoom, built-in flash, and a self-portrait mirror. Watch this video cell phone tutorial and learn how to capture photgraphs on a Blackberry Curve. Take a picture on a Blackberry Curve cell phone.
Ever wondered how a digital combination lock works? Instructables member Nino123 is kind enough to demonstrate the inner workings, with a step-by-step HowTo on building your own.
See how to use mesh preparation and sculpting in Mudbox in this video tutorial. Designed by professional artists in the film, games, and design industries, Autodesk Mudbox digital sculpting and texture painting software gives 3D modelers and texture artists the freedom to create without worrying about the technical details. Just check out this video to see about mesh preparation and sculpting. Use mesh preparation and sculpting in Mudbox.
See how to use displacement maps and rendering in Mudbox in this video tutorial. Designed by professional artists in the film, games, and design industries, Autodesk Mudbox digital sculpting and texture painting software gives 3D modelers and texture artists the freedom to create without worrying about the technical details. Just check out this video to see about rendering and displacement maps. Use displacement maps and rendering in Mudbox.
Adobe Photoshop CS4 is the industry-standard software for perfecting digital images and is ideal for professional photographers, serious amateur photographers, and graphic designers. In this Photoshop CS4 tutorial, you'll learn how to make local adjustments using Adobe Camera RAW. For comprehensive instructions on using the Adobe Camera RAW tool, take a look. Make local adjustments in Photoshop with Camera RAW.
Adobe Photoshop CS4 is the industry-standard software for perfecting digital images and is ideal for professional photographers, serious amateur photographers, and graphic designers. In this Photoshop tutorial, you'll learn how to use Kuler themes in your Adobe Photoshop CS4 projects. Use Kuler color themes in Adobe Photoshop CS4.
Get an overview of the award-winning Genuine Fractals 5 plug-in for Photoshop in this software tutorial. The Genuine Fractal 5 plugin allows you to enlarge digital images over 1000% without loosing quality. A must for anyone printing photos or other digital footage. If you are new to the Genuine Fractals 5 Photoshop plug-in, this tutorial is a great place to start. Get started with Genuine Fractals 5 Photoshop plugin.
Traditional artists re-create reality using paints, colored pencils, and air-brushing. Digital imaging technology has given a new generation of artists an entirely new way to create photo realistic illustrations in Photoshop. Create photo realistic illustrations in Photoshop.
This is a tutorial on how to paint a desert digital paintjob on and airsoft gun. Paint an airsoft or paintball gun.
Every song is not created equal. So, every song should not be treated equally by your digital music player. We'll tell you how to customize your Zune software's equalizer to get the most from your music. This video will show exactly how to change your Zune software's equalizer. How To Change Your Zune Software's Equalizer.
This video will show you everything you need to know about taking your cats temperature. We cover the preparation needed,restraint used, digital thermometer usage and glass thermometer. Take your cat's temperature.
You might prefer a dedicated button, whether physical or digital, to bring up your digital assistant. Pixel phones have the squeeze function to bring up the assistant, but what about OnePlus phones? Luckily, OnePlus has included a feature that uses your power button to act as your assistant button of sorts.
