In 2016 Excel added many new charts, including the Waterfall chart. Waterfall Charts are great for telling the story of how a quantity of interest (for example, cash position) changes over time. Waterfall charts also allow the finance professional to chart for a single point in time how a quantity...
by Wayne Winston
Treemap charts, also known as mosaic charts, and Sunburst charts
were added to Excel to help you visualize hierarchical data. Hierarchical data
is a way to organize data with multiple one-to-many relationships. The
structure is based on the rule that one parent can have many children, but
Excel has three dimensions: rows, columns and worksheets. Most of us are familiar with how to use the powerful and indispensable Copy command to “copy” a formula across columns and down rows. In this article, we explore three tricks that can help you work across worksheets.
Office 365’s new geographic data types allow you to type a location in Excel and write formulas that extract information about the location to a different cell. For example, if you enter “Paris” in cell E4, entering the formula “E4.Population” in a different cell will...
Forgot your password?
Username or E-mail: