Skip to course content
SKILL HUBBY SHUBHAM
COMPUTER INSTITUTE
☰ Menu

SKILL HUB • BY SHUBHAM • COMPUTER INSTITUTE

Three essential tools.
One complete
Office journey.

MS Word · Excel · PowerPointBasic to Advanced · Bahraich

Create professional documents, work confidently with data and present your ideas clearly. Explore all three training courses in one place at Skill Hub, Bahraich.

Skill Hub complete Office journey: practical MS Word, MS Excel and MS PowerPoint training from basic to advanced
WMS WordDocuments & designXMS ExcelData & analysisPMS PowerPointSlides & storytelling
3 Office applications58 Learning modules378 Syllabus topicsEnquire About Admission ↗

01 / OFFICE SKILLS

MS Word

Create documents that work.

16 modules · 108 topics
MS Word Basic to Advanced — Complete Training Course

Letters, reports, bilingual documents and professional office work. Explore the complete basic-to-advanced syllabus below.

1

Fundamentals (MS Word Basics)

TOPICS & PRACTICAL SKILLS
  1. Introduction to MS Word
  2. Interface & Workspace
  3. File & Document Management
  4. Keyboard & Mouse Shortcuts
  5. Text Entry & Basic Editing
2

Formatting (Text & Paragraph)

TOPICS & PRACTICAL SKILLS
  1. Font & Character Formatting
  2. Paragraph Formatting
  3. Bullets & Numbering
  4. Borders, Shading & Effects
  5. Find, Replace & Proofing
3

Page & Document Layout

TOPICS & PRACTICAL SKILLS
  1. Page Setup
  2. Margins, Orientation & Paper Size
  3. Page & Section Breaks
  4. Headers & Footers
  5. Page Numbering
  6. Columns & Newspaper Layout
4

Tables

TOPICS & PRACTICAL SKILLS
  1. Creating Tables
  2. Table Editing
  3. Table Formatting
  4. Table Layout & Design
  5. Formulas & Calculations
  6. Advanced Table Techniques
5

Graphics & Design

TOPICS & PRACTICAL SKILLS
  1. Pictures
  2. Shapes
  3. WordArt & Text Boxes
  4. Icons
  5. SmartArt
  6. Charts
  7. Objects & Layering
6

Professional Formatting

TOPICS & PRACTICAL SKILLS
  1. Styles
  2. Themes
  3. Templates
  4. Building Blocks & Quick Parts
  5. Fields
  6. Professional Document Design
7

Advanced Documents

TOPICS & PRACTICAL SKILLS
  1. Long Documents
  2. Sections & Section-wise Formatting
  3. Navigation Pane
  4. Bookmarks & Hyperlinks
  5. Cross-References
  6. Captions
  7. Table of Contents
  8. Index
8

References & Academic Work

TOPICS & PRACTICAL SKILLS
  1. Footnotes & Endnotes
  2. Citations
  3. Bibliography
  4. Research Documents
  5. Thesis & Project Reports
9

Mail Merge & Forms

TOPICS & PRACTICAL SKILLS
  1. Mail Merge Fundamentals
  2. Letters
  3. Envelopes & Labels
  4. Email Merge
  5. Advanced Mail Merge
  6. Developer Tab
  7. Forms & Form Controls
  8. Document Protection
10

Review & Collaboration

TOPICS & PRACTICAL SKILLS
  1. Spelling & Grammar
  2. Comments
  3. Track Changes
  4. Compare & Combine Documents
  5. Accessibility
  6. Collaboration & Sharing
11

Printing & PDF

TOPICS & PRACTICAL SKILLS
  1. Print Settings
  2. Print Preview
  3. Advanced Printing
  4. PDF Creation & Export
  5. PDF & Document Optimization
12

Automation

TOPICS & PRACTICAL SKILLS
  1. Macros
  2. Macro Recording
  3. VBA Introduction
  4. Word VBA Objects
  5. VBA with Tables & Documents
  6. Automated Reports
  7. Automated Certificates
  8. Word + Excel Automation
13

Professional Office Work

TOPICS & PRACTICAL SKILLS
  1. Official Letters
  2. Applications & Notices
  3. Reports & Proposals
  4. Resume & CV
  5. Certificates
  6. Invoices & Quotations
  7. HR Documents
  8. Business Documents
  9. Letterheads
14

DTP & Creative Work

TOPICS & PRACTICAL SKILLS
  1. Visiting Card
  2. ID Card
  3. Certificate Design
  4. Brochure
  5. Flyer
  6. Poster
  7. Invitation Card
  8. Newspaper Layout
15

