Tip & Trick

I remember my first statistics class at Carnegie Mellon—Professor Martinez made us calculate t-distributions by hand. ⚡ Now Excel does it in one formula with T.DIST, saving hours of manual work. This function takes your data, a significance level, and spits out probabilities for hypothesis testing. It’s the same tool researchers use, but distilled into … Read more

Microsoft Teams doesn’t have to look like everyone else’s. I customised mine last week and suddenly meetings feel less like a chore and more like my own space. The free online version has more personalisation options than most people realise. You can change themes, rearrange the sidebar, and even tweak notification sounds. It took me … Read more

That sudden jump to a new page in Word is infuriating. I’ve seen users waste 20 minutes trying to backspace a break that stubbornly refuses to disappear. Here’s the thing—most people don’t realize there are two kinds of breaks, and only one responds to normal deletion. The fix is shockingly simple once you know where … Read more

I wasted two hours realigning a document once because I didn’t know this trick. Grouping objects in Word locks them together so they move and resize as one. This isn’t just for images—you can group text boxes, shapes, and even charts. The process takes under 30 seconds once you know the steps, and it works … Read more

I was editing a resume on my phone last week when I realized I needed to add my headshot. ✨ The mobile Word app makes this shockingly simple—no desktop required. You just need the Word app installed, a picture in your phone’s gallery, and 30 seconds of your time. The process works the same on … Read more

I spent years manually updating figure numbers in Word documents until I discovered the built-in table of figures. This one-click solution saves hours on long reports and academic papers. The trick is using Word’s caption feature first. Once you’ve added captions to all your images, charts, and tables, generating the table takes under 30 seconds. … Read more

I spent years copying and pasting between spreadsheets until I learned this method. One formula or Power Query step can link workbooks and keep data synced automatically. Whether the other sheet is open or closed, you can pull in data with =[Workbook.xlsx]Sheet1!A1 or use Power Query for more control. The setup takes less than 2 … Read more

I still remember the first spreadsheet my uncle showed me in that 1998 basement workshop. Numbers made sense, but percentages? That took a few extra tries to nail down. Multiplying percentages in Excel is one of those tasks that seems tricky until you see the pattern. The key is understanding that 25% isn’t 25—it’s 0.25 … Read more

I spent two hours manually comparing columns last week before remembering this trick. Excel’s conditional formatting can highlight mismatches between two columns in under 60 seconds. Here’s the thing—most users don’t realize you can set rules to compare entire columns at once. No formulas needed, just point-and-click. I’ve used this on 10,000+ row datasets with … Read more

Renaming a OneNote notebook on Mac is simpler than most users realize. I’ve helped dozens of people in Five Points who were stuck on this exact step, and the solution always comes down to knowing where to look. The process starts in the notebook list—right-click the notebook name, select rename, and type your new title. … Read more