Microsoft Excel

Excel FILTER Function | Excel One Minute Quick Reference

The FILTER function in Excel allows you to filter a range of data based on the criteria you define. The FILTER function is a dynamic array function. The FILTER function has three arguments, but only two are required.

FILTER function in Excel

YouTube Video

Excel FILTER Function | Excel One Minute Functions Explained

Arguments for the FILTER function

- array - The array, or range to filter REQUIRED - include - A Boolean array whose height or width is the same as the array REQUIRED - \[if\_empty\] - The value to return if all values in the included array are empty (filter returns nothing) - Optional

Versions of Excel the FILTER function works in

- Excel for Microsoft 365 - Excel for Microsoft 365 for Mac - Excel for the web - Excel 2021 - Excel 2021 for Mac - Excel for iPad - Excel for iPhone - Excel for Android tablets - Excel for Android phones|

Delete Blank Columns in Excel: 3 Easy Ways

Blank columns break sorting, filtering, and PivotTables. Remove them with Go To Special, a COUNTA helper row, or Power Query's Column quality view.

Copilot in PowerPoint: Explain vs. Review This Presentation

Copilot in PowerPoint now has two skills with nearly identical names that do very different jobs: Explain this presentation and Review this presentation. One helps you understand a deck someone else made. The other helps you improve a deck you made yourself. If you train people on Copilot, expect questions

Redesign Slides with Copilot's Visualize This Slide Skill in PowerPoint

Use the Visualize this slide skill in Copilot for PowerPoint to turn text-heavy slides into visual layouts. Three examples: bullets, a six-step process, and a timeline.

Copilot Skills in PowerPoint - Live Stream on October 20, 2026

𝗠𝗼𝘀𝘁 𝗣𝗼𝘄𝗲𝗿𝗣𝗼𝗶𝗻𝘁 𝘂𝘀𝗲𝗿𝘀 𝗸𝗻𝗼𝘄 𝗖𝗼𝗽𝗶𝗹𝗼𝘁 𝗰𝗮𝗻 𝗰𝗿𝗲𝗮𝘁𝗲 𝘀𝗹𝗶𝗱𝗲𝘀. 𝗙𝗮𝗿 𝗳𝗲𝘄𝗲𝗿 𝗸𝗻𝗼𝘄 𝗮𝗯𝗼𝘂𝘁 𝘁𝗵𝗲 𝟴 𝗯𝘂𝗶𝗹𝘁-𝗶𝗻 𝗖𝗼𝗽𝗶𝗹𝗼𝘁 𝗦𝗸𝗶𝗹𝗹𝘀 𝘁𝗵𝗮𝘁 𝗰𝗮𝗻 𝗰𝗼𝗺𝗽𝗹𝗲𝘁𝗲𝗹𝘆 𝗰𝗵𝗮𝗻𝗴𝗲 𝗵𝗼𝘄 𝘆𝗼𝘂 𝗯𝘂𝗶𝗹𝗱, 𝗶𝗺𝗽𝗿𝗼𝘃𝗲, 𝗮𝗻𝗱 𝗽𝗿𝗲𝘀𝗲𝗻𝘁 𝗮 𝗱𝗲𝗰𝗸. Join me live on October 20, 2026, at Noon Eastern as I demonstrate each Copilot Skill and show practical ways to use them in your presentations. PDF of the 8 Copilot Skills in Pow