Start learning with our library of video tutorials taught by experts. Get started
In Excel 2007: Creating and Managing Invoices, Microsoft Most Valuable Professional Curt Frye shows how to set up an efficient and flexible invoice management system. As part of the instruction on how to design a custom invoice in Excel, Curt explains how to use a PivotTable to put each customer's information on its own worksheet. If Word is the preferred method for creating an invoice, Curt covers how to use Word 2007's Mail Merge function to work with an Excel sheet. He also outlines some advanced tips, including calculating interest on unpaid items and tracking invoices. Exercise files accompany the course.
(Music playing.) Hi! I'm Curt Frye. Welcome to Excel 2007: Creating and Managing Invoices. In this course, I'll show you how to set up a flexible and efficient invoice management system in Excel 2007. I will begin by describing the data you should collect and show you how to design and construct Excel tables that enable you to combine data from several tables into a single entity. Then we'll show you how to use a PivotTable to put each customer's information on its own worksheet.
If you would prefer to create your invoices in Microsoft Word, I will show you how to use Word 2007's Mail Merge capability to transform your Excel data into a series of invoices. Finally, I'll show you a series of advanced invoice management techniques, such as how to include unpaid items in an invoice, calculating interest on unpaid items and tracking invoices you create. Let's get started with Excel 2007: Creating and Managing Invoices.
There are currently no FAQs about Excel 2007: Creating and Managing Invoices.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.