Introduction to Pivot Tables in Excel

Learn how to use Pivot Tables in Excel to easily summarize data. The example uses income and expense data and shows how to summarize by account, category and date. See the corresponding blog article: https://www.vertex42.com/blog/excel-tips/using-pivot-tables-to-analyze-income-and-expenses.html 0:00 Introduction 0:14 How to Insert a Pivot Table 1:06 Using the field list pane to construct the Pivot Table 1:54 Add a Calculated Field 2:29 Changing the number formatting 2:47 Summarize data by month 3:03 Use the Timeline feature to filter by month 3:28 Show a running balance for each account by date 👍 Remember to Subscribe! FOLLOW VERTEX42 HERE: Website: https://www.vertex42.com Instagram: https://www.instagram.com/vertex42/ Facebook: https://www.facebook.com/vertex42/ Pinterest: https://www.pinterest.com/vertex42/ Twitter: https://twitter.com/vertex42 LOOKING FOR MORE SPREADSHEETS? START HERE: https://www.vertex42.com/ExcelTemplates/