Excel 2007: Creating and Managing Invoices
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.
- Tracking time using an Excel table
- Adding customer information to invoices
- Filtering the invoice table to find current items
- Dividing data by customers using report filters
(upbeat music) - [Voiceover] 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'll 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 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'll 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.
Excel 2007: Data Validation in Depth45,415 Views
Excel 2007: Working with Dates and Times69,059 Views
Excel 2007: Creating Charts with Dynamic Data87,698 Views
Excel 2007: Advanced Formatting Techniques124,182 Views
Running a Web Design Business: Defining Your Business Structure42,397 Views
Excel 2013 Essential Training6,264,406 Views
Excel 2010 Essential Training6,004,543 Views
PHP with MySQL Essential Training4,274,773 Views
Foundations of Programming: Fundamentals7,748,469 Views