Excel Solutions

2 Methods to Password Protect Your Excel Workbooks (Part I)

The security of Excel is rather important for individuals and companies. Here we will discuss about how to set or delete passwords for workbooks in detail. When you are dealing with an essential Excel file, you will certainly want to protect it. There are many methods to protect your file. And Excel itself has also provided a way. You can set passwords for Excel to protect it. Here we will demonstrate how to set or delete passwords in the following passage. There are 2 ways to set passwords...

Read more »

How to Diagnose and Fix Formula Errors Step by Step in Excel

We will use formulas in Excel to solve a variety of problems. And in this article, we will demonstrate how to how to diagnose and fix formula errors step by step in Excel. Most of the time, you will apply special function to solve certain Excel problems. And formula can handle most of the complex calculations. However, once the formula is complex, errors in formula can easily appear. Most of the time, one formula will contain several different functions, which add difficulties into the...

Read more »

How to Improve Your Efficiency via Fill Series Feature in Excel

Excel can serve as a very good helper in our work. And here we will discuss about the fill series features. In the process of using Excel, you may probably apply the fill features in certain row or columns. This is indeed a very practical feature in Excel. In addition, it has some other usage that can also help you finish some tasks. And now we will discuss about the fill series features in detail. Fill Series Feature Suppose you need to record the monthly sales volume in Excel. And you...

Read more »