PIVOTBY is great for analysis, but PivotTables still have the edge when formatting needs to adapt to data changes.

PivotTable-aware conditional formatting ties rules to fields, so visuals persist even when you refresh, filter, or change layout.

"I want to highlight items with low stock in red," "I want to make overdue rows stand out," "I want to change the color only for weekends"—this is what conditional formatting does: it "automatically ...

Creating visually engaging dashboards in Excel doesn’t always require complex formulas or external add-ons. My Online Training Hub demonstrates how the often-overlooked REPT function can be used to ...

Now that Gemini is integrated with Google Sheets, using it for work has taken some of that work off my hands. In March 2026, ...

In this third installment, we will cover "Cell Formatting," which adjusts the appearance of cells, and "Conditional Formatting," which automatically changes colors based on specific conditions. Unlike ...

Compare the best free Microsoft Excel alternatives for 2026, including features, pricing, pros and cons, and use cases for each spreadsheet tool. The kinds of features you need from your spreadsheet ...

Modern business intelligence demands speed, and utilizing AI tools for Excel is the ultimate way to hyper-charge your data workflows this year.

Frustrated by artificial intelligence (AI)-generated essays, teachers and instructors embed invisible instructions in assignments to expose students relying on AI. Prompts such as “include the words ...

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas (with or without help from the Copilot AI assistant) and ...

Customer stories Events & webinars Ebooks & reports Business insights GitHub Skills ...