Advanced Microsoft Office (Excel, Word, Powerpoint)

Offered by: Lifa n Lúce Consultancy
Delivery Mode: In-person / Online / Blended
Target Audience: Office professionals, administrators, analysts, and team leaders who already have basic Microsoft Office skills and wish to master advanced features for enhanced productivity
Objective: To empower participants with advanced techniques in Microsoft Excel, Word, and PowerPoint for efficient data analysis, high-impact documentation, and professional presentations.

• Advanced formulas and functions (IF, VLOOKUP/XLOOKUP, INDEX & MATCH)

• Data validation, conditional formatting, and named ranges

• PivotTables, PivotCharts, and dashboards

• Advanced charting techniques and data visualization

• Introduction to Power Query and basic macros

• Mastering styles, templates, and themes

• Working with large documents: table of contents, headers/footers, cross-referencing

• Mail merge for mass communication

• Creating and modifying forms (fillable PDFs, content controls)

• Review, track changes, and collaboration tools

• Designing professional presentations with slide masters and layouts

• Incorporating multimedia: videos, audio, animations, and transitions

• Custom themes and design best practices

• Using SmartArt, charts, and infographics effectively

• Presenter view, timing, rehearsals, and recording presentations

• Embedding Excel data/charts into Word and PowerPoint

• Linking documents and updating dynamic content

• Collaboration via OneDrive and SharePoint

• Introduction to Office automation and Microsoft 365 tools (e.g., Power Automate)

• Best practices for document management and version control

• Hands-on guided exercises and templates

• Productivity toolkit for Office users

• Real-world examples and case scenarios

• Certificate of Completion

• Optional: Post-training support and project-based assessment