Advanced MS Office + AI Excellence Syllabus
Diploma in Advanced MS Office + AI Course Syllabus |
||
| PHASE 1- Advanced Word : Course Overview - ( Click here for full Syllabus ) | ||
|
~ Advanced Document Structuring & Formatting ~ Mastering Styles, Themes & Templates ~ Advanced Tables, Layouts & Visual Elements ~ Working with References & Long Documents ~ Document Review, Comparison & Collaboration (In Detail) ~ Advanced Find, Replace & Navigation Tools ~ Mail Merge & Document Automation (Non-Programming) ~ Document Protection & Security ~ Professional Publishing & Exporting ~ Productivity & Best Practices |
||
| AI with Microsoft Word – Content & Documentation : | ||
|
~ Content creation and rewriting ~ Grammar and tone improvement ~ Dictation features ~ Converting Word documents into presentations |
||
| Copilot in Word : | ||
|
~ Creating and formatting documents using Copilot ~ Generating summaries and insights ~ Drafting reports, letters, and proposals with AI ~ Enhancing writing with grammar & tone suggestions ~ Hands-on Exercise: Create a report using Copilot |
||
| PHASE 2- Advanced PowerPoint : Course Overview - ( Click here for full Syllabus ) | ||
|
~ Corporate Presentation Design Principles ~ Slide Master & Corporate Templates ~ Advanced Layout & Alignment Techniques ~ Infographic Creation in PowerPoint ~ Shapes, Icons & Visual Elements ~ Data Visualization for Executives ~ SmartArt – Advanced Customization ~ Visual Storytelling & Slide Flow ~ Animations & Transitions (Professional Use) ~ Executive-Ready Deliverables |
||
| AI with Microsoft PowerPoint – Presentation Productivity : | ||
|
~ Creating presentations from AI prompts ~ Converting Word content to slides ~ Improving storytelling and transitions ~ Rehearsal and delivery improvement |
||
| Copilot in PowerPoint : | ||
|
~ Creating presentations from text input ~ Enhancing slides with design suggestions ~ Automating content summarization ~ Hands-on Exercise: Generate a presentation using Copilot |
||
| PHASE 3 - Advanced Excel: Course Overview - ( Click here for full Syllabus ) | ||
|
~ Overview of the Basics of Excel ~ Working with Different Functions ~ Data Validations ~ Working with Templates ~ Sorting and Filtering Data ~ Power and Text Functions ~ Conditional Formatting ~ WhatIf Analysis ~ Charts ~ Macros ~ New Features Of Excel ~ New Excel feature 365 ~ Simple Dashboard ~ Final Assignment |
||
| AI with Microsoft Excel – Data Analysis & Productivity : | ||
|
~ Dynamic arrays and spilled ranges ~ AI-assisted formula explanation ~ Data filtering and sorting using AI ~ Extracting unique values ~ Using XLOOKUP with AI guidance |
||
| Copilot in Excel : | ||
|
~ Analyzing data with AI insights ~ Automating formula generation & data cleaning ~ Creating charts and pivot tables with Copilot ~ Predictive analysis & forecasting ~ Hands-on Exercise: Generate a data-driven report with Copilot |
