Insights and Perspectives in a Project

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 excellent information on the wonderful world of Excel.
TCO 6: Given a business case requiring a forecast of future sales, profits, or expenses, develop a worksheet that can facilitate decision making.


Key Concepts


· Create data tables to conduct multiple What-If Analyses and organize and display results.
· Create the ability to conduct What-If Analyses to determine the optimal solution considering given goals, constraints, and parameters.
· Evaluate user requirements to plan a worksheet capable of forecasting financial expectations based on given assumptions and conducting What-If Analyses for varying scenarios.
· Develop charts to graphically display the results of forecasts and multiple What-If Analyses.
· Create a reporting medium that summarizes the results of varying scenarios with multiple variables defined by the user.
· Create a report presenting recommendations to management based on the results of the various scenarios.
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 excellent information on the wonderful world of Excel.

I have two parts for this assignment
1ST Part is Discussion writing post (WEEK 6 : 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.

2nd PART: REPLY TO DISCUSSION POST ONW YOUR OWN WORDS WITH COMMENT SAYING I AGREE ETC

POST 1:
Zaimarie Lopez
What is meant by Data Consolidation? When I think of consolidation of data I think of sources and tables put all into one like a Pivot table.

What are some examples in which you might want to consolidate data? I work in retail and one of the things we do is compare how my BC (Beauty Consultants: Trained cosmeticians and extensive training in all areas of beauty) are doing weekly, also which brand is selling and if they have made commission. For example I have been trying to combine my BC sales, with all 6 brands, and then see were they fall commission wise based on their sales.
Which of these do you see yourself using in your job or personal life and why? I see myself using Pivot tables and Data Mining in field of work.
Analyzing large amounts of data is important for making solid business decisions. Entering data is the easy part; retrieving data in a structured, meaningful way is more challenging. Data mining is the process of analyzing large volumes of data, using advanced statistical techniques, and identifying trends and patterns i (Poatsy 339)

Poatsy, Mary A. Exploring Microsoft Office Excel 2016 Comprehensive. Pearson Learning Solutions, 05/2016. VitalBook file.
REPLY TO COMMENT:

POST2:
Hi CLASS ,

Thanks for your comprehensive discussions and examples. Your definitions and descriptions are right on the mark. Thank you for sharing your experiences. Thank you for sharing your workplace experiences, “I work in retail and one of the things we do is compare how my BC (Beauty Consultants: Trained cosmeticians and extensive training in all areas of beauty) are doing weekly, also which brand is selling and if they have made commission. For example I have been trying to combine my BC sales, with all 6 brands, and then see were they fall commission wise based on their sales.” We are seeing learning and collaboration at its finest. it makes all the difference. Keep up the great job. How about creating an example spreadsheet to illustrate your information for the benefit of the class? Practice makes perfect

Let’s explore further.

What data consolidation and what if analysis is being done in this week’s lab assignment and why?
REPLY TO COMMENT:

POST 3:
Anastasia Jakubow-Rashtchian
YesterdayLocal: Dec 3 at 4:49pm
Course: Dec 3 at 2:49pm
Manage Discussion Entry
Hello All,

This week’s lab assignment you have to create two one variable data tables? What are the steps to do so? Why are they being created? If you created them already, please offer your experiences, strategies, tips and tricks.

Here is some additional information.

Article: How to Create One Variable Data Table
http://www.dummies.com/software/microsoft-office/excel/how-to-create-a-one-variable-data-table-in-excel-2016/ Links to an external site.

Video: How to Create One Variable Data Table
https://www.youtube.com/watch?v=7HpeFKUzPcI Links to an external site.
REPLY TO COMMENT:

POST 4:
Katherin Percca
What if Analysis is a tool that help us to estimate possible values base on some specific data. In other words What- if Analysis tools allow us to experiment different scenarios without changing values of the spreadsheet. There are 3 kinds of What- if Analysis tools, which are Goal Seek, Scenarios, and Data Tables.
Goal Seek help you to determine your goals.
Scenario is a group of values that can be save and replace automatic in the worksheet.
Data tables help you to create one or two variables, depending the number of variables and formulas that we want to study in the data tables.
https://edu.gcfglobal.org/en/excel2013/whatif-analysis/1/

Leave a Reply