In Office 2011 for Mac, Excel can try to load tables from a Web page directly from the Internet via a Web query process. A Web query is simple: It’s just a Web-page address saved as a text file, using the .iqy, rather than .txt, file extension. You use Word to save a text file that contains just a hyperlink and has a .iqy file extension. Excel reads that file and performs a Web query on the URL that is within the .iqy text file and then displays the query results.

Office 2011 for Mac comes in several editions, so when installing new Word, Excel, PowerPoint, and more on your Mac, you need to do some research. Each version of Office 2011 for Mac has a different set of applications and features, as well as a different price. The following list helps you pick the edition. Once you have your product key, see Activate Office for Mac 2011. When you install or reinstall Microsoft Office, you are prompted to enter the product key. The product key is. Using Microsoft Office for Mac as a relational database by Jim Gordon, Microsoft Mac MVP, revised January, 2017 Co-author Office 2011 for Mac All-in-One For Dummies Part 1 - Introduction You can use Microsoft Excel 2011 or Excel 2016 for Mac as a fully relational database. You can find data in many different places and bring it into Excel 2011 for Mac workbooks in whole, or as the result of a query in a query table. 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. Using Microsoft Office for Mac as a Relational Database By Jim Gordon, co-author of Office 2011 for Mac All-in-One For Dummies. Part 6 - SQL and queries in Office for Mac A query is a question are you ask of your database. The answer is delivered as a result set in a query table.

You can easily make Web queries for Microsoft Excel in Microsoft Word. Follow these steps:

  1. Go to a Web page that has the Web tables that you want to put in Excel.

  2. Highlight the Web address in the address field and choose Edit→Copy.

  3. Switch to Microsoft Word and open a new document.

    Launch Word if it’s not open already.

  4. Choose Edit→Paste.

    The URL is pasted into the Word document.

  5. In Word, choose File→Save As.

    The Save As dialog appears.

  6. Click Format and choose Plain Text (.txt) from the pop-up menu that appears.

  7. Type a filename, replacing .txt with .iqy as the file extension.

    Don’t use the .txt extension. The .iqy file extension signifies that the file is a Web query for Microsoft Excel.

    If you encounter the File Conversion dialog, select the MS_DOS radio button, and then click OK.

  8. Select the Documents folder.

  9. Click the Save button.

After you save your Web query, follow these steps to run the Web query:

Mac Office 2011 Microsoft Query Download

  1. Open Excel.

  2. Choose Data→Get External Data→Run Saved Query.

  3. Open the .iqy file you saved in Word.

Uninstall Microsoft Office Mac 2011

Excel attempts to open the Web page for you, which creates a query range formatted as a table. Web queries work with HTML tables, not pictures of tables, Adobe Flash, PDF, or other formats. The fancy Web query browser found in Excel for Windows is not available in Excel for Mac.

You can refresh a Web query quickly by first positioning the selection cursor anywhere in the data table and then choosing Data→Refresh Data.

Mac Office 2011 Microsoft Query Tutorial

Office 2011 for Mac comes in several editions, so when installing new Word, Excel, PowerPoint, and more on your Mac, you need to do some research. Each version of Office 2011 for Mac has a different set of applications and features, as well as a different price. The following list helps you pick the edition that’s right for your purposes:

Microsoft Office For Mac Free

  • Home and Student Edition: This version comes with complete editions of Microsoft Word, Excel, PowerPoint, Messenger, Microsoft Query, Visual Basic for Applications (VBA), and Silverlight. In addition, you get some nifty new fonts. Purchasers of Home and Student Edition are entitled to use the free templates, add-ins, sounds, backgrounds, clip art, and other materials from Microsoft’s extensive online offerings. Home and Student Edition users can also store and share documents on Microsoft’s SkyDrive Web site. Product validation is required.

  • Home and Business Edition: In addition to everything included with Home and Student Edition, the Home and Business Edition comes with the Microsoft Outlook e-mail and organizer program and the ability to use the SharePoint portal server, a file server often used by large businesses.

  • Volume License Edition: Purchasers of large quantities of Office 2011 may save considerable amounts of money by purchasing under the volume license program. Many universities, colleges, and schools take advantage of this program to offer free or low cost Office 2011 to employees, faculty, staff, and students.

  • Limited time trial: This is not a separate version of the product, but a test version. After using this version for the trial period, you should know whether you plan to purchase Office 2011. To purchase, all you need is a product key, so you don’t have to reinstall anything if you decide to keep Office 2011.

    Microsoft Excel 2016 15.1 for Mac can be downloaded from our website for free. This Mac download was scanned by our built-in antivirus and was rated as virus free. The actual developer of this software for Mac is Microsoft. Microsoft excel download mac os x. Mar 25, 2020  Our software library provides a free download of Microsoft Excel 16.35 for Mac. Our built-in antivirus scanned this Mac download and rated it as 100% safe. This Mac application is an intellectual property of Microsoft. The program lies.

  • SkyDrive Edition (free): SkyDrive is the name of a Microsoft Web site where you can upload, share, and edit documents. On SkyDrive, Microsoft offers lightweight editions of Word, Excel, PowerPoint, and OneNote for free online to compete head-to-head with other free applications such as Google Docs, OpenOffice, and Lotus Symphony. In addition, the SkyDrive versions of Office applications work as a seamless complement to the desktop versions of Office 2011 for Mac.

    Being online, SkyDrive requires no installation. There’s no software to download or install other than your Web browser, which may already be installed as part of your Mac OS X. SkyDrive editions of Office applications run equally well in Apple Safari or Mozilla Firefox.