Resources
How to make words plural in Excel
Neither words nor grammar is where Excel shines. On the other hand, texts may be handful to inform users what a numeric value means, such as units. Making this type of information changed between singular and plural forms dynamically may increase the end-user...
How to change CSV delimiter in Excel
Although CSV stands for comma-separated values, it has become a common file type to define simple text files including delimiter-separated data. Thus, a CSV file can use a semicolon or tab character as a delimiter as well. In this guide, we’re going to show you how to...
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. [button...
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. [button...
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. [button...
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. [button...
How to create pill charts in Excel
A pill chart is a fancier way of drawing bar or column charts. Rounded corners and space after axis are enough to make your dashboards catchier. In this guide, we’re going to show you How to create pill charts in Excel. [button...