execl assignment 2.1

Attachments

Documentation

New Perspectives Excel 2019 | Module 10: End of Module Project 1
Peak Partners
ANALYZE DATA WITH POWER TOOLS
Author: Richard Feliz
Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website.

Revenue History

Revenue 2000 – 2021

Sheet4

Date Monthly Revenue: 2020 – 2021 Forecast(Monthly Revenue: 2020 – 2021) Lower Confidence Bound(Monthly Revenue: 2020 – 2021) Upper Confidence Bound(Monthly Revenue: 2020 – 2021)
1/31/20 $355,700
2/29/20 $371,100
3/31/20 $372,100
4/30/20 $413,700
5/31/20 $442,600
6/30/20 $451,100
7/31/20 $432,100
8/31/20 $460,700
9/30/20 $370,600
10/31/20 $453,200
11/30/20 $481,000
12/31/20 $426,100
1/31/21 $426,400
2/28/21 $423,400
3/31/21 $440,200
4/30/21 $476,600
5/31/21 $489,900
6/30/21 $496,400
7/31/21 $490,200
8/31/21 $496,400
9/30/21 $516,400
10/31/21 $549,900
11/30/21 $593,000
12/31/21 $606,300 $606,300 $606,300 $606,300
1/31/22 $519,420 $468,033 $570,807
3/3/22
3/31/22
5/1/22
5/31/22
7/1/22
7/31/22
8/31/22
10/1/22
10/31/22
12/1/22
12/31/22

Monthly Sales

Monthly Sales
Date Monthly Revenue: 2020 – 2021
1/31/20 $355,700
2/29/20 $371,100
3/31/20 $372,100
4/30/20 $413,700
5/31/20 $442,600
6/30/20 $451,100
7/31/20 $432,100
8/31/20 $460,700
9/30/20 $370,600
10/31/20 $453,200
11/30/20 $481,000
12/31/20 $426,100
1/31/21 $426,400
2/28/21 $423,400
3/31/21 $440,200
4/30/21 $476,600
5/31/21 $489,900
6/30/21 $496,400
7/31/21 $490,200
8/31/21 $496,400
9/30/21 $516,400
10/31/21 $549,900
11/30/21 $593,000
12/31/21 $606,300

Positions Data

Positions Pivot

Positions PivotTable

Revenue Data

Revenue by State

Revenue by State
0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *