BIS155 Course Discussions Week 6

$4.50

BIS155 Course Discussions Week 6
This week will be an opportunity to share ideas and approaches to the Excel course…

SKU: BIS 155 Bringing it All Together  Categories: , Tags: , , ,

Description

BIS155 Course Discussions Week 6

BIS155 Course Discussions Week 6

Bringing it All Together  All Students Posts – 37 Pages 

This week will be an opportunity to share ideas and approaches to the Excel course project.  What are some spreadsheet features you will use to make your spreadsheet professional, readable, reliable, and repeatable?  Which spreadsheet functions and data analysis types do you think will be the most challenging to implement in this project?  What questions do you have about those functions and types of data analysis?

There are many ways to analyze data in Excel. Some of the feature that can be used in Excel is the PivotTable which allows you to take a large amount of data to analyze and create many different tables and highlight the only data you need. As a Regional Manager, I will be able to analyze large amounts of sales data by using Excel; to check the sales, inventory and store information.

By using the concept from this week, first step is to determine by sorting out the stores and their profits. One tools of Excel that is very helpful when looking at large data sets, would be Freezing. Freezing keeps rows and/or columns visible as you scroll through a worksheet…