Applied office tools to the professional world

The advanced features of Word:
Setting up a mail merge with insertion of conditions in the merger
Making labels and badges using direct mail
Sending the mail merge.

The basic functions of Excel:
The entry in a spreadsheet: modification, deletion, moving cells, formatting cells, frames, automatic series, instant fill.
Calculation formulas: create, modify, copy a formula, apply a format on numbers, use absolute references, conditional formatting.
The layout of the table: margins, orientation, header and footer.
Print options.
Graphics creation
Creation and exploitation of a database: sorts, automatic filters and custom filters.

Implementation of a project by team of 3 people to practice the software and use new tools:
Using a task manager to work effectively in a team
Creating a Form with Forms to Poll
With Excel, use simple pivot tables, summary of survey results.
Production of comparative price tables
With Word, use Plan mode, automatic hierarchical numbering, create the table of contents from the plan to create a complete project file
Using review mode, tracking changes and comments to share in the folder within the group
Sending custom invitations to an event
With PowerPoint, making communication slides, more impactful and innovative
Archiving a folder