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
|