MS Office & AI Excellence: Essential to Advanced Syllabus
| Diploma in MS Office + AI Content | ||
| PHASE 1 - Word: Course Overview - ( Click here for full Syllabus ) | ||
|
~ Introduction to MS Word ~ Creating Documents ~ Text Basics ~ Text Formatting ~ Paragraph Formatting ~ Page Setup ~ Insert Options ~ Working with Tables ~ Find and Replace ~ Header and Footer ~ Spelling and Grammar ~ Printing Documents ~ File Management ~ Basic Shortcuts |
||
| PHASE 2- 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 3- Powerpoint: Course Overview - ( Click here for full Syllabus ) | ||
|
~ Introduction to PowerPoint ~ Creating Presentations ~ Slides Basics ~ Text in Slides ~ Slide Design ~ Insert Options ~ Working with Images ~ Tables and Charts ~ Animations ~ Slide Transitions ~ Slide Show ~ Audio and Video ~ Review Toolst ~ Printing and Export |
||
| PHASE 4- 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 5- Basic Excel: Course Overview - ( Click here for full Syllabus ) | ||
|
~ Introduction to MS Excel ~ Workbook and Worksheet ~ Cells and Ranges ~ Data Types ~ Basic Formatting ~ Rows and Columns ~ Basic Formulas ~ Aggregate Functions ~ Sorting and Filtering ~ Working with Tables ~ Charts (Basic) ~ Page Setup and Printing ~ File Management ~ Basic Keyboard Shortcuts |
||
| PHASE 6 - 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 |
