MS Office With AI Masterclass Microsoft, Google ChatGPT

Navigate the Excel interface and set up a new workbook, mastering the ribbon, formula bar, and worksheet grid, with headers and multiple worksheets for clean data organization.

Format cells in Excel by adjusting fonts, alignment, borders, colors, and number formats to improve readability and create polished, professional sales reports.

Learn how to use sum, average, and count formulas in Excel and Google Sheets to add numbers, calculate mean, and count numeric entries with real sales data.

master intermediate formulas in Excel or Google Sheets using IF, AND, and OR to automatically determine pass or fail, bonus eligibility, and performance status from real data.

Learn to use VLOOKUP and XLOOKUP to fetch unit prices from the product list into the sales sheet, and understand their differences and real-world applications.

Learn to clean and format data in excel using text functions such as left, right, mid, len, upper, lower, proper, concat, and text join to extract names, emails, and addresses.

Clean messy Excel data using built-in tools like trim, clean, proper, upper, and lower functions, then fix duplicates, apply text to columns, and enforce whole numbers with data validation.

Learn to sort and filter large Excel datasets to quickly locate sales information, using single and multilevel sorts and filters to analyze regional performance and top selling products.

Master conditional formatting in Excel to automatically highlight important data, spot trends, and identify errors using colors, icons, data bars, and color scales.

Learn to turn raw data into clear visual insight using Excel charts, including cluster column and line charts, to show trends, comparisons, and patterns in real data.

Learn to use pivot tables in Excel to summarize sales quantities and revenue, analyze by product and region, and customize reports with filters and formatting.

Enable data validation in Excel to prevent errors and keep spreadsheets accurate. Set drop-downs for departments, enforce age, date, and salary ranges, and apply input and error alerts.

Learn how Power Query cleans, transforms, and automates data in Excel without complex formulas. Import from multiple sources, apply repeatable steps, and refresh to update new data automatically.

Discover how Excel templates are pre-designed spreadsheets that save time, ensure consistency, and include formatting, formulas, and layouts for tasks like sales reports, invoices, and budgets.

Explore the PowerPoint interface, including the title bar, toolbar, and ribbon, and learn to create and edit slides using home, insert, and design tools.

Learn how layouts and themes in PowerPoint help you create clean, professional, visually consistent slides, using pre-designed structures and one-click themes to maintain consistency.

Master the slide master in PowerPoint to control fonts, colors, layouts, and logos across an entire presentation. Changes in slide master update all slides, saving time and ensuring consistency.

Enhance slides with images and icons by inserting photographs, illustrations, and icons, maintaining balanced alignment and aspect ratios, and using icons to replace bullets for a clear, memorable presentation.

Learn to use shapes, design ideas, and smart art in PowerPoints to create clean, professional, visually engaging slides. AI-powered ideas suggest layouts while smart art visualizes processes and timelines.

Explore how to visually represent data with charts and infographics in PowerPoint, using bar, column, line, pie, and area charts to show comparisons, trends, and storytelling.

Explore PowerPoint animations to make slides engaging by applying entrance, emphasis, exit, and motion spade effects to text, shapes, images, and charts, with timing and sequencing controls.

Master PowerPoint transitions as slide-to-slide visual effects that boost flow and engagement. Balance usage, apply to all slides, and control direction and duration with fade, pause, wipe, and morph.

Learn to embed videos and audio in PowerPoint to create engaging, professional presentations. Insert from device or online sources, set playback options, trim, fade in or out, and add narrations.

Learn to confidently present with PowerPoint presenter view, manage notes, slides, and timers, enable presenter view, and deliver professional presentations with improved organization and timing.

Export PowerPoint as PDF for fixed-layout reports and handouts, or as MP4 video for online courses and social media, using recorded timings, narrations, or set slide durations.

Choose, customize, and design professional presentations using ready-made templates, slide masters, and branding options to ensure consistent fonts, colors, and clear visuals for business, education, and marketing.

Discover how Copilot in PowerPoint automates slide creation, content writing, and design tasks with AI, enabling six slide digital marketing presentations for beginners from simple prompts in Microsoft 365.

Navigate the Google Docs interface to create, edit, and manage documents with real-time collaboration, formatting, and insert options, while understanding the menu bar, toolbar, and auto-save.

