Excel File Recovery

How to Protect Your Excel Application from Unlicensed Use

A developer who intends to license an application might wish to limit its use to, say, a three day trial before locking out unregistered users. One way to do this is discussed below. The article assumes 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”. The xlsm in this exercise can be downloaded here. When it opens, it might request a password, which is 123. The development code...

Read more »

2 Different Methods to Create a Funnel Chart in Your Excel

When you need to show the information in a chart according to the values, you can create a funnel chart. Hence, you can use the two methods in this article to create such a chart. The information in a funnel chart can show the original data in a more intuitive way than the ordinary chart. Funnel chart can also reflect data and information in a clearly way. Therefore, in such a chart, you can know the relationship of different data and information clearly. The image below shows a range of...

Read more »

How to Easily Create and Filter Data in a Pivot Chart in Your Excel Worksheet

When you create an ordinary chart in Excel, you will see all the data and information in this chart. Here we will introduce how to create and filter data in a pivot chart in your Excel. Even though ordinary chart in Excel can fulfill many tasks, you will still feel that the chart is not flexible enough. For example, you cannot filter data and information directly in the chart. Therefore, to make the chart more intuitive, you can create a pivot chart in your Excel. Create a Pivot Table...

Read more »