Office 2024 Hidden Features Most Users Never Discover
Most Office users operate with roughly 20% of the application’s capabilities. They open Word to type, Excel to manage numbers, and PowerPoint to make slides — and they use the same ten commands they have always used. This is not laziness; Office is genuinely vast, and its interface does not always highlight the most powerful features. Some of the most impressive capabilities are buried in menus that most users never explore, or they require specific workflow triggers that casual users never encounter.
This guide highlights 20 features across Office 2024’s applications that are either new, underexplored, or genuinely surprising — features that can meaningfully change how you work once you know they exist.
Excel 2024: Analytical Power Rarely Used
1. GROUPBY and PIVOTBY Functions
New in Office 2024, GROUPBY and PIVOTBY allow you to create pivot-table-style summaries using formulas rather than the Pivot Table interface. GROUPBY groups data by one or more columns and applies aggregation functions. PIVOTBY produces two-dimensional groupings, like a pivot table but entirely formula-driven and dynamic.
The formula =GROUPBY(B2:B100, D2:D100, SUM) groups the values in column B and sums the corresponding values in column D — essentially a one-formula pivot table. When source data changes, the GROUPBY output updates automatically without needing to refresh a pivot table. For dashboards and reports that update from live data sources, this is transformative.
2. Cell Checkboxes
Excel 2024 added native checkbox support in cells — something that required complex workarounds or ActiveX controls in previous versions. Select a cell (or range of cells), go to Insert > Checkbox, and each selected cell becomes a checkbox that toggles between TRUE (checked) and FALSE (unchecked). Use these in task trackers, project checklists, and survey templates. Since the cell value is simply TRUE or FALSE, you can COUNTIF, SUMIF, or otherwise formula-reference the checkbox states like any other cell value.
3. Flash Fill Intelligence
Flash Fill (Ctrl+E) has been in Excel since 2013 but remains massively underused. It detects patterns from examples you provide and fills an entire column based on that pattern. Type a few examples of how you want data reformatted — for instance, extracting first names from a full name column, formatting phone numbers consistently, or combining values from multiple columns in a specific way — and press Ctrl+E. Excel recognises the pattern and fills the rest of the column instantly. No formulas required.
4. XLOOKUP with Match Mode
Most users who know XLOOKUP use it as a direct replacement for VLOOKUP. But XLOOKUP’s fourth argument (match_mode) enables capabilities that go far beyond exact match lookups. Setting match_mode to -1 performs an “exact match or next smaller” lookup — useful for tax bracket calculations, tiered pricing, and any lookup where you want the largest value that does not exceed your search term. Setting it to 2 enables wildcard matching, allowing you to look up partial text strings with * wildcards.
5. LET Function for Readable Formulas
Complex Excel formulas that repeat the same calculation multiple times are slow to calculate and difficult to read. The LET function allows you to define named variables within a formula, calculate them once, and use the name multiple times. A formula that previously required the same XLOOKUP calculation repeated four times can now define that lookup as a variable once and reference it by name in the rest of the formula. The result is faster, more readable, and easier to maintain.
6. Name Manager for Workbook Documentation
The Name Manager (Formulas > Name Manager) lists all named ranges and named constants in a workbook. Beyond managing names, it is the most underrated workbook documentation tool in Excel. You can add a descriptive comment to each named range explaining its purpose. For complex models with many named ranges, the Name Manager with well-written comments provides a self-documenting reference for anyone maintaining the workbook later.
Word 2024: Document Intelligence You Are Missing
7. Editor: Beyond Spell Check
The Editor tool in Word 2024 (Review > Editor) goes far beyond spell checking. In its full mode, it analyses writing style: flagging passive voice, overly complex sentences, excessive use of filler words, unclear phrasing, and formal register inconsistencies. For professional documents where clarity and concision matter — proposals, reports, contracts — running the full Editor analysis identifies improvements that spell check entirely misses. The Similarity Checker integration compares your text against web sources, a useful option for academic and research writing.
8. Focus Mode
Word 2024’s Focus mode (View > Focus) hides all ribbons, toolbars, and the taskbar, leaving only the document on screen with a subtle fade around the edges. For distraction-prone writers, this dramatically reduces visual noise. Move the mouse to the top of the screen to reveal the ribbon when you need it, then it hides again automatically. It is a small feature that makes a disproportionate difference for long writing sessions.
9. Compare and Combine Documents
Most professionals know about Track Changes for reviewing a single document, but many do not know about Compare and Combine (Review > Compare). Compare generates a new document showing all differences between two versions of a file — even if neither version had Track Changes enabled. Every addition, deletion, and formatting change is marked up as a tracked change in the comparison document. This is invaluable when receiving a revised document from a client who made changes without using Track Changes.
10. Building Blocks Organiser
The Building Blocks Organiser (Insert > Quick Parts > Building Blocks Organiser) reveals every saved building block in every category across all templates — including the built-in cover pages, headers, footers, table styles, and text boxes that Microsoft provides. Browsing the Organiser reveals dozens of pre-built content blocks available in every Word installation that most users have never seen.
11. Style Sets for Instant Redesign
Style Sets (Design tab > Document Formatting) apply a coherent visual theme to all Heading, Normal, and List styles simultaneously. Select a different Style Set and the entire document’s visual design changes in one click. Combined with the Colours and Fonts dropdowns in the Design tab, this allows rapid experimentation with different visual treatments of a complex document without manually reformatting anything.
PowerPoint 2024: Presentation Features Worth Knowing
12. Cameo: Live Camera in Slides
Cameo (Insert > Cameo) inserts a live camera feed as a positioned object on any slide. During a presentation, your webcam feed appears within the slide — you can position it in a corner, make it larger, or integrate it as part of the slide design. For hybrid presentations where some audience members are remote, Cameo makes the presenter feel integrated with the slide content rather than appearing as a separate overlay.
13. Slide Zoom
Slide Zoom (Insert > Zoom) creates an interactive thumbnail of another slide that, when clicked during presentation, smoothly zooms into that slide and then zooms back out when you move on. This enables non-linear navigation — you can return to a summary slide and click on any section thumbnail to zoom into it on demand, without breaking the flow of the presentation or having to skip through slides.
14. Morph Transition for Smooth Animation
The Morph transition (Transitions > Morph) creates smooth, animated transitions between slides by automatically detecting matching shapes and moving them from their position on one slide to their position on the next. Duplicate a slide, move some elements around on the duplicate, apply Morph — and the transition appears as if the elements are sliding and transforming into their new positions. This achieves complex animation with a single step.
15. Rehearsal with Presenter Coach
Slide Show > Rehearse with Coach opens a private rehearsal mode that records the timing of your presentation and analyses your speaking. The Presenter Coach flags when you are speaking too quickly, using filler words, reading directly from the slides, or using repetitive language. After your rehearsal, a report summarises all of these issues with specific counts and timestamps. Using this feature before an important presentation is like having a presentation coach available at no cost.
Outlook 2024: Email Management You Have Overlooked
16. Quick Steps for Email Automation
Quick Steps (Home > Quick Steps) allow you to create one-click buttons that perform multiple email actions simultaneously. A single Quick Step can: mark an email as read, move it to a specific folder, reply with a template text, and forward a copy to a team member — all in one click. Build custom Quick Steps for your specific workflow to reduce repetitive email management to a single interaction.
17. Focused Inbox with Rules-Based Exceptions
The Focused Inbox (View > Show Focused Inbox) separates emails that Outlook considers important from others. The more powerful approach is teaching it: right-click any email in the wrong section and select “Move to Focused” or “Move to Other,” and Outlook learns your preferences. Combined with Rules for known low-priority senders, Focused Inbox becomes a genuinely useful filter.
18. Meeting Polls
Outlook 2024 includes a built-in polling tool for scheduling meetings across multiple people (accessed via the Scheduling Poll option in the meeting composer). You propose several time slots, the attendees vote on availability, and the tool automatically books the slot with the most votes. Attendees can respond without needing Outlook themselves — they receive a web link to the poll.
Cross-Application Features
19. Dictation Across All Applications
The Dictate feature (Home > Dictate in Word, Excel, and PowerPoint, or via the microphone button in Outlook) converts speech to text in real time. In Word 2024, it includes auto-punctuation and supports voice commands for formatting (“new line,” “new paragraph,” “bold”). For people who find typing slow or who think more fluidly when speaking, dictation offers a genuinely useful alternative input mode.
20. Accessibility Checker
The Accessibility Checker (Review > Check Accessibility, available in Word, Excel, and PowerPoint) scans your document for issues that would make it difficult for people with disabilities to access — missing alternative text on images, poor colour contrast, tables without header rows, and reading order issues. For UK organisations subject to the Public Sector Bodies Accessibility Regulations 2018, or any business committed to inclusive communications, this is a valuable compliance tool that takes under a minute to run.
All of these features are available in Office 2024 Professional Plus for Windows, available at £29.99 from GetRenewedTech, and in Office 2024 Home and Business for Mac, available at £49.99.
Making the Most of Discovery
The most effective way to continue discovering Office features is to use the Tell Me search bar (the search box at the top of the Office ribbon). Type any description of what you are trying to do — “find differences between documents,” “make text read aloud,” “create a poll” — and Tell Me will navigate directly to the feature or suggest related options. It is Office’s own built-in feature discovery tool, and it works better than most users expect.
The second approach is to deliberately explore the ribbon tabs you never visit. The Review tab, the View tab, and the Draw tab in each application contain features that daily users rarely discover because their habits keep them in the Home and Insert tabs. Allocating thirty minutes to systematically reviewing every option in these less-visited ribbon tabs will reveal at least three or four features worth adding to your regular workflow.
Conclusion
Office 2024 is a remarkably deep application suite. The features covered in this guide represent a fraction of what is available — every section could be an article in itself. The key is deliberate exploration: try the features you discover, integrate the ones that address your specific friction points, and let the rest wait until you encounter the problem they solve. The users who get the most from Office are not those with the most training but those with the most curiosity.
