Closed

Excel Midterm

CS302 Midterm Project Part I:

Write a description that completely describes your project to be implemented. Be sure to choose a project concept that will be of personal use to you. (5 pnts)

Midterm Project Part II:

Create the workbook to complete your project. Your project must implement the following technical requirements. (60 pnt)

1. Well formatted with some background color, borders and style

2. Contain a database sheet with at least 10 records of data and at least one calculated field.

3. Use an if() function someplace in your project.

4. Implement a goal seek analysis using absolute cell references and an assumption area.

5. Use conditional formatting on the database sheet.

6. Use two or more of the functions from this list: iferror(), sumif(), countif()

7. Use a database lookup function like VLOOKUP() using a lookup table.

8. Create a filter sheet. This requires a criteria and extraction area with some filtered data

9. Create some scenarios and generate a summary report.

10. Add at least one macro with a button to run the macro.

11. Use solver in some way. Be sure to create an answer report.

12. Add at least two different data validation fields

13. Create 2 charts of different styles using different data. Include a trend line in at least one chart.

14. Add an imbedded image with a link to another web site.

15. Add cell and worksheet protection. Highlight the unprotected cells. Make the password "MIDTERM".

16. Save your project

17. Be sure to add comments to your project workbook pointing to each of the requirements above. Include the requirement number as the first line in the comment. The comment should point to where you implemented each of the technical requirements. This is required for grading purposes. To add comments right click the cell and select the insert comments menu option. If comments are not added to your workbook it will affect your project grade.

Note: I will be doing the project for my budget. Data will be provided once I receive a quote

Skills: Data Entry, Data Processing, Excel

See more: microsoft excel test questions and answers, myitlab excel final exam answers, excel 2013 midterm exam, excel macro diplay chart, excel time delivery chart, excel plot sets chart 2007, excel macro dynamic chart, excel dynamic stock chart dde, excel vbscript update chart, excel vba menu chart, validation fields con php, validation fields chronoforms, excel macro display chart, excel 2003 dynamic chart, excel vba dynamic chart

About the Employer:
( 0 reviews ) United States

Project ID: #15415729

14 freelancers are bidding on average $26 for this job

aimefx

Hi, I am expert in Excel, VBA and Power BI. I can do any type of data analysis and data visualization creating pivot tables, charts, power pivot, interactive Real Time dynamic dashboards and Reports. Relevant Skills a More

$30 USD in 3 days
(40 Reviews)
5.3
asadkhan3533

Please review my profile as i have more than 9 years of experience in excel and vba coding. My last project is example of such work Relevant Skills and Experience Data Entry, Data Processing, Excel Proposed Milestone More

$30 USD in 2 days
(49 Reviews)
5.3
nurnga1218

I can pick more than 5 points. Formatting are not problem at all for me. The Formulas (If, Iferror, Sumifs, Vlookup), I knew it verry well. Goal Seek I can use it too. Also I can create a macro module Relevant Skills More

$30 USD in 1 day
(37 Reviews)
4.4
anzarulislam

Hello... I'm highly skilled in this categories jobs. You can check my profile. You can trust me on this project. I'll complete this project to your satisfied payment. I'm waiting for your response...!

$25 USD in 1 day
(14 Reviews)
4.3
integrahup

Let's work on your MidTerm Project. I've read all your requirements as per stated in the description still you will need to provide the source data Relevant Skills and Experience Ms Excel 2016 /2013 Data Proces More

$20 USD in 1 day
(7 Reviews)
3.6
Zarinaali

CHECK PROFILE Relevant Skills and Experience CHECK PROFILE Proposed Milestones $100 USD - CHECK PROFILE CHECK PROFILE

$100 USD in 1 day
(4 Reviews)
3.2
evancox1

A proposal has not yet been provided

$20 USD in 2 days
(3 Reviews)
2.8
shafeekmohamed

I can do the project perfectly, If you want perfect project please contact me.

$10 USD in 2 days
(5 Reviews)
1.7
waelhaiba

I have 7 experience in financial reporting. professional accountant and bookkeeper. I'm working on MS Excel day by day . Monitor for petty cash daily and Bank Reconciliation monthly. Relevant Skills and Experience I More

$12 USD in 1 day
(0 Reviews)
0.0
NNazir

Hello, The project doesn't seem to be of much worry. I prepared some video lecture which covered most of the requirements you mentioned.. You did not mention when do you want this project completed? Relevant Skills an More

$23 USD in 1 day
(0 Reviews)
0.0
ankitarajpootmca

A proposal has not yet been provided

$25 USD in 10 days
(0 Reviews)
0.0
Meekin007

A proposal has not yet been provided

$15 USD in 1 day
(0 Reviews)
0.0
umanggoswami92

I am currently working with IT field as a MISS team leader.. this is what I am doing every day..

$17 USD in 2 days
(0 Reviews)
0.0
$10 USD in 30 days
(0 Reviews)
0.0