Mention the INDIRECT function in an Excel forum and you'll start a fight. It's volatile, meaning it's always awake and recalculating, which can turn a fast spreadsheet into a sluggish mess. But used correctly, it's a power user's secret weapon for building dynamic, reactive dashboards.
VBA used to be the only way to handle iterative, multistep logic in Microsoft Excel. Not anymore. REDUCE brings the power of functional programming directly into your cells, allowing you to condense complex, messy data into single, clean results.
Many Excel users abandon the ROWS function because it feels like a technicality they can skip. However, to build a truly functional workbook, you need formulas that adapt to your data dimensions, and the ROWS function is ideal for this. Here are four ways I use it to make my Excel spreadsheet smarter.
These tricks show how AI tools, new import formulas, and classic features improve productivity.
The post 10 Clever Microsoft Excel Tricks to Use in 2026 appeared first on TechRepublic.
These tricks show how AI tools, new import formulas, and classic features improve productivity.
The post 10 Clever Microsoft Excel Tricks to Use in 2026 appeared first on TechRepublic.
Don't let that extra "S" fool you—ROW and ROWS do completely different jobs in Excel. One tells you where you are, while the other tells you how much space you have. If you're tired of formulas breaking when you delete a row, it's time to master the difference between these two tools.
You've built a perfect Excel table, but the moment you try to use its headers in a drop-down menu, everything breaks. Excel's Data Validation is notoriously picky with tables, but there's a clever workaround. So, stop hard-coding your menus and use this dynamic sync instead.
If you can't get Microsoft Teams, Outlook, or other Microsoft apps to work right now, you're not alone. There's an outage that has taken out several Microsoft 365 services, and a fix is in the works.
Microsoft 365 is not the only suite around, and it doesn't have the best tools on the market. Yet, many professionals, students, and casual users are completely tied to it. However, before you commit to another payment cycle, it's smart to hit the brakes and seriously look at alternatives that are free, open source, and may work better.
Your Excel spreadsheet might be lying to you. No, it's not a conspiracy—it's just a collection of common, invisible killers that bypass error checks and ruin your reporting. So, let's hunt down these silent traps and fix them for good.
People often confuse Excel's LAMBDA and SCAN functions because they often appear together in formulas. However, they aren't the same: LAMBDA is the "brain" that defines the logic, and SCAN is the "vehicle" that carries it out. Here's how to tell them apart.
There's a ghost in your Excel spreadsheet. It's that invisible text box you keep accidentally clicking, or the chart that refuses to be selected. Instead of losing your mind, use the Selection Pane, the hidden sidebar that reveals every object on your sheet so you can manage them with ease.
Stop trying to win an Excel Hero award with ten-line formulas. They're impossible to debug and even harder to explain to your coworkers. Using helper columns doesn't mean you're a beginner—it means you're an engineer building a system that actually lasts. Here's why the simplest solution is actually the best.
Excel's fill handle is fine for a few rows, but in a big dataset, it's an error waiting to happen. Why drag and drop when you can automate? The MAP function lets you write a single formula that spills logic across your whole sheet, keeping your data clean and your workflow streamlined.
[Editor’s Note: Agents of Transformation is an independent GeekWire series and March 24, 2026 event, underwritten by Accenture, exploring the people, companies, and ideas behind AI agents.]
Microsoft is making its own bid to turn AI conversations into agentic commerce, announcing a new feature called Copilot Checkout that lets users complete purchases directly within its AI chatbot, without being redirected to an external website.
The company is betting that its existing enterprise technology footprint and established relationships with large retailers will give it an edge over OpenAI, Google, and Amazon in winning over merchants wary of giving up control to retail rivals or AI intermediaries.
“We’ve designed it in such a way that retailers own those relationships with the customers,” said Kathleen Mitford, corporate vice president of global industry marketing at Microsoft. “It is their data, it is their relationship, and that’s something that’s really important to us.”
It’s part of a broader AI rollout by Microsoft at NRF 2026, the retail industry’s annual conference in New York. Microsoft is also launching Brand Agents, pitched as a complete solution for Shopify merchants to add AI assistants to their websites, along with new AI tools to assist store employees and help retailers enhance their online product listings and metadata.
Copilot Checkout works by surfacing products from partner retailers within Copilot search results. Purchases can be completed without leaving the conversation. Microsoft says the retailer remains the merchant of record, handling fulfillment and customer service.
The bigger question for the tech industry is whether chat-based commerce is actually the next big thing. Forrester analyst Sucharita Kodali, for example, previously told GeekWire that “e-commerce isn’t a problem that needs to be fixed.” She added that it’s unclear what value chat-based commerce is bringing to retailers, “other than disintermediating Google.”
Microsoft’s Mitford offered a different take in an interview this week, saying that consumer behavior is shifting faster than it may seem. She drew a parallel to how quickly businesses moved from experimenting with AI to putting it into operation over the past year.
“I see the same thing happening with consumers … it just takes a little bit of time,” Mitford said, predicting that the speed of consumer adoption will eventually match the rapid uptake seen in the business world.
Copilot Checkout is rolling out now in the U.S. on Copilot.com, with PayPal, Shopify, and Stripe handling payment processing. Etsy sellers will be among the first available on the platform. Shopify merchants are set to be automatically enrolled following an opt-out window.
That last detail is notable given the backlash Amazon has faced over its “Buy for Me” feature, where brands complained about being included without consent and seeing inaccurate listings.
Microsoft’s approach is more tightly connected to its partners — the company said Shopify will management the opt-out process for its merchants — but automatic enrollment seems to raise the potential for some of the same concerns. (We’ve contacted Shopify for more information.)
More broadly, Microsoft is playing catch-up on the consumer side.
OpenAI launched Instant Checkout in ChatGPT last September, partnering with Shopify and Stripe to let users buy from more than a million merchants. Google followed in November with its own “Buy for Me” feature which lets its Gemini assistant purchase products on a user’s behalf.
Despite its inroads with businesses, Copilot has a fraction of ChatGPT’s market share with consumers. Recent data from Similarweb’s Global AI Tracker showed ChatGPT with about 68% of AI chatbot web traffic, with Google Gemini at 18% and Copilot in the single digits.
But Microsoft has its advantages: Unlike Amazon and Google, which compete directly with retailers through their own marketplaces, it isn’t a retailer. And retail has long been a major vertical for its enterprise cloud and software business, with large chains running on Azure and Microsoft 365.
Mitford said Microsoft is leaning on its existing trust and long-standing relationships with retailers, along with a commitment to responsible AI, to help differentiate itself from rivals.
Microsoft is making the broader case for AI to retailers based on return on investment. A Microsoft-commissioned study from IDC, released in November, found that retail and consumer packaged goods companies are seeing a 2.7x return on every dollar spent on generative AI.
Mitford, a former fashion designer who has been in the technology industry for most of her career, said she sees the retail sector among the leaders in AI uptake across the business world.
The technology, she said, is being “adopted at a pace that I’ve never seen.”
Unable to send, receive, or search email through Exchange Online? Microsoft Outlook suffered an outage for several hours last night, disrupting North America and worldwide email services. Proactive and Early Outage Detection Exoprise sensors first detected and confirmed the outage at 11.03 pm in our London region last night. There was a second outage at…
The post Microsoft Outlook Outage on 6th February EX512238 appeared first on Exoprise.
Microsoft had its corporate earnings call yesterday and posted weaker guidance. But guess what? Several hours later, the tech giant was hit by a networking outage that took down Azure and other services like Teams and Outlook, affecting millions of users globally. Early Detection of Microsoft Teams and Outlook Outage Here’s an email our customers…
The post Microsoft Outage on 25th Jan 2023 MO502273 appeared first on Exoprise.
Login