Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
MS Office with AI - Word Excel PowerPoint ChatGpt Gemini
Rating: 3.5 out of 5(98 ratings)
11,025 students

MS Office with AI - Word Excel PowerPoint ChatGpt Gemini

Learn Microsoft Word, Excel & PowerPoint from Basics to Advanced with AI Tools Like ChatGPT Gemini for Smarter, Faster
Created bySustoab Soren
Last updated 9/2025
English
English [Auto],

What you'll learn

  • Analyze data with functions, charts, and pivot tables
  • Let AI help you clean data, write formulas, and interpret trends
  • Design effective, professional slides
  • Use ChatGPT & Gemini to generate outlines, content, and talking points
  • Word content creation, summarization, and proofreading

Course content

1 section68 lectures9h 14m total length
  • Introduction4:21

    Master Word, Excel, and PowerPoint with AI tools like ChatGPT and Gemini to write, analyze data, create visuals, and build polished documents and presentations.

  • What MS Office is Used For16:11

    Discover how the Microsoft Office suite—Word, Excel, PowerPoint, Outlook, OneNote, and OneDrive—works together to create reports, budgets, slides, and emails.

  • Introduction to ChatGPT and Gemini6:01

    Discover how ChatGPT and Gemini work, and see practical examples of drafting emails, summarizing documents, and rewriting content within Google tools to save time and boost productivity.

  • Benefits of Combining Office with AI5:43

    Combine Microsoft Office with AI to boost productivity across Word, Excel, PowerPoint, and Outlook by generating drafts, data insights, smarter charts, presentation slides, and polished communications.

  • Creating a Document in Word9:43

    Learn to create professional Word documents from scratch in Word, add text, apply formatting, insert images and tables, apply styles, adjust margins and orientation, and prepare a share-ready document.

  • Saving and Formatting Documents in Word16:17

    Master bulletproof saving habits, auto recover, version history, and PDF export while applying clear file naming, OneDrive saves, and password protection with consistent formatting.

  • Using Fonts and Paragraph Settings in Word9:18

    Master fonts and paragraph settings in Word to format text for readability, including font types, sizes, bold/italics/underline, alignment, line spacing, indents, tabs, and page breaks.

  • Adding Headers and Footers in Word9:10

    Learn to insert and customize headers and footers in Word, including page numbers, dates, logos, and document info, and manage sections and linking for consistency.

  • Inserting Images in Word6:04
  • Inserting Tables in Word7:48

    Insert and format tables in Word to organize information clearly, using the Insert grid and Table Design and Layout tools to adjust rows, columns, and merged cells.

  • Inserting Charts in Word8:37

    Insert and customize charts in Word to visualize data vividly, using column, line, pie, and bar charts with live Excel data and chart design tools for titles, labels, and legends.

  • Generating Reports with AI in Word5:47

    Generate professional reports in Word with built-in ai features, crafting outlines, summarizing text, applying formatting, and inserting tables and charts to save time and boost productivity.

  • Writing Professional Letters with AI in Word6:48

    Use Microsoft Word AI to craft polished professional letters, including cover letters for marketing roles and client communications, focusing on tone, structure, and refinement with AI prompts.

  • Summarizing Text with AI in Word5:52

    Learn to generate concise summaries in Microsoft Word using AI tools like Copilot and ChatGPT integrations, quickly condensing long documents into clear bullet points for research, meetings, and reports.

  • Editing AI Text for Formatting in Word4:53

    Edit AI-generated text in Word to format for professionalism and readability by adjusting fonts, spacing, headings, alignment, and bullet lists to create ready-to-use documents.

  • Checking Grammar with AI in Word5:07

    Explore AI-powered grammar and style tools in Word that detect sentence structure issues, offer suggestions to repair, and improve clarity to produce polished writing.

  • Improving Writing Style with AI in Word6:27

    Improve writing styles with Microsoft Word's AI-powered tools, including real-time writing suggestions, clarity and conciseness checks, tone adjustment, and grammar guidance to produce clearer, more professional documents.

  • Using Track Changes in Word6:46

    Learn to use track changes in Word to edit collaboratively, view edits with color-coded markup, add comments, and manage changes with accept or reject options and display settings.

  • Adding Comments in Word7:43

    Add comments in Word to share feedback without changing text, using the Review tab to insert new comments, replay threaded discussions, and navigate or resolve comments for collaborative reviews.

  • Creating Templates in Word9:48

    Create Word templates, pre-designed documents that save time by reusing formatting, styles, headers, footers, logos, and placeholders, and save them as templates for recurring documents.

  • Using Styles in Word8:41

    Master styles in Word to format headings (heading 1 and 2), paragraphs, and text with consistent font size, color, and spacing; use navigation pane and tables of contents for navigation.

  • Exporting Word Documents to PDF4:55
  • Exporting Word Documents to Other Formats6:27

    Export Word documents to other formats by saving as PDF, plain text, or HTML, and preserve formatting for compatibility with older Word versions and easy sharing.

  • Understanding Cells, Rows, and Columns in Excel6:59

    Understand how cells, rows, and columns create the building blocks of Excel worksheets to enter, format, and analyze data using formulas and addresses like A1.

  • Writing Basic Formulas in Excel8:52

    Learn to perform calculations in Excel using basic formulas, starting with =, using +, -, *, /, and simple functions like sum, average, max, min, with cell references.

  • Using Basic Functions in Excel11:56

    Explore Excel's basic functions to perform quick calculations on numbers, text, and dates. Use sum, average, min, max, and count with real ranges to analyze data faster and more accurately.

  • Formatting Data in Excel8:12

    Enhance readability in Excel by formatting headers, currency and date formats, and conditional formatting. Convert data to tables, adjust alignment, wrap text, and apply borders.

  • Creating Tables in Excel7:15

    Convert ranges to Excel tables to enable automatic filtering, built-in styles, structure references, and quick totals, then rename, format, and auto-expand as data updates.

  • Generating Excel Formulas with AI8:55

    Learn to generate accurate Excel formulas from plain English using AI tools like ChatGPT and Copilot, turning descriptions into working formulas for data analysis and reporting.

  • Cleaning Data with AI in Excel4:59

    Learn how Excel's AI tools clean messy data by removing duplicates, fixing inconsistencies, and formatting for reliable, ready-to-use insights.

  • Organizing Data with AI in Excel5:02

    Explore ai-powered tools in Excel to clean, structure, and manage data; remove duplicates, fix missing values, and automatically sort and categorize to speed analysis and forecast trends.

  • Summarizing Data with AI in Excel4:06

    Explore how Excel's AI features automatically generate summaries and insights from sales data, using natural language queries, smart pivot suggestions, and quick analysis to drive smarter decisions.

  • Creating Charts in Excel7:32

    Learn to create and customize charts in Excel to visualize sales data, revealing patterns, trends, and comparisons across products and months using column, line, pie, and bar charts.

  • Using Conditional Formatting in Excel8:14

    apply conditional formatting in excel to highlight data with rules, color scales, bars, icons, and custom formulas, revealing trends and performance at a glance.

  • Creating PivotTables in Excel7:40

    Learn to create and customize pivot tables in Excel to quickly summarize revenue by regions and products, analyze patterns, and turn raw data into clear insights.

  • Building Dashboards in Excel11:37

    Build a professional Excel dashboard by preparing data sets, creating pivot tables, and turning them into charts with slicers for interactive, clean, data-driven insights.

  • Automating Tasks in Excel8:52

    Automate Excel tasks with flash fill, quick analysis, and macros to save time and reduce errors. See a sales report example showing totals and formatting across hundreds of rows.

  • Creating a PowerPoint Presentation10:41

    Create a professional PowerPoint from blank slides by designing slides, inserting text and visuals, adding charts and media, applying themes, and preparing for delivery.

  • Organizing Slides in PowerPoint6:21

    Organize slides in PowerPoint with slide shortcuts view and thumbnails to drag and drop. Use sections, rename, collapse groups, and duplicate or hide slides to keep decks concise.

  • Using Slide Layouts in PowerPoint9:12

    Discover how PowerPoint slide layouts provide structure and placement for titles, text, images, and charts. Use layouts to save time and maintain a polished, consistent presentation.

  • Applying Themes in PowerPoint7:44

    Apply themes in PowerPoint to instantly transform your slides with coordinated backgrounds, fonts, colors, and effects, then live preview, switch variants, and import or save custom themes for branding.

  • Using Templates in PowerPoint11:49

    Learn to pick and apply PowerPoint templates, customize the slide master with logos, fonts, colors, and layouts, and save or share a polished branded template for reuse with your team.

  • Adding Images in PowerPoint21:30

    Insert, edit, and optimize images in PowerPoint using local, stock, and online sources, then crop, resize, replace, apply picture styles, add alt text, and compress.

  • Adding Charts in PowerPoint13:40

    Create PowerPoint charts from a quarterly sales data set using cluster column and combo charts with a secondary axis and data labels. Animate by series and save charts as templates.

  • Using SmartArt in PowerPoint16:01

    Transform plain text into clear visuals with SmartArt in PowerPoint, building a four-step process or one-slide timeline and animating it like a pro.

  • Creating Presentation Outlines with AI11:42

    Learn to use ai to plan, structure, and polish presentation outlines, then generate slide-by-slide outlines, speaker notes, titles, and visuals tailored to your audience and purpose.

  • Generating Slide Text with AI4:17

    Generate clear, engaging slide text from topics using ai to create concise bullet points or full sentences. Review and tailor ai-generated content for audience alignment and visual impact.

  • Generating Bullet Points with AI2:45

    Generate clear, concise bullet points with ChatGPT to streamline content creation, save time, and ensure consistency for presentations, reports, or course content.

  • Using AI for Slide Design Suggestions4:29

    Explore AI-powered slide design suggestions, including layouts, color palettes, font pairings, and icons. Use AI features in PowerPoint and ChatGPT for PowerPoint to streamline creation of professional, engaging slides.

  • Using AI to Add Visual Ideas in PowerPoint3:58

    Discover how AI in PowerPoint quickly adds visuals, layouts, and graphics to slides, turning plain content into professional, eye-catching presentations—even if you have no design background.

  • Adding Transitions in PowerPoint12:50

    Learn to add, customize, and preview slide transitions in PowerPoint, including fade and morph, set durations and timings, and apply transitions across slides for polished, automated presentations.

  • Adding Animations in PowerPoint13:53

    Master adding and customizing PowerPoint animations to create polished slides, including entrance and emphasis effects, motion paths, triggers, and rehearse timings, then export a video with animations.

  • Using Presenter View in PowerPoint5:42

    Master presenter view in PowerPoint to see current and next slides, speaker notes, timer, and tools like laser pointer, pen, and highlighter, enabling smoother, more confident presentations.

  • Exporting PowerPoint to Video7:21

    Export PowerPoint to MP4 by selecting export, choosing video quality, and using recorded timings and narrations; review transitions and animations before saving for YouTube or social media.

  • Exporting PowerPoint to PDF6:42

    Export your PowerPoint slides to a pdf via file > export > create pdf or xps, choose slides or all, select quality, and save for easy sharing.

  • Writing Clear Prompts for AI10:03

    Learn to craft precise prompts for AI using the context, format, tone, and length formula, and apply practical steps to elicit clear responses from tools like ChatGPT.

  • Converting Reports into Summaries with AI8:23

    Learn to convert long reports into concise AI summaries by pasting text, giving clear instructions, and focusing on key areas like revenue growth, expenses, and risks.

  • Creating Slide Points from AI Summaries6:30

    Generate a concise AI-powered summary from long texts and convert it into five clear slide points for engaging presentations using ChatGPT or Gemini.

  • Asking AI for Excel Solutions9:28

    Learn how ai helps solve Excel problems with formulas, data analysis, and automating tasks. Explore running totals, Vlookup, trimming spaces, macros, dynamic charts, duplicates, and troubleshooting errors.

  • Getting Step-by-Step Explanations from AI7:28

    Learn to get step-by-step explanations from AI to break down complex problems and learn new skills using tools like Gemini and ChatGPT. Apply these methods to math and workflows.

  • Writing a Professional Report with Word and AI11:03

    Learn to structure, write, and polish a professional report using Microsoft Word and AI; create outlines, insert cover pages, draft executive summaries, and refine with AI and charts.

  • Building a Financial Model with Excel and AI8:50

    Build a simple financial model in Excel that projects revenue, expenses, and profits, then supercharge forecasting with AI to derive growth assumptions and generate insights.

  • Creating a Pitch Deck with PowerPoint and AI3:33

    design a professional pitch deck in PowerPoint with AI tools like ChatGPT, generating slide content for title, problem, solutions, market, business models, and call to action.

  • When to Use AI and When to Work Manually6:03

    Identify tasks that are repetitive or data-driven for AI, and reserve human judgment for emotional, brand, and nuanced work; apply a step-by-step hybrid approach to balance efficiency and quality.

  • Fact-Checking AI Content6:36

    Learn to fact-check ai content by identifying key claims, verifying with reliable sources, cross-referencing data, and checking context and updates to maintain credibility.

  • Editing AI Content for Accuracy5:33

    Learn to edit AI-generated content for accuracy by verifying facts, checking numbers, and ensuring contextual relevance with fact-checking tools, trusted sources, and human review.

  • Protecting Data Privacy with AI6:32

    Explore why data privacy matters, how AI uses personal data, and practical steps such as encryption, differential privacy, federated learning, and GDPR/CCPA compliance to balance innovation with privacy.

  • Using AI Safely in MS Office5:29

    Learn to use AI safely in Word, Excel, and PowerPoint by protecting sensitive data, using placeholders, testing formulas, and applying privacy best practices.

