* The first page should be a cover page with hyperlinks to the other pages and a picture in the background.
* The second page should be a dashboard.
* All subsequent pages should display every tool we have used throughout the semester, including a screen shot of your data model measures and calculated columns. In the data model, create measures using CALCULATE, ALL, FILTER, and DISTINCTROWS (at least). You should be using the measures in your pivot table (at the least).
* include relative absolute and mixed cell reference
* use all the summary statistics (sum, average, min, max, count, etc.)
* use at least two different instances of date and time functions
* use at least three different formats such as number, date, custom etc.
* use at least three different instances of nested if functions
* use vlookup and index/match functions
* create and use range names and use them in formulas
* have at least 7 charts with axis names, chart title, etc. describing the data
* use data bars
* use at least three instances of conditional formatting, one of which needs to be custom formatted
* design at least 2 tables
* design at least 4 pivot tables
* freeze panes
* text boxes to explain
* name your sheets and give them colors
* sort the table at two levels or more
* use the subtotal function
* have grouped data
* have at least four relevant pivot tables with at least two calculated fields (measures) and a calculated item
* have a slicer available for the pivot table
* create a one variable data table
* create a two variable data table
* use solver (with saved and summarized scenarios)
* use advanced filters
* use the database functions
* use the sumif(s), countif(s), averageif(s) functions
* use rank, percentrank, quartile, frequency, stdev, and correl functions
* create a histrogram
* at least four different formulas using arrays
* at least two cases of data validation
* use dynamic charts connected to lists
* use some VBA (even just something simple)
* use at least 4 different types of buttons (non-VBA)
TOPIC:
You work for a government agency, and although you have been there for fifteen years, your boss only recently came over to you and asked you to actually do some work.At first you weren’t sure what he was talking about; after consulting with some friends, you remembered that supposedly that is what you are being paid for.Thankfully, you have been very keen to fiddle around with Excel in-between checking email, Facebook, and Halo.Your boss said that the government has a spent a lot of money on a huge housing project which is now empty. Your job, should you choose to accept it, is to create an ad campaign to entice people to move in.You must use government statistics to decide how, where, what when and why to target certain neighborhoods, etc.You must detail and present the reasoning for your plan with clear and precise procedural steps of how you arrived at your conclusion.
The post * The first page should be a cover page with hyperlinks to the other pages and a appeared first on Skilled Papers.