News

Executive Assistants handle large volumes of administrative work every week. Much of this work is routine, predictable and heavily driven by Microsoft 365 tools. Yet many EAs still complete these tasks manually, even when Microsoft 365 can automate or streamline the process in a way that dramatically reduces effort. The cost of doing these tasks manually is not just lost time. It also increases the risk of errors, delays and duplicated effort, especially when supporting a senior leader with a high workload.

The most effective EAs do something different. They use the hidden automation, structuring and management tools built into Outlook, SharePoint, OneNote, Excel and Teams to remove repetitive steps. These tools are not complicated, but they are often undiscovered because most professionals learn Microsoft 365 only under urgent, work‑pressure conditions.

Below are seven EA admin tasks you should never handle manually, along with the Microsoft 365 features that make them effortless.

Manually moving email attachments into folders

Many EAs download attachments one by one, rename each file and move them into structured folders for their leader. This can take hours per week, especially during busy periods like board cycles or project updates.

Instead, use Outlook rules combined with OneDrive or SharePoint autosave flows. When messages arrive with specific subjects, senders or keywords, attachments can be saved to the correct location automatically. OneDrive and SharePoint keep every file version and ensure documents are centralised, reducing the common problem of inconsistent naming and incomplete filing.

Even a simple rule such as “save all finance reports into the Finance folder” reduces 80 percent of the manual work.

Re‑entering information into tracking spreadsheets

Many EAs maintain trackers for actions, approvals, supplier details or recurring tasks. The slowest method is copying information from emails or forms and pasting it manually into Excel.

Excel’s structured tables, Power Query and linked spreadsheets remove this manual work. Instead of pasting, you import data directly into the workbook so it refreshes automatically. This helps EAs maintain accurate dashboards without time‑consuming updates and ensures that reports for senior leaders are always based on the latest information.

For simple workflows, Excel’s Flash Fill automatically extracts patterns such as names, dates or codes, eliminating hours of repetitive data entry.

Chasing people for information or updates

One of the most draining EA tasks is chasing colleagues for documents, meeting inputs or updates. Doing this manually requires remembering who responded, who didn’t and who needs a polite nudge.

This is a task that should always be automated. Outlook templates combined with Teams scheduled messages allow you to send structured reminders with one click. When information is collected through Microsoft Forms, you can receive automatic alerts in Teams for each submission and monitor who has completed the request without chasing manually.

This creates a consistent reminder system that keeps work flowing even when your day is busy.

Searching through notebooks and emails to find meeting decisions

If an EA records decisions in different places, their day becomes dominated by finding what was agreed and when. Decisions become buried in email threads, handwritten notes or Teams messages.

OneNote eliminates this problem when used correctly. Create a decision log section in OneNote and record outcomes immediately during meetings. OneNote’s search indexes every word across all notebooks, including text inside images and documents. This means that even if you only remember a few words from the discussion, you can retrieve the decision instantly.

Storing meeting packs in OneNote pages allows you to link decisions to the supporting documentation, removing the need to hunt across multiple locations.

Building recurring calendar schedules from scratch

EAs supporting busy leaders often rebuild schedules for weekly, monthly or quarterly routines manually. This includes scheduling 1:1s, team meetings, finance cycles or stakeholder updates.

Microsoft 365 provides better methods. Outlook allows you to create recurring templates, including pre‑set attendees, agendas, reminders and categories. Once created, you simply duplicate the template or adjust the recurrence pattern. This avoids calendar drift and ensures your executive’s rhythm remains stable.

For complex multi‑meeting cycles, shared group calendars in Teams provide a unified view across departments so you never rebuild schedules from scratch.

Updating shared documents when multiple colleagues contribute

A common problem for EAs is managing documents that different teams update, such as briefing packs, project trackers or status reports. Manually merging content from multiple versions is slow and error prone.

SharePoint and OneDrive offer real time co authoring so multiple people can work on the same file simultaneously. Combined with version history, the EA can revert changes or compare versions without keeping separate copies. This prevents the familiar chaos of filenames like “Final Version 3 Last One Use This One”.

It also ensures that the executive reads the most accurate and up to date information.

Writing minutes and actions from scratch after every meeting

Minute taking becomes unnecessarily slow when the EA rebuilds the structure each time. Starting from a blank page leads to inconsistent formatting and missed details.

Use OneNote meeting templates, which store the agenda, action sections, attendee lists and decision areas. When a new meeting begins, duplicate the template page. This saves 10 to 20 minutes per meeting and improves the quality of recorded actions. For Teams meetings, add the meeting notes tab and link it back to OneNote so materials, tasks and chat history stay connected.

Combined with Outlook meeting integration, actions can be converted into structured tasks quickly without manual rewriting.

Real world scenario

Imagine an EA supporting a director in a complex organisation. They manage two inboxes, maintain several trackers, prepare reports and coordinate recurring meetings. Before using Microsoft 365 features, they spend most of their day filing attachments, searching for decisions and updating spreadsheets manually.

After introducing these seven practices, their workload changes dramatically. Attachments file themselves, spreadsheets update automatically, decisions are found in seconds, and reminders are handled by templates. The EA gains hours of capacity each week and can focus on supporting the director’s priorities rather than getting pulled into repetitive admin.

The stress level drops noticeably because fewer details slip through the cracks.

Practical takeaways

• Set up three Outlook rules that file attachments automatically.
• Convert one manual tracker into a structured Excel table with refreshable data.
• Use OneNote search as your decision retrieval system.
• Build two meeting templates to speed up recurring meetings.
• Practice real time co authoring to reduce document chaos.

Conclusion

EAs who rely only on manual methods will always feel stretched, especially when supporting leaders with demanding workloads. By using the automation and structuring tools built into Microsoft 365, you can remove large amounts of repetitive work and build a more controlled, predictable day. These tools are simple when you know how they work, but discovering them requires structured learning.

If you want guided, practical training on using AI, prompting and Microsoft 365 tools at a professional EA standard, you can learn these skills in depth through:

Today’s PA Academy
and
Microsoft Copilot Masterclass