With Mbrella, you can easily export your data to an Excel file and use pivot tables to filter and analyze the information you need. This guide will walk you through the steps to export your data and create a pivot table in Excel (or Google Sheets) to make data filtering easier and more effective.
Step 1: Exporting Data from Mbrella
Go to the relevant section in Mbrella and select the data you’d like to export.
Click the Export button and choose Excel as the file format.
Save the file to your preferred location.
Step 2: What is a Pivot Table?
A pivot table is a powerful data analysis tool available in spreadsheet applications like Excel and Google Sheets. It allows you to summarize, filter, and group data dynamically. With a pivot table, you can focus on specific data points without changing the original data.
Step 3: Creating a Pivot Table
Follow these steps to create a pivot table in Excel or Google Sheets:
Open the Excel file you exported from Mbrella.
Select the data range you want to use in the pivot table.
In Excel, go to Insert > PivotTable. In Google Sheets, go to Data > Pivot table.
Choose a new worksheet or an existing one for the pivot table.
Configure the pivot table by dragging fields to the following areas:
Rows: Define categories you want to organize (e.g., date, employee name).
Columns: Define additional fields to compare across the row categories.
Values: Select numeric data to summarize (e.g., total costs).
Filters: Set filters for refined data views.
For more details, consult the official documentation: