Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 47th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the PMT function to calculate payments. Specifically, this video addresses the following topics:
Some savings plan pays interest 365 days in a year but you make deposit monthly. You can use Excel functions to calculate the maturity value of the of the monthly plan. To do this you have to use the nominal and effect functions before using the future value functions. First enter the know data like the monthly payment, the number of years of payment, the number of days in a year, and the annual percentage rate. First take the nominal rate and calculate the effective rate with the help of eff...
It's finally here. After years of rumors and speculation, Apple unveiled the new iPhone SE on April 15. While it doesn't have a 4-inch display like the original SE, it's the smallest new iPhone you can buy today, with the chipset of the iPhone 11, 11 Pro, and 11 Pro Max. So, when can you get your hands on it?
The in-fighting between the major US carriers just got a little more interesting. In July of last year, T-Mobile introduced their JUMP! plan, letting customers upgrade their devices after just six months, up to twice a year. Buy a device, split up the price into monthly payments, and pay an additional $10/month to enroll in the service.
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 45th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to perform debt analysis with the following input variables: % Down Payment, APR, Years, Points, Extra Fee. See how to calculate Amount to Borrow, Monthly Pay...
They're finally here. Apple revealed the brand new iPhone 11, 11 Pro, and 11 Pro Max on Sept. 10, and despite the questionable names, these are the best iPhone models money can buy. If you're looking to get your hands on one of these devices as soon as possible, there are few important dates you need to know.
Apple just unveiled the new iPhone 7 and 7 Plus at their September event, which means we're inching closer to traffic jams, parking lot fights, and day-long lines at Apple Stores, as well as those inevitable, dreaded words: "sold out."
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 679th installment in their series of digital spreadsheet magic tricks, you'll learn how to summarize yearly totals from monthly totals when there Year Criteria is entered as a serial date. See the SUMPRODUCT and SUMIFS functions. Learn about criteria and how to enter it into the SUMIFS functions.
The world finally received its first official look at the iPhone XR, XS, and XS Max, Apple's 2018 suite of smartphones, on Wednesday, Sept. 12. If you're someone looking to get their hands on one, two, or three of these new iPhones as soon as possible, you'll need to know all of the important dates so you don't end up missing out to others ahead of the line.
Apple officially unveiled the long-awaited iPhone X, its tenth-anniversary edition iPhone, on September 12. With preorder and release dates just around the corner, you'll want to brush up on all things iPhone X to make sure you get your hands on one as soon as possible. After all, preorders start Friday, October 27.
One the main gripes against cutting-edge augmented reality headsets like the Magic Leap One and the HoloLens is the price — they're pretty expensive compared to most consumer devices. Well, now some of that pain has been relieved for those looking to pick up a Magic Leap One as the company has just announced a financing option that allows anyone with a spare $96/month to gradually pay their way into full ownership of the device.
Mobile data is expensive. The internet connection that comes with your cell phone plan is generally limited to a certain amount of gigabytes that can be downloaded before your monthly cap kicks in, at which point you run the risk of incurring costly overage fees.
For accepting payments on the go, try out the Square payment system. Square allows you to take your customer's credit cards as payment when selling your products out of food trucks, at events, or door-to-door. This guide will show you how to use Square to charge customers using their credit cards.
With new iPhone models out, you'll have updated cameras to try out, a faster processor, and new colors to choose from. The only thing that could stop you from picking one up yourself is, well, your current iPhone. Here's how to check if you're eligible to upgrade to iPhone 11, iPhone 11 Pro, iPhone 11 Pro Max, or any other iPhone still being sold.
Learn how to calculate interest on loan payments with Microsoft Excel 2007. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the Excel 2007 workflow, you're sure to be well served by this video tutorial. For more information, and to get started making your own loan payment calculations, watch this free video guide.
What happens when somebody sends you Apple Pay Cash inside of an iMessage? Do you have to add it to your Apple Pay Cash card on your iPhone manually or does it miraculously appear there automatically?
So, you've got your website set up, but there's something missing. Oh right- you need a PayPayl payment button so that people can easily buy your product. Watch this video to learn how to make your custom own PayPal payment button and put it on your wesbite.
Looking for a primer on how to calculate child support payments in a Microsoft Excel spreadsheet? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, you'll learn how to do just that. For more information, including detailed instructions on how to find child support payment amounts yourself, watch this helpful how-to.
In this three-part video tutorial, learn how to manage loans with an amortization table in Excel. The three parts of this video go over the following:
TextNow is a great App for the iPhone that allows you to, for a $1 initial fee, send unlimited text messages to any other TextNow user without using any of the precious limited texts on your AT&T plan. The App is very easy to use, requires only a modest amount of additional money to keep using it forever, and will probably wind up saving you money in the long run by cutting down your monthly billed texts.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 51st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use a VLOOKUP function inside a Text Formula to add a variable word (e.g., Annual, Semi-Annual, Quarterly, Monthly, or Weekly).
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.
Kids can have fun using the iTunes music store while parents still control the credit card and content their children can access. Parents can restrict access to certain content, set up a shopping cart to review music choices before they're purchased, and give kids a monthly allowance.
Making a purchase through PayPal is great because you have the option to pay using your account balance, a bank account, debit card, credit card, rewards balance, or even PayPal's own credit product. You need to pick one to be your preferred payment method for each in-stores and online but, unfortunately, changing these preferences can get a bit tricky on your iPhone or Android phone.
Zently — the mobile app for renters — is taking on Venmo with its newest feature. Traditionally used to automate rent payments, deliver rent checks for free, and communicate with your landlord, it now allows you to connect to your bank account and split bills with housemates. Following the addition of Zelle to several major banks apps — to allow users to transfer money to their contacts — the battle of the mobile payment apps is getting increasingly fierce. With this new update, Zently is als...
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 45th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the SUMPRODUCT & TEXT functions together in 1 formula to sum the month's sales. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
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 325th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that takes a fixed daily cost and calculates the monthly total for months with different number of days.
Did you just find an iPhone 3G or 3GS on the floor but don't want to pay for the expensive AT&T plan?? This instructional video takes you step by step on how to easily jailbreak the phone with a couple of simple of steps that will allow you to use your phone in a matter of minutes without having to pay outrageous monthly phone bills. All you need to do is have iTunes installed on your computer and then just follow the simple steps stated in the video.
When it comes to your cell phone, do you feel like you’re paying more and more for less and less? Get the upper hand with these tips. You will need:
iPhone 6 pre-orders begin on September 12th, with the devices set for sale on the 19th. If you're ready to pick one up—no matter if you're a loyal iPhone user or an Android user about to make the switch—now is the time to check your upgrade eligibility.
As you might guess, one of the domains in which Microsoft Excel really excels is finance 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 12th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate average and marginal tax rates with Excel.
This video demonstrates how to remove the air conditioning condenser from a Nissan Altima. If your air conditioning isn't working, especially if you live in a hot, traffiky part of the world, your life is probably pretty miserable. This video will help you to rectify the situation yourself at home without having to pay half of your monthly salary to a mechanic.
Take a look at this instructional video and learn how to use simple formulas in Microsoft Office Excel 2007 to add, subtract, multiply, and divide. For example, you can use a prewritten formula called the SUM function to find totals, such as your total monthly expenses. Excel updates the results if the numbers change later.
This video walks you through the steps of using geometric series sum to figure out mortgage payments. This excellent video shows you a clean blackboard, with the instructors voice showing exactly what to do. Don't fret, any question you may have, will be answered. Watching this video will make you feel like your back in the classroom but rather comfortably from your home.
If you've set up a way with the IRS to pay off your taxes, you may want to consider signing up for the new Online Payment Agreement. This simple method lets you pay from your home computer and you can even set up direct debit for even more convenience.
Need some help figuring out how to create shipping profiles when selling on Etsy? This brief video tutorial from the folks at Butterscotch will teach you everything you need to know. For more information, including detailed, step-by-step instructions, and to get learn more about setting up payment and shipping options as a seller on Etsy, take a look.
As you might guess, one of the domains in which Microsoft Excel really excels is finance 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 67th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate the value of a stock with irregular dividend payments,
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 47th installment in his "Business Math" series of free video lessons, you'll learn how to determine credit given for partial payment of an invoice.
It's that time of year again. No, not Thanksgiving. Black Friday. There are a lot deals available this holiday weekend, many of which include flagship Android devices. Whether you are thinking of buying a phone for yourself or looking for a gift for someone else, you can find a little savings to shop smart during the holidays.
You might be proficient at sending your family and friends money using Apple Pay Cash on your iPhone, but what about when you need some digital currency in your wallet to buy in-app purchases or to get back the money you spent on someone's lunch? Requesting some Apple Pay Cash can be done a few different ways, none of which are hard.
