Level of knowledge: Intermediate

March 10, 2023
Top 3 Financial Statements in Excel: Income Statement, Balance Sheet & Cash Flow
To gain insight into their financial health and progress, most companies need to prepare three essential reports – income statement, balance sheet and cash flow statement. Let's explore them one by one.
Intermediate
February 21, 2023
Sales variance analysis report templates for Excel
Visualize your sales performance with these easy-to-use templates for Excel. Compare your actuals with up to 3 measures (PY, PL and FC) and take advantage of advanced visualization features to show business insights in the clearest way possible.
Basic
Intermediate
February 18, 2023
Income statement templates for Excel
Use these high-quality income statement templates for Excel to uncover key business insights easier and visualize your P&Ls faster than ever.
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.

Pagination