Excel University Blog

Read on for in-depth articles, tutorials, and videos. Search or browse for specific topics. Be sure to subscribe if you'd like to be notified when we write something new.

External Data

man looking at a computer while learning How to Merge Excel Files without using VBA

How to Merge Excel Files (Without Using VBA)

By Excel University | October 11, 2022 |

You might be surprised how much time is lost flipping between Excel workbooks trying to find information – especially if you have a lot to sort through. Learning how to merge Excel files will make finding information easier, faster, and more user-friendly (especially if you’re sharing workbooks). While you can use VBA to combine files,…

Read More

Stock Quotes

By Jeff Lenning | June 2, 2016 |

If you get stock quotes into Excel by typing or copy/pasting from your web browser, you may be able to get your work done faster if you use a built-in Excel feature. Excel’s external data feature enables you to retrieve data from a variety of sources—one of which happens to provide stock quotes. Check out…

Read More

MSN MoneyCentral IQY Web Query

By Jeff Lenning | May 9, 2013 |

Note: see this post for instructions on using the new stock quotes system in Excel. I happened to notice that the MSN MoneyCentral Investor Stock Quotes IQY file did not install automatically with Excel 2013.  I’m not sure if this just occurred on my system, or, if this is by design. In any event, I’d like to…

Read More

Pull External Data into Excel

By Jeff Lenning | March 28, 2013 |

Often, we use Excel to summarize detail that comes from some other program or accounting system. There are essentially three ways that I am aware of to get data from another program into a destination Excel worksheet, I’ll nickname them: Copy/Paste Pull Push Copy/Paste The Copy/Paste method is probably the most common.  It is when…

Read More