Easy Tech Tuts
Fix Broken Excel Links by Changing Data Source Path
By Impran M N
Reports built on Excel data break the moment the underlying file moves, gets renamed, or is shared to a different folder path, and Power BI won't fix that on its own. This guide…
Microsoft Excel tutorials
5 free, step-by-step Microsoft Excel guides covering setup, common tasks, fixes, and best practices — each illustrated with screenshots from the app itself.
How to Combine Multiple Excel Files in Power BI Easily
By Impran M N
Manually pasting together data from a handful of separate Excel files is tedious and error-prone, especially when new files keep arriving from different departments. This guide…
Upload Bank Transactions From CSV/Excel to QBO
By Impran M N
When a bank feed isn't available, or you'd rather control exactly what gets imported, QuickBooks Online lets you bring transactions in manually from a CSV or Excel file instead of…
How to Export the General Ledger to Excel in QBO
By Impran M N
Handing a bookkeeper or accountant a live QuickBooks login isn't always practical, and sometimes you just need the numbers in a spreadsheet you can sort, filter, or drop into…
How to Import Data From Excel Into QuickBooks Online
By Impran M N
Retyping a spreadsheet full of debits and credits into QuickBooks Online is slow and invites transcription errors. QuickBooks Online's journal entry screen includes a…