Clean up bank transaction data in Excel to build a pivot table report or import it into QuickBooks

QuickBooks 30-day free trial + 30% off for 12 months: https://quickbooks.intuit.com/partner... Take my full Advanced Excel Course for Accountants for $100: https://hectorgarcia.teachable.com/p/... Clean up bank transaction data in Excel to build a pivot table report 00:00:00 – Select all button or CTRL A in excel CSV file 00:00:42 – How to expand columns in excel 00:01:21 – How to separate or clean up data from columns (duplicate data, insert new column, use formulas, etc.) (step by step) 00:04:27 – How to convert a number to a text (formula) 00:06:30 – How to separate debits and credits (formula) (IF formula) 00:14:16 – How to clean up the data (formula) 00:16:30 – Find and replace (how it works) 00:18:30 – Paste special (shortcut) 00:19:07 – Open new column (TRIM formula) 00:20:15 – Select all, data, filter (enable filters) (sort by) 00:22:05 – Select all, insert tab, pivot table (create a pivot table and how it works)