Select Page

# Resources

## How to change case in Excel

In this article, we are going to show you how to change case in Excel using different methods. Unlike in Word,...

## How to use emojis in Excel

Did you know that Emojis have been around since 1997? They essentially became an integral part of most written communication methods. In this article, we are going to show you how to use emojis in Excel. [button...

## Net Worth Calculator

This Excel template can help you calculate your overall net worth. The model takes both assets and liabilities into account. The single-page layout of the workbook helps you see a snapshot of your finances at a glance. The calculator is divided into two sides: Assets...

## Investment Model

This template is a simple investment model that may be used for analyzing a single investment. Straight line, declining balance and sum of the years' digits methods may be used for depreciation. Initial inputs and projected growth rates are entered by the users to...

## How to use symbols on charts in Excel

Adding symbols or icons into charts can enhance the visual representation, and make it easier to understand the data. In this article, we are going to show you how to use symbols on charts in Excel. [button...

## How to find nth closest match in Excel

In this article, we are going to show you how to find nth closest match in Excel. [box...

## How to create a Waterfall Chart in Excel

A waterfall chart is a data visualization tool that shows how positive or negative values in a data series change in a sequential manner. A common scenario is to display the cumulative effect of income and expenses on net income. The values can be distributed either...

## How to cut and paste transpose in Excel

A common problem when transposing data in Excel is that data is populated in their relative cells. This means that you may occasionally see messed up references when using the Paste function with transpose. In this article, we are going to show you how to cut and...

## Safety Stock Inventory Template

This Safety Stock Inventory template is prepared for simulating orders and inventory positions according to Safety Stock policy. SigmaPedia defines Safety Stock as the inventory held in a process as a buffer against demand and supply variations. Starting inventory,...