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...
You can create a calendar for your computer using VB.net. It is extremely easy and very quick to make this for yourself. First you're going to select 'month calendar' and click that into your form area. Now center the box closer to the calendar, and change the name of your application to monthly calendar. Now all you need to do is test the application. Go up to the Start Debugging button and make sure everything is good with that. That's all you need to do-now you have your very own little ca...
In this video, ExcellsFun takes you step by step on how to calculate your employee payroll using an excel spread sheet. ExcellsFun teaches you how to take the base pay of various employees' salaries and determines how much you are paying them over a week, month, and year. Excellsfun also shows you how to incorporate various pay periods including weekly, semi-weekly, bi-weekly, and monthly on the same form using the same calculation for the entire spread sheet. After watching this video, you w...
Want to get more from the raw data you're entering into your Excel worksheets? Now you can create two distinct pivot tables in Excel comparing, for example, monthly and quarterly sales data. Not familiar with the pivot table? Pivot tables summarize spreadsheet input by counting, sorting and totaling data within a list and providing at-a-glance computations within the same sheet. Become an expert on the subject within 5 minutes and 24 seconds by following easy to understand instructions narrat...
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...
This video demonstrates how to sharpen a carbon steel knife using a whet stone. Depending on how much you use the knife and how you use it, the knife might need to be sharpened once a month or every other week. First the whet stone should be lubricated using water. Then place the knife on the whet stone at an angle as shown in the video and drag it up and down while applying ample pressure to sharpen it. Do not twist the knife. Depending on the hardness of the knife and the roughness of the w...
Check your car's automatic transmission fluid monthly! This will take a few minutes, but will increase the lifetime of your vehicle considerably. Just watch this automotive video tutorial to see how to check and add transmission fluid in your car.
In this tutorial, we learn how to make a histogram chart in Excel. To create a vertical histogram, you will enter in data to the chart. Then, highlight all of the data and go to "insert", "chart", then choose a regular column chart. Grab a regular 2D column and then make sure your values are correct. Then, right click and go to "chart options", then take the legend off. Now, make these columns all touch each other by right clicking over the columns and formatting them. Go to "options" then ch...
Before watching this video, we thought there was only one type of butter: The kind you buy in sticks or in plastic containers at the grocery store and toss into all your foods for extra flavor. But apparently butter is a much more complex foodstuff than we thought.
This video in the Software category will show you how to remove pimples and wrinkles in Photoshop. Yanik from Yanik’s photo school presents this video. Select the photo you want to work on. First you duplicate the layer by ctrl+J or select from the dropdown menu. You start off with removing those pimples that you want to remove completely. Select the spot healing or the regular healing brush. Yanik prefers the regular healing brush. Also choose a small brush size. To select a source point, ho...
In this Photoshop tutorial, learn how to convert regular photos into works of art that create a painted on effect. By using the right brush tool, a regular picture can be made to look as though it was painted onto a canvas with real brush strokes. This tutorial shows us how to use different types of brush presets loaded in Photoshop in conjunction with a new layer to create a canvas effect. The result is photo converted into a painting.
The heavy chain stitch used in hand embroidery is a variation of the regular chain stitch, but it creates a wider, thicker chain stitch band. It's an easy stitch to execute. When you want a bolder line, you can substitute it for the regular chain stitch. This video tutorial will show you the basic concept of creating a heavy chain stitch band. Watch this video from Needle 'n Thread to see how it's done.
This tutorial uses footage from the demo version of Madden NFL 12, but it should work just fine for the retail versions of the full game. It demonstrates how to successfully execute a Surprise Onside Kick. If you're looking to surprise your opponent, try this off from the regular kicking formation and see how many yards you can gain on either the Xbox 360 or the PS3.
Make your own earrings out of buttons! Use some vintage buttons, or cover some regular buttons with pretty fabric. All you will need are the buttons, some hot glue and a few basic jewelry making supplies (earring posts and backings).
Shooting good footage with handheld cameras that wiggle, bounce, and fall onto rocks on a regular basis is tough. Sometimes, though, you may want to make it appear as if film that you've shot with tripods and such was actually shot with a handheld, like in some horror films. This video will show you how to create a fake camera movement effect in After Effects, giving your professionally-shot film just enough of that vérité quality.
Regular hexagons are so blah, so amp up the tried and true geometric shape (and kindergarten building blocks toy) by adding a whole new dimension!
Buttermilk is a great thing to have around in your kitchen. Unfortunately, most of us don't have buttermilk on our regular grocery list, so those buttermilk pancakes will have to wait for another day. Think again! You can easily make tasty buttermilk alternatives with common refridgerator items. This video will show three easy ways to make a buttermilk substitute.
PixelPerfect teaches you everything you need to know about being a digital artist. Learn tips and tricks to turn your regular vacation photos into works of art worthy of museums.
Bokhara couching is a filling technique used in surface embroidery. Unlike regular couching, Bokhara couching uses only one thread, which serves as both the laid thread and the couching thread. Watch the video from from Needle 'n Thread to see how it's done.
Following the success of Mimic Baby (sign language for babies) Selena Lohan developed Mimic Mutt - sign language for dogs. It turns out it's easier to communicate with your dog using regular sign language than voice commands. Watch the video to find out more.
Learn to create this beautiful paper flower garland by watching this video. You can make it out of origami or regular construction paper.
Kind lady at CoolKarma.com teaches you how to toilet train your cat in four steps with this instructional video. Her delivery sounds like a joke, but the content is rich and I'd imagine it works. Watch this video pet training tutorial and learn how to teach a cat to use a regular toilet, instead of a litter box. It's eco-friendly and less work for you!
While a new museum to house the original torch of the Statue of Liberty is under construction on Liberty Island and scheduled to open in May 2019, New York Times readers can now view the sculpture in their own space through augmented reality.
A team of academics from three different universities and two private companies have just discovered a new vulnerability that affects almost every Android device since 2012. The vulnerability is known as RAMpage, and it could be used to gain complete control over the device.
This video shows how to knit a stitch through the back loop. It's the way you can twist your knit and tight the fabric by stitching through the back loop.
In this tutorial, we learn how to install dual exhaust on your tractor! First, find the exhaust strip on the tractor, then detach the muffler and slip the regular pipe into the muffler. After this, get a 3/4" pipe and slip it up into the other pipe and well around it. It should come to the bottom of the tractor. Next, take a bushing and connect it to the elbow pipe. Connect a short pipe and connector to this, then connect a long straight pipe that goes into the dead center of the bottom of th...
You can do the basic engine care - such as changingJust like a car, a lawn tractor is an expensive piece of hardware that should be properly maintained on a regular basis. Not only does it need a regular oil change and tune up, but it needs to be cleaned as well in order to maximize its efficiency.
Tony Hawke and Eric Koston both define a hard flip and then demonstrate it. It is a flip of the skateboard while going on a flat surface, like a parking lot. Push down with your back foot, apply pressure on one side, then get your feet out of the way (by jumping) to allow the board to flip, then land back on the board (all while moving, of course). Apply a quick hard turn at the end to compensate for over-rotation. Tony and Eric joke around about Tony's inferior hard flips but he's a vert ska...
This video tells us the method to make buttermilk from raw milk. This procedure has many steps. We start by taking the raw milk in the first step. This should be carefully measured. Take a pound of milk for our purpose. Purchase a regular buttermilk from the grocery store. In the next step, take about a teaspoon of buttermilk bought from the grocery store and add it to the raw milk kept in the jar. Mix the added buttermilk and the raw sugar thoroughly. Leave the mixture overnight to sit. This...
In this video tutorial, viewers learn how to do a switch kick-flip on a skateboard. It is the same as a regular kick-flip, except you switch your stance. Users should be able to perform a regular kick-flip before attempting this trick. Start with the front foot near angled near the bolts and back foot on the tail of the board. Pop the tail hard and flick the front foot outwards. Make sure that your weight is centered and do not lean to far back or forward. This video will benefit those viewer...
In this video tutorial, viewers learn how to perform the vertical or regular suplex wrestling move. Begin by setting up the move with a toe kick to the opponent and then wrap your arm around the opponent's neck with a light grip. Then put the opponent's arm loosely around your neck. Grab the opponent's attire as they hold onto your hip. Then both you and your opponent need to crouch together and push up. This video provides a visual demonstration for viewers to easily follow along. This video...
Childcareland demonstrates how to make a cupcake shaped book in this video. First, make a pattern page from a regular piece of paper. It should be designed like a cupcake. Place the designed pattern on top of a thicker paper like construction paper or card stock. Place five pages of regular paper behind the thicker page and finally place another thicker page at the back of the stack. Glue the cupcake pattern to the top, thick page, slightly to the left side. Then staple down the length of the...
In this video you learn to make earrings out of guitar picks. You will need round nose and regular pliers, wire cutters, 2 regular picks, bead reamer, earring hooks, jump rings, and long silver strands. Use the bead reamer to make a nice clean hole on the top edge of the guitar pick. Use the jump ring through the hole you just made to attach the silver strand. This makes the earrings dangle. On the other end of the silver strand connect the earring hook with another jump ring. This completes ...
Learn how to make a homemade kite with this video. To do this you will need a regular plastic bag, some plastic straws, string and scissors. Begin by using the scissors to cut the bag in half, around the edges. Once you have this, make a rhombus shape out of it. You will need five straws and tape. Use one straw for the top and two straws on each side. Make sure that these two sides are the same side. Add clear or regular tape to stick the straws to the plastic bag. Lastly, tie the string at t...
Cleaning makeup brush rolls can be quite challenging and frustrating. MakeupByRenRen teaches us an easy and quick technique on how she cleans her sigma makeup brush rolls. Things you will need: an oil-based facial cleanser or a regular olive oil and paper towel. Grab a paper towel and damp it with your oil-based facial cleanser or regular olive oil. Gently rub the paper towel on the surface of your dirty makeup brush rolls. Make sure that you go in every direction to effectively remove all th...
Our host Dawn teaches how to use the Versa Mark resist technique when stamping a card. Dawn teaches the technique on a Christmas card to create a snowflake background. The basic idea behind this technique is that the Versa Ink is clear and will resist any other ink you put down, so you can stamp a pattern and then go over with a flat coat of regular ink, and you will be left with a white pattern where you made the Versa Ink stamps. To complete this specific craft, you will need a Versa Mark i...
This video goes back to basics, using regular pencil, pen and colored pencils to create a manga female figure. He begins by drawing basic lines and shapes of the torso with pencil, then adding legs, arms and marking the joints. He adds detail to the body and fills in the shapes of the muscles. He then adds the head shape and fills in the facial details and hair before adding detail to the hands and fingers. He continues with the clothing, before going over all the lines with a black ink pen. ...
See how to do Salah Prayer for Muslims by Sheikh Adly, with instructions in English. Sunni way!
Your first bank account can be exciting and confusing at the same time. Check out this video and learn how to manage your money and accounts so you don't wind up in the red. You don't have to earn an MBA to make good financial decisions; this video offers plenty of suggestions to keep your accounts on track.
To make its services more accessible to regions with limited bandwidth, Spotify has rolled out with a leaner, stripped down version of its music streaming app. The aptly named Spotify Lite has been released for Android devices in 36 countries in Africa, Asia, and Latin America, but you can try out the app right now thanks to a simple workaround.
