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 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...
by Ilker | Jun 22, 2020 | Excel Tips & Tricks
Building a COVID-19 Dashboard – or really any other similar data trend – in Excel can help track and present the data more effectively. In this guide, we’re going to show you tips of building a COVID-19 Dashboard in Excel. Download Workbook...
by Ilker | Jun 18, 2020 | Excel Tips & Tricks
Visualizing, and subsequently observing trends in data is very important for making any sense of it, and hopefully plan accordingly. Likewise, tracking the spread of COVID-19 has been paramount in understanding how, where, and when it has been spreading, and...
by Ilker | Jun 9, 2020 | Excel Tips & Tricks
Excel has built-in support for adding chart and map combinations – also as known as map charts – since Excel 2016. A map chart is an easy-to-use tool that is great for when you want to visualize geographic data on a map. In this article, we are going to...
by Ilker | Jun 5, 2020 | Excel Tips & Tricks
Bing Maps is an add-in for Excel, that has been featured since Excel 2013 to create dynamic maps in your Excel workbook. You can create a dynamic map with data visualizations by using location data in your workbook. In this article, we are going to show you how to...
by Ilker | May 28, 2020 | Excel Tips & Tricks
Workbook_Open and Auto_Open are two predefined events for Excel VBA. Both events allow you to run a macro right after the workbook is loaded. You may want to open the workbook without triggering anything in some cases – either to skip a certain code block for...
by Ilker | May 28, 2020 | Excel Tips & Tricks
Workbook Statistics is a new feature Microsoft has released recently for Excel 365 users. Workbook Statistics is a dialog box that contains information about your spreadsheet such as the number of sheets, tables, formulas, charts, and PivotTables. In this guide,...
