50 Excel Hacks That Make Spreadsheets Work For You
Most Excel users waste hours on tasks that take experts minutes. The difference is not talent. It is knowing the right shortcuts.
These 50 Excel hacks from Kenji Explains cover the functions, formulas, and workflows that make spreadsheets work for you instead of against you.
Each one comes with step-by-step instructions and ready-to-use templates. Subscribe to Marketing Against the Grain and get all 50 free.
Here's what you'll get:
Time-saving shortcuts that eliminate the most common formula frustrations
Interface essentials most users never discover on their own
Game-changing functions for data analysis, automation, and visualization
Guided practice template so you can apply every hack immediately
The people who are fast in Excel are not smarter. They just stopped fighting the tool.
Get 50 Excel Hacks free when you subscribe to Marketing Against the Grain today.

Special Cannes Weekly Edition
Something weird happens every June. America's adtech industry packs up its laptops, AI decks, expense accounts and carefully rehearsed buzzwords and relocates to the French Riviera. For one glorious week, it seems like every vendor, consultant, measurement company and agency executive disappears from the U.S. and magically reappears within walking distance of the Croisette. It's less an advertising festival these days and more an annual migration pattern.
There's nothing wrong with Cannes. Business gets done. Relationships matter. But maybe bragging about billion-dollar exits, record profits and ever-growing slices of advertisers' budgets isn't the best look while regulators back home are finally asking uncomfortable questions about transparency, measurement and whether the industry has been grading its own homework for the last decade. Read the room. Or at least read the subpoenas.
Walmart Buys the Billboard
Vibe.co spent the last year making itself impossible to ignore, plastering New York subways, San Francisco streets and just about anywhere marketers gathered with ads promoting its self-serve CTV platform. Apparently it worked. Walmart agreed to pay $1.4 billion for the French company, adding another important piece to its growing advertising empire alongside Vizio and Walmart Connect. Sometimes the best acquisition strategy is simply buying the company whose ads you can't stop seeing.
The bigger story is what Walmart is actually building. Connected TV is becoming performance media, powered by retail data instead of Nielsen ratings. Walmart doesn't just want advertisers buying streaming commercials—it wants to prove those commercials sold shampoo, cereal and patio furniture. That's a much stronger pitch than promising "brand lift." Retail media continues its march toward becoming the industry's most dangerous competitor.
Everyone Wants to Own Television
The Vibe acquisition wasn't happening in isolation. Fox wants Roku. Paramount and Skydance are finally together. Warner Bros. Discovery continues reshuffling. Everywhere you looked this week, somebody was buying somebody else in television. Apparently everyone reached the same conclusion: whoever controls the screen controls the advertising.
It's also becoming obvious that the future isn't about owning content alone. It's about owning the identity, the data, the commerce layer and eventually the AI agent buying the ads. Television isn't consolidating because executives suddenly love each other. It's consolidating because nobody wants to become just another supplier inside someone else's ecosystem.
PMG Actually Built Something
While much of Cannes featured executives explaining how AI would someday transform marketing, PMG quietly hosted an AI hackathon where developers, strategists and creatives built working products using large language models to solve actual client problems. Funny how the people writing code needed fewer beach parties than the people writing PowerPoint slides.
The difference matters. AI has officially entered its "show me" phase. Every consultancy now has an AI framework. Every holding company has an AI manifesto. Fewer companies have engineers shipping software that marketers can actually use next Monday morning. That's where competitive advantage comes from—not another keynote explaining why change is coming.
Creators Graduated
One of the biggest shifts at Cannes wasn't another AI announcement—it was watching creators stop acting like influencers and start behaving like media companies. MediaLink's exclusive dinner gathered some of the world's biggest creators alongside senior marketers, and the conversations weren't about follower counts or engagement rates. They were about businesses, partnerships and intellectual property.
The creator economy has finally reached adulthood. Brands don't want to rent audiences anymore—they want long-term creative partners. The smartest creators know this, which is why they're pitching franchises instead of sponsored posts. The days of treating creators as an extension of the social media team are ending. They're becoming strategic partners with leverage.
Brands Finally Got the Memo
Executives from Unilever, Bose, LinkedIn and P&G all spent the week saying essentially the same thing: creators aren't a media channel—they're part of how brands get built now. That's a dramatic shift from just a few years ago, when influencer marketing was often treated like an experimental line item buried somewhere inside PR.
Of course, saying creators matter is much easier than reorganizing a Fortune 500 marketing department around them. Budgets remain fragmented, ownership remains confused and measurement still lives in three different departments. Until companies solve those operational problems, creator marketing will continue to punch below its weight despite everyone agreeing it's the future.
Everyone Loves AI. Everyone Is Nervous.
If there was one statistic that captured Cannes, it came from McKinsey. Eighty-seven percent of marketers say they're excited about AI. Fifty-seven percent admit they're anxious about what it means for their jobs. Welcome to modern marketing, where optimism and existential dread happily coexist over overpriced rosé.
The numbers get even better. Nearly sixty percent of marketers use AI every week, yet fewer than ten percent say they're seeing meaningful business value across their organizations. In other words, everyone has ChatGPT open in another browser tab, but almost nobody has figured out how to redesign their business around it. Adoption is easy. Transformation is hard.
Advertising Invented Another Acronym
Omnicom and NBCUniversal unveiled Dynamic Contextual Content, pairing Acxiom audience data with scene-by-scene metadata from NBC programming so advertising creative can adapt based on what's happening on screen. It's contextual advertising pushed to an entirely new level, where your commercial changes because someone on television walked into a forest instead of a kitchen.
The technology is genuinely impressive. The naming convention is exhausting. Advertising has somehow convinced itself that innovation is measured by acronym density. Still, if marketers can finally deliver creative that feels relevant without relying entirely on third-party cookies, that's real progress—even if explaining it requires an alphabet soup of product names.
Retail Media Keeps Eating Everything
One of the quieter themes of Cannes was how quickly retail media is expanding beyond sponsored search. Retailers including Walmart, Amazon, Target, Kroger and Albertsons are investing heavily in creator ecosystems, affiliate programs and content partnerships designed to connect entertainment directly to commerce. They're becoming publishers, talent managers and media companies all at once.
It makes perfect sense. Retailers already know what consumers buy. Now they want to influence what consumers want before they ever reach the checkout page. That's a much bigger business than banner ads. The next retail media war won't be fought on retailer websites. It'll be fought wherever consumers spend their attention.
Gary Vee Finally Said the Quiet Part Out Loud
Leave it to Gary Vaynerchuk to provide the most brutally honest quote of the week. During a Cannes discussion, he described much of the media industry as "borderline fraud," arguing that too many companies justify their own value by inventing measurement systems that conveniently prove they deserve more money. Plenty of people laughed. Plenty more shifted uncomfortably in their chairs.
Whether you agree with him or not, his timing couldn't have been better. As regulators begin asking tougher questions about measurement, transparency and accountability, the industry's biggest challenge may no longer be convincing advertisers to spend more. It may be convincing them the numbers were real in the first place. Cannes celebrated advertising's future. Gary reminded everyone there's still some unfinished business from its past.
Stay Bold. Stay Curious. Know More Than You Did Yesterday.

