In partnership with
If you’ve got 2 minutes, please give us your view by filling in our survey. This helps us create content YOU love.
Hey! It’s Jack.
Today, we’re wrapping up our Excel series with 10 tricks you’ll actually use — some handy tips to take away and start implementing straight away.
Keep an eye out later in the week for a vote on our next series of emails; we’re letting YOU pick what we write about next…
In this edition of On The Pulse:
10 Excel tricks you’ll ACTUALLY use daily
The (very) odd way people are using ChatGPT…
Foldable game consoles and extending screens?!
Table of Contents
Let’s get started!
You’re Doing Breakfast Wrong
Discover Huel Black Edition—complete nutrition without compromise.
With 40g of protein and 27 essential vitamins, it’s the perfect meal for your busy life. Whether at home or on the go, fuel up in seconds with a high-protein meal.
Even better? New customers get a bundle of savings to kickstart their Huel journey. Use code BEHUEL15 for 15% off your first order, plus a FREE t-shirt and shaker.
🔍 FAVOURITE FINDS
📰 News
Indiana is set to receive a massive $15 billion investment from Big Tech companies like Amazon, Microsoft, and Google to build new AI-powered data centers, but residents are pushing back against the potential spike in their energy bills. With projections showing data centers could soon use more power than the entire state’s population, lawmakers are considering a bill that would force tech firms to cover 80% of the infrastructure costs. While the measure aims to shield consumers, it also allows utilities to pass costs of small nuclear reactors onto residents, raising concerns from consumer advocacy groups. The debate highlights the growing tension between AI’s energy demands and fair cost distribution — because as much as tech giants promise “green energy,” for now, it’s mostly coal and gas keeping the lights on.
🧐 Interesting
Samsung has unveiled a futuristic lineup of display technology at Mobile World Congress, including a foldable gaming console, a stretchable screen, and even a TV that folds neatly into a briefcase. Among the standout innovations is the Flex Gaming device, a Nintendo Switch-style console that folds in half for portability, and the Flexible Cabinbag, an 18.1-inch OLED screen disguised as a carry-on bag for travellers. Samsung also showcased OLED Tile, a nearly bezel-less modular TV system, and a stretchable display capable of expanding 125% of its original size. While these concepts are still in development, they highlight Samsung’s ambition to redefine how we interact with screens in everyday life. Honestly, it’s wild to see tech that once seemed like sci-fi become reality — if Samsung can bring these ideas to market at a reasonable price, the future of portable and customisable displays is looking seriously exciting.
Couples are turning to ChatGPT for relationship advice, using it as a budget-friendly, neutral “referee” to resolve disputes and improve communication. LA-based duo Abella Bala and Dom Versaci swear it’s saved their relationship, while others praise its instant, judgment-free feedback. Experts warn AI lacks the depth of a real therapist and raises privacy concerns, but its convenience is winning people over. It’s a clever hack for minor issues, but should we really be outsourcing emotional intelligence to a chatbot? AI might help smooth out arguments, but real relationships need more than just logic.
✨ DEEP DIVE
Here’s Why Over 4 Million Professionals Read Morning Brew
Business news explained in plain English
Straight facts, zero fluff, & plenty of puns
100% free
💯 10 Excel Tricks You’ll Actually Use
We’ve covered formulas, shortcuts, and collaboration, but before we wrap up the series, here’s a final set of Excel tricks that will save you time and frustration. These are the ones you’ll actually use — whether you’re crunching numbers, cleaning up data, or just trying to work faster.
1. Double-click for instant results
💡 Tired of dragging formulas? Instead of clicking and dragging the fill handle, double-click the bottom-right corner of a cell—Excel will auto-fill the column down as far as the data goes.
2. Quickly jump to the end of your data
⏩ Ctrl + Arrow keys will take you to the last filled cell in a column or row. Add Shift to select everything in between.
3. Flash fill: Let Excel spot the pattern
⚡ Excel can automatically fill in data based on a pattern.
• Type a first name in one column and a last name in another.
• Start typing full names in a new column.
• Press Ctrl + E and Excel will complete the list.
Great for splitting or combining names, formatting phone numbers, or fixing inconsistencies.
4. Select all data in seconds
📌 Ctrl + A selects everything in your table.
📌 Ctrl + Shift + Space selects the entire worksheet.
Useful when copying, formatting, or making changes across multiple cells.
5. Fix errors fast with F2
✏️ Click a cell and press F2 to edit it directly. No need to double-click or retype the entire cell.
6. Transpose data without retyping
🔄 Need to switch data from rows to columns (or vice versa)?
1. Copy your data.
2. Right-click where you want it.
3. Select Paste Special > Transpose.
Perfect for flipping tables around without manually copying every value.
7. Clean up messy data with TRIM
✂️ If you’ve copied text from another source, extra spaces can cause errors. Use:
=TRIM(A2)This removes unwanted spaces before and after text while keeping single spaces between words.
8. Insert multiple rows in one go
➕ Instead of inserting rows one at a time:
1. Select the number of rows you need.
2. Right-click and choose Insert.
Excel will add as many new rows as you originally selected.
9. Lock headers for easier scrolling
🔒 Freeze Panes keeps your headers visible while scrolling.
• Click the row below your headers.
• Go to View > Freeze Panes > Freeze Top Row.
Now, your titles stay put while you scroll through data.
10. Speed up work with a simple shortcut
⌨️ Alt + = automatically adds a SUM formula to the selected column or row—no need to type it manually.
Final Thought: Work Smarter, Not Harder
These tricks aren’t just cool—they’ll actually make your work easier. Whether you’re cleaning up data, moving faster with shortcuts, or automating small tasks, these little changes add up.
Try them out this week, and let us know—which one is your favourite? 🚀
✅ WRAPPING UP!
That’s all for this edition of On The Pulse.
Thanks for reading and see you soon! 👋