Let ChatGPT Do the Spreadsheet Heavy Lifting

Let ChatGPT Do the Spreadsheet Heavy Lifting

ChatGPT can now work directly inside Excel and Google Sheets, helping users build, clean, explain, and update spreadsheets without leaving the workbook. It is especially useful for budgets, reports, trackers, financial models, messy data, and formulas that need a second look.

By Rodger Mansfield, Technology Editor

May 18, 2026

Subscribe | Read the Newsletter Version

Few productivity tasks create more quiet frustration than opening a spreadsheet you did not build.

The formulas are buried. The labels are inconsistent. 

Three tabs seem important, two tabs appear abandoned, and one cell is throwing an error that breaks the whole report.

That is exactly where ChatGPT for Excel and Google Sheets becomes useful. 

OpenAI’s spreadsheet add-ins place ChatGPT in a sidebar inside Excel or Google Sheets, where it can help build, update, clean, and explain spreadsheet work using plain-language instructions. 

OpenAI says the feature is available globally to ChatGPT Free, Go, Plus, Pro, Business, Enterprise, Edu, and K-12 users, with usage limits depending on plan type.

Here’s a Cool Tip: Use ChatGPT as your spreadsheet co-pilot before you touch the formulas.

AI Image Editing in PowerPoint

AI Image Editing in PowerPoint

PowerPoint now includes a full AI image editor that can clean up photos, remove objects, and enhance slides without leaving the app. It’s one of the most useful upgrades Microsoft has shipped in years.

By Rodger Mansfield, Technology Editor  

April 20, 2026

Subscribe | Read the Newsletter Version.

Every presenter knows the pain of scrambling to fix a photo minutes before a meeting. 

Maybe the lighting is off. Maybe there’s a stranger in the background. Maybe the image looks fuzzy on a big screen. 

Until now, you had to jump into a separate app to fix it. 

Here's a Cool Tip:  Edit PowerPoint Images with AI.

PowerPoint’s new AI image editing tools turn the app into a capable photo editor that handles the most common fixes with surprising accuracy.

Excel’s GROUPBY Function: Pivot Table Power In A Single Formu

Excel’s GROUPBY Function: Pivot Table Power In A Single Formula

Turn messy Excel lists into live summary tables with one formula. GROUPBY gives you Pivot Table style insight without the Pivot Table overhead.

By Rodger Mansfield, Technology Editor

April 6, 2026

Subscribe  |  Read the Newsletter Version.

Have you ever built the perfect Pivot Table, only to break it the moment someone adds a new row of data? 

If you live in Excel all day, you know the pain of refreshing, rearranging, and reformatting the same reports over and over.

Here's a Cool Tip:  Use Microsoft Excel's GROUPBY Function.

GROUPBY is Microsoft’s quiet answer to that problem. 

It turns a single formula into a dynamic summary table that updates itself whenever your source data changes. 

If you work in sales, finance, operations, education, or any role that lives in spreadsheets, this is the kind of feature that quietly saves you hours every month.

Feature Explanation

At its core, the Excel GROUPBY function creates a summary table by grouping rows and aggregating values. Think of it as a Pivot Table written as a formula. You choose what to group by, what to calculate, and how to sort or filter, and GROUPBY spills out a clean, dynamic result.

The syntax looks like this:

=GROUPBY(row_fields, values, function, [field_headers], [total_depth], [sort_order], [filter_array], [field_relationship])

In plain language:

• row_fields: The column or columns you want to group by, such as Region, Product, or Manager.
• values: The numeric data you want to summarize, such as Sales or Quantity.
• function: How you want to summarize it, such as SUM, AVERAGE, COUNT, or PERCENTOF.
• Optional arguments: Control headers, totals, sorting, filtering, and how multiple fields relate.

Why it matters:

• You get a live summary table that recalculates automatically when data changes.
• You do not need to maintain a separate Pivot Table layout.
• You can combine GROUPBY with other dynamic array functions for advanced dashboards.

How To Create QR Codes In Microsoft Word (So People Actually Scan Them)

How To Create QR Codes In Microsoft Word (So People Actually Scan Them)

