WORK 
01
Word, beyond typing
Styles, automatic tables of contents, sections, templates, mail merge, tracked changes. Producing a thirty-page document that does not fall apart.
← All courses
Course 05
Office tools and Microsoft 365
Most people use ten percent of Word and Excel, and lose hours on tasks the software does by itself. This course covers the full suite, from a clean document through to automation. Online or in person in Yaoundé.
Practical details
- Duration
- 3 months3 h a day, 4 days a week
- Format
- Online & in personOne to one or in a group
- Level required
- Two levels, beginner and advancedYour starting point is assessed beforehand
- Price
- 50 000 FCFAFor the complete course
- Certificate
- YesWork Smart certificate of completion
Syllabus
What the course covers
02
Excel, the foundations
Absolute and relative references, formats, sorting, filters, conditional formatting, data validation.
03
Excel, the level that makes the difference
XLOOKUP, nested IFs, SUMIFS, pivot tables, charts and dashboards.
04
PowerPoint and OneNote
Building a presentation that stands up without unreadable walls of text, and organising notes so you can find them again.
05
Outlook, Teams, OneDrive, SharePoint
Mail, rules, shared calendars, meetings, co-editing a document, sharing and access rights.
06
Forms, Planner and automation
Creating a collection form, tracking a team's tasks, and automating a repetitive sequence with Power Automate.
What you will be able to do
- ✓Produce a long, structured document with an automatic table of contents
- ✓Run a full mail merge to hundreds of recipients
- ✓Build a pivot table and a dashboard
- ✓Write the Excel formulas that cover most real needs
- ✓Work on the same file as a team without overwriting each other
- ✓Automate a repetitive task across several Microsoft 365 tools
Who it is for
- →Secretaries, assistants and administrative staff
- →Accountants and managers who live in Excel
- →Teams who have just moved to Microsoft 365 without support
- →Anyone redoing the same manual operation every month
Before you start
Prerequisites and equipment
A computer running Windows or macOS
A Microsoft 365 licence, or the free online version
Basic keyboard and mouse skills
Your own working files, to practise on real material
Your starting level is assessed before the first session
Your trainer
Before you enrol
Talk to the trainer
A question about the level required, the pace or the price? It goes straight to the person who runs the course, not to a sales desk.
Or book a meeting
A thirty minute conversation to place your level and check this is the right path. No obligation.
Reserve your seat
Tell me your level and your availability. I will confirm the format, the dates and the price, with no obligation.