Microsoft Office Productivity Training Course

Participants can produce stable, professionally formatted Word documents from reusable structures.

• Styles pane used to standardise headings, body text and document hierarchy
• Multilevel lists linked to heading styles for stable numbering
• Sections, page breaks and headers configured for controlled layouts
• Insert a table of contents from heading-level fields
• Caption and cross-reference fields maintain figures, tables and appendices
• Apply document themes and style sets to approved corporate formats
• Template files and building blocks reduce repeated document assembly

Participants can manage document review, protected editing and personalised communications in Word.

• Track Changes settings separate insertions, deletions, formatting and comments
• Compare documents to identify revisions between controlled versions
• Accept or reject changes using reviewer-specific filtering and display modes
• Restrict Editing controls protect forms, comments and permitted formatting
• Mail Merge rules generate personalised letters, labels and email messages
• Recipient lists filtered, sorted and validated before merge output
• Quick Parts and AutoText store approved clauses for reuse
• Accessibility Checker identifies document barriers before distribution

Participants can build dependable Excel workbooks using structured formulas and input controls.

• Relative, absolute and mixed references control formula copying behaviour
• SUMIFS, COUNTIFS and AVERAGEIFS calculate multi-criteria operational measures
• IF, IFERROR and nested logic manage exceptions and status rules
• XLOOKUP retrieves matched values with explicit missing-value handling
• Excel Tables create structured references, filters and expandable ranges
• Data Validation lists prevent invalid entries in controlled workbooks
• Formula auditing traces precedents, dependents and calculation errors

Participants can transform data into filtered analyses, operational insights and readable reports.

• Clean imported data with Text to Columns and TRIM
• Power Query imports and transforms repeatable datasets without manual rework
• Sort and filter records using multi-level criteria and custom lists
• PivotTables summarise transactions by category, period, owner and region
• Slicers and timelines filter PivotTable reports for focused review
• Conditional Formatting flags thresholds, duplicates, overdue items and exceptions
• Chart selection matches comparisons, trends, distributions and composition questions
• Create a one-page operational dashboard from linked PivotTable outputs

Participants can create clear PowerPoint slides that support informed audience decisions.

• Audience-purpose-message framework defines presentation scope before slide production
• Slide Master controls layouts, fonts, placeholders and recurring elements
• Assertion-evidence slide titles state the conclusion before supporting detail
• Data-ink ratio guides removal of decorative chart clutter
• Use alignment, distribution and guides for disciplined slide composition
• SmartArt, icons and shapes communicate process and hierarchy clearly
• Speaker notes capture evidence, transitions and delivery prompts

Participants can prepare, rehearse and distribute presentations for distinct stakeholder needs.

• Presentation sections organise long decks for review and reuse
• Custom Slide Shows tailor content for different stakeholder groups
• Hyperlinks and Summary Zoom create non-linear briefing routes
• Rehearse Timings measures pacing against the allocated speaking slot
• Presenter View separates speaker cues from audience-facing material
• Export handouts and PDF versions using appropriate distribution settings
• Accessibility Checker verifies reading order, contrast and alternative text

Participants can manage communications, commitments and meetings through a structured Outlook workflow.

• Outlook categories, flags and follow-up dates create visible work queues
• Rules route routine messages into defined folders and exception paths
• Quick Steps standardise frequent filing, forwarding and response actions
• Calendar scheduling uses availability, Scheduling Assistant and meeting options
• Meeting agendas, attachments and follow-up actions remain linked to appointments
• Search folders and Advanced Find retrieve messages by compound criteria
• Tasks and To Do lists distinguish commitments from reference email

Participants can share, co-author and retrieve files while maintaining clear access and version control.

• OneDrive sharing links apply view, edit and expiry permissions
• SharePoint document libraries use metadata, version history and check-out
• Co-authoring protocols prevent conflicting edits and unclear document ownership
• Teams channels separate project discussions, files, meetings and decisions
• @mentions, tags and channel posts direct action to accountable colleagues
• Version history restores prior files and identifies substantive changes
• File naming conventions support retrieval, traceability and retention

Participants can combine Microsoft 365 applications into a controlled reporting workflow and improvement plan.

• Select Word, Excel, PowerPoint and Outlook for a reporting cycle
• Link Excel charts into PowerPoint while preserving source-update control
• Embed Word content, hyperlinks and document references without duplicate maintenance
• Apply a RACI matrix to document ownership, review and approval
• Build a weekly reporting workflow from inbox, analysis, draft and briefing milestones
• Define file locations, naming rules and version-control checkpoints
• Create a 30-day application plan with measurable productivity targets