If your documentation lives in Word, it's already out of date
Your process changed three times since someone saved Process_FINAL.docx. The doc looks exactly as authoritative as the day it was right.
Microsoft 365
// 41 postsTutorials, tips, and deep dives on Microsoft 365 — every post from bianca.codes tagged Microsoft 365.
Microsoft 365 posts
-
-
A week of actually using Copilot: what a beginner discovers (and what trips them up)
Seven days actually driving Copilot across Excel, Word and PowerPoint - the wins, the confidently wrong deck, and the habit that mattered more than any prompt.
-
One Copilot prompt that summarises a 20-tab workbook
The one Copilot prompt that turns twenty unlabelled tabs into a sheet-by-sheet summary, outliers included, in under a minute.
-
The Power Automate trigger that ends manual file shuffling
One Outlook trigger, configured once, means invoices and attachments file themselves before you've even opened the email.
-
Learn Python, or learn to drive Copilot? A beginner's honest fork in the road
Two tabs open, four spare hours a week, and everyone insisting the other tab is a waste of your time - here's the no-hype version of the beginner's fork.
-
Align any set of objects in PowerPoint in two clicks
One win: stop nudging boxes with the arrow keys. Select, Align, done - PowerPoint's Arrange menu lines up and evenly spaces any set of objects in two clicks.
-
Stop reading Copilot hot takes and just open the thing
Most Copilot opinions come from people who've never clicked into it. Open the thing for an afternoon and form one that's actually yours.
-
Build a self-updating summary slide in PowerPoint linked to Excel
Paste Link turns three Excel cells into a PowerPoint object that updates itself, once you stop letting the linked range look like a spreadsheet.
-
LAMBDA: the day Excel let you write your own functions
Copy-pasting the same formula across a workbook used to be the only way to reuse logic - until LAMBDA let you name it and call it like any other Excel function.
-
Power Query from Scratch, Part 1: The mental model nobody teaches you
Most people learn Power Query by clicking through wizards. Nobody explains what it's actually doing - and that gap is why queries break in confusing ways.
-
Python in Excel: When a Cell Stops Being a Number and Becomes a DataFrame
For forty years an Excel cell could hold one of four things, and Python in Excel quietly added a fifth: a whole pandas DataFrame, living inside a single cell.
-
3-Minute Win: Create a Power Query Parameter to Switch Between Dev and Prod Data Sources
A query parameter holds your data source path, so switching from a test CSV to the production SharePoint file is one dropdown, not a find-and-replace through your M code.
-
Pivot Tables Are Still Great - But GROUPBY Is What You Should Be Using for New Work
Pivot tables aren't obsolete, but reaching for one by reflex on every new analysis is a quiet tax GROUPBY does not charge.
-
Build a Self-Updating Sales Summary Using GROUPBY - From Raw Transaction Data
A raw transaction table becomes a monthly sales summary by category with one GROUPBY formula - no PivotTable, no Refresh, and it updates the moment you add a row.
-
GROUPBY: Excel's Answer to Pandas groupby - Without a Pivot Table in Sight
A pivot table is a tool you operate. GROUPBY is the same group-and-aggregate logic as a single spilled formula - the summary recalculates itself, with no fields to drag and nothing to refresh.
-
3-Minute Win: Replace Your Most-Used Pivot Table With a Single GROUPBY Formula
A pivot table is a snapshot that needs refreshing. GROUPBY is a formula that recalculates itself. Swapping one for the other takes about 90 seconds and removes a recurring chore.
-
Stop Treating SharePoint as a Database - It Will Eventually Bite You
SharePoint Lists are brilliant for what they're designed for and actively dangerous past that scope - and the limits bite when your solution has been accumulating data that matters.
-
3-Minute Win: Use REDUCE to Concatenate a Column of Values Into One Cell
Joining a column of names or tags into one comma-separated string used to need TEXTJOIN or a helper column. REDUCE does it in one formula, and lets you transform each item before it gets concatenated.
-
Build a Dynamic Data Validation List That Updates Itself When Your Source Table Grows
You'll build a dropdown list that reads from a structured table and includes every new row automatically. No named range maintenance, no 'why isn't my new entry showing up' moments.
-
MAP: Apply Any Transformation to Every Element in an Array - Without a Loop
MAP takes your LAMBDA and runs it on every element in an array. No helper columns, no dragging formulas, no VBA loops.
-
3-Minute Win: Use Power Query's 'Keep Rows Where' Filter Without Writing a Line of M
The Keep Rows filter in the Power Query UI handles 80% of row filtering tasks without you ever opening the Advanced Editor. Most people skip past it and go straight to writing M. Five clicks and you're done, and the M it generates is clean enough to modify later.
-
The Skill Nobody Told You Was Half the Job: Asking Good Questions
The analysts who get traction aren't the fastest at pulling data, they're the best at unpacking what was actually being asked. The skill is asking good questions, and nobody trains for it.
-
Power Automate Desktop: The Automation Layer That Connects the Apps That Don't Have APIs
Cloud flows are great when your data lives in SharePoint or Teams. But some processes still live in legacy apps, PDFs, or the export button of a system that predates APIs.
-
3-Minute Win: Set a Power Automate Flow to Only Run on Weekdays
Your flow runs daily — but you only need it Monday through Friday. One condition block and a formatDateTime expression, and your automation skips Saturday and Sunday without you touching it. Three …
-
How to Say No to a Data Request Without Burning the Relationship
You can't build every dashboard that gets requested. But 'no' lands differently depending on how you say it — and most data people either say yes to everything and resent it, or say no in ways that…
-
The Excel Functions Your Spreadsheet Has Been Missing for Ten Years
XLOOKUP, LET, LAMBDA, BYROW, SCAN, MAP — Microsoft shipped more genuinely useful functions in the last three years than in the previous decade. If you learned Excel before 2022 and haven't revisite…
-
Getting Credit for Work That 'Looks Easy'
The more competent you get, the less people see the effort behind what you deliver. A clean dashboard looks effortless. A fast turnaround looks like it was always fast.
-
Stop Using Helper Columns for Running Totals — There's a Better Way
Helper columns aren't wrong. But when a running total requires three of them and breaks every time someone inserts a row, you've created fragility in exchange for familiarity. The Excel array funct…
-
Build a Rolling 12-Month Balance Tracker That Updates Without Touching a Formula
You'll build a balance tracker using SCAN and a structured table that extends itself as new rows come in. No helper columns, no fragile cell references, no 'just re-paste the formula down.' Add a r…
-
SCAN: The Excel Function That Keeps a Running Total of Anything
Running totals used to mean helper columns or array gymnastics. SCAN changes that — it applies a function cumulatively across an array and hands you back every intermediate result. Once you see it …
-
3-Minute Win: Use SCAN to Add a Running Total Column Without Any Helper Columns
SCAN hands you every intermediate result as it accumulates — which means a running total is one formula that spills down the column. No helper rows, no dragging, no breaking when someone inserts a …
-
LAMBDA: How to Write the Excel Functions Microsoft Didn't
Before LAMBDA, every Excel function that existed was one Microsoft decided to write. After LAMBDA, you can write them yourself — naming the logic, hiding the complexity, and calling your custom fun…
-
Build a Word template that holds its formatting
Your Word templates shouldn't fight you on formatting.
-
3-Minute Win: Name Your LAMBDA Function and Call It From Any Cell in the Workbook
One function definition in the Name Manager, and every cell in the workbook can call it like a built-in. LAMBDA + named functions means you stop copy-pasting logic and start writing like someone wh…
-
When Your Manager Doesn't Understand What You Built
You delivered a clean model, a solid dashboard, a real solution — and got a blank look in the room. The work was right. But explaining technical work to someone who doesn't share your frame of refe…
-
Stop Manually Checking Whether That Report Got Updated
Five minutes to set up a SharePoint file-change trigger with a Teams notification. You'll never manually check whether that report got updated again.
-
LET: How to Write Excel Formulas That You Can Actually Read Tomorrow
Complex formulas aren't the problem. Unreadable ones are. Before LET, you had to repeat the same range reference six times or accept that your formula was a black box. LET gives you named variables in
-
Why 'Just Learn SQL' Is the Wrong Advice for Most Excel Users
The advice is everywhere: if you're serious about data, you need SQL. But for most analysts already working in Excel and Power BI, the gap isn't SQL knowledge - it's data modelling instinct. Here…
-
Nobody Knows What You Actually Do (And That's Partly Your Fault)
You deliver good work consistently, your manager knows you're reliable — and yet somehow you're invisible at promotion time. The problem isn't your output. It's that you've never made your work l…
-
Build a Drop-In XLOOKUP Upgrade for Every VLOOKUP in Your Workbook
Stop replacing VLOOKUPs. Your workbook deserves XLOOKUP without touching the formula.
-
Dynamic arrays: FILTER, SORT, UNIQUE - what changed
I spent years writing 400-character Ctrl+Shift+Enter arrays just to filter a table, but the calculation engine finally changed the rules and killed that misery for good.