Walmart Paid $1.4 Billion for a Billboard
Let me get the embarrassing part out of the way first, because it's the part nobody in Bentonville will say into a hot mic.
Vibe.co is a self-serve connected-TV ad platform.
Translation: it's software that lets a mattress store or some creatine bro's DTC brand buy streaming commercials the way they buy Instagram ads. Click, go, measure. It's a nice little product. It is also, and I mean this lovingly, the kind of thing three caffeinated engineers could rebuild in a year. The moat here is ankle deep. You could wade across it in Crocs.
So why did Walmart cut a check for $1.4 billion, of which $1.2 billion is cash and roughly $180 million is just sprinkled directly onto the founders to leave to keep them from wandering off?
That second number is the whole tell. You don't pay retention bonuses for code you could clone. You pay them for people who walk out the door with the magic in their pockets. Walmart didn't buy a moat. It bought the guys who know where the moat isn't.
Which leaves the question you're already asking: is this strategy, or is this panic wearing a strategy costume?

The case for panic
Here's what desperation looks like in 2026. Everyone in television woke up on the same morning with the same thought (never a good sign), and the thought was: whoever owns the screen owns the money. So now they're all sprinting for the screen like it's the last lifeboat. Fox is paying $22 billion for Roku. Paramount and Warner Bros. Discovery finally stopped flirting and merged. It's musical chairs, except the players noticed there aren't enough chairs and started showing up with their own folding ones.
In that room, paying $1.4 billion for a company whose biggest public achievement was being annoying on the subway does not scream cold-blooded M&A. It screams retailer-who-counted-the-chairs-and-grabbed-the-nearest-one. Vibe spent a year carpet-bombing New York platforms and San Francisco sidewalks and every conference lanyard on Earth, and the oldest gag in the business came true: the fastest way to get acquired is to make the acquirer unable to stop seeing your ad. Congratulations, you played yourself, Walmart.
The case it's not panic at all
And yet. Squint past the billboards at what Walmart is actually stacking up, and traditional TV should be skipping lunch.
Walmart does not want you to buy a streaming ad. Walmart wants to prove your streaming ad sold the shampoo. It knows what 240 million weekly customers buy, browse, and search for, and bolting that onto CTV targeting gets you closed-loop measurement from impression to checkout. The networks have never offered that and never will. "Brand lift" is what you sell when you can't prove anything happened. Walmart is selling the receipt.
Vibe was never the asset. Vibe is the on-ramp, the self-serve front door for all the little-guy advertisers who'd rather die than call a national ad rep, funneling their performance budgets straight into Walmart's pipes. $3.5 billion-plus on CTV in two years, counting the $2.3 billion Vizio buy, is not a side hustle. That's a grocery chain announcing what it wants to be when it grows up, and the answer is Amazon.
The numbers cosign the swagger. Walmart's ad business grew 50% year over year last quarter. Groceries run on single-digit margins. Ads do not. You can see this strategy from space.
So which is it
Both. Sorry. That's the annoying, correct answer.
The product is replicable, and Walmart almost certainly overpaid. But the software was never the point, the door was the point. Television isn't consolidating because executives suddenly enjoy each other's company. It's consolidating because nobody, not Fox, not Paramount, not Walmart, wants to wake up as a supplier inside someone else's ecosystem. The endgame isn't owning the content. It's owning the identity, the data, the commerce layer, and eventually the AI agent buying the ads while everyone's asleep.
Walmart didn't pay $1.4 billion for Vibe. It paid $1.4 billion to own the door before someone else builds one and starts charging it rent.
The panic and the strategy are the same move. That's the part that should keep you up.
You're reading the free edition.
ADOTAT+ is where the work happens.
The full ADOTAT Scorecards. Vendor comparisons that name winners and losers, with the analysis your planning team needs before Q3 budget meetings.
The takes nobody else will publish. Independent means we don't answer to vendors, agencies, or the trade press establishment.
The archive. Every Scorecard, every analysis, searchable. The reference layer for how this industry actually works.
Read by senior leaders at every major holding company agency, GroupM, Publicis, Omnicom, IPG, Havas, Dentsu, and inside the buying and strategy teams at Netflix, Roku, Pinterest, Disney, NBCUniversal, Spotify, Amazon, Meta, and most of the platforms shaping where ad dollars actually go.
If your competitors are reading ADOTAT+ and you aren't, you're planning with less information than they are.
$99/month. $999/year (save $189). Expense it.
[ Join ADOTAT+ ]
Founding member rate. Locks in for life.
Also, no ads. Zero ads. No Ads.
Subscribe to our premium content at ADOTAT+ to read the rest.
Become a paying subscriber to get access to this post and other subscriber-only content.
Upgrade



