Excel Tips and Tricks

How to Roll Dice in Excel in 3 Ways

How to Roll Dice in Excel in 3 Ways

The throw of dice is a common way of generating random numbers. It's not necessary to talk about the role of dice in board and role-playing games. Although, a simple formula can give what you need easily, you can make the dice rolling fancy in Excel. In this guide,...

How to Perform Trend Analysis in Excel

How to Perform Trend Analysis in Excel

Trend Analysis is an important tool for decision making, which allows you to analyze the historical patterns to predict future events. Excel is not shy about tools that help you in the process. In this guide, we’re going to show you How to perform trend analysis in...

How to Calculate Selected Cells Only in Excel

How to Calculate Selected Cells Only in Excel

Although manual calculation mode helps to deal with big files that take seconds or minutes to be calculated, waiting for the calculation of the entire workbook may not be convenient. Instead, it would be better to calculate certain cells for quick try-error changes....

How to Store User Defined Function in Excel

How to Store User Defined Function in Excel

The ability to create a User-Defined Function (UDFs in short) is an awesome feature of Excel. It basically removes the limitation of built-in functions. Aside from coding them, storing and distribution of UDFs are another point. In this guide, we’re going to show you...

How to Create Tornado Charts in Excel

How to Create Tornado Charts in Excel

A Tornado Chart is a fancy form of a bar chart. They shine when the goal is to compare two variables. Although Excel doesn't support tornado charts natively, they are a few simple steps far away from you. In this guide, we’re going to show you How to Create Tornado...

How to make words plural in Excel

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