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 673rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT formula to calculate commission amounts based on varying commission rates based on cumulative sales totals for each month.
The video shows you how to calculate capital budgeting with a Texas Instruments BA2+ financial calculator. Capital budgeting will help you determine cash flows for given investments for a certain number of years in the future, thus helping you determine if the investment is worthwhile. The buttons you will use are the CF (cashflows) button, the NPV (net present value) button, and the IRR (internal rate of return) button. The video uses the example of a $10,000 investment that will return $5,0...
Frustrated with the seemingly inscrutable machinations of YouTube's HD video upload feature? With this home video production how-to, you'll learn how to optimize clips exported from Final Cut Pro for YouTube's high-definition player, resulting in beautiful, perfectly syncronized video every time.
Watch this video tutorial to learn how to book the best hotel room for your money. You've spent all year saving up for your dream vacation. The last thing you want is to end up in a hotel room that ruins the whole trip.
It’s never too late to clean up your credit record – and save yourself thousands of dollars in exorbitant interest rates in the process. Learn how to repair your credit with this guide from Howcast.
From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps. With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to simplify a rate or ration using simple math.
From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps. With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to unpack and solve word problems that require you to find a unit rate.
So, you've started playing golf, and you've started getting competitive... Figure out a golf handicap with help from this free video from expert golf site, Golf Link. A golfer's handicap is determined by two factors, which are the course rating and the slope of the golf course. Subtract the course rating from a golf score, multiply by 113 and divide by the slope, and finally multiply by .96 to find a handicap.
Dr. Allen Bridges details methods for detection of estrus in beef cattle, part of an efficient breeding program. Poor estrus detection results in poor pregnancy rates. Learn how to maximize pregnancy rates and increase the health of female beef cattle by watching this video tutorial.
After months of waiting, the iPhone 11 is here. At an event in Cupertino, Apple unveiled the iPhone 11, 11 Pro and 11 Pro max. You probably have a lot of questions after reviewing the specs sheet, including wanting to know more about the IP68 rating that all three phones have. We're here to clarify.
Ratings and reviews apply everywhere, from a restaurant you want to try to a new camera you're thinking of buying and games you might want to play. Podcasts are no different. Reading reviews of shows can help determine which are worth listening to, and your opinion is valuable to other people too. In Apple Podcasts, there are a few different ways to read, rate, and review shows.
When Apple released the iOS 10.2 update to the public on December 12, 2016, iPhone users got a slew of new features, including new emojis, a brand new TV app, the ability to save camera settings, and more. But out of all of these new features, the one that interests me the most is something they didn't even include in the release notes—star ratings are back in the Music app!
Back in iOS 8.4, Apple introduce a new "heart" icon in their Music app, which works in direct correlation with their Apple Music service that was released at the same time. By hearting a song, you're telling Apple that you love that song, and they can make better suggestions for you (in the "For You'" tab) based on it.
Video: . Being one of the most popular DIY/maker projects around, Musical Floppy Drives are nothing new. However, myFloppyDriveOrchestra includes a few unique features, which separate it from the crowd.
Samsung Galaxy S5 has an exciting feature through which you could measure your heart bit. So this video will show you how to measure your heart rate with Samsung Galaxy S5. Watch the video and follow all the steps carefully. Employ the technique in your Galaxy S5 phone.
In this video tutorial, viewers learn how to test their system performance. Begin by clicking on the Start menu and select Control Panel. Then click on System and Security, and select "Check the Windows Experience Index" under System. Now click on "Rate this computer". The system will then begin to run some tests. This will take about 1-2 minutes. The Windows Experience Index assesses key system components on a scale of 1.0 to 7.9. This video will benefit those viewers who use a Windows 7 com...
In this video tutorial, viewers learn how to create a tilt shift effect with Adobe Final Cut Studio. Begin by changing the video's speed to 300% and disable the Frame Blending. Now click on Effects, go to Video Filters, press on Time and select Strobe. Change the Strobe rate to 7-15 fps. Now switch to Motion and Duplicate the group. Then create a simple mask in the upper group and apply defocus to the lower group. Under Mask, increase the Feather rate up to 100%. Now add another mask around t...
In this Education video tutorial you will learn how to solve a word problem that involves proportions. To solve such problems you got to express the scenario in proportions. For example, in the problem, ‘Jacob ran 10 miles in 80 minutes’; this rate can be expressed as 10miles/ 80 minutes. The second part of the problem is to find out ‘at that rate how far would he run in 2.5 hours’? ‘How far’ being a variable, write it as ‘x’ and this can be expressed as x/ 2.5 hours. So, the complete equatio...
In this tutorial, Sarah Sheppard teaches us how to conduct a closed suction procedure. First, wash your hands, apply gloves, and identify yourself to the patient. Now, you will do vital signs such as, heart rate, respiratory rate, and lung sounds. After this, check the suction pressure and it should be around 80 to 120. Now, perform the rest of the closed suction procedure by inserting your standing needle and turning it off, then turning on the 02 sensor. This will give your patient two minu...
As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 32nd installment in his "Excel Business Math" series of free video lessons, you'll learn how to solve simple markup (mark-up) & markdown (mark-down) business math problems.
In this video tutorial, viewers learn how to negotiate with a credit card company. There are 3 main items that users can negotiate. The first item is the date of payment. Users are able arrange a more convenient date for payment. The second item is the annual fee. Users are able to work out a way to not have to pay an annual fee for using a credit card, which will help save money. The third item is the interest rate. Users can negotiate and try to lower the interest rate that they must pay. T...
In this video tutorial, learn how to delete unwanted applications on the iPhone or iPod Touch. Begin by finding the application(s) that you want to delete. Then, press the application(s) and hold it. All the applications will have an X on the top left corner. Click on the application(s) that you want to delete and select "Delete". Another window will pop up asking for a rating of the application. Users may choose to rate it or simply select "No Thanks".
This video is about understanding the basics of selling on eBay. Your feedback rating is very important. Buyers rate you on their purchase, the quality of the merchandise, how quickly it arrived, and the information you provided. Research prices on eBay. If the item is priced $2.99, and there are "0" bids, it's the starting price. If there are 8 bids, and the price is $12.99, the item was bid up to $12.99. Click on the item link below the picture, and it will bring up the bid history. You can...
Samsung's new line of Galaxy S20 flagships have a water resistance rating of IP68. This means you don't have to worry as much about getting the phones wet, but there's a limit to that.
Black Desert Mobile is one of the hottest new smartphone games around, but there seems to be something missing in the frame rate department. Gamers quickly noticed many Android phones are stuck on a 30 FPS cap when it comes to performance. It's not that the phones are too weak to handle higher frame rates, but that there is a particular list of approved devices that can achieve this.
If you're looking into buying shoes from DSW on Black Friday, then you can save an extra 20% — but only if you smile more.
They're finally here. Apple announced three new iPhone models at their "Gather Round" event in Cupertino, and they're all absolutely gorgeous phones. With bezel-less screens and polished titanium edges, the iPhone XS, XS Max, and XR are truly marvels of engineering — but perhaps the most impressive design feat Apple pulled off is the fact that two of these models are rated IP68 under the IEC standard 60529.
Bluetooth Low Energy (BLE) is the de facto wireless protocol choice by many wearables developers, and much of the emerging internet of things (IoT) market. Thanks to it's near ubiquity in modern smartphones, tablets, and computers, BLE represents a large and frequently insecure attack surface. This surface can now be mapped with the use of Blue Hydra.
Not to be outdone by Apple and it's new line of flagship phones, Google has followed suit and finally announced the followup to their highly regarded Pixel line of handsets — the aptly named Pixel 2. Thankfully, the tech giant has also joined in on the trend towards more durable devices, and has engineered both the Pixel 2 and Pixel 2 XL to have a rating of IP67 under the IEC standard 60529.
When Apple announced its new iPhone 7 and iPhone 7 Plus models in San Francisco, one of the biggest new features was an "IP67" water-resistance rating. Couple that with a few official renderings that show the new iPhone covered in water, and you'd probably arrive at one logical conclusion: The iPhone 7 is waterproof.
While flying isn't easy, once an airplane gets into the clouds there isn't a whole lot to worry about—most of the work happens during takeoff and landing. Helicopter pilots, on the other hand, have a lot of dangerous obstacles (like power lines and buildings) to contend with. But, once again, augmented reality can save the day.
Chinese tech company OPPO has been on the cutting edge of smartphone battery charging since it released its VOOC Flash Charge in 2014. Using VOOC, you can charge your battery from 0-75% in 30 minutes.
Samsung's Gear VR headset is a thing of beauty; unfortunately, it only works with the Samsung Galaxy Note 4. That's where ImmersiON-VRelia's Head-Mounted Displays come in to play. With four different HMD models, we got a hands-on look at "The Go," which is not only affordable (at $125), but also compatible with the majority of Android and iOS devices.
The Billboard Charts have been a measurement of commercial success for pop songs since roughly the time that radios became a household item. In its modern form, Billboard ranks the sales and performance of all singles with its "Hot 100" chart, as well as many other genre-specific rankings.
Oddly enough, stock Android does not come with a "do not disturb" function out of the box. Samsung has their own version built into to TouchWiz called "Blocking Mode," and Apple has had their "Do Not Disturb" feature since iOS 6, so why is stock Android so late to the game?
If smartphone video games have a weakness, it's probably their inability to emulate the riveting and immersive experience that consoles offer.
While there is definitely no shortage of video game emulators in the Android Market, it lacks in modern gaming consoles. Nintendo 64, Game Boys, and Sega Genesis are all accounted for, but what about emulators for some of the gaming consoles that have come out in the, let's say...past decade?
Invented by Philadelphia tinsmith John L. Manson in 1858 for canning and preserving perishables, mason jars are experiencing a major resurgence in the DIY community. In addition to being a handy storage device for both food and non-food items, its old-timey, quaintly antiquated look also makes for good drinking glasses, candle holders, flower vases and eye-pleasing decorations.
In 1958, Patrick Flanagan invented the Neurophone, a device patented in 1962 that allows radio signals to be picked up by the human nervous system. The skin is the organ that receives the signal, converting it into a modulated molecular vibration, which the brain interprets into sound. Basically, it gives one the ability to 'hear' through the skin, making it sound like the audio you're hearing is actually in your head. It's kind of like having headphones in your brain. The only problem was th...
Freelance web developer and Internet marketer David Frosdick offers some tips and tricks in this video tutorial on how to get the best Camtasia settings for YouTube widescreen.
