MS Excel
How to calculate asset depreciation with DDB function in Excel
If you want to learn how to calculate an Assets depreciation in Excel, keep reading the following article.
When we talk about depreciation, we refer to something similar to an operating expense, where they will be taken into account before calculating the net profits of a company or company.
It is carried out in order to know the depreciation that some tangible asset of the company can reach, a very important calculation that must always be made for the financial statement, to later know your economic situation, and if it is profitable to think about the corporate advantages of the global market (something many entrepreneurs aspire to one day reach).
In accounting matters, depreciation is a calculation that must be carried out after a set time has elapsed, in order to know how much an asset depreciates from time to time.
How to calculate asset depreciation using Excel’s DDB function?
Calculating depreciation by the double decrease method is calculated at an accelerated rate, that is, the depreciation is greater during the first period and decreases in the succession of the following periods. Calculating is very simple, even more so if you use the Excel sheet to carry it out, but to use this syntax you must specify the following arguments:
 Cost. Refers to the initial amount
 Residual value. The final residual value of depreciation, which can even be 0.
 Lifetime. It is the period during which the property can be depreciated. This can be known as the useful life of the property.
 Period. It is the time for which you want to calculate the depreciation. The resulting values must use the same units as the previous point.
 Factor. The rate of depreciation of the balance. Omitting this value immediately assumes that its value is 2. But it is important to remember that this can only be calculated if the numbers are positive.
Excel formula for depreciation with DDB
In the DDB function, a specific formula is used to calculate the depreciation of a period: Min (cost – total depreciation of previous periods) * (factor/life) (cost / residual – total depreciation of previous periods). To understand it a little more, the following example will be used:
 Initial cost: $ 2,400
 Residual value: $ 300
 Life (years): 10
The amounts of the three arguments must be placed in boxes A2, A3, and A4 correspondingly if the following example is to be understood in itself. Therefore, the following formula would apply = DDB (A2, A3, A4 * 365, 1)
This would be the amortization on the first day of the year, assuming the factor is 2. Your result would be $ 1.32. = DDB (A2, A3, A4 * 12, 1, 2) . The first month’s amortization would be $ 40.00 = DDB (A2, A3, A4, 1, 2) . With this, the amortization for the first year would be calculated, resulting in $ 480.00 = DDB (A2, A3, A4, 2, 1, 5).
But in this case, to get the amortization of the second year, a factor of 1.5 was used, instead of 2. Obtaining, as a result, $ 306.00. = DDB (A2, A3, A4, 10)
This would be the final formula to calculate the depreciation of the lifetime that we wanted to find, and in the case of this example, the total depreciation of those ten (10) years was $ 22.12. Taking into account that for this formula the factor remained at 2.
For many people, it may seem a bit confusing to apply the DDB formula, but the truth is that it is very easy to use as soon as you get the hang of it, although you can also copy the formulas shown here and paste them into the Excel sheet to obtain results quickly.
In accounting issues, payroll calculations, simple discounts or depreciation, is something that is quickly learned to remove manually, so using Excel makes the task much easier to perform. With excel you can also make forecasts or sales projections of a product to study the finances.
MS Excel
How to Create Automatic Serial Numbers in Excel
There are several ways to create automatic serial numbers in Microsoft Excel that you can use to help with any given job.
Starting from the manual method, there are various ways, really.
And for you beginners who may just be getting to know Microsoft Excel, we will explain how to do it.
Go ahead, here’s the complete tutorial.
HOW TO CREATE SEQUENTIAL NUMBERS IN EXCEL
Creating a serial number is very easy, and you don’t need to do it manually.
For the automatic method, you can write only two numbers, then select both, and a dot will appear on the bottom right side.
Press and hold the dot then drag downwards.
By doing this, you no longer need to use the very old manual method.
Using Excel Fills
In addition to this method, you can use another method, namely Excel Fill.
First, write only one number, then select it and go to the Home menu – Fill – Series as below.
A new menu will appear, and fill in as needed. Because you want to make the number downward, we choose Columns, Linear, and in the stop value fill in the last number you want.
Well, that’s easy, isn’t it? You can use all methods according to your needs.
That’s all and good luck!
MS Excel
How To Find & Replace Feature in Microsoft Excel
Excel has a feature called Find & Replace, this feature will help you when searching for data according to its name.
So you no longer need to search manually one by one. Because this feature will find words or data according to what you input.
But it’s not only limited to searching for data or words, but you can also use it to replace data.
How to? Here’s the full tutorial.
EXCEL’S FIND & REPLACE FEATURE
To use the Find feature, you can click the Home menu – Find & Select – Find like this,
A popup menu will appear and you can simply type the word or data you want to search for and then press Find Next.
Excel will automatically display the data quickly.
Or, if you want an even faster way, you can use the Ctrl+F shortcut to open the menu.
Change Words or Data Quickly
In addition to searching, you can also use this feature to replace data or words very quickly.
The trick is to press Ctrl + F and the same menu will appear as before. But here select Replace like this.
On the menu, when the word you want to change is in the Find what and Replace with a column for replacement words or data.
Then Replace All to replace all these words or you can select Replace to replace only one data.
How, after knowing this, the use of Microsoft Excel becomes easier, dong.
Of course, this feature makes it very easy for you to process your data, especially if you experience a lot of data input errors.
MS Excel
How to Set Column and Row Size in Microsoft Excel
The easiest way to adjust the size of columns and rows in Microsoft Excel is this way. Guys, curious, right?
Before We tell you how usually you will need to set the column and row sizes when you are inputting data but the number of characters exceeds the thickness or height of the cell.
In other words, the data you input only appears partially.
Then how to solve it? Here’s the full tutorial.
HOW TO SET COLUMN AND ROW WIDTH
This is very easy for you to do, even those who are just learning will immediately be able to. You can directly use the mouse to expand or adjust the size.
The trick is to press, hold and drag the mouse on the boundary of each column or row like this.
Easy, right? The same goes for when you want to resize rows, yes. The difference is, you need to hover your mouse over the row of lifts on the left.
Column Width Features
In addition to this method, there is one other method that requires several steps.
First, select all or the area you want then go to the Home menu – Format – Column Width like this.
After the popup menu appears again, you just enter the desired value, then the column will automatically have the same size.
This second method is perfect for those of you who want to set the same column and row sizes in Excel without any difference.
But if you want a fast one, you can use the first method, both are the same depending on your needs.

Phones2 years ago
Apple iPhone 11 (2019) – Release, Info, Leaks, Rumors

Phones2 years ago
Huawei’s New Operating System is HarmonyOS [ Officially ]

Tech2 years ago
Levi’s Bluetooth Jacket Lets You Control Your Smartphone

News2 years ago
Belle Delphine bath water – Instagram Model Sells Used Bathwater For 30$ To Their Loyal Followers