Easy Tech Tuts
Productivity & Office

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.

Fix Broken Excel Links by Changing Data Source Path

By Impran M N1 official source

Reports built on an Excel file break the moment that file moves, gets renamed, or lands in a new folder, and Power BI won't reconnect on its own. This guide covers finding the…

Upload Bank Transactions From CSV or Excel to QBO

By Impran M N2 official sources

When a bank feed isn't available, or you'd rather control exactly what gets imported, QuickBooks Online lets you bring transactions in from a file instead of typing each one by…

How to Export the General Ledger to Excel in QBO

By Impran M N3 official sources

Sometimes you need the ledger in a spreadsheet: to hand to an accountant who doesn't have a login, to reconcile a period, or to feed another report. QuickBooks Online gives you…

How to Import Data From Excel Into QuickBooks Online

By Impran M N2 official sources

Retyping a spreadsheet full of debits and credits into QuickBooks Online invites transcription errors and takes far too long. QuickBooks Online's own Import Data tool takes a CSV…