MS Office & AI Productivity: Detailed Course Syllabus
| Ms Office + Generative 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 |
||
| 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 - 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 |
||
| 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 - 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 |
||
| 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 |
