Category Archive: Excel 2011

May 27

How to: Create Web query files for use with Excel for Mac

How to: Create Web query files for use with Excel for Mac Web queries allow you to query data from a specific World Wide Web, Internet, or intranet site and retrieve the information directly into a Microsoft Excel worksheet. Microsoft Excel includes some sample Web queries. Definition of a Web Query File A Web query …

Continue reading »

Nov 21

Resolved: Where and How to use Name Management function in Excel 2011 for Mac

Resolved: Where and How to use Name Management function in Excel 2011 for Mac So this is one of those things I keep referring back to. One of the key things I do when I work in Excel is control the values that can be entered in certain fields. I am clearly not good at …

Continue reading »