Fix Payroll Mappings with Quickbooks Online
TIMESTAMPS 0:00 0:57 Intro QBO Demo 1:40 Payroll Settings Payroll Accounting Edits 4:23 Edit wages mappings for all employees 5:11 Update mappings for past transactions based on date range
Create SKU Sales Reports in Excel with Power Query Help
0:00 Intro 1:30 Demo begin 2:45 Power Query - Text Between Delimiters to pull out SKU number 6:12 XLOOKUP to fetch SKU number related product name 9:00 Summarize with PivotTable 11:28 Analyze with PivotTable Charts 11:55 Insert Timeline to filter dashboard sales graph by dates
