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

How Does a Task List Help You?

A task list, often known as a to-do list, is a simple yet powerful tool that can greatly enhance your productivity and organization. Here are some key benefits of using a task list:

Organization and Clarity

Structure Your Day: A task list helps you organize your day by breaking down your responsibilities into manageable tasks. This provides a clear roadmap of what needs to be accomplished.

Prioritize Tasks: By listing tasks, you can prioritize them according to urgency and importance. This ensures that critical tasks are addressed first.

Enhanced Productivity

Focus and Concentration: A task list helps you focus on one task at a time, reducing the likelihood of getting distracted by other activities.

Track Progress: Marking tasks as completed provides a sense of accomplishment and motivates you to keep going.

Stress Reduction

Reduce Overwhelm: Seeing all your tasks laid out can reduce feelings of being overwhelmed. It breaks down your workload into manageable portions.

Peace of Mind: Knowing that you have a clear plan for your tasks alleviates stress and frees up mental space.

Improved Time Management

Efficient Scheduling: A task list helps you allocate time effectively, ensuring that you make the most of each day.

Deadline Management: By keeping track of deadlines, a task list ensures that you complete tasks on time.

Incorporating a task list into your daily routine can transform the way you manage your responsibilities, leading to greater efficiency and peace of mind. Whether you are a student, a professional, or managing a household, a task list is an indispensable tool for achieving your goals.

Cleaning Data with Excel Power Query: A Guide

Microsoft Excel is a powerhouse for data manipulation, but dealing with messy datasets can be time-consuming. Enter Power Query, an Excel tool designed to clean and transform data efficiently. Whether you’re handling inconsistent formats, missing values, or duplicate entries, Power Query simplifies the process through an intuitive interface and powerful automation.

Why Use Power Query for Data Cleaning?

Power Query automates tedious data-cleaning tasks, reducing manual work and minimizing errors. Instead of manually reformatting columns or filtering rows, you can define repeatable steps that automatically clean your data each time it’s refreshed.

Key Benefits:

• Automates Data Cleaning: Saves time by applying transformations automatically.
•  
• Handles Large Datasets: Processes millions of rows more efficiently than standard Excel formulas.
•  
• Prepares Data for Analysis: Ensures data is structured correctly before further processing.
•  
• Creates Reusable Queries: Updates data dynamically without redoing tasks.