Turn any Word document into a scannable, mobile-friendly experience with built-in QR codes. No add ins, no sketchy websites, just a smart field code hiding in plain sight.  Creating QR codes directly in Microsoft Word lets you turn reports, handouts, and invoices into interactive documents. 

By Rodger Mansfield, Technology Editor

March 23, 2026

Subscribe  |  Read the Newsletter Version.

You have probably seen QR codes slapped on posters, menus, and invoices that no one actually scans. 

Often they are too small, too blurry, or point to a link that is already out of date.

Here's a Cool Tip:  Create QR Codes in Microsoft Word.

Microsoft Word has a built in way to generate QR codes that update with your document, without uploading anything to a third party site. 

Once you know the trick, you can drop a QR code into a template in seconds and keep it in sync with your latest URL, form, or contact info.

Turn Messy Meeting Notes Into a Clean Summary with AI

Turn Messy Meeting Notes Into a Clean Summary with AI

Capture rough meeting notes and turn them into clear, organized summaries using ChatGPT or similar AI tools in seconds.

By Rodger Mansfield, Technology Editor

March 16, 2026

Subscribe | Read the Newsletter Version.

Have you ever left a meeting with pages of notes that barely make sense?

Most people type or scribble ideas quickly during meetings. 

The result is usually a messy collection of bullet fragments, partial thoughts, and scattered reminders. 

Later, someone has to rewrite everything into a clean meeting summary.

AI tools such as ChatGPT can do that work in seconds. 

Paste the raw notes, provide a structured prompt, and the AI organizes the content into a clear summary that includes key discussion points, decisions, and action items.

Or even just upload the audio file of the meeting.

For busy professionals, this can save time, improve clarity, and make it easier to share meeting outcomes with the rest of the team.

Clipchamp: The Built-In Windows Video Editor That’s Finally Worth Using

Clipchamp: The Built-In Windows Video Editor That’s Finally Worth Using

Short on time, long on video ideas? Clipchamp turns your Windows PC into a surprisingly capable editor without extra software. If you have Windows 11, you probably already own a solid video tool and just haven’t opened it yet.

By Rodger Mansfield, Technology Editor

March 9, 2026

Subscribe  |  Read the Newsletter Version.

Have you ever skipped a video project because you assumed you needed expensive, complicated software to make it look decent? 

For many Windows users, Clipchamp has been hiding in plain sight, quietly evolving into a real editor that can handle social clips, training videos, and quick promos without a steep learning curve.

Here's a Cool Tip:  Try Microsoft Clipchamp.

Clipchamp started life as a web-first editor and is now integrated into the Microsoft ecosystem, with a dedicated Windows app and a freemium model that covers most everyday needs. 

The result is a tool that feels approachable for beginners yet fast enough for busy professionals who just want to trim, caption, and publish.

Query your local Excel files with Copilot Chat

Query your local Excel files with Copilot Chat

Copilot in Excel is finally learning a new trick: it can now answer questions about workbooks stored right on your device. If you primarily work in local folders, this update quietly changes how you work with data every day.

By Rodger Mansfield, Technology Editor

March 2, 2026

Subscribe  |  Read the Newsletter Version.

You know that one folder on your desktop where all the “final_v3_really_final.xlsx” files live. 

Until now, those local workbooks were invisible to Copilot Chat unless you moved them into the cloud. 

That extra step was just enough friction to skip using Copilot at all.

Here's a Cool Tip:  You Can Now Query Your Local Excel Files with Copilot Chat.

Copilot can now analyze modern Excel files stored locally, so you can ask questions, clean data, and build summaries without reshuffling your storage strategy or uploading sensitive files.

Edit Slides in NotebookLM: No More Starting Over

Edit Slides in NotebookLM: No More Starting Over

Google has finally added the ability to edit individual slides within NotebookLM using simple text prompts. This update also introduces a long-requested PowerPoint export option for professional workflows.

By Rodger Mansfield, Technology Editor

February 23, 2026

Subscribe  |  Read the Newsletter Version.

