Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Advanced Excel Clean-up Skills for Accountants (for data import) - ADVANCED WEBINAR
September 20th, 2019 Webinar Recording: Advanced Excel Tip, Tricks, and Data Cleaning Tools
2-Hour Webinar Recording from Sep. 20th , 2019 (119:58)
Advanced Excel Tips from Accountants (Pre-recorded Videos)
50+ Keyboard Shortcuts that will cut your work in HALF (18:22)
Top 15 Excel 2019 Advanced Formulas, Tips, and Shortcuts (updated) (44:15)
Cleaning up dates not formatted correctly (16:24)
Extract Date, Description, and Amount with Text Formulas vs. FlashFill (17:00)
Sort, Filter, and Pivot Tables (9:59)
Multiple ways to clean up bank statements for import prep or creating pivot reports (25:19)
Batch create multiple worksheets from a table using a Pivot Tables trick (10:58)
Paste Special Deep Dive (18:29)
Introduction to EXCEL Data cleanup and Importing into QuickBooks
Exercise Files
Webinar - Part 1 - Introduction to Conversion Software and Data-Cleanup (52:31)
Webinar - Part 2 - Importing Data (57:25)
Webinar - Part 3 - Other Importing Tips (78:39)
Using MoneyThumb to Import Data into QuickBooks
Introduction to 2qbo Convert Pro+ and Excel Cleanup of Bank Transactions (22:25)
3-Hour MoneyThumb Deep Dive Webinar Webinar (187:29)
Older Pre-recordings, with relevant content
BASIC OF IMPORTING CONCEPTS INTO QUICKBOOKS (26:17)
In-Depth Bank Feeds for QuickBooks and importing Bank Statements (58:15)
BATCH ENTER TRANSACTIONS IN QUICKBOOKS DESKTOP ACCOUNTANT (21:26)
Importing Bank Transactions from PDF/CSV into QuickBooks (Both: Desktop and Online) (58:51)
IMPORTING A JOURNAL ENTRY VIA .iif FOR QUICKBOOKS DESKTOP (6:01)
QUICKBOOKS ENTERPRISE DATA IMPORTING WITH BUILT-IN TOOLS (68:53)
IMPORT CSV/EXCEL FILES USING BATCH ENTER AND ZED AXIS (56:07)
Cleaning up dates not formatted correctly
Download
Examples for dates.xlsx
Complete and Continue