Skip to content
Home Tutorials Roadmaps Courses
Log in Join free

Microsoft Office Mastery

Become an expert in Word, Excel, PowerPoint, Outlook, OneDrive and Teams for maximum productivity.

SU Taught by Sukhwinder Singh 0 enrolled Beginner

What you will learn

  • Create professional documents in Microsoft Word
  • Master Excel formulas, functions, pivot tables and dashboards
  • Design impactful presentations in PowerPoint
  • Manage email and calendars with Outlook
  • Collaborate effectively with OneDrive and Microsoft Teams
Master the entire Microsoft Office suite - the most widely used productivity tools in the world.

From professional documents in Word to powerful data analysis in Excel, stunning presentations in PowerPoint, email management in Outlook, cloud collaboration with OneDrive, and team communication through Teams. This course covers everything from basics to advanced features used in corporate environments.

Who this is for:
- Students and professionals who use Office daily
- Job seekers wanting to add Office skills to their resume
- Anyone who wants to work faster and smarter with Microsoft 365

Course Syllabus

0 lessons · 9 modules
1. Microsoft Word Essentials 6 lessons
  1. Lesson content for "Word interface, ribbon and navigation".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  2. Lesson content for "Formatting text, paragraphs and styles".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  3. Lesson content for "Inserting tables, images and shapes".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  4. Lesson content for "Page layout, headers, footers and sections".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  5. Lesson content for "Mail merge for bulk letters and labels".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  6. Lesson content for "Track changes, comments and document protection".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
2. Excel Basics 6 lessons
  1. Lesson content for "Excel interface, cells, rows and columns".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  2. Lesson content for "Entering data, formatting cells and number formats".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  3. Lesson content for "Basic formulas - SUM, AVERAGE, COUNT, MIN, MAX".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  4. Lesson content for "Cell references - relative, absolute and mixed".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  5. Lesson content for "AutoFill, flash fill and find & replace".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  6. Lesson content for "Sorting, filtering and basic data validation".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
3. Excel Functions & Formulas 6 lessons
  1. Lesson content for "IF, nested IF and logical functions".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  2. Lesson content for "VLOOKUP, HLOOKUP and XLOOKUP deep dive".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  3. Lesson content for "INDEX-MATCH - the ultimate lookup combo".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  4. Lesson content for "SUMIF, COUNTIF and conditional aggregation".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  5. Lesson content for "TEXT, DATE and TIME functions".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  6. Lesson content for "ROUND, MOD, INDIRECT and advanced functions".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
4. Excel Data Analysis 6 lessons
  1. Lesson content for "Data validation and dropdown lists".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  2. Lesson content for "Conditional formatting with rules".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  3. Lesson content for "Pivot tables - creation and customization".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  4. Lesson content for "Pivot charts and slicers for interactive reports".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  5. Lesson content for "What-if analysis - Goal Seek, Scenario Manager".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  6. Lesson content for "Data consolidation and subtotals".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
5. Excel Dashboards & Charts 6 lessons
  1. Lesson content for "Chart types and when to use each".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  2. Lesson content for "Creating and formatting charts professionally".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  3. Lesson content for "Sparklines, maps and combination charts".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  4. Lesson content for "Building interactive dashboards from scratch".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  5. Lesson content for "Dynamic named ranges and OFFSET".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  6. Lesson content for "Power Query - import and transform data".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
6. PowerPoint Mastery 6 lessons
  1. Lesson content for "Slide master, layouts and design themes".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  2. Lesson content for "Text, images, SmartArt and shapes".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  3. Lesson content for "Animations and transitions - timing and effects".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  4. Lesson content for "Embedding charts, videos and audio".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  5. Lesson content for "Presenter view, speaker notes and rehearsal".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  6. Lesson content for "Exporting to PDF and video formats".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
7. Outlook Productivity 5 lessons
  1. Lesson content for "Configuring accounts and email rules".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  2. Lesson content for "Organizing inbox - folders, categories and flags".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  3. Lesson content for "Calendar management and scheduling meetings".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  4. Lesson content for "Tasks, to-do lists and follow-ups".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  5. Lesson content for "Quick steps and keyboard shortcuts for speed".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
8. OneDrive & Cloud Collaboration 4 lessons
  1. Lesson content for "OneDrive setup and file sync".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  2. Lesson content for "Sharing files and setting permissions".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  3. Lesson content for "Co-authoring documents in real time".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  4. Lesson content for "Version history and file recovery".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
9. Microsoft Teams 5 lessons
  1. Lesson content for "Teams interface, channels and conversations".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  2. Lesson content for "Audio and video meetings".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  3. Lesson content for "File sharing and tab integration".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  4. Lesson content for "Teams apps, bots and automation".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  5. Lesson content for "Best practices for team collaboration".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon

Student reviews

No reviews yet - be the first after you complete the course!

Prerequisites

Basic computer knowledge. Windows OS recommended.