Have you ever spent twenty minutes waiting for an AI to generate the "perfect" slide deck, only to realize that slide seven has a glaring typo or an image that looks nothing like your brand? 

Until now, NotebookLM users faced a frustrating "all or nothing" choice: keep the flawed deck or roll the dice on a full regeneration. 

Here's a Cool Tip: Edit Slides in NotebookLM.

Google has quietly upgraded its research powerhouse with a surgical editing tool that allows you to fix individual slides without touching the rest of your presentation. 

It is the bridge between AI creativity and human precision that business professionals have been waiting for.

Turn Excel Chaos Into Clarity With Copilot’s Summarize And Categorize Superpowers

Turn Excel Chaos Into Clarity With Copilot’s Summarize And Categorize Superpowers

Copilot in Excel can scan thousands of rows, surface the story in your data, and organize it into meaningful categories with just a few natural language prompts. If you work in spreadsheets all day, this feature is like having a data analyst sitting in the ribbon.

By Rodger Mansfield, Technology Editor  

February 16, 2026

Subscribe  |  Read the Newsletter Version

You open a workbook with 18,000 rows of sales data, customer comments, and dates, and your manager wants a one-page summary before lunch. 

You know Excel can do it, but building the right formulas, PivotTables, and filters feels like a project, not a quick task.

Here's a Cool Tip:  Use Copilot to Summarize and Categorize Your Data.

Instead of hunting for the perfect function, you describe what you want: “Summarize this data by category.” 

Copilot reads the table, proposes a summary, and can even build the supporting PivotTable for you.

Excel stops being a wall of cells and starts acting like a conversation about your data.

Supercharge Your Spreadsheets with Gemini in Google Sheets

Supercharge Your Spreadsheets with Gemini in Google Sheets

Stop struggling with complex formulas and manual data entry; let Google’s AI build your trackers, write your syntax, and analyze your data for you. Google Gemini in Sheets transforms your static spreadsheets into an intelligent data partner that can build tables, write formulas, and clean data through simple conversation. Whether you are a business pro or a home user, this AI integration eliminates the tedious "blank grid" problem forever.

By Rodger Mansfield, Technology Editor

February 9, 2026

Subscribe  |  Read the Newsletter Version

Have you ever stared at a blank Google Sheet, knowing exactly what data you needed but having no idea how to structure the table or write the necessary VLOOKUP to find it? 

You aren't alone. 

For decades, spreadsheets have required users to speak the language of "Cell C4" and "Nested IF statements."

Here's a Cool Tip:  Use Google Gemini in Google Sheets.

With the 2026 rollout of Gemini 3 into Google Workspace and Google AI Pro plans, the spreadsheet has finally learned to speak human. 

Instead of hunting for tutorials, you can now simply ask your sheet to "Create a 12-month budget tracker" or "Calculate the variance between these two columns." 

It is the most significant shift in how we handle data since the introduction of the Pivot Table.

Turn Word Into Your AI Writing Partner With Agent Mode

Turn Word Into Your AI Writing Partner With Agent Mode

Agent Mode in Word lets you describe your goal and have Copilot do targeted edits, rewrites, and formatting inside your document. Once you learn where to find it and how to steer it, Word starts to feel less like a blank page and more like a collaborative editor.

Rodger Mansfield, Technology Editor

February 2, 2026

Subscribe  |  Read the Newsletter Version.

How many times have you stared at a messy draft and thought, "I wish someone could just fix this for me"? 

Here's a Cool Tip:  Use Agent Mode in Microsoft Word.

Agent Mode in Word is Microsoft’s answer to that feeling: a way to talk to Copilot as if it were a colleague sitting beside you, editing the document in real time.

Instead of copying text into a chat window and pasting results back, you stay in the document while Copilot restructures sections, tightens language, and applies Word styles for you. 

For busy professionals, that shift from "AI on the side" to "AI inside" is a big deal.

Paste To Link In Word: The Tiny Shortcut That Saves Big Time

Paste To Link In Word: The Tiny Shortcut That Saves Big Time

