Top 5 new features in Office 2024

Office 2024 brings major innovations: Copilot artificial intelligence, enhanced collaboration, new Excel formulas. Discover the 5 features that revolutionize productivity.

1. Copilot AI: The Integrated Intelligent Assistant

What is Copilot in Office 2024?

Microsoft Copilot is the generative artificial intelligence natively integrated into Office 2024. Based on OpenAI's GPT-4, Copilot assists users in all office tasks: document writing, data analysis, presentation creation.

Copilot in Word: Assisted Writing

In Word, Copilot can:

• Write automatically: "Write a cover letter for a project manager position"
• Rephrase: "Make this paragraph more professional"
• Summarize: "Summarize this 20-page report in 500 words"
• Translate: "Translate this document to British English"

Copilot analyzes document context and generates content consistent with your tone and style. Estimated time savings: 30-40% on writing.

Copilot in Excel: Simplified Data Analysis

Excel 2024 + Copilot revolutionizes data analysis:

• Natural language queries: "Calculate average sales by region for 2025"
• Formula generation: "Create a formula to extract emails from text format"
• Chart creation: "Display monthly revenue evolution in line chart"
• Anomaly detection: Copilot automatically flags outlier values

Copilot in PowerPoint: Presentations in 2 Minutes

PowerPoint 2024 with Copilot can generate a complete presentation from a simple prompt:

1. Open PowerPoint 2024
2. Click "Create with Copilot"
3. Enter: "10-slide presentation on e-commerce trends 2026"
4. Copilot generates structure, content, layout, images in 1-2 minutes

2. Enhanced Real-Time Collaboration (Up to 100 People)

Mass Simultaneous Co-Editing

Office 2024 increases from 10 simultaneous users (Office 2021) to 100 users in co-editing. Ideal for large teams, live events, corporate brainstorms.

Improved @mention Comments

@name mentions in Word, Excel, and PowerPoint now trigger instant push notifications. No need to monitor the document: you're alerted as soon as a colleague mentions you.

Extended Version History

Office 2024 keeps 500 previous versions of a document (vs 25 in Office 2021). You can go back several months to restore a previous version.

Live Share Mode: Synchronized Presentation

New PowerPoint 2024 feature: Live Share. Share your presentation in real-time via a web link. Participants follow your slides automatically on their browser, without installing Office.

Use cases: webinars, distance training, client presentations where all participants have different devices (PC, Mac, iPad, smartphone).

3. Automatic Transcription in PowerPoint

Real-Time Subtitles During Presentation

PowerPoint 2024 integrates a speech recognition engine. During your oral presentation, the text you speak is automatically displayed as subtitles on screen.

Benefits:

• Accessibility: Hearing-impaired people can follow
• Comprehension: Non-native audience reads subtitles
• Reminder: You can review your words live

Simultaneous Translation in 60 Languages

Generated subtitles can be instantly translated into 60 languages. You present in French, your slides display subtitles in English, German, Spanish simultaneously.

Ideal for international conferences, multinational meetings, global webinars.

Export to SRT File

Transcription can be exported to SRT format (subtitle file), compatible with YouTube, Vimeo, video players. Perfect for creating automatically subtitled video tutorials.

4. PowerPoint Designer Powered by AI

Intelligent Layout Suggestions

PowerPoint Designer has existed since Office 2016, but the 2024 version uses AI for 10x more relevant suggestions. Insert an image or text, Designer instantly proposes 5-10 professional layouts.

Automatic Icon and Illustration Generation

Type "economic growth," Designer automatically generates relevant vector icons (rising charts, arrows, coins). No need to search for icons on stock image sites.

Corporate Color Harmonization

Define your corporate color palette once. Designer automatically applies these colors to all new slides, ensuring perfect visual consistency.

5. New Excel Formulas: LAMBDA, ARRAYTOTEXT, IMAGE

LAMBDA: Create Your Own Excel Functions

LAMBDA is Excel 2024's most revolutionary feature. It allows creating reusable custom functions without VBA.

Example: calculate total with tax from pre-tax amount and variable tax rate.

=LAMBDA(pretax, rate, pretax * (1 + rate))

Name this function "CalcTotal", then use it everywhere: =CalcTotal(A2, B2)

ARRAYTOTEXT: Convert Arrays to Text

ARRAYTOTEXT transforms an Excel array into formatted text string. Useful for exporting data to external systems, generating JSON, creating comma-separated lists.

=ARRAYTOTEXT(A1:C10, 0)  // Concise format
=ARRAYTOTEXT(A1:C10, 1)  // Strict format

IMAGE: Insert Dynamic Images in Cells

The IMAGE function inserts images directly into Excel cells from a URL or file path.

=IMAGE("https://example.com/logo.png")
=IMAGE("C:\Photos\product.jpg", 4, 150, 100)

Applications: product catalogs with photos, dashboards with logos, dynamic visual reports.

Other New Excel 2024 Functions

• REGEX: Extraction and validation by regular expressions
• GROUPBY / PIVOTBY: Pivot tables as formulas
• TEXTBEFORE / TEXTAFTER: Text extraction before/after delimiter

Is Office 2024 Worth the Extra Cost vs Office 2021?

Office 2024 is Recommended For

• Excel power users using advanced formulas daily
• Collaborative teams (>10 people) working simultaneously
• Frequent presenters using transcription and Designer
• AI early adopters ready to invest in Copilot ($35/month)
• Long-term investment: Microsoft support until 2029

Office 2021 is Sufficient If...

• You use Office for standard office tasks
• You work mostly alone (no intensive collaboration)
• Your budget is limited to $220 maximum
• You don't need Copilot AI or advanced Excel formulas

Conclusion: Office 2024, a Major Evolution

Office 2024 is not a simple incremental update. The 5 features presented (Copilot AI, 100-person collaboration, PowerPoint transcription, AI Designer, Excel LAMBDA/IMAGE formulas) represent a qualitative leap in office productivity.

If you use these innovations daily, the $40 extra cost vs Office 2021 is widely offset by time savings. If your usage is basic, Office 2021 remains an excellent alternative.