GETTING FAMILIAR WITH EXCEL
GETTING FAMILIAR WITH EXCEL
Excel was introduced way back in 1985. Since then, it has become a standard business tool.
List one or more unique features of Excel that make it a valuable business tool. Explain why you believe these features are valuable.
Be sure to read your classmates’ posts and see how many features you can find that haven’t been listed yet.
Note: In addition to the Microsoft Excel 2019 overview in the Course Home section, there are many Excel resources on the Web that can complement the resources available to you in this class. Try an Internet search on Excel 2019 Features and sift through some of the resources. Make sure you credit your sources.
BIS155 Data Analysis With Spreadsheets With Lab
Week 2 Discussion
CREATING AND EDITING CHARTS
Excel can create many different kinds of charts. The variations within each chart type are almost limitless. Charts provide a visual representation of the data selected and often are a needed element to help others understand the data from a new perspective. Let’s illustrate the various types of charts. Pick a chart and provide a description and a pictorial example. You can find an example online or create one of your own. If you find an example online, it will need an APA citation. If you create an example of your own, it does not need an APA citation.
Review your classmates’ posts to make sure that you’re not duplicating charts already discussed.
BIS155 Data Analysis With Spreadsheets With Lab
Week 3 Discussion
DATA ANALYSIS TOOLS
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 Organizing Data With Excel. You can also do a search using some of the Excel tools you learned in this week’s lesson.
Note: Please don’t use the same methods. Show your research and creativity skills. One research post is required this week. Make sure it is unique. Please also make certain to focus on analysis methods from Chapter 4. We will tackle statistical analysis during Week 5. This can be quickly verified using the search tool in our discussion.
BIS155 Data Analysis With Spreadsheets With Lab
Week 4 Discussion
DATA CONSOLIDATION
Discuss and compare the various grouping and consolidation tools available in Excel.
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.
One of your posts requires research on data consolidation tools this week. Your research post should be unique. Please include an APA citation for any content used from an outside source.
BIS155 Data Analysis With Spreadsheets With Lab
Week 5 Discussion
SO MANY FUNCTIONS
Functions in Excel are grouped for easy reference. Locate the Insert Function button (Fx button) to bring up the Insert Function dialog box. How many different ways exist to look for a function? What are they? Select one of these functions and provide information on what it does and what it needs to work properly. Make sure you choose a unique function.
Please include your research references in APA format.
BIS155 Data Analysis With Spreadsheets With Lab
Week 6 Discussion
DATA VALIDATION
This week we will learn about the many kinds of data validation that exists for Excel workbooks. Do some research and find a resource about data validation and why it is important to your work. How many different ways are there to validate the data that gets into a workbook? Any outside resource needs an APA citation to accompany it.
BIS155 Data Analysis With Spreadsheets With Lab
Week 7 Discussion
WHAT-IF ANALYSIS
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.
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
