by Ilker | Apr 28, 2022 | Excel Tips & Tricks
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,...
by Ilker | Apr 18, 2022 | Excel Tips & Tricks
Document-based Microsoft Office applications like Excel, Word, and PowerPoint include a Mark as Final feature to inform the other users not to update the file. If Mark as Final feature is active for a document, Excel welcomes the user with a warning message. In this...
by Ilker | Apr 8, 2022 | Excel Tips & Tricks
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...
by Ilker | Apr 7, 2022 | Excel Tips & Tricks
Excel charts can do more than visualizing the data, like calculating and showing trends and moving averages. In this guide, we’re going to show you How to perform trend analysis with charts in Excel. Download Workbook Performing Trend Analysis with Charts Creating a...
by Ilker | Apr 4, 2022 | Excel Tips & Tricks
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....
by Ilker | Mar 31, 2022 | Excel Tips & Tricks
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...
by Ilker | Mar 31, 2022 | Excel Tips & Tricks
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...
by Ilker | Mar 29, 2022 | Excel Tips & Tricks
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...
by Ilker | Mar 11, 2022 | Excel Tips & Tricks
Big or small, all business operations need forecasting. Forecasting can be either qualitative or quantitative. In the end, you should estimate future incomes and expenses to draw up a budget. Since each business sector and the company have their own dynamics, there is...