Add hyperlinks in Word without breaking your writing flow. This small change quietly fixes one of Word’s most annoying habits.  Word now lets you paste a link directly onto selected text so it instantly becomes a hyperlink. If you live in documents all day, this one shortcut can save hundreds of clicks a week.

By Rodger Mansfield, Technology Editor

January 25, 2026

Subscribe  |  Read the Newsletter Version.

How many times today have you opened the Insert Link dialog in Word and sighed a little? 

If you work in proposals, reports, lesson plans, or documentation, hyperlinking is constant, repetitive, and just fiddly enough to slow you down.

Here's a Cool Tip:  Paste a Link Directly Onto Text in Microsoft Word.

Previously, if you pasted a URL over selected text in Word, it nuked the text and left you with a raw link. 

Then you had to undo, open the link dialog, paste again, confirm, and finally get back to your sentence. 

Now Microsoft has quietly aligned Word with how modern editors behave: select text, paste a link, keep typing. It feels obvious in the best possible way. 

Turn Excel Into Your AI Teammate: How To Use Agent Mode In Excel For The Web

Turn Excel Into Your AI Teammate: How To Use Agent Mode In Excel For The Web

Agent Mode in Excel turns Copilot from a polite assistant into a hands-on builder that can reshape your workbook for you. If you work with reports, budgets, or messy data, this is the rare feature that can actually give you hours back each week.

By Rodger Mansfield, Technology Editor

January 19, 2026

Subscribe  |  Read the Newsletter Version

You know that feeling when a “quick” spreadsheet tweak quietly eats your entire afternoon? 

One more column, one more formula, one more chart, and suddenly you are deep in a maze of references and formatting.

Here's a Cool Tip:  Use Agent Mode in Excel for the Web

Instead of nudging Copilot one prompt at a time, you describe the outcome you want, and Agent Mode plans, builds, and revises a multi-step workflow inside your workbook. 

It behaves less like a chatbot and more like a junior analyst who can explain what it is doing as it goes.

PowerPoint’s New Explainer Tool Makes Dense Slides Actually Understandable

PowerPoint’s New Explainer Tool Makes Dense Slides Actually Understandable

PowerPoint’s new Explainer feature uses Microsoft 365 Copilot to translate dense, jargon-heavy slides into clear, quick explanations. If you regularly sit through baffling decks, this might be the quiet little button that saves your next meeting.

By Rodger Mansfield, Technology Editor 

December 22, 2025

Subscribe - Read the Newsletter Version

You know that moment in a meeting when a slide full of acronyms and chart junk hits the screen and everyone politely nods while silently thinking, “What does this even mean?” 

Now imagine being able to right-click that mess and get a clear, one-paragraph explanation that speaks human.

Here's a Cool Tip:  Use Explainer in Microsoft PowerPoint.

Powered by Microsoft 365 Copilot, PowerPoint Explainer quietly sits in your right-click menu, ready to summarize dense content so you spend less time re-reading and more time actually understanding the point.

Give Your Google Docs a Visual Makeover with Cover Images

Give Your Google Docs a Visual Makeover with Cover Images

Learn how to instantly upgrade the look of your documents by adding full-width cover images.  This Cool Tip walks you through the simple steps to turn boring text files into engaging, professional wikis and reports that elevate your corporate branding and impress clients.

By Rodger Mansfield, Technology Editor

December 15, 2025

Subscribe - Read the Newsletter Version.

Have you ever opened a Google Doc and felt immediately bored by the endless wall of white background and black text? 

We have all been there. 

While tools like Notion and Coda have long allowed users to beautify their workspaces with splashy header images, Google Docs often felt strictly utilitarian. 

Here's a Cool Tip:  Use the Cover Image feature in Google Docs.

Google has introduced a native Cover Image feature that allows you to add a splash of personality, branding, or visual context right at the top of your document. 

It is a small change that makes a massive difference in how your work is perceived.

How to Add Automatic Alt Text to Microsoft Word Images

How to Add Automatic Alt Text to Microsoft Word Images

Adding images to a Word document is easy, but making them accessible is just as important. Microsoft Word’s Automatic Alt Text feature instantly generates descriptions for your pictures, helping business and home users save time while ensuring inclusivity.

