1. Discussion topic 1 Visit the Journal of Accountancy portal (https://www.journalofaccountancy.com/) and using the search tool located in the upper right corner of the journal portal, do a research on "Excel Power Query". Choose an item and complete the following: Briefly summarize the main topic of the article Provide an example of how an accountant or manager can use this new Excel function, tool, or formula in the workplace.

2. Discussion Topic 2 - Ethics You are a new manager of a company in the automotive industry. You are requested to review the results reports that are submitted to the owner each month. The previous manager, who had been employed for many years before retiring, usually only approved the reports and returned them immediately. The comptroller has called him several times, insisting that he sign the report. The controller's behavior makes you feel anxious because you take a long time to review and sign it. According to his experience and professional intuition, the financial statements for the month that just ended, February, and which are included in the report, reflect variations and discrepancies that are not expected. For example, a significant increase in sales and accounts receivable is reflected when comparing February with January of the same year. However, the cost of goods sold and cash is similar in both months. The increase in sales is so significant that it caused significant increases in gross profit and in net operating profit for February compared to January. These very significant differences make you think that the reports have been deliberately modified and that the constant calls you are receiving from the controller make you think that he is covering up something. You are on good terms with the business owner and are scheduled to have a meeting with him during your second week at work.

Answer the following two questions: What would be a better alternative to evaluate the results of the month of February instead of comparing them with those of the previous month? What kind of analysis would you conduct to address your concerns related to sales, cost of goods sold, gross profit, net income, cash, accounts receivable, and inventory? Would it be appropriate to bring up your concerns during the meeting with the owner or better to remain silent?

3. Discussion Topic 3

Your supervisor has to make a presentation to the president of ABC, Inc. to summarize the sales results for the months of September and October of this year. Next, the Excel file prepared by your supervisor is included where it summarizes the sales for the months of September and October of this year for the company ABC, Inc.In this there are two versions of graphs that summarize the data in the table of sales . The two versions of the graphs look different, although they summarize exactly the same data. This is because the data is expressed differently in the two versions of the graphs. ACG 2062S Discussion Forum Week 1 Topic 2 Ethics.xls. Her supervisor has decided to use version # 2 of the charts because she understands that visually the situation looks more favorable. This situation reminded her of an article that she recently read and decided to review it again: https://www.elartedepresentar.com/2011/11/4-formas-de-mentir-con-graficos-de-datos-en- a presentation /

Answer the following two questions: * Question 1. Why do you understand that the supervisor thinks the situation looks more favorable if she uses version # 2 of the charts and not version # 1 even though they both summarize the same data? * Question 2. Do you consider your supervisor's decision to be ethical? Explain your answer.

4. Discussion Topic4 In chapters 1 and 2 of the textbook, we see that Excel spreadsheets can be used to present aggregate data, and display a summary of information for managers and owners to make more informed financial decisions. Excel has been useful in helping companies understand "big data" and also in performing increasingly complex data analysis. Read the article below and discuss the advantages and disadvantages of using Excel to analyze big-data. Excel and big data - Microsoft 365 Blog https://www.microsoft.com/en-us/microsoft-365/blog/2016/06/23/excel-and-big-data/

References:

Read the article below and discuss the advantages and disadvantages of using Excel to analyze big-data. Excel and big data - Microsoft 365 Blog https://www.microsoft.com/en-us/microsoft-365/blog/2016/06/23/excel-and-big-data/

https://www.microsoft.com/en-us/microsoft-365/blog/2016/06/23/excel-and-big-data/

Owen, G.(2019) UsingMicrosoftExceland Access2016 9781337109048

In chapters 1 and 2 (Topic 3 And 4) of the textbook, we see that Excel spreadsheets can be used to present aggregate data, and display a summary of information for managers and owners to make more informed financial decisions. Excel has been useful in helping companies understand "big data" and also in performing increasingly complex data analysis.

Chapter1:ExcelTour (Topic 3 and 4)

https://keiseruniversity.blackboard.com/bbcswebdav/pid-20616957-dt-content-rid-94720875_1/xid-94720875_1

Chapter2:ExcelBasics (topic 3 and 4)

https://keiseruniversity.blackboard.com/bbcswebdav/pid-20616957-dt-content-rid-94720876_1/xid-94720876_1