Microsoft 365 Mastery: Word, Excel, PowerPoint & Outlook - Complete Course

Unlock Your Productivity with Microsoft 365

This comprehensive course will equip you with the skills to master the core applications of Microsoft 365: Word, Excel, PowerPoint, and Outlook. Whether you're a beginner or looking to enhance your existing skills, this course provides practical, step-by-step guidance to boost your productivity. Taught by MOS-certified instructor Miguel Ángel Franco García, this course is designed to empower you with the tools you need to succeed.

Microsoft Word: Write with Confidence

Learn to create professional documents, refine your writing, and leverage intelligent writing assistance. This course covers everything from basic text formatting to advanced features.

• Fundamentals: Understand the core concepts of Microsoft Word, including working with paragraphs, styles, and document layouts.
• Advanced Writing Tools: Utilize intelligent writing assistance, grammar checks, and style suggestions in over 20 languages.
• Document Design: Master document design principles to create visually appealing and impactful documents.
• Collaboration: Learn how to easily create, edit, and share Word files with others, including real-time collaboration with Microsoft 365 for the Web.
• Templates: Start with pre-designed templates to quickly create professional-looking documents.
• Advanced Features: Explore features like mail merge, table creation and manipulation, and advanced formatting options.
• Data Handling: Learn how to work with data within Word, including creating linked images from data models.
• Advanced Techniques: Master weighted averages using SUMAPRODUCTO, conditional logic (IF statements), and explore advanced functions.
• Macros & VBA: Automate tasks and create custom reports using macros and Visual Basic for Applications (VBA).
• Financial Reporting: Build professional financial dashboards from scratch.
• Regular Expressions: Learn to use powerful regular expressions with functions like REGET.

Microsoft Excel: Data Analysis & Powerful Spreadsheets

Transform raw data into actionable insights with this in-depth Excel course.

• Basics: Learn the fundamental building blocks of Excel: rows, columns, cells, and ranges.
• Keyboard Shortcuts: Master essential keyboard shortcuts like CTRL+= for auto-sum.
• Copy & Paste: Utilize the "Copy Format" tool for efficient data manipulation.
• Data Views: Explore different ways to view your data, including split-screen functionality.
• Relative, Absolute & Mixed References: Understand and apply different cell referencing methods.
• Functions: Dive into a wide range of Excel functions, including:
  • BUSCARV, BUSCARX, INDICE, INDIRECT, COINCIDIRX for data retrieval.
  • SUMAPRODUCTO for weighted averages.
  • SUBTOTALES, SUMAPRODUCTO for advanced calculations.
  • Financial, Time, and Lookup functions.
• Data Validation: Ensure data accuracy with data validation rules.
• Grouping & Consolidation: Organize and summarize data effectively.
• Workbook & Worksheet Protection: Secure your data with password protection.
• Pivot Tables: Master pivot tables, including linking, calculated fields, and advanced features.
• Advanced Functions: Explore functions like ELEGIR, DESREF, and database functions like BDSUMA.
• Array Formulas: Work with array formulas and inherited functions.
• Forecasting: Utilize forecasting tools and Solver for scenario analysis.
• Macros & VBA: Automate tasks and create custom reports with macros and VBA.
• Financial Dashboards: Build professional financial dashboards from scratch.
• LAMBDA & REGET: Learn to use LAMBDA functions and regular expressions for powerful data manipulation.

Microsoft PowerPoint: Create Engaging Presentations

Craft compelling presentations that captivate your audience.

• Design & Layout: Learn to create visually appealing presentations using pre-designed templates or custom designs.
• Text & Graphics: Format text, insert images, charts, and other visual elements.
• Animation & Transitions: Add animation and transitions to enhance your presentations.
• Video & Audio: Embed videos and audio clips directly into your slides.
• Real-time Collaboration: Share your presentations with others for real-time collaboration without requiring a subscription.
• Cameo: Integrate live video effects into your slides (available with Microsoft 365).
• Slide Show Management: Control the flow of your presentation with advanced