By Rodger Mansfield, Technology Editor 

December 8, 2025

Subscribe - Read the Newsletter Version

Ever dropped an image into a Word document and wondered how someone using a screen reader would interpret it? 

Accessibility is not just a compliance checkbox, it’s a way to make your work usable by everyone. 

Here's a Cool Tip:  Use Word's Automatic Alt Text feature.

Microsoft Word’s Automatic Alt Text feature takes the guesswork out of writing descriptions, offering instant suggestions that you can refine.

Transform Research into a Structured Presentation with NotebookLM

Transform Research into a Structured Presentation with NotebookLM

Need to quickly distill complex research into a shareable outline? NotebookLM’s slide generation feature instantly converts all your source documents into a structured, review-ready presentation, outputting a high-quality PDF perfect for sharing key findings or drafting a lecture structure.

By Rodger Mansfield, Technology Editor

November 24, 2025

Subscribe - Read the Newsletter Version

How much time do you spend fighting with bullet points and slide masters instead of focusing on what you actually want to say? 

In the professional world, presentations often begin not with a blank slide, but with a mountain of research: PDFs, meeting transcripts, long reports, and web articles. 

The manual process of summarizing these sources into a coherent narrative is a massive time sink.

Here's a Cool Tip:  Use NotebookLM to Generate a Slide Deck.

 NotebookLM, Google's AI-powered research assistant, now offers a solution that fundamentally changes this workflow. 

With a single prompt, the tool takes your complex source material and instantly drafts a professional, structured slide deck.

Microsoft 365 Copilot vs Microsoft Copilot: What’s the Difference?

Microsoft 365 Copilot vs Microsoft Copilot: What’s the Difference?

Two Copilots, one name, and a lot of confusion. Here’s how to tell them apart and why it matters for your workflow.

By Rodger Mansfield, Technology Editor 

November 17, 2025

Subscribe - Read the Newsletter Version

If you’ve ever asked, “Wait, which Copilot am I using?” you’re not alone. 

Microsoft has launched multiple AI-powered assistants under the “Copilot” brand, and while they share a name, they serve very different roles. 

Here's a Cool Tip:  Microsoft 365 Copilot is inside Microsoft 365 apps.

Whether you're a business user, educator, or productivity enthusiast, understanding the difference between Microsoft 365 Copilot and Microsoft Copilot can save you time and headaches.

How to Instantly Edit Data Label Text in Excel for the Web

How to Instantly Edit Data Label Text in Excel for the Web

Now you can edit chart data labels directly in Excel for the web with no desktop detour required. This crucial update makes your visual storytelling faster, cleaner, and more intuitive.

By Rodger Mansfield, Technology Editor

November 3, 2025

Subscribe

How often have you found yourself squinting at an Excel chart, trying to extract relevant details from a jumble of garishly colored bars or columns? 

You’re not alone. 

Here's a Cool Tip: Edit Label Text in Excel for the Web.

Until recently, editing data labels in Excel for the web meant switching platforms or settling for generic values. 

But now, Microsoft has quietly rolled out a deceptively powerful update that lets you edit data label text directly in the browser. 

No downloads or workarounds. 

Just clean, contextual labeling, right where you need it.

Master AI and Cloud Skills Faster with Google Skills: Your One-Stop Learning Hub

Master AI and Cloud Skills Faster with Google Skills: Your One-Stop Learning Hub

A fresh way to build in-demand AI and cloud expertise, Google Skills brings together thousands of labs, courses and badges that serve individuals and teams alike.

By Rodger Mansfield, Technology Editor

October 27, 2025

Subscribe

Have you ever found yourself juggling half-a-dozen online training portals and asking “Which one actually moves my career or team forward?” 

Here's a Cool Tip:  Learn with Google Skills.

Google is targeting frustrated employees with its new platform, Google Skills. 

With AI moving at breakneck speed and businesses demanding deeper cloud and machine-learning literacy, the old piecemeal approach to training is showing its age. 

Google Skills aims to give you one coherent place to build practical skills, validate them and even tie them into hiring or team-development pathways.