Microsoft Office Tips & Tricks


1-day course

CPD Credit: 7 hours, C1

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. 



  • Shortcuts
  • Hidden Functionality
  • Tips & Tricks
  • Visual Tools
  • Simplifying Formulas
  • Finding Errors
  • Date & Time Functions
  • Pivot Tables
  • Dashboards


  • Outlook Integration
  • Creating Reports
  • Quick Parts
  • Shortcuts
  • Hidden Functionality
  • Tips & Tricks


  • PowerPoint Best Practices
  • Presentation Tips & Tricks
  • Visual Diagramming Tools
  • Inserting & Editing Videos
  • Dynamic linking to Excel
  • Using Pictures Effectively


  • Understanding the OneNote Layout
  • Creating Sections, Page & Subpages
  • Adding Content
  • Page Templates
  • Linking OneNote & Outlook


  • 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.


  • "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 team for further information on scheduled course dates and in-company options. You can reach us by phone: 01 665 1305 or email