fbpx

Excel workbook project | Business & Finance homework help

Don't use plagiarized sources. Get Your Assignment on
Excel workbook project | Business & Finance homework help
Just from $13/Page
Order Now

Excel Workbook Project
Description of the Study:
Mr. Johnson is a 5th grade teacher. Up until this year, he has regularly tracked information about his students using notebooks, index cards and his excellent memory. When it came time to provide reports cards, attendance records or other reports such as honor roll information or class rosters – he did these by hand. This project will create an easy to use application to electronically collect information about his students and then generate interesting and required reports.
The information below can be used as a guideline in creating and completing your project.

Create worksheets that will contain excel lists that will track (but not limited to)
Student Data
Attendance Data
Class Data
Grade Data
Lists should share/reference data across worksheets (where appropriate)
Create tables from lists use table formatting
Use of formatting (styles, conditional, table formatting, numbers, percentages, text, etc.)
Use functions to perform useful calculations:
Create at least 3 different formulas
Utilize relative, absolute and mixed cell referencing (where applicable)
Use at least 3 different functions including
Use the Vlookup function at least once
Create at least one conditional and one nested If function
Create interesting charts to showcase the data
Create at meaningful at least one chart for each worksheet of data. Be sure to include a call-out object on your chart to being attention to the chart’s meaning.
Create at least 1 combination chart.
In one of your worksheets add a column for data bars sparklines (hint: if you have a worksheet of students grades this would be an excellent place to use data bars or sparklines)
Utilize sorting, filters and subtotals
Create at least 2 interesting pivot tables and a related pivot chart for each pivot table
Create one summary worksheet that uses 3-D references to “collect” data from the other worksheets in the workbook (hint: if you have separate worksheets that collect data about a student’s grades, attendance, and demographic data – reference this data to create a “report card” summarizing a student’s progress)
Use named ranges in at least one of the worksheets
Create validation on selected cells to ensure the integrity of the data
Create at least one macro to automate a process within the workbook (hint: automate the print preview of a particular cell range)
Create buttons to manage the macros
As appropriate all data and charts should be formatted using formatting concepts learned in the text. Themes and styles should be taken advantage of to enhance the appearance the content.
Save the project as: Excel Project-YourName
This project is worth 100 points.

What does it consist of?
As you complete each chapter in the textbook you will learn new concepts in Excel. Each of these concepts should be applied to your design. For example, if the chapter covers the use of logical functions, you must aptly apply instances of using logical functions to your design – and so forth

You should at the very least include:
3 or more related sheets of data, relating/referencing the data where possible
Use of formatting (styles, conditional, table formatting, etc.)
Create at least 3 different formulas
Use at least 3 different functions including at least one conditional and one nested If function
Utilize relative, absolute and mixed cell referencing
Create at least 3 meaningful charts. Be sure to include a call-out object on your chart to being attention to the chart’s meaning.
Create at least 1 combination chart.
In one of your worksheets add a column for data bars sparklines (hint: if you have a worksheet of students grades this would be an excellent place to use data bars or sparklines)
Creating lists of data on your worksheets
Utilize sorting, filters and subtotals
Create at least 2 interesting pivot tables and a related pivot chart for each pivot table
Create one summary worksheet that uses 3-D references to “collect” data from the other worksheets in the workbook (hint: if you have separate worksheets that collect data about a student’s grades, attendance, and demographic data – reference this data to create a “report card” summarizing a student’s progress)
Use named ranges in at least one of the worksheets
Create at least one macro

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Homework Writing Services
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
Testimonials
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Computer science
Good paper approach.
Customer 462387, April 4th, 2022
Technology
I want to say, "Thank you so much!" to the writer that completed the revision to my specifications. Although there are slight changes that need to be made, I am satisfied with the final product.
Customer 452455, January 19th, 2023
Healthcare & Medical
Excellent work!
Customer 463337, November 18th, 2022
Business and administrative studies
GOOD work.
Customer 463105, June 27th, 2022
Finance/Acc related
Great job!
Customer 460073, August 14th, 2022
Military
Good work.
Customer 456821, June 22nd, 2022
Military
excellent work
Customer 456821, August 14th, 2022
IT
Good job. Few edits made
Customer 463245, November 16th, 2022
Nursing
Several grammar issues identified.
Customer 462821, April 6th, 2022
Psychology
Good job.
Customer 453707, May 8th, 2022
Business and administrative studies
Good job.
Customer 459305, April 6th, 2022
Education
Nice try.
Customer 452441, April 19th, 2022
11,595
Customer reviews in total
96%
Current satisfaction rate
3 pages
Average paper length
37%
Customers referred by a friend
OUR GIFT TO YOU
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat