Automating Gathering and consolidating of data files and more automation, Creating PivotTables that automatically refresh with data source thru VBA Excel.
Importing Binary Excel files from another workbook and automatically update with the original source sheet. Creating eye catching tables, graphs and PivotTables.
Automating Reconciliation of bank deposits to credits and debits.
- Power Query Combining multiple files
- Writing formulas for reconciling debits & credits
- Cleaning, organizing data for analysis
- Automating repetitive tasks
- Creating Fillable Purchase Orders
- Creating Inventory stock reports and spreadsheets
- Linking files to automatically update copied link
- Creating AR Aging reports and Collections letter
- Creating Flyers
- Creating PowerPoint presentations