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...
To obtain a work permit, you must first have a job offer from a Canadian employer. To get a job offer, you can apply directly and send your resume to a perspective employer, use an employment agency, or post your resume on employment websites. Next, you must have a labor market opinion. To get an LMO, you have to fill out some forms and submit some supporting documents. This process can take from a few weeks to 6 months to complete. After the LMO is approved, you must then apply for a work pe...
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.
This video is provided by "Betty Sell" from AAA travels. In this video she tells about the international travel and also about the important documents to be carried while carrying out an international travel, that is the international driving permit, commonly called as an IDP. It's very important to carry an IDP while traveling overseas because an IDP acts as an important recognizable form of photo identification which helps us to communicate with foreign authorities. To get more information ...
Interested in jockeying discs? Compact discs? If so, you'll want a CDJ, which will permit you to do with your CDs what your turntable permits you to do with your records. In this tutorial, you'll learn how to set cue points using the Pioneer CDJ1000. For more, and to get started setting cue points on your own Pioneer CDJ1000, take a look!
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.
The purpose of this video is to show how to become a permanent resident in Canada. Some programs are federal and some are for Quebec. The first program is the skilled worker program. The applicant is accessed under a point system and is awarded points for education level, knowledge of English or French, work experience, age, confirmed job offer, and adaptability and you must have sufficient proof of funds. The next program is Family Class Sponsorship. A citizen or permanent resident can spons...
Want to fulfill your dream of becoming an ice cream truck driver? If the idea of rolling around in the sunshine selling ice cream sounds good to you, here's what you need to do.
Pre-production is a much less complex process for an indie film than a big-budget one that needs stars and permits and such, but it's still vital to shooting a good film in a timely fashion. This video will walk you through Ryan from Film Riot's entire pre-production process, including script breakdowns, free casting calls, budgeting, getting a crew and locations.
In this video tutorial, we learn how to use Tweet Auto Post, an application which permits its users to schedule and, later, automatically post tweets to the Twitter microblogging service. For all of the detailsm and to get started using Tweet Auto Post yourself, take a look.
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.
Learn how to force the Windows 7 taskbar to display a preview for each and every one of your Mozilla Firefox tabs upon mouse-over. This home-computing how-to from the people at Tekzilla will show you a quick and easy about:config Firefox hack that will permit you to do just that. For more information, and to get started using this hack yourself, give this clip a look.
Interested in jockeying discs? Compact discs? If so, you'll want a CDJ, which will permit you to do with your CDs what your turntable permits you to do with your records. In this DJ tutorial, you'll learn how to create a buzzy sound effect with the Pioneer CDJ-800. For more, and to get started creating your own sound effects on your own Pioneer CDJ-800, take a look!
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.
Looking for an easy way to share big files over the Internet without having to pay for the privilege? With the right Internet services, it's easy. This home computing how-to from the folks at CNET TV presents an overview of a number of the better and most popular file sharing websites, some of which will permit you to upload files in excess of 1 GB. For more information, and to get started sharing your own big files over the web, watch this free video tutorial.
Some governments and organizations employ proxy servers to filter web content, permitting access to some web sites while blocking others. Here are several ways to get around these censorship policies. This is employed in China with YouTube and many other voices of anti-goverment ideas.
CSS div layers permit you to abandon the traditional MySpace layout by covering it up with a blank slate. Then you can create virtually anything you want to. You can add images, tables, Flash documents—most anything you can think of. For more information, and to get started using CSS div layers on your own MySpace profile, watch this helpful video guide.
There's nothing better than being your own boss some say. If you are ready for the risks and the work, take your passion to the next level and start your own business. Learn how to start your own business with help from this video.
Here's a fun hack! In this clip, we learn of a bug that will permit you to circumvent the passcode lock screen on any iOS 4.1 iPhone 4. For detailed, step-by-step instructions, and to get started using this exploit yourself, watch this video guide.
Looking for a primer on how to create and work with array formulas in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 12th installment in his series of Excel array formula series, you'll learn how to create array formulas with the ROW & COLUMN functions that will in turn permit you to create a set of permanently consecutive integers.
Interested in jockeying discs? Compact discs? If so, you'll want a CDJ, which will permit you to do with your CDs what your turntable permits you to do with your records. In this DJ tutorial, you'll learn how to use the loop function on a Pioneer CDJ turntable. For more, and to get started creating loops on your own Pioneer CDJ-800, take a look!
If you ever use NS lookup in Microsoft Windows Server 2008, you have to permit the machine running it to accept zone transfers. To do so, follow the instructions in this video. This video will show you how to use the name servers tab in DNS to allow machines to receive DNS lookups.
Learn how to turn on and use the Canned Responses tool within Google Gmail. As the name suggests, Canned Responses permit you to create and send form email responses with the click of a button. For all of the details, and to learn how to enable and use Canned Respones in your own Gmail, watch this video guide.
Learn how to turn on and use the Quick Links tool within Google Gmail. Quick Links permit you to create easy-to-access shortcuts to your favorite and most-frequently-read emails. For all of the details, and to learn how to enable and use Quick Links in your own Gmail inbox, watch this video guide.
In this clip, you'll learn how to build a Silverlight application that permits users to switch between two or more pages. Whether you're new to Microsoft's popular web application framework or a seasoned web developer merely looking to improve your chops, you're sure to find benefit in this free MS Silverlight programming lesson. For more information, including a complete demonstration and detailed, step-by-step instructions, take a look.
Want to adjust the Windows Firewall to permit µTorrent? This clip will show you how it's done. It's easy! So easy, that this video tutorial can present a complete, step-by-step overview of the process in about two minutes. For more information, including detailed, step-by-step instructions, watch this video guide.
Root your T-Mobile MyTouch 3G or G1 Android smartphone using the flashrec.apk method, which will permit you to replace your recovery image in a single click. For detailed, step-by-step instructions, and to get started rooting your own T-Mobile Android MyTouch 3G or G1 phone, watch this free video tutorial.
Interested in jockeying discs? Compact discs? If so, you'll want a CDJ, which will let you do with your CDs what your turntable permits you to do with your records. In this tutorial, you'll learn how to spin back on a CDJ turntable while simultaneously setting up cue points. For more, and to get started using advanced spin back techniques on your own CDJ , take a look!
Keynote allows you to make some amazing and creative presentations, but were you aware it allows you to share said presentations just as creatively? In this video, you'll learn to take full advantage of Keynote's export feature, which will permit you to save your work in a wide variety of formats. For more, watch this OS X video tutorial.
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.
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.
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...
How to put windscreen wiper blades in special position which permits release of the blades. It is used for cleaning or replacement of the blades. It can also be useful, in winter, to detach the blades from the windscreen.
Want to make a phone call on an iPhone 4 running Apple's iOS 4.1, but don't know its passcode? Not a problem. In this clip, we learn a simple trick that will allow you to bypass the lock screen entirely and permit you to view the phone's contact list and place phone calls to any number you like. This glitch has been fixed with iOS 4.2, so treasure this hack while it still lasts! This will let you unlock someones password on an ipod or iphone touch.
