Microsoft Office: Excel, Word, PowerPoint and Teams for Pro

Course Overview

• Course Title: Microsoft Office: Excel, Word, PowerPoint and Teams for Pro
• Instructor: Click Learning
• Target Audience:
  • Business Professionals
  • Students
  • Managers and Team Leaders
  • Anyone
• Prerequisites: None

Curriculum Highlights

• Key Topics Covered:
  • Introduction to Excel, Word, PowerPoint & Teams
  • Understanding the Ribbon, Tabs, and Quick Access Toolbar
  • Sorting and Filtering Data
  • Advanced Formulas and Functions (VLOOKUP, HLOOKUP, IF, SUMIF, etc.)
  • Conditional Formatting
  • Data Validation
  • Power Query and Power Pivot
  • Advanced Data Analysis Tools
  • Basic Slide Transitions and Animations
  • Working with SmartArt and Charts
  • Advanced Design Techniques
  • Advanced Slide Show Options
  • Basic Page Layout and Design
  • Working with Tables and Charts
  • Advanced Formatting Techniques
  • Advanced Document Design and Layout
  • Integrating Word with Other Applications
  • Mail Merge: Letters, Labels, and Emails
• Key Skills Learned:
  • Excel for Professionals
  • Word for Professionals
  • PowerPoint for Professionals
  • Teams for Professionals

Course Format

• Duration: 8 hours on-demand video
• Format: Self-paced online course
• Resources:
  • Access on mobile and TV
  • Certificate of completion