MS Excel

MS Excel Applied Tech

Course Syllabus

 Worksheet Building

• Projected Budget for Cape Cod Arts Council
• Loan Amortization to Lease or Buy a Car
• Planning a Budget for a European Vacation
• Independent Challenge/ Assessment

Workbook Linking

• Simple Payroll for The Marina Cafe
• Record of Earnings for a Freelance Photographer
• Travel Expense Report for Feature Plus Online
• Independent Challenge/ Assessment
  

Charting 

• Course Grades Analysis for Marketing 200
• Regional Sales Analysis for Data Time Books
• Spending Analysis for Greg Barr
• Independent Challenge/ Assessment

Financial Analysis

• Savings Plan for Donna Burgess
• Investment Analysis
• Mortgage Options for the Watson Family
• Independent Challenge/ Assessment

Data Analysis

• Inventory Report for Premium Videos
• Customer Profile for Travel France
• Research Report on Internet Providers
• Independent Challenge/ Assessment

Predictions

• Sales Forecast for Books’ n ‘ Beans
• Sales Report on Island Resorts
• Home Renovation Project
• Independent Challenge/ Assessment