Resources
How to insert a degree symbol in Excel
The degree symbol (°) typically indicates temperature measurement, the magnitude of angles in geometry, and diminished chords in music. However, standard keyboards don't have a button for this useful symbol. In this article, we're going to show you 4...
How to insert a check mark in Excel
A check mark is the universal character for confirmed tasks and is widely used in managing lists. Seeing how commonly it's used in organizing ourselves, you would think that there should be a keystroke for this! In this article, we listed 5 methods you can use to to...
Column Chart in Excel: Everything You Need to Know
A column chart is a graphic visualization of data using vertically placed rectangular bars (columns). Usually, each column represents a category, and all columns are drawn with a height proportional to the values they represent. The types of data column...
How to format numbers in Excel with millions separators
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...
How to format numbers in thousands in Excel
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...
Use Excel for Regression Analysis to Make Better Predictions
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...
Actuarial Models in Excel
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
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...
How to delete Excel shapes (AutoShapes) using VBA
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...