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. […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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. […]

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 […]

REQUIREMENTS ANALYSIS AND CONCEPTUAL DESIGN   As you ponder the graded discussion topic for this week, please share your insights and perspectives based on your personal and professional experiences. Please feel free to offer links and references that further elaborate on the topics for this week. The class lectures and readings for this week offer […]