(LO 4-5) (This problem requires Excel for PC). Replicate the steps taken in the chapter regarding obtaining...
Question:
(LO 4-5) (This problem requires Excel for PC). Replicate the steps taken in the chapter regarding obtaining data from the Web through Excel, and access Amazon’s balance sheet from the Reuter’s site through Excel’s Get & Transform and Power Query tools.
Transform the data in the following ways:
a. In the Power Query editor, rename the first empty column header to “Components.”
b. In the Power Query editor, insure that all columns other than the Components column are numerical (adjust any columns labeled as ABC to 1.2).
c. Close & Apply the changes to load the data into Excel, and add Sparklines to show a visual representation of how the data has changed over the years of data provided.
Step by Step Answer:
Introduction To Data Analytics For Accounting
ISBN: 9781266358234
2nd Edition
Authors: Vernon Richardson, Katie Terrell And Ryan Teeter