13 Sections
129 Lessons
8 Weeks
Expand all sections
Collapse all sections
MS Word 365
16
1.1
What is Microsoft Word
1.2
Uses of MS Word (letters, projects, assignments)
1.3
Understanding pages and documents
1.4
Opening and saving documents
1.5
Typing and editing text efficiently
1.6
Copy, Cut, Paste, and Find & Replace
1.7
Font styling (Bold, Italic, Underline, Size, Color)
1.8
Paragraph alignment and spacing
1.9
Inserting images, shapes, tables, and SmartArt
1.10
Page layout (margins, orientation, themes)
1.11
Headers, footers, and page numbers
1.12
Print setup and preview
1.13
Using ChatGPT with Word 365
1.14
Content drafting and editing with AI
1.15
Proofreading and formatting assistance
1.16
Practical activities and real-world exercises
MS Excel 365
19
2.1
Introduction to MS Excel
2.2
Understanding workbook and worksheets
2.3
Excel interface overview
2.4
Basic navigation and file management
2.5
Entering and editing data
2.6
Cell formatting and styling
2.7
Tables and structured data
2.8
Conditional formatting basics
2.9
Basic calculations
2.10
SUM, AVERAGE, COUNT, MIN, MAX
2.11
IF function basics
2.12
Date and text functions
2.13
Sorting and filtering data
2.14
Managing large datasets
2.15
Creating different sheets: Attendance sheet, Marks sheet, Sales sheet, Salary sheet, Purchase sheet
2.16
Creating charts (bar, line, pie)
2.17
Data visualization basics
2.18
Professional reporting
2.19
Practical business use cases
VLOOKUP,HLOOKUP & XLOOKUP
13
3.1
Introduction to Lookup Functions in Excel
3.2
Difference between VLOOKUP, HLOOKUP, and XLOOKUP
3.3
Syntax and arguments explanation
3.4
Exact match vs approximate match
3.5
Using lookup functions with different data ranges
3.6
column and row indexing concepts
3.7
Practical examples (employee data, product lists)
3.8
Error handling (#N/A, IFERROR usage)
3.9
Advanced matching options and flexibility
3.10
Best practices for efficient lookup formulas
3.11
Using XLOOKUP for dynamic data retrieval
3.12
Nested lookup functions usage
3.13
Common mistakes and troubleshooting techniques
Pivot Tables & Analysis
13
4.1
Introduction to Pivot Tables
4.2
Creating Pivot Tables from datasets
4.3
Field selection and layout (Rows, Columns)
4.4
Summarizing large datasets quickly
4.5
Sorting and filtering within Pivot Tables
4.6
Grouping data (dates, categories, numbers)
4.7
Creating Pivot Charts
4.8
Basic data insights and trends analysis
4.9
Formatting Pivot Table reports professionally
4.10
Real-world business reporting examples
4.11
Using slicers for interactive filtering
4.12
Refreshing and updating Pivot Tables
4.13
Designing simple dashboards with Pivot Tables
MS Powerpoint 365
16
5.1
Introduction to PowerPoint 365
5.2
PowerPoint interface and workspace
5.3
Slide navigation and layouts
5.4
Presentation setup basics
5.5
Professional slide design
5.6
Creating effective content
5.7
Text structuring and readability
5.8
Design themes and consistency
5.9
Inserting visual elements (images, shapes, charts)
5.10
Animations and transitions
5.11
Multimedia integration (audio/video)
5.12
Interactive presentation features
5.13
Business presentation examples
5.14
Professional storytelling
5.15
Real-world presentation scenarios
5.16
Hands-on practical activities
Using Internet
16
6.1
Introduction to the Internet
6.2
Understanding web browsers
6.3
Internet safety basics
6.4
Surfing and navigating websites
6.5
Searching on Internet
6.6
Using keywords effectively
6.7
Advanced search techniques
6.8
Identifying reliable sources
6.9
Creating e-mail accounts
6.10
Sending & receiving emails
6.11
Adding attachments
6.12
Email etiquette and security
6.13
Downloading files safely
6.14
Uploading documents online
6.15
Cloud storage basics
6.16
Managing files across devices
Using Generative AI
12
7.1
Basics of Generative AI
7.2
How Generative AI works
7.3
Understanding AI capabilities
7.4
Real-world applications of AI
7.5
Overview of ChatGPT & Copilot
7.6
Practical use cases in daily work
7.7
Content creation and automation
7.8
Productivity and workflow enhancement
7.9
Creating powerful prompts
7.10
Zero-shot prompting
7.11
Few-shot prompting
7.12
Chain of thought prompting
AI For Research & Content
4
8.1
AI for research and content
8.2
Text summarization
8.3
Best practices for AI usage
8.4
AI for content creators
AI Learning & Productivity
4
9.1
Supercharge learning with AI
9.2
AI for active learning
9.3
Task automation with AI
9.4
Workflow optimization using AI
AI Powered Marketing
4
10.1
AI-based marketing strategies
10.2
Content planning and automation
10.3
Campaign optimization using AI
10.4
Audience targeting and personalization
AI Content Creation
4
11.1
AI for voice overs
11.2
AI for content production
11.3
AI video creation tools
11.4
Workflow automation for creators
Image AI & Prompting
4
12.1
AI image generation (Text to visuals)
12.2
Writing effective image prompts
12.3
Advanced AI prompting techniques
12.4
Creative design with AI tools
Data Stories & Visuals
4
13.1
Exploratory Data Analysis (EDA) basics
13.2
Data visualization techniques
13.3
Visual storytelling principles
13.4
Presenting data insights professionally
Professional Office & Generative AI Essentials Course
Curriculum
This content is protected, please
login
and enroll in the course to view this content!
Your Website
Modal title
Main Content
Your Website
