Microsoft Office Intermediate
4 sessions
This course is designed to help users build on their existing Microsoft Office knowledge and make better use of the features available within the Microsoft 365 suite. Participants will develop practical skills that improve productivity, efficiency, collaboration, and the quality of their day-to-day work.
Suitable For
This course is suitable for employees who:
- Have a basic understanding of Microsoft Office applications.
- Regularly use Word, Excel, Outlook, PowerPoint, or Teams as part of their role.
- Want to improve efficiency and reduce time spent on routine tasks.
- Need to create more professional documents, presentations, and reports.
- Are looking to enhance their digital skills and confidence when working within Microsoft 365.
What You Will Learn
By the end of the course, participants will be able to:
- Create and format professional documents using advanced Word features.
- Work more effectively with data using intermediate Excel functions and tools.
- Improve email and calendar management in Outlook.
- Design engaging and consistent presentations in PowerPoint.
- Collaborate more effectively using Microsoft 365 applications.
- Apply productivity features to streamline common workplace tasks.
- Use features that improve accuracy, organisation, and information management.
Topics Covered
Microsoft Word
- Styles, themes, and templates
- Document layout and formatting
- Tables and graphics
- Headers, footers, and section breaks
- Reviewing, commenting, and collaboration tools
- Mail merge fundamentals
Microsoft Excel
- Formulas and functions
- Working with tables and structured data
- Sorting, filtering, and conditional formatting
- Data validation
- Creating charts and visualisations
- Introduction to PivotTables and data analysis
Microsoft Outlook
- Email organisation techniques
- Rules, categories, and flags
- Calendar management and scheduling
- Task management and prioritisation
- Effective communication practices
Microsoft PowerPoint
- Creating professional presentations
- Slide Master and templates
- Working with images, charts, and SmartArt
- Presentation delivery tools
- Consistent branding and slide design
Microsoft 365 Productivity and Collaboration
- Sharing and collaborating on documents
- Version control and co-authoring
- OneDrive and cloud storage basics
- Teams integration and communication tools
- Best practices for working collaboratively
Course Outcomes
Upon completion, participants will be equipped with the skills and confidence to use Microsoft Office applications more effectively, improve workplace productivity, and create high-quality business documents, spreadsheets, presentations, and communications
