Topic: Business

June 7, 2021

Monthly Variances in Excel

This Excel template visualizes monthly and year-to-date AC, FC and BU data featuring absolute and relative variances (using a waterfall and lollipop chart).

Download

Excel

Template

June 7, 2021

Monthly Variances (Waterfall) in Excel

This Excel template visualizes monthly data for AC, PY, BU and FC, displaying absolute variances (waterfall chart) and relative variances (lollipop charts).

Download

Excel

Template

June 7, 2021

Income Statement in Excel

This Excel template allows you to visualize your Profit & Loss data for current and previous year using vertical waterfall charts, absolute and relative variance charts.

Download

Excel

Template

June 7, 2021

Income Statement with Small Multiples in Excel

This Excel template uses small multiples to visualize the Profit & Loss data for multiples, featuring waterfall and absolute variance charts.

Download

Excel

Template

June 7, 2021

Cost Variance Analysis

This Excel template uses vertical variance charts to visualize AC vs BU variances for different types of costs for current month and year-to-date.

Download

Excel

Template

June 7, 2021

Cash Flow Forecast in Excel

This Excel template uses monthly waterfall charts to visualize how Cash Flow from Operations, Investing and Financing contribute to Net Cash Flow.

Download

Power BI

Template

June 7, 2021

Dynamic Comments in Power BI

This Power BI template is designed to help you implement dynamic commentary that will react to filters and display relevant comments.

Download

Power BI

Template

June 7, 2021

Consolidated Financials in Power BI

This Power BI template is designed to help you make an actionable overview of financials for the management. Spoiler alert: it includes lots of waterfall charts.

Download