The Windows Azure Marketplace DataMarket Add-In for Excel (CTP3) provides a simple another to exporting abstracts as Excel *.csv files from DataMarket or Abstracts Hub and aperture them in Excel. According to the download page’s “Overview” section:
Microsoft Windows Azure Marketplace DataMarket Add-in for Excel (CTP 3) provides a simple acquaintance acceptance you to ascertain datasets appear on the Windows Azure Marketplace DataMarket or in your instance of Microsoft Codename “Data Hub” appropriate aural Excel. Users can browse and chase for a affluent set of datasets aural a apparatus they already use.
With alone a brace of clicks, the user can concern their datasets and acceptation the abstracts as a table into Excel. Once in the workbook, the abstracts can be visualized, aing with added abstracts sources (including owned/on apriorism data) or exported to be acclimated in added applications.
Prerequisites: Accession of the Windows Azure Marketplace DataMarket Add-In for Excel (CTP3) is required. (See footfall 1 below.)
This tutorial assumes (but doesn’t require) that you acquire accounts for the Windows Azure Marketplace Datamarket and the OakLeaf Accessible Abstracts Hub and acquire subscribed to (Datamarket) or added the Air Carrier Flight Delays dataset to your accumulating (Data Hub). See Accessing the US Air Carrier Flight Delay DataSet on Windows Azure Marketplace DataMarket and “DataHub” for details.
The afterward accomplish administer to both DataMarket and Abstracts Hub datasets unless prefixed with [DataMarket] or [Data Hub]:
1. Download the Windows Azure Marketplace DataMarket Add-In for Excel (CTP3) from here, abstract the files from the DataMarketExcelAddInSetupCTP3.zip, and run Setup.exe to install the add-in and its prerequisites.
Note: The afterward accomplish are added abundant than the Getting started with Windows Azure™ Marketplace DataMarket Add-In for Excel (CTP3) page, which displays back accession completes.
2. Launch Excel 2010, bang the Abstracts tab, which now sports an Acceptation Abstracts from DataMarket on:
3. Bang the on to accessible a Subscribed Datasets taskpane:
4. If you’re not accustomed with the accessible DataMarket, bang its Learn Added articulation to accessible the DataMarket’s About page. Alternatively, bang the clandestine DataHub’s Learn Added articulation to accessible the SQL Azure Lab’s Welcome folio for Codename “Data Hub,” and assurance in with a Live ID.
5A. [DataMarket] Bang the Assurance In or Create Annual on to accessible the sign-in page:
5B. [Data Hub] Blazon the HubName.clouddatahub.net URL for your organization’s Abstracts Hub in the argument box:
5C.[Data Hub] Bang the articulation to acquisition your annual key (sign in, if requested):
5D. [Data Hub] Baddest and archetype the Annual Key to the Clipboard, aing the Abstracts Hub folio to acknowledgment to Excel, adhesive the Annual Key to the argument box and, optionally, mark the Remember Me checkbox. (Refer to footfall 5B’s awning capture.)
6A. [DataMarket] Bang Assurance In to accessible an Allow Access form:
6B. [DataMarket] Bang Allow Access to affectation a account of the Datamarket datasets to which you’ve subscribed:
6C. [Data Hub] Bang Assurance In to affectation a account of Abstracts Hub abstracts sets in your collection:
7. Bang the US Air Carrier Flight Delays Acceptation Abstracts articulation to accessible the Concern Architect dialog:
Note: It isn’t bright how to accredit the Group and Ungroup ons.
8. Bang the Add Clarify on to add the aboriginal clarify builder, baddest Month and blazon 2 as the value; bang , baddest Year and blazon 2012 as the value; and bang , baddest Dest and blazon OAK as the amount to bind the cardinal of rows to a reasonable number:
Note: It isn’t bright how to acknowledgment to breadth you were afore beat the Preview Abstracts on, so beat it isn’t recommended.
10. Bang the Array Results tab, bang the Add Array Adjustment on to add the aboriginal array builder, baddest FlightDate, bang and baddest Carrier to adjustment by date and carrier:
11. Bang the specify Returned Fields tab and bright the DayOfMonth, Month, RowId and Year analysis boxes:
12. Bang Acceptation Abstracts to ample the worksheet, which has 3,462 rows and includes abandoned columns for the fields you bare in footfall 11:
Tip: You can get advice for the DataMarket add-in by analytic online Office advice for DataMarket.
13. Bang the Insert tab, accessible the PivotTable arcade and acquire PivotChart to accessible the Create PivotTable with PivotChart dialog, acquire the absence Table/Range amount and bang OK to accessible a PivotTable and PivotChart with a PivotTable Filed Account taskpane.
14. Mark the Carrier and DepDelayMinutes acreage analysis boxes, accessible the Sum of DepDelayMinutes account in the Values area, baddest Amount Acreage Settings, acquire Summarize Values by Average, annul the fable and adapt the blueprint title:
11 Ways On How To Get The Most From This Excel Form Builder | Excel Form Builder – excel form builder
| Welcome in order to our blog site, within this period We’ll teach you about excel form builder