# Microsoft Excel Archive

## Five Basic Elements of Formulas in Microsoft Excel

Formulas are a set equations that perform a certain calculations on values in your worksheet. Proper use of Formulas in Excel can make your life really easier. In

## Different Types and Usages of Operators in Excel Formulas

Operators are special symbols that perform specific operations between operands, and then return a result. In our everyday life we basically use four mathematical operators, i.e. + (addition),

## 40+ Personal Finance and Planning Templates for Microsoft Excel

Less work, more result. That is what template is all about. Download this set excel template and calculate your personal financial problems easily and quicker. This set includes

## 45+ Shortcuts to make Microsoft Excel easier

Lets make working in MS Excel easier, smarter and faster. Here I’ve listed over 45 easy to use and remember shortcuts that will really increase your productivity with

## Change Excel’s default Subtotal format

The Subtotal function in MS Excel is one of the most used functions. But the default formatting of this function is not as good as the function is.

## Highlight cells that contains Formula in Excel

This hack is very useful if you often need to change or check your formulas in your worksheet. To achieve the goal we will use Excel’s conditional formatting

## Calculating a Mid-Year Depreciation Schedule in MS Excel

This is no possible to buy or put in service assets every time on January 1, and therefore the depreciation of that asset cant be the same every

## Creating an Double Declining Balance Depreciation Schedule in Excel

The Double Declining Balance method provides an accelerated depreciation schedule. Calculation of this method is quite interesting. For example You are buying something for \$5000, it has life