Microsoft Excel Business Project (365)

microsoft-excel-365 This module provides students the opportunity to take on the role of an intern at a company and update a Microsoft Excel spreadsheet to present financial income data for a meeting.

Phase: Learn & Practice

learn-and-practice

Unit 1: Income Statement (Part 1)

In this unit, students enter financial equations in an Excel worksheet, format the data, and graph the net income results.

Lessons:

Your Internship
Your Task (Part 1)
Implementation Overview
Implement - Enter Calculations
Implement - Format Spreadsheet
Implement - Create a Graph

Unit 2: Income Statement Project (Part 2)

In this unit, students continue with the project by using Excel to perform a financial analysis. They choose options to determine results on gross profit and show how the option they choose affects next year's net income.

Lessons:

Your Task (Part 2)
Implementation Overview
Implement - Option 1, Increase Ticket Prices
Implement - Option 2, Second Run Movies
Implement - Calculate Net Income
Implement - Review and Revise

Back to Catalog