Changes to Excel in the last 24 months

Here are just some of the changes that have happened over the last 24 months in Excel

Copilot Agent mode

Excel’s AI assistant that builds, edits, and transforms entire workbooks for you, step‑by‑step, performing the work directly in your spreadsheet

Benefits

Huge time saver, reducing hours of manual work to minutes

COPILOT function

The COPILOT function lets you Talk to your data using plain English

Benefit

Handles messy, real-world data. Works directly in a cell and you don’t have to create long complex formulas.

Search box

Used to find any feature and formula function in Excel

Benefit

No need to remember where features are on the ribbon, or to use right click in the hope you’ll find what you’re after

GROUPBY function

The GROUPBY function creates a summary table using just one formula.

Benefit

If your data range changes your summary range changes dynamically – no need to refresh

PIVOTBY function

The PIVOTBY function lets you create a PivotTable‑style summary using just a formula.

Benefit

You get the equivalent of a dynamic PivotTable layout (row headers, column headers, values) without manually building one.

TRIMRANGE function

The TRIMRANGE function is like telling Excel only give me the part of this range that actually has data — trim the empty bits off the edges.

Benefit

Eliminates wrong results, prevents slow calculations and spreadsheets, prevents unnecessary zeros showing up, ensures charts and reports update correctly

Focus cell

Focus cell highlights specific rows and columns

Benefit

Allows for easier navigation and readability in a large Excel data range

Checkboxes

Excel checkboxes are small clickable boxes you can tick or untick to show whether something is selected, completed, or true/false.

Benefit

Easier to set up and use than dropdowns and can be filtered.

Understanding the Difference Between SharePoint and One Drive

Why They May Cause Confusion

SharePoint and OneDrive found in Microsoft 365 often cause confusion among users. Both platforms provide powerful functionalities for storing, sharing, and managing files, but they serve distinct purposes and are tailored for different use cases.

SharePoint

SharePoint is a comprehensive web-based collaboration platform designed primarily for organisations, teams and groups of coworkers. It offers a suite of tools that facilitate team collaboration, document management, and workflow automation. SharePoint’s capabilities include creating intranet sites, managing corporate content, and enabling seamless communication within an organization. The platform allows users to create custom sites and libraries, integrate with other Microsoft services, and manage permissions and access controls.

Key Features:

• Intranet and team sites
• Document libraries and version control
• Workflow automation
• Integration with Microsoft Office suite
• Advanced permissions and access controls

One Drive

OneDrive, on the other hand, is a cloud-based storage service that focuses on individual use. It allows users to store personal files and access them from any device with an internet connection. OneDrive is ideal for users who need a straightforward and secure way to store, share, and sync files across devices. It integrates seamlessly with Windows operating systems and provides features such as automatic photo backup, file sharing, and collaboration.

Key Features:

• Personal cloud storage
• File sharing and collaboration

Reasons for Confusion

Despite their distinct purposes, SharePoint and OneDrive can cause confusion due to several overlapping features. Both platforms offer cloud storage and file sharing capabilities, which can lead users to believe they serve the same function. Additionally, both integrate with the Microsoft Office suite, further blurring the lines between their intended uses.

• Overlap in functionality: Both platforms allow users to store, share, and collaborate on files, making it difficult to distinguish their primary use cases.
• Integration with Office: The seamless integration with Microsoft Office can make users question whether they should use SharePoint or OneDrive for certain tasks.
• Similar user interfaces: The user experience and interfaces of SharePoint and OneDrive share similarities, which can add to the confusion.
• Organisational use vs. personal use: Users may not be aware that SharePoint is designed for organizational collaboration while OneDrive focuses on personal file storage.

Conclusion

Understanding the differences between SharePoint and OneDrive is crucial for choosing the right tool based on specific needs. SharePoint is a robust platform for organizational collaboration and content management, while OneDrive is tailored for individual cloud storage and file syncing. Recognizing their unique features and intended use cases can help users leverage these tools effectively and minimize confusion.

Our courses

We provide a one-day course that explains the difference between SharePoint and One Drive. It’s fully hands on so you get the opportunity to use both throughout the day. We will show you many tips and tricks and best practices, after all we have used both for over 8 years now

Click this link to find out about our SharePoint course

SharePoint Training

Click this link to find out about our One Drive course

One Drive Training