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...
by Ilker | May 28, 2021 | Excel Tips & Tricks
In this guide, we’re going to show you how to create and name a worksheet with VBA in Excel. Download Workbook Syntax You can create and name a worksheet using the Sheets.Add and Worksheets.Add methods. Both methods work similarly and have 4 optional arguments and...
by Ilker | May 27, 2021 | Excel Tips & Tricks
Normal distribution is a probability function in statistics and is often used to represent real-valued random variables. It is known as the bell curve because normally distributed set of random numbers create a bell-shaped curve on a graph. In this guide, we’re...
by Ilker | May 26, 2021 | Excel Tips & Tricks
A milestone chart is a visualization tool that can show scheduled events in a specific time. These significant events are called as milestones. Unfortunately, milestone charts are not natively supported by Excel. In this guide, we’re going to show you how to...
by Ilker | Apr 30, 2021 | Excel Tips & Tricks
In this guide, we’re going to show you how to find all combinations of two lists in Excel by using Power Query. Download Workbook In our example, we have two lists that contain Pokémon names and we want to see the combinations of matched Pokémon. We can join...