Lynda.com - Excel 2007: Creating and Managing Invoices [2009, ENG] torrent

Обучающие видео » Компьютерные видеоуроки и обучающие интерактивные DVD » Офисные программы Microsoft

Lynda.com - Excel 2007: Creating and Managing Invoices

Производитель: Lynda.com
Год выпуска: 2009
Страна: США
Язык: английский
Автор: Curt Frye
Продолжительность: 38 мин
Формат: клипы QuickTime (.mov)
Видео: AVC 960x600 15 fps ~70Kbps
Аудио: AAC 48kHz 2ch 96Kbps
Файлы примеров: присутствуют
Описание: 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.

Topics include:

* 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
[spoiler="Содержание"]
Introduction 01:26
Welcome 00:55
Using the exercise files 00:31

1. Collecting and Structuring Invoice Data 13:48
Collecting the appropriate data 02:35
Structuring the tables 01:26
Combining tables 02:45
Tracking time using an Excel table 04:40
Tracking reimbursable expenses 02:22

2. Creating Invoices Using Excel 2007 09:17
Creating a PivotTable report from Excel table data 01:52
Dividing data by customer using report filters 01:29
Adding customer information to invoices 05:56

3. Creating Invoices Using Mail Merge 06:17
Creating invoices with mail merge 04:06
Filtering the invoice table to find current items 02:11

4. Advanced Invoice Handling 05:27
Calculating interest charges on unpaid items 04:28
Voiding invoices 00:59

5. Printing Invoices 02:21
Printing invoice worksheets 01:39
Printing Word invoices 00:42

Conclusion 00:23
Goodbye 00:23
[/spoiler]
[spoiler="Скриншоты"]

[/spoiler]
Оставайтесь на раздаче!!!
Если на моих раздачах нет сидов, то пишите в личку. Без вашей помощи раздача начнет болеть, хиреть и может даже помереть.