How to format numbers in thousands in Excel

How to format numbers in thousands in Excel

by | Dec 18, 2018

Number Formatting feature in Excel allows modifying the appearance of cell values, without changing their actual values. Currency formatting with dollar signs ($), or highlighting negative values with red are common examples. Another advantage of this feature is the...

Use Excel for Regression Analysis to Make Better Predictions

by | Nov 30, 2018

What is Regression Analysis? The regression analysis is a statistical method that can estimate the relationship between two or more variables. This method can provide a better understanding of how the value of the dependent variable changes, when one of the...

Actuarial Models in Excel

by | Nov 21, 2018

Most actuaries are experts in Excel and love the tool. Actuarial model one of the most common usages of the software, since it makes it a breeze to build complex mathematical models and test them under various conditions. In this article, I will walk you through...

Create an Excel Heat Map

by | Nov 20, 2018

What is a Heat Map? A heat map is a two-dimensional graphical representation of data, where values are represented by a color scale in a matrix layout. Color-coded cells allow easily identifying the outliers and see the patterns in your data. Excel’s cell-based matrix...
How to delete Excel shapes (AutoShapes) using VBA

How to delete Excel shapes (AutoShapes) using VBA

by | Nov 20, 2018

Excel, just like other Office products, supports AutoShapes. Although Excel shapes are nice to have for presentation purposes, getting rid of them may become time consuming if your workbook is cluttered with them. This article shows you how to delete Excel shapes...
How to make Excel delete all pictures

How to make Excel delete all pictures

by | Nov 16, 2018

Excel, just like other Office products, supports inserting pictures of various formats into your workbooks. However, deleting them may be time consuming in large workbooks if you’re trying to find and delete every single image manually. Let us show you how to...
How to remove hyperlink in Excel quickly using VBA

How to remove hyperlink in Excel quickly using VBA

by | Nov 15, 2018

Excel, just like other Office products, can detect URLs and email addresses, and turn them automatically into hyperlinks. While this can usually speed things up when creating workbooks, they can become nuisance when you don’t want them to be clickable links with...
How to make Excel update links using VBA

How to make Excel update links using VBA

by | Nov 13, 2018

Excel doesn’t automatically update any external links in your workbooks and this can become a hassle if it’s something happening frequently. In this article, we’re going to show you how to make Excel update links automatically using VBA. How to make...
How to delete named range Excel using VBA

How to delete named range Excel using VBA

by | Nov 12, 2018

Managing and removing named ranges in Excel can be a challenging task as you would have to do this one by one for each field. We’re going to show you how to delete named range Excel using VBA with one click.How to delete named range ExcelEach named range is an...