This 5 day course offers a full and comprehensive training in the MS office suite (Outlook, Teams, Excel, Word and PowerPoint), that will enable you to maximize collaboration efficiency within MS 365 by using best practices, such as centralizing files via OneDrive and SharePoint, using real-time co-authoring in Word, Excel and PowerPoint, using Teams as a centralized communication platform and Outlook to manage emails and plan collaborative events. The goal of this approach is to create a harmonious and transparent collaborative environment within your team.
IT Training
MS 365 complete
Qui devrait suivre ce cours?
This course is addressed to intermediate or expert users looking for an efficient working method by using the Office applications in a collaborative way, in order to efficiently take on their workload or leading their projects.
Prérequis
Being familiar with the Office application : Excel, Word, PowerPoint, Outlook and Teams
Excel (2 days) : turn your Excel tables into communication tools, review of Excel calculations, using the table tool, analysing data, charts and tips & tricks on efficiently presenting your data
Word (1 day) : guidelines on producing well-structured and attractive reports
PowerPoint (1 day) : efficiently creating a summary presentation from your Word report or your Excel analysis and efficiently designing your presentation
Outlook & Teams (1 day) : communicating with Outlook and Teams and collaborating with Teams and OneDrive
Excel (2 days) : turn your Excel tables into communication tools (strategies on sharing your files with colleagues, on using colour codes, on naming tables, sheets and files), review of Excel calculations (formulas, function, references, nexting functions, lookup functions…), using the table tool (understanding and using its many advantages), analysing data (sorting, filtering, pivot tables, conditional formatting…), charts (and pivot charts) and tips & tricks on efficiently presenting your data
Word (1 day) : guidelines on producing well-structured and attractive reports (styles, table of contents, illustrations, page numbering, footnotes, page orientation…)
PowerPoint (1 day) : efficiently creating a summary presentation from your Word report (creating an automatic outline) or your Excel analysis (paste special options) and efficiently designing your presentation (tips & tricks)
Outlook & Teams (1 day) : communicating with Outlook (managing incoming and outgoing messages) and Teams and collaborating with Teams (on teams files) and OneDrive (sharing personal files)