Learn to create and format documents in Google Docs, including headings, lists, and basic styling. Share files with others using permissions and links for real-time collaboration.

Format text and paragraphs in Google Docs to produce clean, professional documents by applying font styles, sizes, bold, italics, underline, color, alignment, spacing, indentation, and heading styles.

Learn to use Google Docs styles to format documents quickly with one-click formatting, maintain consistency, and create professional reports, proposals, and manuals by applying headings and updating across the document.

Adjust page sizes, orientations, margins (including headers and footers), and spacing in Google Docs to create professional reports, using the file menu page setups and rulers to fine-tune margins.

Master comments and suggestions mode in Google Docs to collaborate effectively, learn to add comments, reply to feedback, track edits with suggestions, and manage documents.

Track and restore edits in Google Docs with version history, view who changed what and when, and name important versions for long projects.

Explore how templates in Google Docs save time and ensure consistent, professional documents. Learn to access, customize, and create your own templates for recurring tasks like invoices and weekly reports.

Learn to share google docs, set access levels, and invite teammates, enabling real-time collaboration with colored cursors, comments, and suggestions mode for efficient teamwork.

Translate documents in Google Docs to reach a global audience by using the translate documents tool, choose target languages, and review machine-generated text to ensure accuracy.

Learn to create structured, professional reports in Google Docs using headings, a table of contents, and formatting tools for clear, visually appealing results.

Navigate the Google Sheets interface—title bar, menu bar, toolbar, grid, formula bar, and name box—and organize data with sheets, templates, and real-time collaboration.

Format cells in Google Sheets to make data clear and professional by applying text styles, colors, borders, alignment, and currency or date formats, with conditional formatting to highlight key values.

Learn to build basic Google Sheets formulas with the equals sign and cell references, drag-down techniques, to calculate totals, grand totals, and average price per item from sales data set.

Explore logical formulas in Google Sheets, using IF, AND, OR, and IFERROR to automate decisions like pass/fail and bonus eligibility, with practical data sets and auto fill.

Explore lookup functions in Google Sheets, including vlookup, aslookup, and xlookup, to search data across sheets and return related product names or prices.

Explore essential text functions in Google Sheets, including concat, text join, left, right, mid, len, and case controls, to clean, join, and extract names, emails, and product codes.

Clean messy data in Google Sheets by trimming spaces, standardizing text with proper, upper, and lower functions, converting text to numbers, and removing duplicates to support reliable analysis.

Sort data in Google Sheets by quantity or unit price, then filter by category electronics, region, and quantity to produce organized, readable, and actionable sales data.

Learn to use conditional formatting in Google Sheets to highlight key data with colors, icons, and rules, revealing trends, top performers, and potential issues.

Create charts in Google Sheets to turn monthly sales data into clear visuals, using column, line, and pie charts and customizing titles, axes, and data labels for professionalism.

Master pivot tables in Google Sheets to quickly summarize large datasets, analyze sales data, and generate insightful reports by dragging fields to rows, values, and filters.

Collaborate in Google Sheets with real-time updates, sharing controls, comments, and version history. Learn how to set viewer, commenter, and editor access, track changes, and restore previous versions.

Learn the Google Slides interface, its cloud-based tools, and where the menu bar, toolbar, slide panel, and speaker notes live. Discover how to create, edit, and share online presentations confidently.

Learn to use Google Slides layouts to structure title, text, images, and charts, and apply themes to maintain visual consistency and a professional presentation.

Learn to work with text in Google Slides by adding text via text boxes or placeholders, formatting size, color, font styles, and alignment to create clean, professional slide layouts.

Learn to add images in Google Slides from computer, web, and URL, resize and move them, and create shapes like rectangles, arrows, callouts, and equations with customizable fill and borders.

Learn to use charts and diagrams to present data clearly in Google Slides, choosing bar, pie, and line charts to compare values, show parts, and reveal trends.

Explore animations and transitions in Google Slides to bring slides to life for audiences. Differentiate motions from slide-to-slide transitions, apply smooth professional effects, and highlight key points without distraction.

Learn to insert videos from YouTube or Google Drive and audio from Google Drive in Google Slides, then control playback, trim start/end, and mute audio to enhance presentations.

Explore collaboration tools that enable real-time editing, file sharing, and feedback to boost team productivity across locations. Learn how to manage viewing, commenting, and editing permissions in Google Slides.