Requirements

  • Microsoft Office: Word, Excel, PowerPoint
  • ChatGPT Account
  • Gemini Account

Description

Are you ready to upgrade your Microsoft Office skills and take full advantage of the power of AI? This course is your complete guide to mastering Microsoft Word, Excel, and PowerPoint, while also learning how to integrate cutting-edge AI tools like ChatGPT and Google Gemini to work smarter—not harder.

Whether you're a student, professional, teacher, or entrepreneur, this course will show you practical, real-world applications of AI-enhanced productivity using the tools you already use every day.

What You’ll Learn:

  • Microsoft Word:

    • Create professional documents with ease

    • Use AI for writing, editing, formatting, and summarizing content

    • Automate report generation with ChatGPT and Gemini

  • Microsoft Excel:

    • Analyze data with formulas, functions, and pivot tables

    • Use AI for data cleaning, interpretation, and formula generation

    • Build dashboards and automate reports using natural language prompts

  • Microsoft PowerPoint:

    • Design engaging presentations quickly

    • Use ChatGPT/Gemini to generate slide content and visual ideas

    • Create AI-assisted scripts, summaries, and design enhancements

  • AI Integration (ChatGPT & Gemini):

    • Understand how to use ChatGPT and Gemini alongside Office apps

    • Learn prompt engineering basics for maximum efficiency

    • Create templates, automate workflows, and enhance creativity

Who This Course is For:

  • Anyone curious about how AI can integrate with Microsoft Office

Why Take This Course?

  • No prior AI experience required – beginner-friendly!

  • Step-by-step demos with real-world examples

  • Unlock the full potential of AI + Office in your personal or professional life

Tools Covered:

  • Microsoft Word, Excel, and PowerPoint

  • ChatGPT

  • Google Gemini

By the end of this course, you’ll not only be more confident in Microsoft Office, but you’ll also be able to think and work like a modern digital professional—powered by AI.

Who this course is for:

  • Anyone interested in practical AI skills with real tools