Excel Solutions

How to Read Data from Online Web Pages with Excel VBA

This exercise shows how to read data from a website, in this case up-to-the-minute currency exchange rates from Yahoo.com. It is assumed the reader has the Developer ribbon displayed and is familiar with the VBA Editor. If not, please Google "Excel Developer Tab" or "Excel Code Window". Prerequisites include a knowledge of populating combo-boxes and defining names. The workbook consists of two sheets: The User Interface: The Buy and Sell combo boxes reference the local data sheet...

Read more »

How to Create and Use Your Own Excel Add-Ins

Excel add-ins can provide plenty of additional features for you. You may even create and use your own add-ins for your Excel. So now let’s see how to realize this. There are numerous Excel add-ins available in the market. If you need to use Excel to finish your tasks quite often, you might have already utilized certain add-ins. On the other hand, even though the add-ins are beneficial, they cannot meet all the requirements. Therefore, you can create your own add-ins for your Excel. Follow...

Read more »

How to Create and Use the Scatter Chart in Your Excel Worksheet

Except for the lines or columns in a chart, you can also use the markers in a scatter chart to show data and information. In this article, we will show you how to create and work with the scatter chart. The scatter chart is a very special chart in Excel. Some special markers in the chart will represent the data in your worksheet. With those obvious markers, you can easily analyze the data and information. Below allow us to show you how to create such a chart. Create a Scatter Chart ...

Read more »