Week 1 to Week 7 - All Discussions Bundled:
BIS 155 Week 1 Discussion | Getting Familiar with Excel --- $7.00
BIS 155 Week 2 Discussion | Formulas and Functions | Version 1 --- $7.00
BIS 155 Week 2 Discussion | Formulas and Functions | Version 2 --- $7.00
BIS 155 Week 3 Discussion | Data Analysis Tools --- $7.00
BIS 155 Week 4 Discussion | Data Consolidation --- $7.00
BIS 155 Week 5 Discussion | Data Consolidation --- $7...
DQ: Getting Familiar With Excel (graded)
Excel was
introduced in 1985. Since then, it has become a standard business tool.1. Discuss and explain at least six different (unique)
features of Excel that make it a valuable business tool.2. Discuss what type of Excel skills would be
important in today’s job market and why. Be specific.
Note: In addition to the Microsoft Excel 2016 overview
in the Course Home section, there are many Excel resources in addition to your
text on the Web...
DQ: Formulas and Functions (graded) - Version 1
One of
the benefits of Excel is the ability to use formulas and functions. 1. 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. Review your classmates’ posts to make
sure that you’re not duplicating formulas or functions already discussed. Using
the following scenarios, discuss how you would apply the Excel functions or
..
DQ: Formulas and Functions (graded) - Version 2
One of
the benefits of Excel is the ability to use formulas and functions. 1. 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. Review your classmates’ posts to make
sure that you’re not duplicating formulas or functions already discussed. Using
the following scenarios, discuss how you would apply the Excel functions or
..
DQ: Data Analysis Tools (graded)
1. Excel provides many different ways in which to
analyze data. Discuss the different methods by which you can analyze data in
your spreadsheet. That is, try an Internet search for “data analysis with
excel,” or use some of the methods you learned in this week’s lesson. (Please
don’t use the same methods. Show your research h and creativity skills.) 2. Assume the role of a regional manager for a retail
organization looking ..
DQ: Data Consolidation (graded)
1. Discuss and compare the group
summations and consolidation tools used with Excel. You may need to look up
(research) the group summations.
2. Under what circumstances would you use
each of these features? Do they both serve the same purpose, or is each one
used under different scenarios? Give examples of how each can be used...
DQ: Specialized and Statistical Functions (graded)
1. Discuss and compare the the specialized and
statistical functions in Excel. You may need to research your answer.2. Under what circumstances would you use logical and
lookup functions? What financial and statistical functions exist for use? Give
examples of how each can be used.
Please
include your research references in APA format...
DQ: What-If Analysis (graded)
Life is full of questions and each question deserves a good answer. Let’s explore the What-If Analysis tools available in Excel.
Explain how these tools are used to assist with solid decision making. Give examples of how each of the What-If Analysis tools can be used practically.
Please include your research references in APA format...
Expert Tools (graded)
1. Excel shares very well with other applications. Why
does it import data so easily from other external sources? What features make
it easy to manipulate this imported data?
2. Adding a macro to an Excel workbook is almost like clicking the “Easy”
button. They can automate very simple tasks. Why are people often intimidated
by macros?..