Select Page

How to hide used items in dropdown lists in Excel

How to hide used items in dropdown lists in Excel Dropdowns are a great way to controls user entries to specific values. Although the default data validation dropdown in Excel doesn’t support hiding items as they are used, we can mimic the behavior with formulas. In...

How to create waffle charts in Excel

A waffle chart is basically a square display that shows progress towards a target or a completion percentage. They can be a fancy alternative to pie charts. In this guide, we’re going to show you How to create waffle charts in Excel. Download Workbook Creating a...

How to visualize percentage progress in Excel

Nothing beats visuals when you need a simple way to track progress. Visual indicators can tell you which project is leading immediately without delving into numbers. In this guide, we’re going to show you How to visualize percentage progress in Excel. Download...

How to close all workbooks in Excel with VBA

If you are working with multiple Excel files at once, you often find yourself dealing with warning messages when trying to close them. Although it is a good thing to be warned about saving to not lose changes in a workbook, it may become annoying quickly. Thanks to...

How to calculate depreciation in Excel

Excel supports various methods and formulas to calculate depreciation. There 7 built-in functions dedicated to depreciation calculation. In this guide, we’re going to show you How to calculate depreciation in Excel in 7 ways. Download Workbook Depreciation types in...

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 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...