If you use an invoice or order form in Excel routinely, you may come across times when it would be handy to select items from a drop-down list and have other information update automatically. Here is an example.
Welcome to the Vertex42 Blog
Our most recent articles are listed below. To jump to a specific category of posts, see the category list to the right. The links at the top of this page will take you to some of our most popular collections of Excel and Word templates.
Is A Camping Checklist Necessary?
Going camping? Be prepared! Use a camping checklist to help ensure you don’t forget important items.
Make Sharing Easy – Create a PDF
PDF files have been around for a long while now and there is a reason they only increase in popularity – they make sharing documents with others a breeze. Created exactly for this purpose in 1993 by Adobe Systems, the PDF, or Portable Document Format, has lived up to its purpose. Here are five reasons [...]
Tips to Help Plan for a New Baby
Some tips and tools that can help you plan for your new arrival.
Business Startup Costs are Easily Overlooked
Nothing can kill a great business idea and a growing business faster than running out of cash. To get off to a great start in any venture, you should make sure that you have enough funding to cover all your start up costs.
Dropbox Makes Organizing and Collaborating on Documents Easy
Dropbox provides a great solution for working with files from multiple locations and computers, as well as collaborating with others.
10 Ways To Have More Effective Meetings
We’ve all been in meetings that we felt were a complete waste of time. Here are some pointers to help you improve your meetings.
Budgeting Tips for the New Year
Have you made your new year’s financial resolutions? Many people pledge to do better with their finances around this time of year, but they just don’t know where to start.
Start The New Year Out Right With Proper Planning
It’s that time of year again. Whether you are an organizational junkie or a casual planner, kicking off the year on the right foot is important. The fact that you are reading this shows that you want to accomplish this. By planning out this next year, you are living life for the important things instead [...]
How to Use an Invoice Template in Your Freelance Business
As a freelance business owner, one of the first things you’ll want to work out is how to invoice your clients! After all, the success of your business depends on getting paid for the products or services you offer.
How To Use a Timesheet Template in Your Business
A chance for users to share their experiences and give feedback on using timesheet templates in their business.
Why Have a Home Inventory?
If you closed your eyes right now, could you list off every single item in your home that you own? If you’re like most of us, you can’t. Having a familiarity with your possessions is a way to help you keep track of your personal property and be organized. More importantly, having a home inventory [...]
Biweekly Mortgage Payment Plans Uncovered
Find out the inside scoop on biweekly mortgage payment plans, how to choose a service provider, and some of the fees to watch for.
Money Management for Kids – The Family Bank Approach
If you have kids, you’ve probably tried various methods to help your younger kids save and manage their money. We started out using the envelope method, but that wasn’t working for us. The problem with the envelope method was that we never had the cash or change on hand to put into the envelopes. Also, [...]
10 Strategies for Paying Off Your Mortgage Early
If you are interested in getting completely out of debt, paying off your mortgage may be the largest hurdle. Here is a list of strategies for paying off your mortgage early. Most of these strategies can be evaluated using the free Home Mortgage Calculator spreadsheet. With that spreadsheet you can estimate how much overall interest [...]
