Page 290 - CITS - Computer Software Application -TT

COMPUTER SOFTWARE APPLICATION - CITS

• We can append a query to another query similar to a union of two queries in SQL.

Note: The available data connection options will depend on your version of Excel.
There are a couple of the more common query types available in the top level of the ribbon commands found in
the Get & Transform section of the Data tab. From here we can easily access the From Text/CSV, From Web and
From Table/Range queries. These are just duplicated outside of the Get Data command for convenience of use,
since you’ll likely be using these more frequently.
Depending on which type of data connection you choose, Excel will guide you through the connection set up and
there might be several options to select during the process.

At the end of the setup process, you will come to the data preview window. You can view a preview of the data
here to make sure it’s what you’re expecting. You can then load the data as is by pressing the Load button, or you
can proceed to the query editor to apply any data transformation steps by pressing the Edit button.
A Simple Example of Importing Data in an Excel File
Let’s take a look at importing some data from an Excel workbook in action. We’re going to import an Excel file
called Office Supply Sales Data.xlsx. It contains sales data on one sheet called Sales Data and customer data
on another sheet called Customer Data. Both sheets of data start in cell A1 and the first row of the data contains
column headers.

277

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