Reference no: EM131155315
Individual Excel Project
You should make up your own data for this excel project. You may use different data for some if you want - just explain what data you are using. There are two examples in a file right under the assignment on blackboard.
Create a workbook to contain your worksheets related to this project. Your workbook and worksheets should look professional in terms of formatting and titles, etc. Date the workbook. Name the workbook Excel Project and your first name. Name each worksheet according to the task you are performing (such as subtotals). Put your name on each worksheet.
Include the following in your worksheets:
Use a separate worksheet to show results of each task.
1. Use a minimum of five functions in your first worksheet (such as SUM, MIN, etc.)
2. Create a Chart to help visualize your data.
3. Use the sort command on more than one column. Create conditional formatting along with this sort.
4. Use AutoFilter to display a group of records with particular meaning.
5. Use subtotals to highlight subtotals for particular categories.
6. Develop a Pivot Table and Pivot Chart to visualize data in a more meaningful way.
7. Use the If function to return a particular value.
8. Use the Goal Seek command.
9. Use Excel's Scenario Manager.
10. Note: If you want to add Solver example you will get extra credit. Otherwise omit #10.
11. Either in a separate word document or directly on the worksheet (whatever you prefer) explain each numbered item and worksheet specifically so that I can follow your logic. For example, the worksheet showing functions - what five functions did you use and what is the purpose for each?Explain the data you are using. Make sure your name is also on the word document.
12. Submit your workbook and word document on Blackboard so that I can evaluate the cells.
|
Pricing policies and buyers
: You are a salesperson at a local building supply store. For the past five years, you have dealt with a contractor who constantly asks for discounts on all of his purchases. You have consistently given him discounts in part because this contractor ..
|
|
Phillip seymour hoffman interpretation of father flynn
: Phillip Seymour Hoffman's interpretation of Father Flynn (does he look, sound, and act the same way you interpreted Father Flynn? What does he do differently? Where has he succeeded in creating the character you read from the page and where has h..
|
|
Create a feasibility study for harley-davidson
: The analysis of current strategy and competitor analysis you conducted last module impressed the senior vice president. She now needs you to delve into the brands and analyze them by conducting a business unit analysis and presenting your findings..
|
|
Which ones are subsets of others
: Briefly describe the functions and major components of the central, peripheral, somatic, automatic, sympathetic, and parasympathetic nervous systems. Which ones are subsets of others?
|
|
Create a chart to help visualize data
: Create a workbook to contain your worksheets related to this project. Your workbook and worksheets should look professional in terms of formatting and titles, etc. Date the workbook. Name the workbook Excel Project and your first name. Name ea..
|
|
Describe a time when you experienced effective communication
: Explain the elements that foster effective communication in business. Use technology and information resources to research issues in business. Describe a time when you experienced effective communication in a business environment.
|
|
Government and public health agencies have a role
: Are overweight and obesity conditions an individual and family responsibility, or do government and public health agencies have a role?
|
|
Chiquita leadership ethically defensible
: Are the ethical decisions made by the Chiquita leadership ethically defensible? Explain
|
|
Burlington northern railroad
: How does Mr. Buffett's age affect Berkshire Hathaway's recent strategic moves such as buying Burlington Northern Railroad instead of another large insurance company?
|