Learn how Google Slides version history automatically saves changes, lets you view, restore, and name versions to stay organized during team projects.

Learn to use Google Slides templates to create professional presentations quickly and consistently. Customize pre-designed slides with your content, adjust layouts, and stay organized using the template gallery.

Apply design best practices to create clean, professional slides in Google Slides by using one idea per slide, readable fonts, limited colors, visuals, and precise alignment and spacing.

Publish and share Google Slides with viewers, commenters, or editors; generate share links, publish to the web, and download as PDFs or PowerPoints for online classes or client presentations.

Discover Google Gemini, an AI power assistant that helps students, creators, and professionals ask questions, write content, explain topics, summarize documents, and plan content and outlines.

Explore the Gemini interface, mastering the prompt box, response area, and new chat controls to interact confidently with Google's artificial intelligence assistant and craft clear prompts.

Discover the basics of prompting in Google Gemini, and craft clear prompts that specify what you want, how you want it, and in what formats using elements—role, context, output, formats.

Learn to use Google Gemini for writing, generating content from scratch, expanding ideas into paragraphs, rewriting for professional or casual tones, and crafting social media captions, emails, blogs, and scripts.

Learn how to use Gemini for research to find, summarize, and organize information fast, creating detailed outlines and ready-to-use content for courses, scripts, and presentations.

Explore how ChatGPT, an ai powered language model from OpenAI, reads, writes, and explains complex topics in simple language, using prompts and tokens for emails, reports, and scripts.

Create a Chargebt account, sign in with Google or Microsoft, and explore a clean dashboard with a central chat window, left history sidebar, and intuitive interface.

Explore the different types of prompts you can use with ChatGPT to elicit accurate, creative, and useful responses, including simple, description, instructional, role-based, step-by-step, and creative prompts.

Learn prompt writing techniques to craft clear, context-rich prompts for ChatGPT, specify roles and output formats, and iterate to elicit accurate, professional responses.

Learn to write faster, edit smarter, and improve document quality with ChatGPT by generating drafts, rewriting text, fixing grammar, and refining tone for emails, reports, articles, and academic writing.

Explore using chat gpt to summarize long content into concise overviews and expand short ideas into detailed explanations, with practical applications for video editing, scripts, and social content.

Learn to draft clear professional emails and structured reports with ChatGPT, choosing tone and audience to save time and improve communication quality.

Chart GPT explains data and performs simple analysis, turning raw figures into clear insights and explanations. It analyzes trends and patterns to support reports and feedbacks.

Use ChatGPT as a creative partner to generate ideas, plan content, and organize projects; create outlines and day-by-day plans for a YouTube channel on video editing for beginners.

ChatGPT for office documents helps draft professional emails, reports, meeting minutes, and presentation outlines, saving time and boosting productivity in everyday office work.

Master safe, ethical, dispensable use of chat gpt for learning, content creation, and professional work, emphasizing privacy, fact verification, and responsible prompts.

Discover how Copilot, an AI powered assistant from Microsoft, speeds writing, idea generation, and document creation across Word, Excel, PowerPoint, Outlook, and more using simple prompts.

Discover how copilot inside Word speeds writing and editing by generating, rewriting, and summarizing text, changing tone or style, all without leaving Word.

Microsoft copilots inside Excel analyze data, generate insights, and create formulas to highlight trends and compute profits.

Learn to use Copilot inside PowerPoint to rapidly create slides, generate structured content with headings and bullets, and improve designs and speaker notes with AI prompts.

Discover how Copilot inside Outlook helps you write emails faster, summarize conversations, and manage your inbox more efficiently with prompts and tone adjustments.

Use copilot for data analysis to automatically scan datasets, find patterns, explain insights in plain language, and create charts with natural language prompts.

Discover how Microsoft Copilot acts as your AI business assistant to write emails, plan meetings, and analyze data. Create quick Word reports and other tasks, boosting productivity.

Learn copilot prompt patterns—role plus task, context plus goal, step-by-steps, rewrite, and translate—to generate more professional, focused results for work, study, or content creation.

Learn how to use copilot automations to handle repetitive tasks and multi-step workflows, generate templates, captions, and checklists, and save time while working smarter.

Real-world copilot projects show how copilots accelerate real tasks—from emails and reports to social media content and presentations—by turning ideas into output in minutes, with prompts, refinement, and customization.