Hindi & Bilingual Word

TOPICS & PRACTICAL SKILLS
  1. Hindi Unicode Typing
  2. Hindi Fonts
  3. Hindi Document Formatting
  4. Hindi Official Documents
  5. Hindi Question Papers
  6. Hindi + English Documents
16

Master Projects

TOPICS & PRACTICAL SKILLS
  1. Professional Resume Project
  2. 20+ Page Project Report
  3. Professional Question Paper
  4. Company Letterhead
  5. Bulk Certificate Generation
  6. Employee Appointment Letters
  7. Professional Invoice
  8. Registration Form
  9. 100-Page Book/Manual
  10. Final VBA Automation Project

Your Skill Journey

  1. 01
    Beginner

    Basic Typing & Formatting

  2. 02
    Basic

    Letters, Applications, Tables

  3. 03
    Intermediate

    Professional Documents

  4. 04
    Advanced

    Reports, TOC, References, Mail Merge

  5. 05
    Expert

    Templates, Forms, Automation

  6. 06
    Professional

    VBA, Large Documents & Office Automation

Ready to learn MS Word?Ask About This Course ↗

02 / OFFICE SKILLS

MS Excel

Turn data into decisions.

24 modules · 144 topics
MS Excel Basic to Advanced — Complete Training Course

Spreadsheets, formulas, analysis, dashboards and practical business tasks. Explore the complete basic-to-advanced syllabus below.

1

Excel Fundamentals

TOPICS & PRACTICAL SKILLS
  1. Introduction to MS Excel
  2. Excel Versions & Features
  3. Excel Interface & Workspace
  4. File Management
  5. Keyboard & Mouse Shortcuts
  6. Data Types & File Formats
2

Basic Operations

TOPICS & PRACTICAL SKILLS
  1. Creating a New Workbook
  2. Opening & Saving Files
  3. Save As & File Options
  4. Close & Recover Files
  5. Workbook Properties
  6. Undo & Redo
3

Worksheet Basics

TOPICS & PRACTICAL SKILLS
  1. Rows, Columns & Cells
  2. Selecting Cells & Ranges
  3. Insert & Delete Cells
  4. Move & Copy Cells
  5. Worksheets & Workbooks
  6. Freeze Panes
4

Data Entry & Editing

TOPICS & PRACTICAL SKILLS
  1. Data Entry Techniques
  2. AutoFill
  3. Flash Fill
  4. Find & Replace
  5. Data Validation
  6. Error Checking
5

Formatting

TOPICS & PRACTICAL SKILLS
  1. Font Formatting
  2. Cell Alignment
  3. Number Formatting
  4. Borders & Shading
  5. Conditional Formatting
  6. Format Painter
6

Formulas & Functions

TOPICS & PRACTICAL SKILLS
  1. Basic Formulas
  2. AutoSum
  3. Mathematical Functions
  4. Logical Functions
  5. Text Functions
  6. Date & Time Functions
7

Charts & Visualization

TOPICS & PRACTICAL SKILLS
  1. Creating Charts
  2. Chart Types
  3. Chart Formatting
  4. Dynamic Charts
  5. Sparklines
  6. Pivot Charts
8

PivotTables & PivotCharts

TOPICS & PRACTICAL SKILLS
  1. Creating a PivotTable
  2. PivotTable Fields
  3. Value & Calculated Fields
  4. Filtering & Slicers
  5. PivotChart Creation
  6. Refresh & Update
9

Tables & Table Tools

TOPICS & PRACTICAL SKILLS
  1. Creating Tables
  2. Table Formatting
  3. Table Styles
  4. Sort & Filter
  5. Table Calculations
  6. Convert to Range
10

Data Management

TOPICS & PRACTICAL SKILLS
  1. Sort & Filter (Advanced)
  2. Remove Duplicates
  3. Text to Columns
  4. Data from Text/CSV
  5. Data Connections
  6. Power Query Basics
11

Advanced Functions

TOPICS & PRACTICAL SKILLS
  1. VLOOKUP / HLOOKUP
  2. INDEX & MATCH
  3. XLOOKUP
  4. SUMIF / COUNTIF
  5. IF & Nested IF
  6. Array Formulas
12

Data Analysis Tools

TOPICS & PRACTICAL SKILLS
  1. What-If Analysis
  2. Goal Seek
  3. Scenario Manager
  4. Solver
  5. Data Analysis ToolPak
  6. Descriptive Statistics
13

Page Setup & Printing

TOPICS & PRACTICAL SKILLS
  1. Page Setup
  2. Margins, Orientation & Size
  3. Print Area
  4. Page Breaks
  5. Headers & Footers
  6. Print Preview & Settings
