Level of knowledge: Intermediate

Intermediate
December 9, 2022
Sales variance report with multiple levels
Use this template to visualize your sales performance with multiple levels in Excel. By using expand and collapse get an overview of data per continent or country. Get more understanding by comparing the actual to the plan and the previous year.
Intermediate
December 9, 2022
Sales overview report in Excel
This template gives a top-level overview of sales KPIs split by products and channels. For better understanding check the comparisons and trends. Align the look and feel with your company branding.
Intermediate
December 9, 2022
Revenue-cost-profit analysis
Use this template to understand the main KPIs of your business: revenue, costs, and profit. For better analysis compare them to plan and analyze the trends over time.
Intermediate
December 9, 2022
Inventory report
Use this template to visualize your inventory data directly in Excel. Use data in tables to understand the comparison of the actual numbers to plan. For analyzing trends check your data in charts. With slicers, you can track the stock across different warehouses to have a complete overview.
Intermediate
December 8, 2022
Quarterly income statement
Use this template to visualize your P&L in Excel with quarterly data. The time dimension in columns lets you understand better the performance of your KPIs. By having the chance to hide unnecessary columns you can ensure an even better clarity of reports.
Intermediate
October 21, 2022
Price-Volume-Mix variance analysis in Excel
This Excel template explains the reasons behind the revenue growth and presents top contributors for each category with a bridge chart, dynamic comments, and automatic variances.
Intermediate
October 19, 2022
Monthly Sales Variances in Excel (PY-AC-FC-PL)
The most advanced template for monthly sales variance report featuring 3 comparisons in the same waterfall or column chart: previous year, forecast, and plan compared to the actual value.
Intermediate
October 19, 2022
Monthly Sales Variances in Excel (AC-FC-PL)
On one page you can compare the actual (AC) sales performance over months to the plan (PL) and forecast (FC) with Zebra BI Charts. Automatically calculated variances are also visualized together with dynamic comments for more insights.
Intermediate
October 19, 2022
Monthly Sales Variances in Excel (AC-PY-PL)
On one page you can compare the actual (AC) sales performance over months to the plan (PL) and previous year (PY) with Zebra BI Charts. Automatically calculated variances are also visualized together with dynamic comments for more insights.