Welcome to This Week’s Tech Tips!
Helping you work smarter — one click at a time.
New on YouTube
Quick Navigation Tools in Microsoft Word
If you work with long Word documents, this one’s for you.
I’ve just released a new video showing how to move around large documents quickly and update formatting in seconds using Styles, the Navigation Pane, and the Table of Contents.
No more endless scrolling.
No more manually fixing headings one by one.
These built-in tools can completely change how you work in Word — and save you a huge amount of time.
🎥 https://www.youtube.com/watch?v=e5_musbUgBk
Coming Soon – Live Workshop
Inspired First. AI Second.
How to Fill Your Social Media Calendar — Easily and Quickly
I’m running a brand-new live workshop on 25 March 2026 (4–6pm London Time) — and you’re hearing about it first.
If you’re a small business owner (or manage social media for one) and want to post more consistently — without letting AI take over your voice — this session will give you a clear, practical framework to plan content quickly and confidently.
💷 £32.40 (27+VAT)
🔗 Details here:https://businessittraining.com/inspired-first-ai-second/
Official launch is coming soon — but you’re very welcome to grab your place now.
Quick Pro Tip
Excel Foundations People Get Wrong – Week 2
Let’s talk about relative vs absolute references.
Say you create a formula like:
=(B5*B2)*100
You might be calculating how a product price (B5) changes based on a percentage increase stored in B2.
It works perfectly… until you copy it down.
By default, Excel uses relative references, which means when you drag the formula:
- B5 becomes B6, B7, etc.
- B2 also becomes B3, B4, and so on
Sometimes that’s helpful. In this case? Not so much.
What you actually want is:
- The product price to change row by row
- The percentage increase to stay fixed in one cell
To lock it in place, you use an absolute reference:
=(B5*$B$2)*100
The $B$2 tells Excel:
“Always use this exact cell.”
Now when you copy the formula down:
- B5 adjusts
- $B$2 stays put
💡 Quick tip: Highlight a cell reference in your formula and press F4 to toggle between relative and absolute.
This small detail prevents big mistakes — especially in budgeting and forecasting.
(And if you’d like a video on mixed references, just let me know!)
In Case You Missed It
If you’re more of a visual thinker and rows of numbers make your eyes glaze over, this one’s worth a watch.
In Easy Excel Hack to Visualise Your Data with Sparklines, I show you how to turn plain spreadsheet data into mini graphs directly inside your cells.
Perfect for reports.
Great for meetings.
Much easier to interpret at a glance.
🎥 https://youtu.be/QXwaz7CTOZA
Thanks for reading — and as always, if there’s a tool you’d like me to cover next on my channel, just hit reply and tell me.
Katherine at Business IT Training
0 comments