BIS155 Course Discussions Week 1-7


BIS155 Course Discussions Week 1-7
Excel was introduced in 1985. Since then, it has become a standard business tool. In this…


SKU: BIS 155 All Discussions Categories: , Tags: , , ,


BIS155 Course Discussions Week 1-7

BIS155 Course Discussions Week 1-7

All Students Posts 265 Pages 

Getting Familiar with Excel Discussions Week 1 All Students Posts – 39 Pages

Excel was introduced in 1985. Since then, it has become a standard business tool. In this thread, discuss the different features of Excel that make it a valuable business tool. In addition, discuss why Excel skills are so important in today’s job market. Many people take Excel for-granted this day in age.  I remember when it didn’t exist.  What did people do before they had such an amazing tool? What was the first electronic spreadsheet named?  It wasn’t Excel.

Indeed, Excel came a long way since many business now a days used it. This is because of many features it offer. Excel spreadsheets are commonly used across business to display financial information and other data relevant to the running of the business. This could be information relevant to the customer relationship management department, sales, marketing or HR. With so many business functions now reliant on IT and the internet, Excel continues to be seen as a vital tool for administration and the effective running of a business. (Microsoft, 2015). Thus, shows that the importance of Excel proved to be an essential factor on many companies and businesses…

Formulas and Functions Discussions Week 2 All Students Posts – 48 Pages

One of the benefits of Excel is the ability to use formulas and functions. Discuss the differences between formulas and functions. Pick a function in Excel and discuss how that function is used to calculate results in your worksheets. Using the following scenarios, discuss how you would apply the Excel functions or create a formula to solve the scenario.

  • You wish to calculate the commission on sales. The commission is 6% on all sales that are at least 20% above cost.
  • You wish to calculate the total pay for an employee who receives regular time for 40 hours, time and a half for 40-50 hours, and double time for hours over 50.
  • You have a list of contracts and due dates for annual maintenance fees. You wish to determine when you have a contract due in the next 45 days and provide a note that warns you that the payment is due.

A Formula is just what it sounds like.  A formula is used to calculate cells, rows, or data within the spreadsheet.   You can create a formula to do exactly what you want it to do.

A Function is a formula that is already loaded in Excel so you don’t have to figure out the formula yourself.   A good example of one would be the SUM function.  One function in Excel that I would use would be the SUM function.  When you use the SUM it can figure out a whole row of numbers and give you the total with out you putting a long formula in the cell…

Data Analysis Discussions Week 3 All Students Posts – 37 Pages

Excel provides many different ways in which to analyze data.  Discuss the different methods by which you can analyze data in your spreadsheet.  Assume the role of a Regional Manager for a retail organization looking at ways to analyze the large amounts of sales data you have.  What are some of the ways Excel can be used to analyze this data?  What are some examples of reports you might want to review?  Using the concepts from this week, how will you determine where to start and what tools can you use within Excel to help you organize everything and make decisions? What types of data might a sales manager need to track?

A good way to use Excel by a Regional manager is to track the sales of each store bi-hourly or every 4 hours to see if any of your stores need more coverage during their respective peak hours. You can apply those sales figures to a chart to easily read your data. Another way is to individually track the sales of employees to see if any employees are struggling to meet their sales quota and train them in their problem areas…

BIS155 Course Discussions Week 1-7

Excel Data Exchange Discussions Week 4 All Students Posts – 30 Pages

Excel provides the capability to exchange data with other applications.  Discuss the different types of ways to exchange data between Excel and other Microsoft applications.  Are there limitations to the exchange process?  How can you exchange data with other applications that are not part of the Microsoft Office Suite?  Discuss how you would exchange data with external data sources such as websites. There are several ways to exchange data between Microsoft Access and Microsoft Excel.  Describe a business scenario where it might be important to have these two popular pieces of software share data?

There are several ways to exchange data between Microsoft Access and Microsoft Excel. To bring data into Excel from Access, you can copy data from an Access datasheet and paste it into an Excel worksheet, connect to an Access database from an Excel worksheet, or export Access data into an Excel worksheet.

To bring data into Access from Excel, you can copy data from an Excel worksheet and paste it into an Access datasheet, import an Excel worksheet into an Access table, or link to an Excel worksheet from an Access table…

Data Consolidation and What-if Analysis Discussions Week 5 All Students Posts – 39 Pages

Discuss and compare the data consolidation and What-If analysis Excel tools. Under what circumstances would you use each of these tools? Do they both serve the same purpose, or is each one used under different scenarios? Give examples of how each can be used. Let’s begin by defining the terms we will be working with this week. What is meant by Data Consolidation?  What are some examples in which you might want to consolidate data?

When you do a What-If analysis it changes the values in the cells and that shows how that change affects the rest of the formulas in the worksheet.  You can use this if you own a company and want to build some budgets with a different amounts of revenue.  You tell Excel the formula to run and then it determines what values to produce…

BIS155 Course Discussions Week 1-7

Bringing it All Together Discussions Week 6 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…

Database Decisions Discussions Week 7 All Students Posts – 35 Pages

Discuss the differences between storing data in Access and Excel.  Why would you use a spreadsheet over a database?  At what point does it become more efficient to store your data in a database rather than a spreadsheet?  If you are deciding whether to use a spreadsheet or database, what questions should you consider? What can a relational database do for a person or company? Access is designed to handle data integrity … How do relational database tables help handle data integrity?

Excel and Access are two applications from the software giant, Microsoft, to deal with tabular data efficiently and conveniently. Access is a Relational Database Management Software or RDBMS that is used to create tables where data can be stored and related to each other. Each of these applications have their own purpose to serve, which they do sufficiently.

Excel is used for paperworks where you can arrange and tabulate data properly for printing or presentations. For this reason, Excel is a staple in offices where a lot of data needs to be collated and tabulated. Access is used as a system of storing data so that it can be retrieved later. It is often set-up so that employees can access it from a few locations and do queries or enter new data when needed. A part of how access works makes this possible. Access does not lock the whole database when it is accessed, it merely locks certain records to prevent the occurrence of errors in the database. Excel locks the whole spreadsheet once it is accessed. Making other people unable to edit other entries or even to add new ones. Because of this, Access can be used by a lot of people at the same time without even noticing any difference.

Excel is also a lot easier to learn since it is meant to be used by a lot of people. The learning curve or Excel  is not really that steep as most of the things you would need to learn are related to word processing. Even the more advanced controls and options do not require a lot of learning. Access is also easy to use when it has been set-up beforehand. But unlike Excel, the learning curve of Access gets pretty steep quickly. To implement the more advanced capabilities of Access, the person who would set-up the database and interfaces would need to know programming.

Knowledge of Visual Basic and SQL is of great help when creating new Access databases.

1.Excel is a spreadsheet application while Access is an RDBMS
2.Excel is usually used for paperwork while Access is used in storing information that can be

accessed by a lot of people
3.Access locks data at the record level while Excel locks the entire spreadsheet
4.Most users of excel do not really know any programming while you need that to take full

advantage of Access

BIS155 Course Discussions Week 1-7