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 with ChatGPT
Rating: 3.9 out of 5(125 ratings)
11,752 students

MS Office With AI - Word Excel PowerPoint with ChatGPT

Master Microsoft Word, Excel, PowerPoint, and Google Sheets with AI tools like ChatGPT to Save time, Automate tasks
Created bySustoab Soren
Last updated 8/2025
English
English [Auto],

What you'll learn

  • How to use ChatGPT to write, edit, and summarize documents in Microsoft Word
  • Methods to automate reports, letters, and other routine tasks with AI
  • How to generate Excel formulas, analyze data, and create reports using AI prompts.
  • How to design professional PowerPoint presentations with AI-generated content.
  • How to apply AI in Google Sheets for automation, data cleaning, and analysis.
  • Practical prompts to integrate AI into business, academic, and personal tasks.
  • Real-world skills for combining MS Office, Google Sheets, and ChatGPT effectively.

Course content

1 section30 lectures10h 53m total length
  • Introduction4:04

    Explore Word, Excel, and PowerPoint basics with AI from ChatGPT, building professional reports, budgets, dashboards, and 5–7 slide presentations; master Google Sheets collaboration.

  • Introduction to Microsoft Word interface27:04

    Explore the Microsoft Word interface from the ground up, navigating the title bar, ribbon, quick access toolbar, and file tabs. Use templates, tables, and layout controls to create polished documents.

  • Creating, saving, and formatting documents in Word30:24

    Develop core Word skills by creating and saving documents in Word and PDF formats. Apply formatting with fonts, spacing, alignment, bullets, styles, templates, margins, headers, footers, and page numbers.

  • Working with fonts, paragraphs, and styles in Word29:49

    Master fonts, paragraphs, and styles in Word to craft professional documents. Apply alignment, spacing, indents, bullets, numbering, and create custom styles and templates for consistent branding.

  • Inserting tables, images, and shapes in Word21:19

    Master inserting and customizing tables, images, and shapes in Word to create organized, visually compelling documents. Learn table layouts, image resizing, and shape highlights for professional, easy-to-read materials.

  • Using headers, footers, page numbers, and templates in Word21:26

    Master headers, footers, page numbers, and templates in Word to create professional, consistent documents with branding, logos, dates, and authors.

  • Introduction to Microsoft Excel interface24:52

    Explore the Excel interface, navigate the ribbon, tabs, and groups, and customize the workspace. Build and format a worksheet, apply formulas, and insert charts.

  • Basic formulas and functions (SUM, AVERAGE, COUNT)23:38

    Learn to use sum, average, and count to transform spreadsheets into smart, automated data tools for budgeting and data analysis.

  • Formatting cells, rows, and columns in Excel32:18

    Format cells, rows, and columns in Excel to create clear, professional reports. Learn font, color, borders, alignment, wrap text, number formats, conditional formatting, and professional layout for polished worksheets.

  • Creating charts and graphs in Excel22:03

    Learn to transform data into clear stories with Excel charts and graphs. Create, customize, and analyze column, line, pie, scatter, area, and combo charts with best practices.

  • Using pivot tables and basic data analysis in Excel20:56

    Create and analyze pivot tables in Excel to summarize data, perform quick aggregations, and visualize insights with pivot charts and filters.

  • Introduction to Microsoft PowerPoint interface18:48

    Explore the Microsoft PowerPoint interface, including the workspace, ribbons, toolbars, and navigation. Learn to use the home, insert, design, transitions, animations, slide show, and backstage file options.

  • Working with slides, layouts, and themes in PowerPoint26:51

    Master slides, layouts, and themes in PowerPoint to craft professional, visually engaging presentations. Apply consistent themes, customize fonts and colors, and optimize content for clarity.

  • Inserting images, shapes, charts, and media in PowerPoint31:39

    Learn to insert and edit images, shapes, charts, and media in PowerPoint, apply crop and picture styles, build charts from Excel data, and add audio and video.

  • Animations, transitions, and slide timings in PowerPoint28:10

    Master PowerPoint animations and transitions, control slide pacing with durations, delays, and rehearsed timings, and apply morph and fade effects to create engaging, professional presentations.

  • Preparing presentations for delivery and export in PowerPoint19:05

    Prepare slides for delivery by configuring slideshow options, presenter view, and embedded fonts and media, then export to video, PDF, or PowerPoint show and share via OneDrive for collaboration.

  • Introduction to ChatGPT and AI tools20:43

    Discover what artificial intelligence and ChatGPT are, how they work, and practical AI tool uses for content creation, learning, and professional work.

  • Using ChatGPT for content generation, summaries, and emails17:15

    Master ChatGPT for content generation, summarizing long documents, and drafting professional emails. Learn to tailor tone and style to boost creativity, save time, and improve communication.

  • Leveraging ChatGPT for learning, research, and automation24:57

    Leverage ChatGPT as a personal learning assistant for self-guided study, research, and automation, including fact-checked research, summaries, and automated emails, content generation, and brainstorming.

  • Prompts and advanced techniques for ChatGPT16:34

    Master crafting precise prompts and advanced techniques for ChatGPT to structure complex queries, optimize responses, and tailor outputs with role-based, step-by-step, and tone-controlled prompts.

  • Introduction to Google Sheets interface16:52

    Explore the Google Sheets interface, navigate layouts, build and format simple data sets, and collaborate in real time using Sheets, templates, and cloud autosave.

  • Basic formulas and functions in Google Sheets20:10

    Learn to transform spreadsheets with Google Sheets formulas and functions, using cell references for dynamic calculations and mastering sum, average, min, max, count, and if.

  • Conditional formatting and data validation in Google Sheets25:34

    Explore conditional formatting and data validations in Google Sheets to create visually interactive, error-proof spreadsheets with drop-down menus, color scales, and inventory status tracking.

  • Charts, graphs, and pivot tables in Google Sheets11:47

    Create charts, graphs, and pivot tables in Google Sheets to transform sales data into clear visual insights and reveal trends for concise reporting.

  • Collaboration, sharing, and cloud features in Google Sheets11:34

    Learn how google sheets enables real-time collaboration with cloud-based sharing, permissions, and version history, and use comments and cloud imports to boost team productivity.

  • Project 1 Create a professional report with styled headings, images, a table, an21:19

    Create a polished professional report in Word using styled headings, images, and tables, with headers and footers, a cover page, and properly formatted layout.

  • Project 2 Build a budget or sales dashboard with formulas, charts, and a pivot t34:13

    Create a complete budget and sales dashboard in Excel with formulas, pivot tables, charts, and slicers, delivering dynamic insights from cleaned data and KPIs.

  • Project 3 Create a 5–7 slide presentation with images, charts, animations, and t32:35

    Create a polished 5–7 slide PowerPoint presentation with images, charts, animations, and transitions; apply a design theme and save as PowerPoint or pdf.

  • Project 4 Generate a complete content package (blog post, email, and summary rep9:51

    Master generating a complete content package—from a blog post to professional emails and a concise summary report—using a single, well-structured prompt with ChatGPT and tone refinement.

  • Project 5 Create an interactive inventory or grade tracking sheet with formulas,7:42

    Create an interactive inventory or grade tracking sheet using formulas, conditional formatting, charts, data validation, and collaboration features in Google Sheets.

Requirements

  • No Prio Experience Required

Description

Artificial Intelligence is transforming the way we work. By combining the power of ChatGPT with Microsoft Office and Google Sheets, you can save time, improve accuracy, and boost productivity across everyday tasks.

This course, “MS Office With AI - Word, Excel, PowerPoint, Google Sheets and ChatGPT”, will guide you step by step through practical applications of AI in the world’s most widely used office tools. You will learn how to write faster, analyze data more effectively, and create professional presentations with ease.

Whether you are a student, professional, freelancer, or business owner, this course will show you exactly how to integrate AI into your workflow to get more done in less time.

What You Will Learn

  • Use ChatGPT to write, edit, and summarize documents in Microsoft Word.

  • Automate repetitive tasks like reports, proposals, and letters with AI.

  • Generate formulas, analyze data, and create reports in Excel using AI prompts.

  • Build charts, pivot tables, and insights faster with ChatGPT.

  • Design engaging PowerPoint presentations with AI-generated content and structure.

  • Improve presentation flow, storytelling, and slide design with AI support.

  • Streamline workflows in Google Sheets with ChatGPT for automation and data cleaning.

  • Apply practical AI prompts for business, study, and personal productivity.

  • Save hours of manual work by integrating ChatGPT into daily office tasks.

  • Gain real-world skills to combine MS Office, Google Sheets, and AI effectively.

Why Take This Course?

  • No coding or technical background required.

  • Practical, step-by-step demonstrations you can apply immediately.

  • Real-world examples designed for workplace, academic, and business use.

  • Stay ahead of the curve by learning how AI is reshaping office productivity.

Who This Course Is For

  • Anyone interested in using ChatGPT with Microsoft Office and Google Sheets.

By the end of this course, you will know how to confidently integrate AI and ChatGPT into Word, Excel, PowerPoint, and Google Sheets to streamline tasks, reduce errors, and work smarter every day.

Who this course is for:

  • Anyone interested in using ChatGPT with Microsoft Office and Google Sheets.