Description
This day course provides tips and tricks in the various applications of the Microsoft Office suite. The participants decide what they want to focus on. They have plenty of opportunity to address specific questions and problems.
All MS Office programs are reviewed, starting with MS Word.
Audience
This course is for average Microsoft Office users.
Participants have a solid basic knowledge of MS Office (Word, Excel, PowerPoint, Outlook, OneNote) through experience or through our beginner courses.
Methods
Interactive classroom, hands-on training
Contents
Contents
Most of the participants put together the program themselves. As an example and guide, we suggest the following topics:
- MS Word
- Tips and tricks for browsing documents with keyboard, mouse, and navigation panel
- Text selection tips and tricks
- Personalize Word's ribbon, quick access toolbar, and contextual tabs
- Using Smart Tags in Word
- Use tabs, indents, or tables and when to use what
- Apply styles when creating documents
- Learn how to work with quick parts: one click to insert text blocks, cover pages, headers and footers, date, page number...
- Remove incorrect formatting and replace it with a different layout
- Make text more appealing, visual, and engaging with SmartArt
- Use templates to save time
- Excel
- Navigation and selection tips and tricks
- Search for and change a specific layout
- Suppressing Table Layout
- Creating your own series
- Personalize Excel's ribbon, quick access toolbar, and contextual tabs
- Using Smart Tags in Excel
- Use group mode to create and shape tables.
- Use graphical models and keyboard shortcuts to save time when creating graphical elements.
- Manage Excel lists with dynamic tables.
- Use F4 for absolute or relative cell references
- Use cell references in formulas and functions to make optimal use of Excel in calculations
- Quickly create AutoSom
- Double-click the fill handle to fill out
- Use a page-end preview to print more efficiently.
- Page layout view to add headers and footers
- Date and time keyboard shortcuts
- Use templates to save time
- Outlook
- decorum
- When to use “On”, “CC” and “BCC”?
- The topic.
- End of Message in the subject.
- Links vs. attachments
- Do's and don'ts with emails (when to ask for a read confirmation, when not)
- Delete emails: dare to delete emails, recover deleted emails...
- Creating order in chaos (quick steps, rules,...)
- Follow up flag, meeting, or task based on a message
- Quickly create a task based on a meeting or email, and vice versa.
- Personalize Outlook's ribbon, quick access toolbar, and contextual tabs.
- MS PowerPoint
- Use the diamodel.
- New slides.
- Use Zoom for Convenient Navigation
- Design ideas.
- Structure a presentation with Sections.
- Reuse slides. (recycle)
- Arranking/grouping/aligning objects.
- Read out loud.
- ...
- MS OneNote
- Take notes quickly.
- Difference between MS Word and MS OneNote.
- Quickly create tables.
- Create MS Outlook tasks in MS OneNote.
- Keep notes from an Outlook meeting in OneNote.
- Create QuickNotes.
- Create personalized tags.
- Add links to other sections, pages,...
- Use the docked window for notes linked to MS Word, MS PowerPoint, or Web Browser (IE or Edge).
- Sharing OneNotebook.
- Show authors.
- View previous versions.
- ...
Certification
Participation certificate: At the end of the training, participants will receive a certificate that they have completed this course.