Read a selection of tips & tricks that make using Microsoft Excel, Power BI, SQL and more way easier!

Download a staff-list workbook and practise calculating age from a date of birth with DATEDIF, a fixed reporting date and checks for blanks, future dates and leap-day birthdays.

Clean a genuinely messy Excel export with Power Query: strip junk rows, standardise text, fix data types, then refresh next month's file in one click. No formulas.

Save Outlook email attachments to a SharePoint library automatically with Power Automate — a step-by-step build, every trigger setting and field explained. No code.

Post a Microsoft Teams alert automatically whenever an important email arrives, using Power Automate — every trigger filter and message field explained. No code.

Turn every Microsoft Forms response into a Planner task automatically, using Power Automate — the trigger, the "Get response details" catch, and field mapping explained. No code.

Build a Power Automate flow that checks a SharePoint list daily and emails a reminder before anything's due — no more missed deadlines, no manual chasing.

Build a Power Automate flow that sends approval requests straight into Teams — one click to approve or reject, no reply-all chains, no chasing.

Build a Power Automate flow that logs every Microsoft Forms response straight to an Excel or SharePoint list automatically — one running record, no copy-paste.

Build a Power Automate flow that gathers the week's list updates and posts one digest to Teams automatically — no more chasing status updates by hand.