Resources

How to normalize data in Excel

How to normalize data in Excel

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...

Building a COVID-19 Dashboard in Excel

Building a COVID-19 Dashboard in Excel

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. [button...

How to create an Excel map chart

How to create an Excel map chart

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 show you how...

How to embed Bing Maps in Excel

How to embed Bing Maps in Excel

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...

How to get Workbook Statistics in Excel

How to get Workbook Statistics in Excel

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, we're...

How to set an Excel expiration date

How to set an Excel expiration date

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...

How to Remove a Line Break in Excel

How to Remove a Line Break in Excel

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...