excel and powerpoint project

  
A. Focus of the project
Project Development
You should select a business related topic (i.e. a decision on purchase or lease a car, a decision on rent or purchase a house, manage a business with multiple divisions (annual sales, expenses and profit, a professor’s gradebook, Decision on the choices of colleges, managing a student club and running a business using database to manage all the record (i.e. project, customer and suppliers), and managing a scholarship fund, and so on. The type of project topic should be clearly defined.
B. Skills applied and expanded for your final project
The following outline is the suggested criteria to be addressed within the project. They are guidelines only, and may be modified as appropriate, following student consultation with the instructor.
1. Creating a worksheet and Chart
2. Use of formula, functions and formatting
3. Working with large sheets
4. Using SUM, AVERAGE, MIN, MAX, Round, and PMT functions
5. Working with What If analysis and Vlookup and/or PMT functions 
6. Working with multiple worksheets
7. Using database functions in excel (creating, sorting and query a table and create a report)