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 181st installment in their series of digital spreadsheet magic tricks, you'll learn how to count words (case sensitive) using the SUM and EXACT functions in an array formula.
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 178th installment in their series of digital spreadsheet magic tricks, you'll learn how to alculate the best value from two categories of 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 175th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT function and an array of TRUE & FALSE to count values between an upper and lower bound.
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 149th installment in their series of digital spreadsheet magic tricks, you'll learn how to take a value in a table and then return the row or column value when there are no duplicate 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 145th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that will calculate the median when you have more than 1 criterion.
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 Excel tutorial from ExcelIsFun, the 554th installment in their series of digital spreadsheet magic tricks, you'll learn how to apply conditional formatting to weekends and holidays with Excel's NOT and NETWORKDAYS functions.
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 336th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the ROWS, COLUMNS, MOD, ROUND, and WEEKDAY functions to increment numbers in Excel formulas.
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 Excel tutorial from ExcelIsFun, the 574th installment in their series of digital spreadsheet magic tricks, you'll learn how to remove duplicate records using the Remove Duplicate feature which was new in Excel 2007.
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 334th installment in their series of digital spreadsheet magic tricks, you'll learn how to use VLOOKUP & data validation to make an invoice when the product list is on a different sheet or different workbook.
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 Excel tutorial from ExcelIsFun, the 263rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a completely dynamic math equation system (function of x) with formulas, data points, charts and chart labels.
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 and Mr. Excel, the 45th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to extract a number from a text string.
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 232nd installment in their series of digital spreadsheet magic tricks, you'll learn how to conditionally sum by array formula in Microsoft Excel.
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 185th installment in their series of digital spreadsheet magic tricks, you'll learn how to to use Advanced Filter to extract records from a table with 1 criteria, then use a Macro to automate the process.
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 483rd installment in their series of digital spreadsheet magic tricks, you'll learn how (and when) to use both the sort and filter tools in Microsoft Excel.
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 prevent Excel from displaying a 13-digit number ID in scientific notation using the number formatting tool.
Using the Digi Effects plugin "Aged Film" in After Effects, learn how to take your digital footage and turn it into a Super 8mm looking reel. Author Oliver Mellan, shows step-by-step how to create that faux grainy look to make your 21st century film look as deep & rich as any 8mm or 16mm film.
This is a tutorial video from Sessions Online Schools of Art & Design's "Photoshop Basics" course. This video is part of Sessions' Graphic, Web, Multimedia Arts, Digital Arts, and Marketing Design certificate programs. You are distorting layers using the transform tool. Use the line tool to check the work. GO Edit: Transform - Distort.
This video shows you how to remove the Digital Rights Management(DRM) protection from iTunes music. DRM is a way for Apple ITunes to control your music and where you save it. Hack the iTunes so that it does not interfere with you like this.
The best way to transfer contacts from a computer to an iPhone is to use Mobile Me, formerly known as Dot Mac, which automatically synchronizes Outlook or Entourage with the iPhone. Keep track of contact information, on both the computer and the iPhone, with tips from a digital technology specialist in this free video on the iPhone.
Do you have hundreds of assets in your Final Cut Pro project, but you are only using a percentage of them in your sequences? Want to find out how to get rid of the unused assets in your Final Cut Pro project quickly? Watch this Digital Media Dude podcast and learn how to search for unused assets in Final Cut Pro.
Tagging real walls can get you in a lot of trouble. So why not let out your creative urges in Photoshop? This Photoshop CS3 tutorial shows you how to make digital graffiti on a digitally made brick wall. Watch and learn how to use layer effects and lighting to create graffiti text in Photoshop.
Check out this instructional cinematography video that shows you how to build the Genesis Super 35 Digital Cinematography Camera System. Watch and learn as this instructor sets up the Panavision Genesis camera and prepares it for a shoot. This cinematography tutorial is perfect for professional filmmakers.
Watch this quick instructional cinematography video that shows how to balance a Canon XL2 professional HD digital camera on a GlideCam 4000 Pro. Learn how to secure the camera using this handheld camcorder stabilizer to prevent unwanted swaying, shoot fluid traveling shots, and produce professional works.
This video shows you how to upgrade your consumer camcorder sound capabilities using a camcorder XLR adapter, a simple device that mounts to the bottom of the camera. It then tests and compares the various types of microphones that can be attached, including the lavalier, sennheiser, handheld interview, and the wireless clip-on microphone. WAtch this helpful instructional video, and boost the sound on your camcorder for professional audio.
All you need is a basic digital camera and GIMP photo editing software to create your own version of the Pan's Labyrinth creatures. The Keyboard Shortcuts used, in case you can't hear it properly:
Ever wish you could see in the dark? Well, you can't but this how-to will show you a way to build a device to help you out. You will need light polarizors, a flashlight, and a digital camera. Make an infrared night vision device, just follow along with the steps in this video tutorial. Now you can see at night!
Want to challenge the filmmakers who spend millions of dollars on their films, yet, still have the nerve to call themselves indie? Pick up a 35mm adapter or build one yourself and you can give your movies that "film look" and start being taken more seriously!
Israel Hyman is a weekend videographer headquartered in Mesa, Arizona. In this video, he demonstrates how to use “Shutter Speed” to make your digital video look better. A rule of thumb is: Set the shutter speed at a rate of 1/60 of a second for normal shooting.
In this tutorial, we learn how to get sharp images in low light w/ a digital camera. If you are wanting to take quality pictures indoors but don't have great lighting, there is still a way to make your pictures turn out great. First, you will need to take a camera with a long lens and zoom in on your subject. After you do this, hold the camera steady and take the shot. When you look at the picture you just took, the picture should be brighter than it would be if you took a wider shot and it w...
The ability to tune a guitar is a skill every guitar player should possess. With this tutorial, learn how to properly tune a guitar either using a digital tuner or by using the fifth fret rule. Though a digital tuner is by far a more convenient option, certain situations my require the player to tune an instrument by ear. Start by tuning the low E string and use that sound as a reference for the tuning of the other strings. If a tuning fork is unavailable, a guitar can still be tuned relative...
Watch this Epson video tutorial to learn how to automatically enhance digital pics with the Epson Artisan 810 All-in-One Printer.
An instructional video by tradigital artist Merrill Kazanjian. Step 1- Scan the image
While the automotive industry is moving towards adopting AR displays in future models, BMW is already shifting into the next gear with its vision of the technology.
While many retailers have introduced try-before-you-buy features in their apps, Walmart has gone in another direction by bringing shoppers an augmented reality tool to help them compare products they want to buy.
As Magic Leap prepares to ship the Magic Leap One later this year, the company is putting its focus on mentoring developers and creators to build a content ecosystem for the spatial computing platform.
A burner number isn't just for criminals and cheating spouses. In this digital world, with many of our interactions being conducted online, a throwaway phone number acts as a buffer — it lets you enjoy the web without having to give out your personal information, such as real name or phone number.
A survey by ABI Research revealed that only 25 percent of businesses have implemented augmented reality technology in some form or fashion.
One inventor wants to bring augmented reality to internet radio and home audio speakers. Meanwhile, a leading consumer electronics company has opened up access its deep learning tools for building augmented reality apps. In addition, analysts examine how augmented reality will impact the design and construction and profile the top developers in augmented and virtual reality.
The automotive industry is traditionally very conservative, so when a carmaker says it will launch a particular model or feature by a certain date, it means a lot.
Getting support for your mental health is now as easy as opening up Facebook Messenger. By just opening up the Messenger app, you can connect to Woebot, a new chatbot developed at Stanford trained in administering cognitive behavioral therapy (CBT).