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 153rd installment in their series of digital spreadsheet magic tricks, you'll learn how to apply conditional formatting to the MAX value in a set of three incentive pay plans.
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 137th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract records from standard table and put a record in a column using the VLOOKUP, IF and ROWS functions.
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 139th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a data validation list drop-down and the hyperlink function to create a list of links.
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 572nd installment in their series of digital spreadsheet magic tricks, you'll learn about how to use conditional operators in your 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 568th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a SUMIFS function to tabulate a monthly running total from transaction data.
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 393rd installment in their series of digital spreadsheet video tutorials, you'll learn how to remove the last two words from column of data with the LEN, SUBSTITUTE, FIND, REPT, RIGHT and TRIM 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 246th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a waterfall profit chart from a stacked column chart.
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 101st installment in their series of digital spreadsheet magic tricks, you'll learn how to use IS functions (ISBLANK, ISERR, ISERROR, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISREF &ISTEXT).
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 94th installment in their series of digital spreadsheet magic tricks, you'll learn how to use and link a currency web query to a data validation cell drop-down list for money conversion.
In the video Boiling Pasta we are taught that there is actually a recipe for how much water to boil per pasta being prepared--1 liter per 100gm--and also what amount of salt--10gm salt to 100gm pasta, after boil. Most people preparing pasta may not know that adding oil while pasta is being boiled will cause it to not adhere to sauce. The video provides many useful tips in preparing pasta, most important of all when it is done just right.
Want to know what secrets are hidden in the palm of the late Michael Jackson? In this twelve-part video series by Palmistry expert & professor, Peter John, go inside the lines and creases present in the King of Pop's ever-telling hand. You'll be surprised by what Peter John finds!
If you somehow find yourself stranded in the woods, you'll need to know how to tie strong knots. But it's actually just as important to know how to untie knots. You probably have limited rope, after all, and you'll need to re-use it. In this video Reggie Bennett from the Mountain Shepherd Survival School shows us how to tie and untie knots.
An easy makeup tutorial to look fresh, youthful and effortless. This makeup routine takes me 5 minutes tops! It's all about minimal eye makeup and giving your lips and blushing skin the attention.
Watch this instructional blacksmithing video to forge a high carbon steel striker for flint and steel. The flint and steel striker served as the original portable lighter. Flint and steel lighters are also used on outdoor trips to light camp fires. These detailed instructions will allow you to begin the craft of metalsmithing and forge a useful tool.
Check out this fishing tutorial video that demonstrates how to tie a Centauri Fishing Knot for tying line to terminal tackle. The Centauri knot's versatility and functionality makes it one of the most useful fishing knots you are likely to encounter. Follow along with this instructional video and reel in the big fish!
Created by Andrew Lowell this tutorial video focuses on the basics of CHOPs and an introduction to the Motion View in Houdini 9. Through the creation of a simple animation learn just how useful CHOPs can be when working in Houdini 9.
Aperture's compare mode lets you keep one image fixed in the viewer while you cycle through your other images for easy side-by-side comparisons. This feature is useful for choosing the best out of a group of similar shots.
All digital cameras automatically record the date and time each photo was taken and store this time stamp as metadata within each image file. In Aperture 2, you can change these time stamps. This is particularly useful if the clock in your camera is set incorrectly or if you're trying to synchronize photos taken by multiple cameras at a single event.
Even if you don't have kids, this project is so useful that you're going to want to build a folding chair yourself. Just because we're building a kids project doesn't mean it has to be just for kids!
Watch this short video and learn seven super useful and common Japanese greetings.
In this episode learn useful idioms in the English language. This video is great for advanced, intermediate, and beginner learning to speak the English as a second language (ESL).
In this episode there will be useful words you need when you check into a hotel and review of the passive voice in the English language. This video is great for advanced, intermediate, and beginner learning to speak the English as a second language (ESL).
TOUCHPAD HACK - This video tutorial shows how to transform a touchpad into a useful mini graphics tablet with some simple, everyday items. You will need a 1.5V battery, a small ball bearing, and a Philips head screwdriver. Watch this video tutorial and learn how to transform a touch pad into a miniature graphics tablet.
Here's a great introduction to the scroll saw. If you're a craft woodworker, you probably already know what a useful tool it is. It's the best saw for making precision cuts in wood, plastic, and metal.
The dolly zoom shot is also known as the Vertigo Effect in filming. It's that dizzying, slightly unstable camera effect you see in shows like "Glee" and sometimes "The Office." It creates audience confusion, thus forcing them to keep watching in interest.
Andrew Price of Dryad Bushcraft demonstrates how to make a whistle out of a piece of willow that could be useful for fun and recreation as well as survival situations.
San Francisco-based 6D.ai is preparing to launch a beta of its AR cloud platform that's capable of constructing a real-time dense mesh from crowdsourced data for use in 3D mapping and multi-user AR experiences.
HoloLens developer Arvizio has expanded its collaboration suite of tools for enterprises with a device that can stream and record mixed reality experiences in high-definition for local and remote audiences.
The art of privilege escalation is a skill that any competent hacker should possess. It's an entire field unto itself, and while it's good to know how to perform the techniques involved manually, it's often more efficient to have a script automate the process. LinEnum is one such script that can be incredibly useful for privilege escalation on Linux systems.
Amazon's Fire TV set-top box has been out for over a month now, and the hacks are starting to come together. Sure you can play your Amazon Instant Video, Hulu, and Netflix content without any issue, but what about your personal media, like movies and music?
Learn how to teach children to read with these video lessons. Teaching reading to kids has never been easier!
Being able to read an electrical diagram will greatly aide your ability to correctly diagnose car problems. If you need some help with it, watch this video for a detailed explanation of how to read an example map for the clutch start switch on a Toyota.
Reading people's minds is something that most inquisitive and sensitive people have wished that they could do at some point. Well, what if you could? This video will show you a great multipurpose bar trick that will allow you to appear to read the mind or body of people in a variety of situations. It's really remarkable how easy this is and how well it works.
Apple might not be ready to unveil its rumored-yet-unconfirmed smartglasses. But the iPhone's current depth-sensing hardware is proving to be useful for both smartglasses makers and mobile AR apps.
Obsidian is a very useful component in any Minecrafter's toolbox, but if you want to easily create a ton of it at once, why not build an obsidian generator so that you can easily get obsidian ore? This video guide will show you exactly what steps to take to build an obsidian generator in Minecraft.
This is a great, sophisticated hairstyle you can achieve without using any heat (which can often damage your hair). It's an easy and useful secret - just braid your wet hair in the evening, secure in place and then undo it all in the morning!
This is a useful tip that can show you how to use a bubble level with a double axis to make sure your shots are perfectly balanced. Avoid having to adjust your photographs or crop part away by making sure your camera is level when you're shooting.
Here's a useful technique for any animator to be able to pick up - give your anaglyph animations a 3-D look. To replicate this, you will need Flash, After Effects and Photoshop, or programs that can accomplish similar animation tasks.
To earn this achievement, you must complete an entire level in Enslaved: Odyssey to the West without being hit once. This can be difficult, but is worth 50 gamerscore if you manage to complete it. Here's some useful strategies when trying to earn Untouchable.
Radar has made much of modern life possible, and if you're into building your own electronics building one is a fun and useful project. Watch this video for instructions on how to build your own simple radar out of cheap spare parts from a satellite dish or a toy radar gun.