Category: Excel

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 »

Aug 21

How to: Obtain stock quotes from Yahoo finance (you can query them via Excel too)

How to obtain stock quotes in Excel I was working on creating a spreadsheet to calculate profits and losses on options positions but didn’t know how to populate excel with stock quotes. Back in the day there used to be an interface to get stock quotes with the MSN Money site but it is not …

Continue reading »

Aug 10

How do you get drop downs in Excel to enter data in cells?

Q: I’ve seen spreadsheets where some of the cells are drop downs and allow you to select from a list of values the entry you want to make. How do you configure a cell in Excel to provide a dropdown?

Continue reading »