Curriculum
5 Sections
43 Lessons
5 Weeks
Expand all sections
Collapse all sections
Microsoft Word
Microsoft Word
14
1.1
1. Introduction to MS Word and interface overview
1.2
2. Creating, editing, saving, and formatting documents
1.3
3. Page layout: margins, orientation, page breaks
1.4
4. Headers, Footers, Page Numbering
1.5
5.Using bullets, numbering, borders, and shading
1.6
6. Working with tables and formatting table data
1.7
7. Applying and customizing styles and themes
1.8
8. Creating and using templates
1.9
9. Mail merge (with Excel integration)
1.10
10. Cross-references, hyperlinks, footnotes, endnotes
1.11
11. Inserting graphics, symbols, charts, SmartArt
1.12
12. Table of contents, indexes, bookmarks
1.13
13. Reviewing tools: Track Changes, Comments
1.14
14. Document protection and version control
Microsoft Excel - Basic to Intermediate
12
2.2
1. Excel interface and navigation
2.3
2. Working with cells, ranges, worksheets
2.4
3. Formatting cells, data types, and conditional formatting
2.5
4. Basic formulas: SUM, AVERAGE, MIN, MAX, COUNT
2.6
5. Logical functions: IF, AND, OR, NOT
2.7
6. Lookup functions: VLOOKUP, HLOOKUP, INDEX, MATCH
2.8
7. Text functions
2.9
8. Excel Sorting and Filtering Data
2.10
9. Data validation and dropdowns
2.11
10. Charts and graphs: Column, Bar, Line, Pie
2.12
11. Named ranges and cell referencing techniques
2.13
12. Creating interactive forms and checklists
Advanced Excel & Reporting
7
3.1
Pivot tables & charts
3.2
Slicers and timeline filters
3.3
Dynamic Dashboards
3.4
Advanced Formulas
3.5
Working with large data sets
3.6
Data Cleanup & Transformation Techniques
3.7
Automating using Macros
Generative AI for Office Automation
10
4.1
Generative AI for productivity
4.2
Introduction to Gen AI
4.3
Prompt Engineering Basics
4.4
Using Gen AI Content Creation (Emails, Letters etc..)
4.5
Summarizing and rewriting text using AI
4.6
AI for Excel
4.7
Data Analysis and Trend Insights with GenAI tools
4.8
GenAI Plugins and Add-Ons for Excel/Word
4.9
Real World AI use cases
4.10
Ethics, responsible usage and limitations of AI
Final Project
0
Office Automation – Microsoft Word, Excel & Gen-AI
Curriculum
This content is protected, please
login
and enroll in the course to view this content!
Home
Courses
Search
Search
Account
Login with your site account
Are you human? Please solve:
Lost your password?
Remember Me
Not a member yet?
Register now
Register a new account
Are you human? Please solve:
Are you a member?
Login now
Modal title
Main Content