by Ilker | Jul 6, 2022 | Excel Tips & Tricks
In this guide, we’re going to show you How to display negative numbers as zero in Excel in two ways. Download-Workbook Formula approach to display negative numbers as zero The first method in our list is the formula way. An obvious way is to use the IF function which...
by Ilker | Jun 27, 2022 | Excel Tips & Tricks
An array is a collection of similar-type values or objects in computer science. This isn’t different for Excel. The only caveat is that Excel has two definitions for arrays, one for workbooks and the other for VBA. In this guide, we’re going to show you How to get the...
by Ilker | Jun 23, 2022 | Excel Tips & Tricks
Excel keeps growing its visualization tools with each version. And the charts are the flagship of those. Although they present lots of customization options, they may become overwhelming when you just need to create a simple bar or column chart. In this guide, we’re...
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 | Apr 1, 2022 | Excel Tips & Tricks
A ridgeline plot, also known as a joy plot, is a chart type visualizing the data as overlapping density curves. Joy plots got its name from the album cover Unknown Pleasures by Joy Division in 1979. They are good-looking visualizations for comparing the distributions...