14

Data & Workbook Protection

TOPICS & PRACTICAL SKILLS
  1. Protect Sheet
  2. Protect Workbook
  3. Encrypt with Password
  4. Restrict Editing
  5. Digital Signatures
  6. Track Changes (Review)
15

Collaboration & Sharing

TOPICS & PRACTICAL SKILLS
  1. Comments
  2. Track Changes
  3. Compare & Combine Workbooks
  4. Share Workbook
  5. Co-authoring
  6. Version History
16

Mail Merge (Excel to Word)

TOPICS & PRACTICAL SKILLS
  1. Preparing Data in Excel
  2. Mail Merge Setup
  3. Create Letters / Labels
  4. Conditional Merge
  5. Preview & Finish
  6. Automation with Excel
17

VBA & Macros

TOPICS & PRACTICAL SKILLS
  1. Macro Recording
  2. VBA Editor
  3. Variables & Data Types
  4. Loops & Conditions
  5. Working with Excel Objects
  6. Automating Tasks
18

Dashboards & Reports

TOPICS & PRACTICAL SKILLS
  1. Dashboard Design
  2. KPI Charts
  3. Slicers & Timelines
  4. Interactive Dashboards
  5. Data Refresh
  6. Report Automation
19

Excel + Other Apps

TOPICS & PRACTICAL SKILLS
  1. Excel & Word Integration
  2. Excel & PowerPoint
  3. Excel & Access
  4. Excel & Outlook
  5. Linked Data
  6. Embedded Objects
20

Professional Office Work

TOPICS & PRACTICAL SKILLS
  1. Budget & Expense Sheets
  2. Inventory Management
  3. Sales & Purchase Reports
  4. HR Records
  5. Project Tracking
  6. Business Reports
21

Real-World Projects

TOPICS & PRACTICAL SKILLS
  1. Student Marksheet
  2. Employee Database
  3. Invoice & Quotation
  4. Monthly Report
  5. Dashboard Project
  6. Full Business Workbook
22

Advanced Topics

TOPICS & PRACTICAL SKILLS
  1. Power Pivot
  2. DAX Functions
  3. Advanced Charts
  4. Dynamic Arrays
  5. Macros with User Forms
  6. Excel Add-ins
23

Certification & Exams

TOPICS & PRACTICAL SKILLS
  1. Practice Exercises
  2. Sample Test Papers
  3. Competitive Exam Preparation
  4. Certification Project
  5. Real-World Case Studies
  6. Final Assessment
24

Extra Learning

TOPICS & PRACTICAL SKILLS
  1. Excel Tips & Tricks
  2. Shortcuts Cheat Sheet
  3. Useful Websites
  4. Templates & Resources
  5. Continuous Practice
  6. Career Guidance

Your Skill Journey

  1. 01
    Beginner

    Basic Operations & Data Entry

  2. 02
    Basic

    Formulas, Formatting & Charts

  3. 03
    Intermediate

    PivotTables, Data Analysis & Reports

  4. 04
    Advanced

    VBA, Automation & Dashboards

  5. 05
    Expert

    Business Solutions & Integration

  6. 06
    Professional

    Real-World Projects & Career Ready

Ready to learn MS Excel?Ask About This Course ↗

03 / OFFICE SKILLS

MS PowerPoint

Present your ideas with confidence.

18 modules · 126 topics
MS PowerPoint Basic to Advanced — Complete Training Course

Clear slides, engaging visuals, animations and complete presentations. Explore the complete basic-to-advanced syllabus below.

1

Introduction & Basics

TOPICS & PRACTICAL SKILLS
  1. What is MS PowerPoint?
  2. Uses & Applications
  3. Versions of PowerPoint
  4. File Types & Extensions
  5. Start & Close PowerPoint
  6. Create a New Presentation
  7. Templates & Themes (Intro)
2

Interface & Workspace

TOPICS & PRACTICAL SKILLS
  1. PowerPoint Window
  2. Ribbon & Tabs
  3. Quick Access Toolbar
  4. Status Bar
  5. View Options
  6. Zoom & Zoom Slider
  7. Customizing the Ribbon
3

Slides & Slide Layouts

TOPICS & PRACTICAL SKILLS
  1. Slide Basics
  2. Slide Views (Normal, Slide Sorter…)
  3. Layouts & Placeholders
  4. Duplicate & Delete Slides
  5. Reuse Slides
  6. Section & Slide Management
  7. Slide Master (Intro)
4

Text & Formatting

