Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 2nd installment in his "Excel Formula Efficiency" series, you'll learn how to compare alternative formulas to see which is faster.
The Apple iPad has already invaded the world, and anyone who bought the iPad as soon as it came out will miss out on the 3G version. But don't fret, if you have the Wi-Fi iPad, you can mod it into a 3G iPad with a little device called the MiFi. The MiFi intelligent mobile hotspot allows you to take your Wi-Fi hotspot with you! This device basically acts like a mobile access point. Once you create a WiFi hotspot on your MiFi, you can connect multiple iPads (or computers and phones) at the same...
This video demonstrates how to make a christmas tree out of newspaper. The author suggests that you start with 3 full sheets of newspaper and have scissors and scotch tape ready to use. Begin the tree making process by rolling the newspaper tightly and then using the scissors to create multiple cuts on one end of the roll. After doing so the newspaper roll should achieve a frayed look on one end. Pull on the frayed side to elongate the other newspaper that was rolled inside previously and the...
If you have recently changed computers, or lost your music files, or even if you are just looking to share amongst multiple PCs; check out this tutorial and learn how to import songs into iTunes off of your iPod. This is a sort of backwards import, because normally you would be exporting your music ONTO your iPod.
Facebook is a social networking website where you can stay in touch with your friends and even make new friends. Using Facebook you can suggest your friend to some one else on Facebook. To do this first open the profile of the person you want to suggest. Scroll down and to the left you will find a link which says suggest friends to others. Click on it and this brings up a list of people who are in your friends list. Now select all the people you want to suggest this person. You can select mul...
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 368th installment in their series of digital spreadsheet video tutorials, you'll learn how to create and use an array formula that will permit you to count unique items within a column while specifying more than one criterion. This guide uses the SUM, IF FREQUENCY, MATCH, ROW, and ISNUMBER functions (in a somewhat unusual combi...
Learn how to balance chemical equations with MyTutorBuddy. Learn about this in this video tutorial. There are four easy steps to do this. Step #1 – place 1 by the most complex compound. Step #2 – balance anything that is not an element. Step #3 – balance the elements. Step #4 – multiply by the lowest common multiple. The 4th step doesn’t always come in to play. The video demonstrates with an equation: C3H8 + O2 -> H2O + CO2. But, this equation is not balanced. Using the 1st three steps, the v...
In this video the host of "Tying It All Together" demonstrates how to create a "Eternity Knot". This type of knot is an attractive way to decorate a rope or string. Strung along one after another on a rope or string, it creates elongated bead-like knots at intervals of your choosing. The Eternity Knot is named for it's resemblance to the symbol of Buddha's all-knowing wisdom and the uncommon quality of his realizations. In this video the host will lead you through the entire process of creati...
Nick from Primeloops shows how to most effectively use the effect sends in Ableton Live. He explains how most people use the effect send, and why that may not be the best way to go. He covers the basics of dry audio and wet audio and how to manage them for optimum effect. If you watch this short video, you can learn the basics of sends and returns and find out how to apply effect settings to multiple tracks which is of great benefit if you want to save time and cpu power.
Interviewing lighting basic training tutorial provides easy to follow instruction in this step by step video. Set up the interview area to allow the best camera angles. Place your lights in key, fill, and backlight positions. Use back lighting spillover to fill subject area without camera spillover. Check your setup with the subjects and make any necessary adjustments to your camera or lighting angles. Place your crew and your ready for your interview. This scenario using key, fill, and back-...
To add drama to a photo and create some additional pop, this video tutorial shows how to create a photo cutout using Photoshop software. What you need to do is determine what subject in a photo you would like to cut out. Using a cutout and multiple layers, the final impact is an effect that makes the cutout appear as though it is extending beyond the photo's boundaries and into white space. By following these steps, you can create additional interest or emphasize a certain part of a photo usi...
Multiplying fractions are very simple, just multiply the numerators of the fractions to get the new numerator, and multiply the denominators of the fractions to get the new denominator. Let's say we have 2 fractions 1/2 and 1/2 when multiplying them 1/2x1/2=1/4 [1x1/2x2].
This video shows how sublimation works. The instructor shows how to mix bubbled water, ice water and dry ice to create dry ice smoke. He is essentially making a hand made fog machine. This task must be done carefully because if the solution is isolated and concealed it will build pressure and possibly explode. Take extreme caution in doing this home experiment. The instructor also shows you how to make music spoons using temperature changes on the metal.
This video is a how to guide on how someone can add multiple colored sections to a photograph. It goes step by step to guide viewers on how to accomplish the color effects. Although the video is only 5 minutes long it provides a great wealth of information. However the speaker is quite fast so using the pause button is highly encouraged for those not proficient with computers, or those not very quick with a mouse. A very informative video that taught me something I did not know how to do in P...
This video relates to Neon Mosaic Nail Tutorial. This video teaches how to make the nails good looking and also pleasing. In this video she teaches how to select the colors of nail polish and also she teaches the steps to be followed regarding which color nail polish to be applied first and also to create a mosaic by using multiple colors. She also add some border line to create and pleasing look. She also narrates to change the colors in applying to each nail. She also teaches how to create ...
The Wedge ROP is a render output driver, which can be used to change variables on the fly while rendering. This can be very useful when simulating, in that you can test out different parameters to see the different results. It's a relatively new feature in Houdini 9.5.
Ah, falling leaves: They remind of the beauty of nature, fall, and the changing of seasons. And if you've ever walked alongside a row of oaks on the street it seems as if their leaves fall to some unknown, hidden perfect orchestration.
The multiple award-winning card game Sixteen is packed with head-to-head action. If you can you count to 16 and take calculated risks, then you can force your opponent to bust. But play your cards defensively at the right time or the tables will turn! Win the most sets and you'll win the game. It sounds simple (and it is), but Sixteen's unique strategy and cribbage-like counting will hold the attention of even the most seasoned game players.
In this video tutorial, Chris Pels will show how to read, write, and delete cookies in an ASP.NET application. First, learn the basic operations for manipulating cookies. Then learn approaches to storing multiple values in a single cookie using name-value pairs called subkeys. Next, learn how to limit the scope of cookies to a particular application domain or folder. See how to modify values and expiration dates in existing cookies and how to delete an existing cookie. In addition, several co...
Every home is a little different, and for a smart home app to work, it has to be able to be customized to work with each person's unique setup. With the iPhone's Home app, everyone can set up a smart home just how they want, including the number and names of rooms, and where those rooms are in the house.
You don't need to delete an entire thread in the Messages app to get rid of a couple of texts on your iPhone. With a few taps, you can remove unwanted iMessages and texts, as well as storage-hungry photos and videos, to de-clutter a conversation. And in iOS 13, the process is even easier.
There are plenty of reasons the Pixel's Google Camera has become a must-have app for Android users. Google Playground AR stickers and Night Sight for low light photography are just the tip of the iceberg. Beyond those, the app comes with other, less-publicized options that add tremendously to its overall usefulness.
DSP Manager, Dolby Atmos, ViPER4Android — how are you supposed to pick just one from the wide variety of Android equalizers? Depending on your OEM, your phone may have come with a stock equalizer, but they're usually not enough. Combine them with a third-party equalizer, and then we're getting somewhere. However, installing multiple equalizers at the same time has always seemed to cause audio glitches — until now.
BlackBerry has formally announced the arrival of its flagship, the KeyOne, during Mobile World Congress 2017 in Barcelona. The all-Android KeyOne looks distinctly BlackBerry, with its 4.5" screen and physical QWERTY keyboard. Here's the lowdown on this elegant handset that hearkens back to BlackBerry's heyday, which had previously been known by its code name, the BlackBerry Mercury. Aluminum Unibody with Physical Keyboard
Mixed reality headsets have limited hardware capabilities and naturally imprecise interfaces. While that works just fine for games and entertainment, can they actually function as a tool for productivity?
As Android owners, we ultimately have to look at our device and ask the difficult question: "Where the hell did all these applications come from?"
With platforms like Facebook, Instagram, and Snapchat available for anyone to take advantage of, I'm all about differentiating from the mundane and repetitive images we see on social media everyday.
Since the days of Friendster and MySpace, social media platforms have taken leaps forward, revolutionizing how we live our lives by changing the way we communicate with others. Not only has social media become a catalyst for major uprisings around the world, but on a personal level, it connects people together in ways that were unimaginable even 10 year ago—no one was taking pictures of their brunch to share with the world in 2004.
Though many students spend four years of high school learning a foreign language, most of us probably retained very little. Chalk it up to the carelessness of youth, but chances are you've since been in situations or places that left you wishing you paid more attention in class or had continued practicing long after you graduated.
There are countless lock screens you can apply to your Android device, but very few offer more than just quick access to apps or advanced security functionality. Since you probably unlock your device a gazillion times every day, why not use this to your advantage and let it teach you something new?
Recently, I offered a guide detailing how to run two separate windows on a Nexus 7 tablets for better multitasking. While extremely useful, that mod was limited to only two windows, and you also needed root access to use it.
If you're anything like me, you'd like the ability to fully exit your iPhone apps to help free up memory, improve battery life, stop background processes, and fix unresponsive apps. The thing is, you can, with the help of the app switcher. Force-closing apps also helps keep your app switch clean and organized.
You can create a multiple user accounts and enable fast user switching. To do this go to system preferences and open accounts. Now authenticate yourself by clicking the lock icon to be able to make changes. Now click + button
If you want to run multiple windows operating systems at the same time you first need a Windows computer, the installation disk for the operating system you want to run, and Windows Virtual PC 2007. To install this, first type in Virtual PC 2007 to Google, go to the Microsoft link and download and install the program. Now, open the Virtual PC and click next on the wizard. Name your hard disk and click next until you choose where you want this at. Now your virtual hard drive is created. Now, p...
How to sync your iPod to more than one computer
Kevin demonstrates multiple methods to clean dirty coins.In the first method he takes some coke in a glass and hangs a dirty coin in it with the help of a string. This coke technique takes a few hours.In another faster technique which takes only 20 to 30 minutes he takes table salt and food vinegar. He takes the table salt and dissolves it in vinegar in a bowl. When most of it is dissolved he drops a dirty coin in it and waits about 20 minutes.Another method is to rub toothpaste on the coin f...
With the Group Text app, you can easily set up a distribution list so you can send out text messages to large numbers of people at once. You can also set up form templates, which are useful if you tend to send out a similar text message each time. This short tutorial shows you how to set up the distribution list, and how to get the most out of your Group Text. You can even set up multiple distribution lists for different topics or texts!
In this video, we learn how to photograph a pregnant mom. Try taking a shot of the woman outside, this will feature her stomach and show off the glow of her skin as well. Process it after you have taken the photo to edit it further. Drape a sheet around the woman as well, which is a really popular photo technique as well. Take fun shots with your partner, animals, other children, and around the house! The camera can focus on different things to show multiple subjects in the scene. Be creative...
The concept of percentages may be a bit difficult to grasp for some beginner level learners. This video attempts to explain the concept of percentages in an easy to understand way.
In this video, we learn how to practice balancing chemical equations. First, take a look at the first and second part of the equation. Write out how many atoms each of the elements has in it. Compare each of the sides to see what the difference is between them. Then, find the multiple of each of the elements until they are equal to each other. After you find this, continue to do this for all of the different elements in the equation. This will give you a balanced chemical equation when you ar...
