Details
1-day course
CPD Credit: 7 hours, C1
Course Delivery Options
Course Overview
This workshop is an opportunity to learn hidden functionality in the Microsoft Office Suite. Did you know you can build a chart in two seconds or a dashboard in two minutes? This session is also especially relevant for those who use Microsoft Office in their daily work. The instructor who has been teaching Microsoft Office for 25 years, will show you the easy way to use powerful functionality.
This course will teach you more in a day than you have learnt in decades of using Microsoft Office. There are many obvious ways to perform tasks but there is usually a hidden much easier way. The course is delivered with the belief that how to use Office is important but learning the easy way to perform the How is the key learning objective.
Learning objectives
- Identify the hidden functionality of Microsoft Office & Office 365.
- Create, edit, and share Microsoft Office files in the most efficient manner possible.
- Productively collaborate and work with colleagues and clients.
- Demonstrate how to analyse, visualise, and share data across the Microsoft Office suite.
Programme
Excel
- Shortcuts
- Hidden Functionality
- Tips & Tricks
- Visual Tools
- Simplifying Formulas
- Finding Errors
- Date & Time Functions
- Pivot Tables
- Dashboards
Word
- Outlook Integration
- Creating Reports
- Quick Parts
- Shortcuts
- Hidden Functionality
- Tips & Tricks
PowerPoint
- PowerPoint Best Practices
- Presentation Tips & Tricks
- Visual Diagramming Tools
- Inserting & Editing Videos
- Dynamic linking to Excel
- Using Pictures Effectively
OneNote
- Understanding the OneNote Layout
- Creating Sections, Page & Subpages
- Adding Content
- Page Templates
- Linking OneNote & Outlook
Teams
- The Microsoft Teams Interface
- Team Structure and Functionary
- Presenting with Teams
- Meetings
- Outlook & Teams
- Hidden Functionality
- Tips & Tricks
Who Should Attend?
This is for participants who are looking to upskill in Office 365. Participants should be existing users and have some knowledge of Microsoft Excel, Microsoft Word, and Microsoft PowerPoint. Participants do not need to have used One Note or Microsoft Teams prior to this course.
Trainer's Profile
John McGrath
John is a trusted advisor to some of the largest organisations in the world. His track record over the last 20 years includes over 250 global companies, government agencies, state enterprises, the United Nations, the London and Rio Paralympics and the World Bank. John’s passion is in building competency within organisations. John is also the Course Director for the MSc in Project Management at TU Dublin. Previously John lectured in Project Management at NUIM, TCD, UCD, Smufit Business School and Brunel University. John has published papers in academic and industry journals and has presented at over 100 international project management conferences.
Testimonials
- "Excellent instructor: very knowledgeable. Informative course."
- Bernard Doherty, Grant Thornton: "Top quality course. John really understands how to deliver Microsoft courses. Kept everything interesting throughout the day. Excellent."
- Roderick Cleary, Grant Thornton: "Very relevant. Extremely well delivered. Would recommend to colleagues."
Please contact the CPD Training team for further information on scheduled course dates and in-company options.