QuickStart! - Managing Financial Data In Excel Training Course

QuickStart! - Managing Financial Data in Excel Training

CD Contents For This Title

All the chapters and lesson contents of QuickStart! - Managing Financial Data in Excel are listed below.

To help you evaluate our training, we have made some of the tutorials for QuickStart! - Managing Financial Data in Excel freely available. Click on any of the linked lesson listings below to preview FREE!

Title Description

Microsoft Excel provides an excellent means to track personal and business expenses that will later be recorded on tax forms or reimbursement reports. This practical VTC QuickStart! course, led by long-time budget and organizational tutor Robert Ekblaw, contains step-by-step instructional videos to help anyone create Excel spreadsheets to make tracking their financial expenses quick and easy. Sample files are also included to help get you started.

* VTC QuickStart! and MasterClass! courses are available only to registered VTC Online University members.

Choose your media type:

To view the Free Tutorials listed below, you must have QuickTime installed. Please note that the online free samples have been compressed for quicker downloads. Purchased CDs have higher sound and video quality.
Monitor resolution needs to be set to at least 1024 by 768 to view the entire movie.

Hide This

Introduction
	Why Use Microsoft Excel to Manage Finances	(04:32)
Tax and Personal Finances
	Choosing Expense Categories - Schedule A	(05:52)
	Choosing Expense Categories - Schedule C	(05:42)
	Creating Excel Model - Schedule A	(07:14)
	Creating Excel Model - Schedule C	(06:43)
	Row and Column Notation	(04:44)
	Excel Functions	(04:51)
	Excel Formulas	(05:25)
	Entering Expenses	(05:36)
	Using Links	(05:32)
	Annual Reporting for Tax Documents	(05:24)
Business Travel Expenses
	Using Excel to Track Business Expenses	(04:15)
	Creating Worksheets for Expense Reports	(06:19)
	Tracking Days of a Trip	(06:11)
	Entering Expenses	(07:17)
	Setting Daily Reimbursement Limits	(04:58)
	Using Links to Record Unreimbursed Items	(04:18)
	Printing Expense Reports	(05:01)
Conclusion
	Putting It All Together	(02:31)
	Wrap Up and Review	(03:03)
Credits
	About the Author	(05:18)

Email this Page

Send us Feedback

Title Information / Pricing

Title:	QuickStart! - Managing Financial Data in Excel
Author:	Robert Ekblaw
SKU:	34302
ISBN:
Release Date:	2012-02-17
Price:
Duration:	2 hrs / 21 lessons
Work Files:	Yes
Captions:	No
Compatibility:	Vista/XP/2000, OS X, Linux QuickTime 7