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 .
BIS 155 Week 3 DQ Data Analysis
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 ?
BIS 155 Week 4 DQ Excel Data Exchange Excel 2010 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 .
BIS 155 Week 5 DQ Data Consolidation and What
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 .