QuickStart! - Managing Financial Data in Excel
by Robert Ekblaw
Start the free chapterMicrosoft 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.<p><i><font color="red">* VTC QuickStart! and MasterClass! courses are available only to registered VTC Online University members.</font></i></p>
Course content
Introduction1 lessons
Tax and Personal Finances10 lessons
- Choosing Expense Categories - Schedule A5:521 credit or ad
- Choosing Expense Categories - Schedule C5:421 credit or ad
- Creating Excel Model - Schedule A7:141 credit or ad
- Creating Excel Model - Schedule C6:431 credit or ad
- Row and Column Notation4:441 credit or ad
- Excel Functions4:511 credit or ad
- Excel Formulas5:251 credit or ad
- Entering Expenses5:361 credit or ad
- Using Links5:321 credit or ad
- Annual Reporting for Tax Documents5:241 credit or ad
Business Travel Expenses7 lessons
- Using Excel to Track Business Expenses4:151 credit or ad
- Creating Worksheets for Expense Reports6:191 credit or ad
- Tracking Days of a Trip6:111 credit or ad
- Entering Expenses7:171 credit or ad
- Setting Daily Reimbursement Limits4:581 credit or ad
- Using Links to Record Unreimbursed Items4:181 credit or ad
- Printing Expense Reports5:011 credit or ad