Excel File Recovery

8 Common Formula Errors in Excel

Excel formulas in Excel is able to help you finish some rather complex tasks. But you will certainly meet with formula errors in Excel. In this article, we will show you the 8 formula errors in Excel. There are many reasons that will cause formula errors in Excel. For example, you are not familiar with the rule of a certain function, or there is something wrong with the referred cells. In the following parts, we will demonstrate the 8 formula errors with some examples. 1.   ...

Read more »

How to Easily Create a Step Chart in Your Excel Worksheet

Among all of the charts in Excel, the step chart in Excel can clearly show the data changes. In this post, let’s see how to create this kind of chart. A step chart in Excel has a wide range of use. In an ordinary line chart, you can only know the trend of data. But in the step chart, you can know the detailed changes of the numbers. Below we will show you how to create such a chart. Arrange the Range Now we will use this sample to create a step chart. Rearrange the range in the...

Read more »

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 »