This video shows how to enter values into cells using Excel macros and Visual Basic. This includes a sample Expense Report that is used in this demonstration. In this demonstration, we will create the macro that inputs a title as "Expense Report", Three columns i.e. "Date", "Item" & "Amount", and the summery field as "Total Expenses", as well as the formulas located at the respective cells. Now, we're going to use two keyboard shortcuts i.e. "Alt + F11" to open-up the VBA window and "Alt + F8...
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 58th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate interest revenue and expense.
If you're driving a commercial vehicle or doing a lot of driving for a company, there are ways to claim deductions on your tax return for actual vehicle expenses. In this video you will learn how to calculate your standard mileage rates to determine how much you will be getting on your tax refund if your employer is not reimbursing you for gas or if you're running a small business.
Living within your means can be done. You don't want to be a slave to the credit card company, do you? Learn what to do to stay out of credit card debt. This how to video will give you the tips. Credit card debt is a slippery slope.
These days, everyone is trying to save money wherever possible. Health care is often one of our biggest expenses and in this tutorial, you will get some expert tips on how to lower your expenses and save money on health care.
June is graduation month, and while for a lot of youngsters that means leaving one phase of their lives behind in order to pursue newer and greater things at college/the workplace, for their relatives and friends that means cards, presents, and money.
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...
In this video tutorial, you'll learn the ancient art of clay tablet making. Back in the old, old, days, before paper and pencil, there were clay tablets. Sumerians used these clay tablets to communicate, record business expenses and more. In this video, you'll learn how to make your own cuneiform clay tablet magazine! Spread the word!
Building a swing arbor is a fun weekend project that can really spruce up the landscape without requiring a lot of out-of-pocket expense. Plus, the project is fairly easy to build, requiring only basic carpentry skills, and can provide years of outdoor enjoyment. The materials for the swing cost about $100, and you can complete the project over the course of two afternoons. For more information, or to get started building your own swing arbor, watch this DIY video tutorial.
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.
How to know how pawn shops work and how to take advantage of them; get expert tips an advice on how to buy, sell, trade, and save money in pawn shops in this free instructional video.
Even getting your hair trimmed at the salon costs a fortune these days, so why not cut back on unnecessary expenses and do the trimming at home? Take a look at this video to learn how to cut edgy side bangs using a razor.
Identity theft typically occurs when someone uses your personal information such as social security numbers, credit card numbers or account information to perform various misdeeds, and you are left to clean up the mess.
In this video, we learn how to develop a competitive advantage. A competitive advantage answers the question "what are you best at." You just need to better than your competitors at what you do in delivering value to your customers. Think about why your customers buy products from you. If you have the competitive advantage clearly identified, it will get you the customers that you want and keep the customers that you have. Put the competitive advantage together by thinking about the company n...
Getting your hair done and dyed at the salon feels luxurious and is as much a rejuvenating, spa-like experience as it is a practical coloring session. But with the economy as it is and hair color appointments costing upwards of $100 average, it's quite a costly expense.
If you're a beauty junkie, you probably go with the "no expense is to be spared" philosophy of purchasing cosmetics. Rather than pick quality or quantity, you go with both.
The best wines will set you back almost as much as a pair of Blahniks on sale, so why not cut expenses and just make your own wine? Watch this beer brewing tutorial to see how to brew hard apple cider which has a wine-like taste.
At stores, imitation plastic or cloth baby booties (to be used to contain party favors or small gifts) can be quite costly, and a backbreaking expense considering all the other more necessary expenditures you're considering when planning a baby shower, including finger food, cake, party favors, and decorations.
Melanie, of Christmas with the Cricket, has an awesome new video from the Simple Card Monday edition. Her video details a valuable tutorial on how to make a Christmas card. All you will need is some paper, pens, stamps and some common house hold tools in order to do this. This is a great tutorial that will ultimately save you money on your holiday expenses this year. Just follow the steps in this useful and entertaining video to get started on creating a nifty looking Christmas card.
See how to choose a tattoo that’s right for you. A tattoo is forever – unless, of course, you want to go through the pain and expense of removing it. So think long and hard before you get one!
In photography, good lighting can mean the difference between an amateur shot and a professional quality portrait. Whether you're taking photographs outdoors or in, using lighting to your advantage creates an artistic, flattering effect.
Becoming better at boffer combat is not a matter of mastering fancy sword moves, it's about being able to force an opening in your opponent's defenses and taking advantage of it without leaving yourself open for a counter-attack. This tutorial shows you precisely how to create these situations and take the most advantage of them.
Learn how to take advantage of Microsoft SharePoint 2010's new social computing tools. Whether you're new to Microsoft's popular content management system (CMS) or a seasoned MS Office professional just looking to better acquaint yourself with the SharePoint 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started taking advantage of SharePoint's social computing features yourself, watch this free video guide.
If you hear a lot of banging coming from your boiler or heating system, you may need to perform a little repair. The banging could be the result of not enough water in your system, but it could also mean there is too much air in your expansion tank. And expansion tank is attached to your boiler and helps regulate the air to water ratio for optimum performance. If the air in your expansion tank expands too much, you may need to release some of the air in order to use your tanks properly and st...
Ilyce Glink with ExpertRealEstateTips tells us about how often home owners ask her "How much should I pay a contractor before he or she starts the job?". The one who will be answering this question is Line Epstein, Vice President of Baker Construction Group. "You should never pay your contractor in full before the entire job is completed" -he says. "Not that he's going to run off with your money, but you want to keep some incentive to get the job done right. You should give a deposit of 5 to ...
This is a tutorial video for the video game Dungeons and Dragons Online (DDO). In his first tutorial video, the cleric Zomm Lightfinger takes you through the quest "Relic of the Sovereign Host" in order to obtain 15 adamantine ore in less than 30 minutes and for less than 1000 platinum in expenses. The step-by-step commentary enables players from almost all classes to acquire their ore and forge one of the fabled Nightforge items in less than an hour. Additional discussion of high-level cleri...
You can take advantage of a few glitches or exploits to earn extra money when playing Fallout: New Vegas. You can either earn the money by playing blackjack and being shameless about resaves, or take advantage of an inventory glitch.
You'll never go hungry again! This cheat works best with Xbox versions of Fable II, and allows you to accumulate infinite money by taking advantage of a glitch in the system. Once you're 30-60 minutes into the game, you can fully take advantage of this cheat.
In this video, you are shown how to apply epoxy to your car area after it's been repaired. Epoxy is a great primer because of its advantages in adhesion and corrosion protection. You can apply one or two coats if you so desire. Watch this video and you'll learn all about the advantages of epoxy primer.
In this next tutorial, you'll be get some advice about reciprocating saws and chainsaws, and which is better to use in certain situations. Each saw has their own advantages when clearing out certain trees or debris on your land, but using the wrong can can damage the plants and yourself. There are many advantages for both, but in no way is a reciprocating saw a replacement to the chainsaw. So sit back and enjoy!
The great thing about photography is that you're able to capture a moment that will be frozen in time forever. There are many different techniques that can be applied to capture specific moments in time, you just need to know which one works best for you. This tutorial describes the depth of field in photography and how to take advantage of it. Enjoy!
This tutorial is a great eye-opener into the world of Microsoft Word. If you thought you could just open Microsoft Word and type, you are not taking full advantage of what the system has to offer. Iain Broome shows you how to use the Document Map feature on Micosoft Word to your best advantage for any writing project. For more video tips on Microsoft Word, search for Microsoft Word on WonderHowTo.
This video uses working simple machines to demonstrate how to calculate mechanical advantage. Suitable for any school program involving simple machines. Demonstrates pulley systems including a chain block.
OpenType fonts are the new standard! Any new fonts you buy today will most likely be in OpenType format and the beauty is that InDesign CS2 takes complete advantage of them. In this video you'll see how to unlock the power of the OpenType fonts you already have!
So you've been given the slip -- the pink slip. Take a deep breath, and do the following. You Will Need
Although Christmas is not a time for pranks and booby traps, but rather quality time with the family, why not have a little fun at the expense of your loved ones? Here's a simple yet effective way to booby trap a Christmas gift. You'll need the help of a balloon, but the end result will be hilarious. Just wait until Christmas morning and everyone is eager to open their presents. That's when the fun begins. Merry Christmas!!!!
Sherwood Dungeon, while lots of fun, is certainly not an entirely glitch-free game. This video shows you seven various glitches in the game, and how to take advantage of them - like walking up a castle wall or getting to the roof.
Becoming a notary can be useful to your business. Check out this tutorial for information for becoming a signing agent in your state. It is much easier than you would think and there a multiple ways to take advantage of your new title. This video will show you exactly how to do all of those things. You won't regret it.
The Eagles may very well be the most played team in the Madden NFL 12, and for good reason--they're the strongest team in the game. Don't worry about forfeiting games when you see them on the other side, with this guide from EA Sports you'll learn how to slow down Michael Vick, use a Sugar Blitz for a strong defensive play, and take advantage of their weak lineback and safety.
This video explains to the viewer the advantages of replacing washing machine hoses. As well as, rather more importantly, explaining how to complete the process. According to the creator the rubber hoses that are standard to most washing machines are subjected to high pressure water for many years. As they are only made of rubber they are apt to break and start leaking. This can cause many thousands of dollars worth of water damage. The creator recommends replacing the rubber pipes with reinf...
