by Ilker | Jun 11, 2021 | Excel Tips & Tricks
The arrow buttons, FILTER function, and Power Query are popular methods for filtering data in Excel. Unless you are using Power Query, these methods may not be enough when working with two or more criteria. The more powerful Advanced Filter feature can help for more...
by Ilker | Jun 9, 2021 | Excel Tips & Tricks
A discrete distribution describes the probability of occurrence of a random variable that can take on only a certain number of values. Common examples for this are the probabilities in a dice roll or getting a certain card in a deck of regular cards. In this guide,...
by Ilker | Jun 8, 2021 | Excel Tips & Tricks
The PROB function is a statistical function that can calculate the probability associated with a given range. The function is useful for calculating the probability for the occurrences having discrete probabilities of an event. In this guide, we’re going to show you...
by Ilker | Jun 8, 2021 | Excel Tips & Tricks
Error bars are graphical representations of data variability in charts. You can add error bars into your Excel charts to provide a more comprehensive view of the data set. An error bar is usually a horizontal and/or vertical line drawn between lowest and highest error...
by Ilker | Jun 7, 2021 | Excel Tips & Tricks
In this guide, we’re going to show you how to strikethrough in Excel. Download Workbook Strikethrough is a handy formatting option to eliminate data that is not relevant anymore. Let’s see how you can apply this formatting in Excel. Keyboard shortcut Simply press the...
by Ilker | Jun 7, 2021 | Excel Tips & Tricks
Using different coloring makes it easy to highlight differences in data or the layout of your spreadsheets. Excel has support for rows with alternating coloring in tables. What if your table contains similar values in groups, and you want to color the rows based on...
by Ilker | Jun 4, 2021 | Blog, Excel Tips & Tricks
Bar charts display data with the use of horizontally placed rectangular bars. Each bar represents a category and they are drawn with proportional length to the represented values. Download Workbook Bar Chart Basics Sections A bar chart has 5 main sections: Plot Area:...
by Ilker | Jun 3, 2021 | Excel Tips & Tricks
Variance is an important metric in statistics, and it can help you calculate like the risk of an investment. In this guide, we’re going to show you how to calculate variance in Excel. Download Workbook What is variance? Variance is the average of the squared...
by Ilker | Jun 1, 2021 | Excel Tips & Tricks
The VAR function is a statistical function calculates and returns the variance of a sample. The variance provides a general idea of the spread of data, and can be used to calculate the standard deviation or determining risk of an investment. In this guide, we’re going...
