by Evan | Dec 7, 2020 | Templates
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...
by Evan | Dec 4, 2020 | Templates
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...
by Ilker | Nov 23, 2020 | Excel Tips & Tricks
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...
by Ilker | Sep 8, 2020 | Excel Tips & Tricks
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...
by Adam | Jul 13, 2020 | Blog
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...
by Ilker | Jun 22, 2020 | Excel Tips & Tricks
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...
by Ilker | Mar 5, 2020 | Excel Tips & Tricks
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...
by Ugur | Jan 29, 2020 | Blog
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...
by Ilker | Dec 17, 2019 | Excel Tips & Tricks
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...
