Page 291 - CITS - Computer Software Application -TT

COMPUTER SOFTWARE APPLICATION - CITS

Go to the Data tab and select the Get Data command in the Get & Transform Data section. Then go to From File
and choose From Workbook.
This will open a file picker menu where you can navigate to the file you want to import. Select the file and press
the Import button.

After selecting the file you want to import, the data preview Navigator window will open. This will give you a list
of all the objects available to import from the workbook. Check the box to Select multiple items since we will be
importing data from two different sheets. Now we can check both the Customer Data and Sales Data.
When you click on either of the objects in the workbook, you can see a preview of the data for it on the right hand
side of the navigator window. This is great for a sense check to make sure you’ve got the correct file.
When you’re satisfied that you’ve got everything you need from the workbook, you can either press the Edit or
Load buttons. The edit button will take you to the query editor where you can transform your data before loading
it. Pressing the load button will load the data into tables in new sheets in the workbook.
In this simple example, we will bypass the editor and go straight to loading the data into Excel. Press the small
arrow next to the Load button to access the Load To options. This will give you a few more loading options.

278

CITS : IT&ITES - Computer Software Application - Lesson 63 - 77