Select Page

## Converter Template

Unit conversion can be tricky, especially when dealing with some scientific units such as velocity, or energy. This Excel template was built to make conversions simple and easy to understand. One of the biggest advantages of using an Excel tool for unit conversion is...

## Depreciation Calculator

This is an easy to use depreciation calculator template that can give you the annual depreciation rates and book values using straight-line, double-declining balance, and units of production methods. Simply enter the asset details like the initial value, salvage...

## How to create a dynamically changing calendar in Excel

In this article, we are going to show you how to create a dynamically changing calendar in Excel. Download Workbook Populate variables First step is creating the variables to be used in the formulas. These variables need to provide the present day information so that...

## How to show workbook location in Quick Access Toolbar

Finding your active file’s location can be a bit tricky at times. However, you can see the file location and even copy its location as a text from the Quick Access Toolbar. In this article, we are going to show you how to show workbook location in Quick Access...

## What's New in 6.18: Formula Override and Advanced Data Filters

Removing the barrier of entry into developing complex web applications even further with each step, we are excited to have brought you another version, jam-packed with new features. Excel’s flexible input/output structure allows for creating straightforward and...

## Building a COVID-19 Dashboard in Excel

Building a COVID-19 Dashboard – or really any other similar data trend – in Excel can help track and present the data more effectively. In this guide, we’re going to show you tips of building a COVID-19 Dashboard in Excel. Download Workbook...

## How to make complex formulas easier to read with line breaks in Excel

Excel allows you to enter a formula with up to 8,192 characters. However, managing a formula will certainly get harder as you get closer to that limit. You might especially have this issue when working with nested formulas – functions in functions. In this...

## The First NoCode Platform: Spreadsheet Software

NoCode is not a new concept: the premise of designing tools for nonprogrammers to build and maintain their own applications without coding has been around for a long time. NoCode is a new name for an old concept. Some of its older names include Visual Programming and...

## How to find duplicates in Excel and remove or consolidate them

Duplicate values in a dataset can cause headaches if you do not know how to deal with them. In this guide, we’re going to show you how to find duplicates in Excel and also go over how you can remove or consolidate them using a few examples. Download Workbook How...