by Ilker | Jul 28, 2020 | Excel Formulas, Excel Tips & Tricks
You can use Excel formulas to populate a random number or string from a list. You can even build a logic to return numbers without any duplicates. In this article, we are going to show you how to select a random Item from a list in Excel. Download Workbook Although...
by Ilker | Jul 28, 2020 | Excel Tips & Tricks
PDF is a popular file type for sharing. Fortunately, Excel has a couple of tools for an Excel to PDF conversion. The process becomes even easier thanks to Excel’s Page Layout options, where you can define page sizes and properties. In this article, we are going to...
by Ilker | Jul 27, 2020 | Excel Tips & Tricks
Excel is rich in data sorting features - you have built in features like Sort and functions like SORT or SORTBY. However, these methods won’t work without some modification when you need to sort dates in Excel. In this article, we are going to show you how to...
by Ilker | Jul 21, 2020 | Excel Tips & Tricks
Sorting is a crucial part of organizing data. Being everyone’s go-to spreadsheet tool, Excel thankfully offers various tools for sorting data like the sort feature and functions like SORT or SORTBY. However, neither of these approaches can really help you with...
by Ilker | Jul 16, 2020 | Excel Tips & Tricks
In this article, we are going to show you how to create a Funnel chart in Excel versions older than 2019 – including 365. Funnel charts are fairly popular among sales and marketing processes. You can use a funnel chart to display the progression of data through...
by Ilker | Jul 15, 2020 | Blog, Excel Tips & Tricks
A funnel chart is a useful visualization for showing progress through different stages of a process. It looks like a bar chart with the difference of centered bars which allow creating the funnel shape. In this guide, we’re going to show you how to create a funnel...
by Ilker | Jul 3, 2020 | Excel Tips & Tricks
A sunburst chart is a type of visualization that – just like treemap charts – works great for displaying hierarchical data. A sunburst chart is drawn in a circular layout where each ring represents a level in the group hierarchy. While the inner ring...
by Ilker | Jul 2, 2020 | Excel Formulas
The STANDARDIZE Excel function is a Statistical formla that calculates and returns normalized value (z-score) based on the mean and standard deviation of a data set. In this guide, we’re going to show you how to use the STANDARDIZE function and also go over some tips...
by Ilker | Jul 2, 2020 | Excel Tips & Tricks
Normalizing (or standardizing) is an essential step in analyzing large datasets. Finding the z-scores of a sample data based on the standard deviation and mean of the entire data set can help you achieve a more manageable workload. This is especially true for when...
