Excel Import Data From Web Professional Presentations And

The tools on the External Data Sources group of the Data tab in the Office 2011 for Mac Ribbon facilitate importing and refreshing data from sources that are external to Excel.

On the Ribbons Data tab, go to the External Data Sources group and click Refresh buttons triangle to display a pop-up menu, where you can choose from the options.

Note that you need to be able to tell Excel which character was used as the delimiter when the file was saved.

Clicking the Text button opens a wizard that helps you establish the content boundaries of each column.

You need to take some preparatory steps before you can successfully use options in the External Data Sources group in the Data tab of the Ribbon.

When you have a data source, you launch Microsoft Query, an Office application that visually builds the query for you and brings the results of your query into Excel.

From this dialog, you can open a Web page that you saved from a Web browser.

Excel Import Data From Web Professional Presentations And

His business is creating professional presentations and templates, and he manages the PowerPoint sites indezine.com and ppted.com.

James Gordon is a Microsoft MVP for Macintosh, creator of the InsertPicture add-in for Mac PowerPoint, and an Office trainer.

Excel For Mac Import Data From Web