Channel: Excel Campus - Jon

Category: Education

Tags: pivot table advanced tutorialpivot tablecalculated field in pivot tablecalculated fieldstips and tricksfinancial reporting and analysismicrosoft exceladvanced pivot table tips and tricks for reporting and analysisbank statements excel formatexcelexcel pivot tabledata analysis excelhow to analyse bank statements using excelexcel pivot table tutorialexcel campusbank file analysis in excel

Description: In this video, I demonstrate how to add calculated fields or calculated columns to pivot tables so that you can analyze and summarize the debits and credits on a bank or credit card statement. If you’d like to read the accompanying blog post on my website, you can access it here: excelcampus.com/pivot-tables/bank-statements-pivot-tables Related Links: 5 Reasons to Use an Excel Table as the Source of a Pivot Table excelcampus.com/tables/table-source-pivot-table Introduction to Pivot Tables, Charts, and Dashboards in Excel: youtube.com/watch?v=9NUjHBNWe9M&t=66s Refresh Pivot Table Automatically when Source Data Changes: youtube.com/watch?v=NI1UQcYtl1A&t=107s How to Calculate Total Daily Averages with Pivot Tables: youtube.com/watch?v=MDZ2Ti5iEu0 #MsExcel #ExcelCampus