Select Page

Excel, just like other Office products, allows for more interactivity with the use of hyperlinks. Hyperlink support was added to Excel to link files and website URLs. In Excel, creating a hyperlink is as simple as typing in a valid URL, and pressing the Enter key....

## Treemap Excel Charts: The Perfect Tool for Displaying Hierarchical Data

A treemap chart is a type of data visualization that is especially useful for displaying hierarchical data. On a treemap, each item is represented by a rectangular shape, where smaller rectangles represent the sub-groups. The color and size of rectangles are typically...

## How to generate a date list using the SEQUENCE function

Date lists are an important part of numerous Excel models. Excel can automatically recognize date-time values, format the cells, and generate a date list quickly with AutoFill or specific functions. However, date-time functions are focused on a generating a single...

## How to calculate percentage in Excel

A percentage is a number or ratio that represents a fraction of 100, and this representation is used widely from interest rates to risk analysis, or really in any application when the contribution of a specific item to the whole is to be highlighted. In this article,...

## All you need to know about Excel's new Spill feature

The term spill in Excel’s literature is defined as populating multiple cells with a single formula. With the announcement of the dynamic arrays in September 2018, Excel formulas can now return (spill) an array of values into neighboring cells by starting with...

## Area Chart in Excel

An area chart is a graphic representation of data by highlighting the areas between the axes and the plot lines. Being a variation of the line chart, the area chart places more emphasis on the “gap” between the data and the axis, and is commonly used to compare two or...

## How to apply conditional formatting to Pivot Tables

Conditional Formatting is commonly used to highlight data fields to easily identify outliers, or narrow down the results. However, this feature works a bit differently when dealing with a Pivot Table. Pivot Tables are also dynamic elements, and conditional formatting...

## How to make a line graph in Excel

Widely used in various fields, a line chart is one of the staples of data visualization. Line graphs (charts) are a graphic representation of data shown on lines across the chart area. In a line chart, lines typically represent categories, and are drawn between data...

## How to compare two columns in Excel

Comparing the data in two different columns is a frequently used method in data analysis. In Excel, you can compare using formulas or highlighting. In this guide, we’re going to show you how to compare two columns in Excel using these two methods.Compare two columns...