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.
This how-to video is about how to check and set the tire pressure in the car. The first and foremost thing we need to consider while setting the right pressure in the car tire is looking for the proper inflation pressure for both front and rear tires. We can find the manufacturers specification for tire inflation near the driver side door, where the tire pressure for both the front and rear tires will be mentioned, take a correct look at the tire pressures. In this video the tire pressure req...
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...
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.
Watch this Epson video tutorial to learn how to automatically enhance digital pics with the Epson Artisan 810 All-in-One Printer.
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.
An instructional video by tradigital artist Merrill Kazanjian. Step 1- Scan the image
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.
The increasingly important world of white hat or "ethical" hacking is getting competitive. Thanks to growing salaries and opportunities for talented and trained coding pros who can infiltrate servers and safeguard networks against digital threats, demand for intrepid cyber warriors is through the roof, and it shows no signs of slowing down any time soon.
Adobe sets the standard for graphic design. Since launching its subscription-based Creative Cloud in 2011, Adobe has consistently updated its suite of applications to serve the needs of the modern designer.
Halloween is barely in the rearview mirror, but Coca-Cola is ready to bypass Thanksgiving altogether to accelerate the arrival of Christmas, and the brand has enlisted augmented reality as an accomplice.
With Apple preparing to bring a slew of new features to its Animoji app this fall, Samsung has updated its AR Emoji imitator with the ability to create more realistic digital doppelgängers.
Augmented reality might not be able to cure cancer (yet), but when combined with a machine learning algorithm, it can help doctors diagnose the disease.
Although the HoloLens is still primarily the domain of developers and researchers, the device is nevertheless on the cutting edge of showing us what will be possible with augmented reality in the coming years. The latest example comes via Microsoft Japan and a new concept video that shows off how the HoloLens will be used in the relatively near future to pilot autonomous ships.
The Razer Phone has already been crowned the best gaming phone on the market today, and it might need to make room on the mantle for another trophy: the best phone for Netflix. Its Quad HD 120 Hz display makes it a great option to binge Black Mirror on, but the Razer Phone didn't exactly stand out from the rest of the pack until now.
A survey by ABI Research revealed that only 25 percent of businesses have implemented augmented reality technology in some form or fashion.
A new demo has given a hint about what's going to be possible in the world of mixed reality, thanks to Apple's ARKit.
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.
One of the disadvantages of the digital world is that you can't pick it up and touch it. While that can feel like less of a problem in virtual reality, where you're already holding controllers, mixed reality environments—like the one you'd experience in Microsoft's HoloLens—suffer from a lack of physical connection with the digital objects that appear in your real world. Dexmo aims to solve that problem with a relatively intimidating new controller that encompasses your hands.
If you've ever wanted to live in the Matrix—or at least the iconic digital rain data visualization that Neo saw when realizing he was, indeed, the "one"—you can now do that with the Microsoft HoloLens. Just download The Red Pill.
If you have an Apple Watch, it's easier than ever to ask Siri for directions, send a quick text, or locate the nearest Chipotle—because you don't need to pull out your iPhone anymore. Luckily, Apple made it fairly painless to get Siri up and running on the Watch, so let's go over the two quick activation methods.
If you're into photography, you're probably no stranger to the myriad of ways you can take macros with your smartphone. Your phone's built-in camera may not take great pictures up close, but you can modify it to do so with anything from a magnifying glass to a drop of water. However, those types of DIY macro lenses can only get so close.