TOPICS & PRACTICAL SKILLS
  1. Text Entry & Editing
  2. Font & Font Size
  3. Bold, Italic, Underline
  4. Font Color & Highlight
  5. Text Effects
  6. Change Case
  7. Paragraph & Alignment
5

Images & Media

TOPICS & PRACTICAL SKILLS
  1. Insert Pictures
  2. Resize & Crop
  3. Picture Styles
  4. Remove Background
  5. Insert Audio
  6. Insert Video
  7. Media Playback Options
6

Shapes & Graphics

TOPICS & PRACTICAL SKILLS
  1. Shapes
  2. Shape Fill & Outline
  3. Shape Effects
  4. Align & Arrange
  5. Group, Ungroup
  6. Order (Bring Forward/Send Backward)
  7. Icons & 3D Models
7

SmartArt & Diagrams

TOPICS & PRACTICAL SKILLS
  1. What is SmartArt?
  2. SmartArt Categories
  3. Create & Edit SmartArt
  4. Organizational Charts
  5. Process & Cycle Diagrams
  6. Hierarchy & Relationship
  7. Formatting SmartArt
8

Charts & Data Visualization

TOPICS & PRACTICAL SKILLS
  1. Chart Types
  2. Insert Chart
  3. Edit Chart Data
  4. Chart Elements
  5. Chart Styles & Colors
  6. Axis, Legend, Data Labels
  7. Advanced Chart Formatting
9

Transitions & Animations

TOPICS & PRACTICAL SKILLS
  1. Slide Transitions
  2. Transition Effects
  3. Animations
  4. Animation Pane
  5. Timing & Triggers
  6. Advanced Animation Options
  7. Custom Animation Paths
10

Design & Themes

TOPICS & PRACTICAL SKILLS
  1. Themes
  2. Colors
  3. Fonts
  4. Effects
  5. Background Styles
  6. Create Custom Theme
  7. Save & Apply Theme
11

Slide Show & Presentation

TOPICS & PRACTICAL SKILLS
  1. Slide Show View
  2. Set Up Slide Show
  3. Rehearse Timings
  4. Record Slide Show
  5. Narration & Ink
  6. Presenter View
  7. Slide Show Shortcuts
12

Printing & Handouts

TOPICS & PRACTICAL SKILLS
  1. Print Settings
  2. Print Preview
  3. Handouts
  4. Notes Pages
  5. Page Setup
  6. Header & Footer in Handouts
  7. Print to PDF
13

Templates & Reuse

TOPICS & PRACTICAL SKILLS
  1. Create Template
  2. Save as Template
  3. Use Template
  4. Custom Theme Templates
  5. Reuse Slides
  6. Content Library
  7. Company Templates
14

Collaboration & Sharing

TOPICS & PRACTICAL SKILLS
  1. Share Presentation
  2. Co-authoring
  3. Comments
  4. Track Changes
  5. Compare Presentations
  6. Save to OneDrive
  7. Share via Email
15

Security & Protection

TOPICS & PRACTICAL SKILLS
  1. Set Password
  2. Mark as Final
  3. Restrict Editing
  4. View Permissions
  5. Digital Signatures
  6. Protect Presentation
  7. Trust Center
16

Accessibility

TOPICS & PRACTICAL SKILLS
  1. Accessibility Checker
  2. Alt Text
  3. Heading Order
  4. Color Contrast
  5. Screen Reader Friendly
  6. Accessible Slides
  7. Best Practices
17

Advanced Features

TOPICS & PRACTICAL SKILLS
  1. Add-ins
  2. Action Buttons
  3. Hyperlinks
  4. Macros (Intro)
  5. VBA (Intro)
  6. Interactive Presentations
  7. PowerPoint as a Tool
18

Real-World Projects

TOPICS & PRACTICAL SKILLS
  1. Professional Presentation
  2. Business Presentation
  3. Educational Presentation
  4. Project Report Presentation
  5. Portfolio / Resume Slides
  6. Interactive Quiz
  7. Final Project (Complete)

Your Skill Journey

  1. 01
    Beginner

    Basics & Interface

  2. 02
    Basic

    Slides & Formatting

  3. 03
    Intermediate

    Design & Animations

  4. 04
    Advanced

    Charts, Multimedia & Show

  5. 05
    Expert

    Collaboration & Automation

  6. 06
    Professional

    Real-World Projects

Ready to learn MS PowerPoint?Ask About This Course ↗

YOUR NEXT STEP

Build skills you can put to work.

Contact Skill Hub for fees, batch timings, software-version requirements and admission details.

In front of Kisan PG College, Bahraich, Uttar Pradesh
SKILL HUB

Explore More Courses

All courses