VTC - QuickStart - Managing Financial Data in Excel
Date: 22 October 2013 | Posted by: Soomro
VTC - QuickStart - Managing Financial Data in Excel | 149.34 MB
Microsoft Excel provides an excellent means to track personal and business expenses that will later be recorded on tax forms or reimbursement MyCompany Quarterly 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.
Tax and Personal Finances
Choosing Expense Categories - Schedule A
Choosing Expense Categories - Schedule C
Creating Excel Model - Schedule A
Creating Excel Model - Schedule C
Row and Column Notation
Excel Functions
Excel Formulas
Entering Expenses
Using Links
Annual Reporting for Tax Documents
Business Travel Expenses
Using Excel to Track Business Expenses
Creating Worksheets for Expense Reports
Tracking Days of a Trip
Entering Expenses
Setting Daily Reimbursement Limits
Using Links to Record Unreimbursed Items
Printing Expense Reports
Conclusion
Putting It All Together
Wrap Up and Review
See full article