Develop an excel retail or business workbook

Assignment Help Basic Computer Science

Reference no: EM13810457

You will develop an Excel retail/business workbook and show how to use excel in real life.

Project Description

When learning a business tool like Excel, its power and capabilities are best understood when Excel is used to solve a "REAL LIFE" problem.

Many of the features/commands you have learned in class will allow you to create sophisticated workbook applications. You will develop an Excel retail/business workbook. You will deliver a 3 to 5-minute demonstration of your workbook to the class.

Project Requirements

The following list has the features/commands you MUST include in your project workbook. You can/may have to use a feature more than once.

General		Formulas
Name of the workbook		AVERAGE, SUM
Date created		COUNT or COUNTA
Created by		IF, CoutIF
Instructions - brief guidelines for using the workbook (minimum of one clearly written paragraph)		Absolut Cell References, Named Ranges Sorting, Excel Table
		Today(), Now()
Formatting		VLookup
Bolding, italics, etc.		Sum between sheets &
Font coloring		3-D Formulas
Borders/Fill color
Conditional Formatting			Charts
Headers/footers - includes the Name of the workbook, Current Date	Bar or Column Proper labels Modified colors and fonts
Freeze Panes Freeze Top Row	Pie Proper labels Percentages
Pivot Tables and Charts	Work Sheet Protection
Pivot tables w/summary options, filters/slicers	Protected Summary Sheet - Users cannot modify this worksheet

Reference no: EM13810457

Questions Cloud

Directly produce any sales but will reduce operating costs : Thornley Machines is considering a 3-year project with an initial cost of $1,020,000. The project will not directly produce any sales but will reduce operating costs by $640,000 a year. The equipment is depreciated straight-line to a zero book value ..

Techniques in terms of course project : Meredith and Mantel (2012) describe top-down and bottom-up budgeting (pp. 289-292). Evaluate these two techniques in terms of your course project. Address the following questions in your posting:

Theology evolution of religions : Theology evolution of Religions

Using the profitability index when evaluating projects : Gold Mining, Inc. is using the profitability index (PI) when evaluating projects. Gold Mining’s cost of capital is 8.75 percent. What is the PI of a project if the initial costs are $2,371,020 and the project life is estimated as 9 years? The project..

Develop an excel retail or business workbook : You will develop an Excel retail/business workbook and show how to use excel in real life. When learning a business tool like Excel, its power and capabilities are best understood when Excel is used to solve a "REAL LIFE" problem

Differences between three different types of interest rates : In this assignment describe and explain the differences between the three different types of interest rates one from the Federal Reserve, one from a bank for business, and one from any financial institution for a consumer loan.

What are the major concerns for corporations in developing : What are the major concerns for corporations in developing and retaining expatriate employees, especially managers? 250 words and 3 scholarly peer reviewed references in APA.

Common stock of flavorful teas has an expected return : The common stock of Flavorful Teas has an expected return of 16.00 percent. The return on the market is 15 percent and the risk-free rate of return is 3.7 percent. What is the beta of this stock?

Define the kent and kendall visions of intelligence : What are the most important differences between the Kent and Kendall visions of intelligence. Why are these differences so important and worth discussing. Which vision might be most applicable today and why

User Account

All Pages