Annual Enrollment Search Results

How To: Apply for a NEXUS card to use in Canada and the United

Nexus is a pre-approved trusted traveler program that allows approved people expedited travel between Canada and the US. The card is available to US and Canadian citizens or permanent residents who travel by air or land between the two countries. Anyone traveling between the two countries must have their own Nexus card including babies. The Nexus card is considered a privilege by both the US and Canadian governments. You must have a clean record with both the Canadian Border Services and The ...

How To: Use a VLOOKUP function inside a text formula in Excel

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).

How To: Calculate YTM and effective annual yield from bond cash flows in Excel

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 49th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate YTM & effective annual yield from bond cash flows.

How To: Calculate yield to market & effective annual yield from bond price in Excel

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 49th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate yield to market and effective annual yield from a bond price.

How To: Calculate APR, EAR & period rates in Microsoft Excel 2010

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, part of his "Excel Finance Class" series of free video lessons, you'll learn how to calculate APR (Annual Percentage Rate), EAR (Effective Annual Rate) and Period Rate.

How To: Get a commercial driver FAST card for US & Canada

FAST is an expedited travel program for commercial truck drivers that travel between the US and Canada. FAST cards are available to citizens or permanent residents of Canada or the US. The FAST program is viewed as a privilege by both Canada and the US. You can be denied for the FAST program if you do not have a clean driving record and a clean record with the Canadian Border Services and The US Customs and Border Protection. Things such as being caught with undeclared items and having a crim...

How To: Do the Vidmaster Challenge - Annual Halo 3 achievement

In this video, Jack and Gav tell us how to do the Vidmaster Challenge in Annual Halo 3 achievement. First, start at the mission start point and change the difficult to legendary. Turn on the iron skull, then get four other people to play with. Now, continue to play the game and go up on the platform. Continue to go around shooting things, then come out the doors from the building and go left to find four ghosts that you can use to finish the game after this. Take it slow after this, then you ...

How To: Compare the difference of annual percentage rate

This video is about Annual percentage Rate(APR) and the Effective APR rate.The video begins with an example of a credit card which has a APR rate of 22.9% and daily periodic rate of 0.06274%.You can get the APR rate by multiplying the daily peiodic rate with 365, which in this case will be 0.06274*365 which is equal to 22.9.If you convert the daily periodic rate into decimal values , it will be 0.006274.So for example, if you have 1 dollar in your balance on day 1, on day 2 you will owe 1.000...

How To: Find APR, EAR & amortization for payday loans in Excel

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 623rd installment in their series of digital spreadsheet magic tricks, you'll learn how to see the pain that pay day loans inflict on people using Excel. Learn how to calculate APR (Annual Percentage Rate), EAR (Effective Annual Rate), an Amortization Table and the EAR for a loan that takes a fee out up front. Learn ...

How To: Effectively negotiate with your credit card company

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...

How To: Use Excel for daily interest and monthly deposits

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...

How To: Use Excel formulas & functions

In this installment of the Excel Basics Series you'll learn how to use formulas to calculate an annual interest rate, as well as breaking it down to a monthly rate and an effective annual rate. A general knowledge of Excel is helpful for navigating the menus in Excel, but if you pay attention during this presentation you'll pick up the skills quickly! Several ideas covered in this video are Formulas with cell references, how to find various Excel functions to use in formulas, and the Effect f...

How To: Derive the annual compound interest formula

In this video tutorial the instructor shows how to derive the formula to compute interest compounded annually. He starts with explaining the basic concepts like principle which is the amount you borrow and the rate of interest or annual percentage rate (APR), which is the rate at which you pay the interest up on the borrowed principle. He shows that the amount after the end of one year is amount A = P(1+APR),and he goes on and generalizes how to compute it for n years. This video shows how to...

How To: Choose the plants best suited to your home garden

So you want to start a home garden in your backyard? Make sure you pick the best plants and flowers for your garden by considering climate, soil composition and growing seasons for what you want to cultivate. Know the difference between annuals and perennials, and master home gardening techniques so your garden can thrive beautifully!

How To: Organize your collection of bras

Chances are that if you've attended any amount of Victoria's Secret's semi-annual sales, you've probably got enough bras to start your own lingerie store. But because you don't have an entire showroom to store those babies, your bras are probably just lying around wherever they fit.

How To: Create a Victoria's Secret Marisa Miller nude makeup look

If you haven't already seen her face plastered in front of every Victoria's Secret store and catalog cover, then you certainly will tonight, when the annual Victoria's Secret fashion show airs. Marisa Miller is one of Victoria's Secret's veteran supermodels. The lady has killer curves, bombshell hair we can only dream of having, and beautiful, sunkissed skin.

How To: Add colorful plants around a mailbox with Lowe's

Mailboxes don't have to look all lonesome, with only the curb to cheer them up. If you have one of those street boxes on a post instead of a house box, the best thing to do to make a happy mailbox is to give it some company. To improve your home's curbside appeal, take your landscaping efforts to the curb and enhance the area around the mailbox. It's a great way to accentuate your landscape.

How To: Make a Christmas holly felt garland for the holidays

Christmas is coming up, but you've been so busy scoping out presents for friends and family, organizing your annual holiday cocktail party, and working hard for your holiday bonus to pay much attention to decorating your house. What do you do if you're in a bind and just don't have the time to decorate? Watch this video to learn how to make a quick holly felt garland for the holidays.

How To: Choose plants that love shade with Lowe's

If you have a shady yard, you can still have a colorful garden. You just need to pick the right plants that do well in the shade. Caladium is a leafy plant with bright colored red, pink and green leaves. They do not tolerate cold weather and should be brought in over winter. Impatiens are popular annual flowers that grow in the shade. They look nice planted around the base of a tree or in containers. The flowers come in shades of pink, coral, white and red. Fuchsia is a beautiful flowering pl...

How To: Improve any credit score with 3 steps

You should watch this video if you want to improve your credit score with just 3 steps. To improve your credit score: Check your credit report. It is where your score comes from. You can also get a free copy of your credit report once a year at Annual Credit Report. Check it for errors. Timing. If you're going to apply for a loan as the application month approaches, stop charging because if your balance happens to be reported while it's big, it will temporary lower your score. Don't close you...

How To: Mix a Universe cocktail

First introduced to the world at the legendary Studio 54, the Universe won First Prize in the the 1978 U.S. Bartenders Guild Annual Competition. And no wonder. Its beguiling mix of tropical juices and slightly nutty finish are certain to wake up your palate. Fair warning: the Universe is so delicious, make sure you have enough ingredients when your guests ask for one or two more. You will need Midori melon liqueur, vodka, pistachio liqueur, lime juice, and pineapple juice.

How To: Keep flowered edges neat using an edger

If you have a beautiful Annual flower bed or a formal bed with lawn on one side you'll want a clean edge between the two. It not only looks nice but keeps weeds from encroaching into the bed helping reduce maintenance. There are several ways to create a nice edge to your beds. You can use a shovel, digging a line bit by bit but that gets hard on the back. Available materials for edging include, plastic edging and metal strips and wooden edging pieces. The wooden edges can be linked together b...

How To: Make a living willow arbor

Willow can be woven into many shapes or to form a living boundary fence. The reason they are called living is because some of the stems used to create the structure root in the soil and grow to form new shoots. This does mean that annual trimming is needed to maintain the shape, but at the same time it adds interest to the garden. Creating a living structure is very simple to do and all you need is a few pruning tools and a bundle of willow sticks in various thicknesses. With this tutorial yo...

Prev Page