Select Page

## How to Perform Trend Analysis in Excel

Trend Analysis is an important tool for decision making, which allows you to analyze the historical patterns to predict future events. Excel is not shy about tools that help you in the process. In this guide, we’re going to show you How to perform trend analysis in...

## How to Perform Trend Analysis with Charts in Excel

Excel charts can do more than visualizing the data, like calculating and showing trends and moving averages. In this guide, we’re going to show you How to perform trend analysis with charts in Excel. Download Workbook Performing Trend Analysis with Charts Creating a...

## How to seasonal forecast with formulas in Excel

Big or small, all business operations need forecasting. Forecasting can be either qualitative or quantitative. In the end, you should estimate future incomes and expenses to draw up a budget. Since each business sector and the company have their own dynamics, there is...

## How to calculate units of production depreciation in Excel

Units of production depreciation is a common and useful parameter for manufacturing firms to calculate the value of an asset based upon usage. In this guide, we’re going to show you How to calculate units of production depreciation in Excel. Download Workbook How to...

## Excel AMORLINC Function

The AMORLINC function is a Finance function used in French accounting system that returns the depreciation for each accounting period, on a prorated basis. The prorated depreciation is considered when an asset is purchased in the middle of the accounting period. In...

## Excel AMORDEGRC Function

The AMORDEGRC function is a Finance function used in French accounting system that returns the depreciation for each accounting period, on a prorated basis. The prorated depreciation is considered when an asset is purchased in the middle of the accounting period. In...

## Excel VDB Function

The VDB function is a Finance function that calculates the depreciation of an asset on the double-declining balance or another basis for a specified period. The VDB stands for variable declining balance and the function switches to straight-line depreciation when...

## Excel DDB Function

The DDB function is a Finance function that calculates the depreciation of an asset on the double-declining balance or another basis for a specified period. In this guide, we’re going to show you how to use the DDB function and go over some tips and error handling...

## Excel DB Function

DB The DB function is a Finance function that calculates the depreciation of an asset on the fixed-declining balance basis for a specified period. In this guide, we’re going to show you how to use the DB function and go over some tips and error handling methods....