QuickStart! - Managing Financial Data in Excel Tutorials
Online Contents For This Course
We have made some of the video tutorials for
QuickStart! - Managing Financial Data in Excel
freely available to help you evaluate our training. Click on any of the linked lesson listings below to preview FREE!
Course 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:
|
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) | ||
Course Information
| Course: | QuickStart! - Managing Financial Data in Excel |
| Author: | Robert Ekblaw |
| SKU: | 34302 |
| ISBN: | |
| Release Date: | 2012-02-17 |
| Duration: | 2 hrs / 21 tutorials |
| Work Files: |
Yes |
| Captions: | No |
Subscription / Purchase Information
Visitors to VTC.com will be able to view all introductory videos for each training course.
Free Trial Members will gain access to first three chapters for each training course.
Sign up for a Free Trial
Full Access Members have full access to VTC.com's entire library of video tutorials.
If you are already a member, please login here.
United States
Email this Page
Send us Feedback