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,...
by Ilker | May 27, 2020 | Excel Tips & Tricks
You may want to set an expiration date for a workbook and prevent access for when creating a trial application, or simply ensuring that the application data is up to date. Unfortunately, Excel doesn’t have a built-in tools to handle this scenario, but you can use VBA...
by Ilker | May 5, 2020 | Excel Tips & Tricks
You sometimes get text with line breaks when copying a text from a website or word document. Although line breaks can be useful for a better layout, they can also make Excel tables look weird. In this guide, we’re going to show you how to Remove Line Breaks in Excel...
