Creating interactive charts, converting numbers to Gigabytes, and merging columns with formulas

The first article explains how to create an interactive chart in Excel. Remember you can always create interactive charts using Pivot Charts and Slicers. But this approach is based on formulas. It can be very handy if you are not familiar with Pivot Charts or prefer not to use them.

My next article offers a nice formula to normalize units to Gigabytes. It combines the formulas LEFT, LEN, MATCH, and RIGHT cleverly to produce the results.

My last article explains how to merge columns using formulas. There is a feature in Excel to do that easily. But there are many situations you may want to achieve this using formulas. It combines IFERROR, INDEX, and ROWS to achieve this.

Advertisements