Advanced Excel
Take Excel to the next level — Power Query, Power Pivot, advanced dashboards, and financial modelling for data-driven decision making.
₹3,500 35 Classes
Complete Office Automation Training
MS Office Complete
Course in Howrah & Kolkata
Master the world's most widely used office suite — Microsoft Office. From creating professional Word documents and building powerful Excel spreadsheets with 100+ formulas to designing animated PowerPoint presentations, managing email, and browsing the internet — become fully office-ready in 40 expert-guided classes.
MS Windows
MS Word
MS Excel
PowerPoint
Internet & Email
40
Classes
40h
Duration
5
Modules
100+
Formulas
10–15
Batch Size
Course Details
What You Get
Everything you need to become a confident MS Office professional — Word, Excel, PowerPoint, Internet, and Email — all in one structured, hands-on course.
40 Classes · 40 Hours
A comprehensive, expert-paced 40-hour programme covering every aspect of MS Office — from Windows basics and Word formatting to Excel macros, PowerPoint animations, and internet communication.
ISO & MSME Certificate
Earn a government-recognized, ISO-certified completion certificate that adds real credibility to your resume and proves professional MS Office training to employers and government offices.
100+ Excel Formulas
Master over 100 Excel formulas and functions — SUM, VLOOKUP, IF, SUMIFS, date/time, financial, statistical, text functions and more — making you a sought-after data professional.
Small Batch Sizes
Only 10–15 students per batch ensures personal attention, faster doubt resolution, and a genuinely productive learning environment where every student masters every concept.
Bengali & Hindi Medium
Complex MS Office concepts — Mail Merge, PivotTables, Macros, Slide Masters — explained clearly in Bengali and Hindi for deeper understanding and faster practical mastery.
Module-wise Assessments
Regular tests and practicals after each module confirm your understanding — ensuring you truly master Word, Excel, and PowerPoint before advancing, building real office-ready confidence.
Full Curriculum
Course Syllabus
5 comprehensive modules — Computer Basics, MS Word, MS Excel (with 100+ formulas), MS PowerPoint, and Internet & Email.
Module 1: MS Windows & Computer Basics
Begin your digital journey from the ground up. Learn what makes a computer tick — hardware vs. software, input/output devices, storage, and the Central Processing Unit. Master the Windows environment: creating folders, using Paint, navigating directories, and the most essential keyboard shortcuts to work faster and smarter from day one.
5 LessonsHardwareSoftwareWindowsShortcuts
01
Computer Basics, Folders & PaintUnderstanding what a computer is — its role and importance in daily life. Creating and managing folders and files on the desktop and in Windows Explorer. Introduction to Microsoft Paint for basic digital drawing and image editing. Learning the file system hierarchy.
02
Directories & Input/Output UnitsUnderstanding the Windows directory and folder structure. Deep dive into input devices — keyboard, mouse, scanner, webcam, microphone — and output devices — monitor, printer, speaker, projector. Practical exercises with each device type for confident daily use.
03
Central Processing Unit (CPU)Understanding the brain of the computer — CPU architecture, clock speed, cores, RAM vs. ROM, primary vs. secondary storage (HDD, SSD, USB, CD/DVD). How the CPU fetches, decodes, and executes instructions. Practical understanding for making smart computer buying decisions.
04
Hardware vs. SoftwareClear distinction between hardware (physical components) and software (programs and operating systems). System software vs. application software vs. utility software. Understanding licensed, freeware, and open-source software. Introduction to Windows OS and how it manages hardware resources.
05
Windows Shortcut KeysMastering the most powerful productivity tool — keyboard shortcuts. Essential Windows shortcuts: Ctrl+C/V/X/Z, Win+D, Alt+Tab, Ctrl+Alt+Del, Ctrl+Shift+Esc, Win+E, F2, F5, and 20+ more. Practice drills to build muscle memory for dramatically faster computer operation in any office environment.
Module 2: MS Word — Complete Document Mastery
From typing your first sentence to producing professional multi-page reports, legal documents, and mail-merged letters — MS Word is mastered here comprehensively. Covers formatting, tables, styles, table of contents, mail merge, headers & footers, proofing, and printing — everything a professional office worker needs daily.
11 TopicsFormattingTablesMail MergeStylesPrinting
01
Text Basics — Typing, Alignment & EditingTyping and entering text in Word. Text alignment (left, center, right, justify). Essential editing operations: Cut, Copy, Paste, Select All, Clear, Undo, Redo. Using Find & Replace to quickly locate and update content across long documents — a critical productivity skill.
02
Text Formatting & File ManagementFile operations: New, Open, Close, Save, Save As. Text formatting: Font Size, Font Style, Font Color, Bold, Italic, Underline. Text case conversion (UPPERCASE, lowercase, Sentence case). Line and paragraph spacing. Shading text and paragraphs. Working with Tabs and Indents for professional document layout.
03
Working with Objects & VisualsInserting and formatting Shapes, ClipArt, Pictures, WordArt, and SmartArt for visually rich documents. Working with Columns for newsletter-style layouts. Changing object order (Bring Forward / Send Backward). Arithmetic expressions in Word. Inserting Page Numbers, Date & Time, Text Boxes, Symbols, and Charts.
04
Headers, Footers & Section BreaksCreating fully custom headers and footers — company logos, automatic page numbers, document titles. Inserting objects (images, dates, page numbers) inside headers and footers. Adding section breaks to apply different headers/footers to different parts of a document — essential for professional reports.
05
Bullets, Numbered Lists & Page DesignMultilevel numbered lists and custom bullet points. Creating and customizing list styles. Page bordering for certificates, reports, and invitations. Page background color and fill effects. Creating visually polished documents with consistent, professional list formatting throughout.
06
Tables — Creation, Formatting & DesignCreating tables from scratch and converting text to tables. Complete table formatting: borders, shading, cell padding. Applying built-in table styles. Alignment options for text inside cells. Merging and splitting cells for complex document layouts. Using tables for invoices, schedules, and data presentation.
07
Styles, Table of Contents & ReferencesUsing and modifying built-in heading styles (H1, H2, H3) for structured documents. Creating custom paragraph and list styles. Auto-generating a Table of Contents from heading styles. Adding internal references, cross-references, Footnotes, and Endnotes — essential for academic and legal documents.
08
Mail Merge — Letters, Labels & EnvelopesMastering Mail Merge — the most powerful Word skill for office work. Creating address lists directly or importing from Excel. Writing and inserting merge fields. Merging with Outlook contacts. Preview results before printing. Merging to envelopes, mailing labels, setting conditional rules for merges, and Finish & Merge options.
09
Sharing, Maintaining & Protecting DocumentsChanging Word options and proofing tool settings. Managing and creating document templates. Restricting document access with passwords and permissions. Using Protected View for safe document opening. Working with building blocks and understanding template libraries for consistent organizational document standards.
10
Proofing — Spelling, Grammar & AutoCorrectReal-time spell checking as you type. Grammar error marking and correction suggestions. Setting up AutoCorrect options for commonly mistyped words and automatic text expansion — a huge time saver. Using the Thesaurus and word count tools for polished, error-free professional writing.
11
Page Setup & PrintingComplete page setup: paper size (A4, Letter, Legal), margins, orientation (portrait/landscape). Print Preview to verify final layout before printing. Printing options: specific pages, number of copies, printer selection, double-sided printing. Exporting documents to PDF for sharing and archiving.
Module 3: MS Excel — Data, Formulas & Analysis
Excel is the world's most powerful data tool — and you'll master it completely. From basic cell operations and 100+ formulas to PivotTables, PivotCharts, Macros, conditional formatting, data sorting & filtering, and workbook protection. Walk out Excel-confident for any office, accounting, or data role.
10 Topics100+ FormulasPivotTableChartsMacrosData Analysis
01
Introduction to Excel InterfaceThe Excel environment — Ribbon, Quick Access Toolbar, Formula Bar, Name Box, Sheet tabs. Understanding rows, columns, cells, and cell addresses (A1 notation). Naming cells and ranges for easier formula writing. Working with Excel workbooks and managing multiple sheets — inserting, renaming, moving, copying, and deleting sheets.
02
Formatting Excel WorkbooksFile operations (New, Open, Save, Save As). Text formatting: Font Size, Style, Color, Bold, Italic, Underline. Wrap Text and Merge & Centre for complex headers. Currency, Accounting, percentage, and other number formats. Modifying column widths, row heights, and cell sizes. Cell borders, fill colors, and applying professional cell styles.
03
100+ Formulas & FunctionsBuilding your formula toolkit from scratch to advanced. Simple arithmetic formulas. Date & Time functions (TODAY, NOW, DATEDIF, NETWORKDAYS). Financial functions (PMT, FV, PV, NPV). Logical functions (IF, IFS, AND, OR, NOT). Lookup & Reference (VLOOKUP, HLOOKUP, INDEX, MATCH, XLOOKUP). Mathematical (SUM, SUMIF, SUMIFS, POWER, SQRT, MOD, ROUND). Statistical (AVERAGE, COUNT, COUNTIF, MAX, MIN, RANK). Text functions (LEFT, RIGHT, MID, LEN, TRIM, CONCATENATE, UPPER, LOWER).
04
Sorting, Filtering & Conditional FormattingSorting data by single and multiple columns (A–Z, Z–A, custom order). Using AutoFilter for quick data filtering. Number filters, text filters, date filters, and custom filter conditions. Removing filters cleanly. Conditional Formatting — highlighting cells by rules, data bars, color scales, and icon sets to make patterns and outliers instantly visible.
05
Charts — Creating Effective Data VisualizationsInserting Column, Bar, Line, Pie, Area, Scatter, and Combo charts. Using Chart Tools — Design, Format, and Layout tabs. Adding chart titles, axis labels, and legends. Changing chart types and layouts. Applying chart styles and color schemes. Editing chart data ranges and data series. Moving charts between sheets for professional dashboard-style reports.
06
PivotTables & PivotChartsUnderstanding PivotTables — the most powerful Excel analysis tool. Creating PivotTables from raw data. PivotTable field list — rows, columns, values, filters. Using PivotTable and PivotChart Frameworks. Creating PivotCharts from PivotTables. Inserting Slicers for interactive dashboard-style data filtering. Creating calculated fields for custom metrics inside PivotTables.
07
Protecting & Sharing WorkbooksProtecting a workbook with a password to prevent unauthorized editing. Setting user permissions to allow editing in specific ranges only. Tracking changes — reviewing, accepting, and rejecting edits. Working with cell comments for collaborative annotation. Inserting Excel objects and charts inside Word documents and PowerPoint presentations for unified professional reporting.
08
Macros — Task AutomationIntroduction to Macros — automating repetitive Excel tasks with one click. Recording and running Macros using the Macro Recorder. Assigning Macros to buttons on the worksheet for easy access. Saving Macro-enabled workbooks (.xlsm format). Overview of the Visual Basic Editor (VBE) for understanding and lightly editing recorded Macro code.
09
Proofing & Printing SpreadsheetsPage setup for printing: paper size, orientation, scaling to fit. Setting print areas to print only selected data regions. Print Titles to repeat header rows on every printed page. Inserting custom headers and footers with page numbers, dates, and company names. Print Preview. Enabling background error checking and AutoCorrect options for clean, error-free workbooks.
10
100+ Excel Formulas — Practice SprintDedicated formula practice sessions covering the full formula library: SUM, SUMIF, SUMIFS, POWER, SQRT, MOD — mathematical foundations. String manipulation with LEFT, RIGHT, MID, LEN, FIND, SUBSTITUTE, TRIM, CLEAN. Date-time mastery with TODAY, YEAR, MONTH, DAY, EDATE, EOMONTH. Real business problems solved using formula combinations and nested functions.
Module 4: MS PowerPoint — Presentations That Impress
Transform your ideas into dynamic, animated presentations that captivate any audience. From creating slides and applying themes to embedding movies, audio, SmartArt, animation, and custom slide shows — master every PowerPoint tool needed to present confidently in classrooms, boardrooms, and interviews.
11 TopicsThemesAnimationSmartArtAudio/VideoSlide Master
01
PowerPoint Environment SetupThe PowerPoint interface — Ribbon, Slide Panel, Notes pane, and View options. File operations (New, Open, Save, Save As). Typing and aligning text in placeholders. Text formatting (Font, Size, Color, Bold, Italic, Underline). Editing operations (Cut, Copy, Paste, Find & Replace). Working with Tabs, Indents, and text layout within text boxes.
02
Creating Slides & Applying ThemesInserting and managing slides — New Slide, Duplicate, Copy, Move, Delete. Changing slide layouts for different content types (Title, Content, Blank, etc.). Applying professional themes for instant visual consistency. Customizing theme colors, fonts, and effects. Setting slide background colors, gradients, textures, and pictures. Using different slide views (Normal, Slide Sorter, Reading View).
03
Bullets, Numbering & Text DesignMultilevel bullet points and numbered lists with custom styles. Creating and customizing list formatting. Page bordering for title slides. Slide background design. Text alignment options — left, center, right, justify. Text direction and vertical alignment. Using multi-column text boxes for magazine-style slide layouts.
04
Working with Objects & VisualsInserting and formatting Shapes, ClipArt, Pictures, and WordArt. Changing the stacking order of objects (Bring Forward / Send Backward / Group). Inserting slide headers and footers with slide numbers and dates. Working with Text Boxes, Quick Styles, WordArt, and Symbols. Inserting and formatting Charts for data-driven slides.
05
Hyperlinks & Action ButtonsInserting clickable Hyperlinks — linking to websites, other slides, documents, and email addresses. Creating Action Buttons for interactive, non-linear presentations (navigation buttons, home buttons). Editing and removing Hyperlinks and Action Buttons. Using WordArt and Shapes as clickable navigation elements for kiosk-style interactive presentations.
06
Working with Movies & SoundsInserting video files from your computer directly into slides. Inserting audio files — background music, narration, sound effects. Audio and video playback options — loop, start automatically, hide during show. Video format options: trim, add video styles, borders, and effects. Reshaping and bordering video objects for polished multimedia presentations.
07
SmartArt & TablesUsing SmartArt to visually represent processes, hierarchies, cycles, and relationships with one click. Converting plain bullet text to SmartArt instantly. Complete table creation and formatting — Table Styles, borders, shading, alignment, merge and split. Designing comparison and specification tables that communicate data clearly and professionally.
08
Animation & Slide TransitionsApplying and customizing Entrance, Emphasis, Exit, and Motion Path animations to any object. Modifying animation timing, speed, direction, and sequence. Reordering animations in the Animation Pane. Applying slide Transition effects — fade, push, wipe, split, and more. Setting transition timing, sounds, and automatic advancement for self-running presentations.
09
Slide Master — Consistent BrandingUsing the Slide Master to apply consistent formatting across all slides simultaneously — fonts, colors, logos, backgrounds. Inserting and customizing slide layouts in the Slide Master. Creating brand-new custom layouts. Inserting and formatting placeholders for titles, content, and graphics. Building a reusable branded presentation template from scratch.
10
Slide Show Options & Custom ShowsStarting slide shows from the beginning or current slide. Using Presenter View for dual-monitor presentations. Rehearsing and recording slide timings for self-running presentations. Creating Custom Slide Shows — presenting only selected slides for different audiences from the same master file. Laser pointer, pen, and highlighter tools during live presentations.
11
Proofing, Exporting & PrintingReal-time spell checking and AutoCorrect setup. Saving in multiple formats: Save as Video (.mp4) for YouTube/social media, Save as JPEG images for slide thumbnails, Save as PowerPoint Show (.ppsx) for direct presentation launch. Printing slides, handouts (2, 4, 6 slides per page), notes pages, and outlines. Full Print Preview and printer setup options.
Module 5: Internet & Email — Digital Communication Skills
The internet is the backbone of modern work and communication. Learn how to use email professionally for sending, receiving, and managing attachments; browse the web efficiently using search engines; download and upload content; use voice and video chat; search for jobs online; and confidently use social media and blogging platforms.
7 LessonsEmailBrowsingJob SearchSocial MediaVideo Chat
01
What is the Internet & Email BasicsUnderstanding the internet — what it is, how it works (ISPs, TCP/IP, DNS), types of internet connections (broadband, Wi-Fi, mobile data). Creating email accounts (Gmail, Outlook). Understanding the email interface: Inbox, Sent, Drafts, Spam, Trash. Receiving and reading incoming messages. Email etiquette for professional communication.
02
Sending Email & AttachmentsComposing professional emails — To, CC, BCC addressing rules and when to use each. Writing clear subject lines and professional email bodies. Sending outgoing messages with proper formatting. Email attachments — attaching documents, images, PDFs, and ZIP files. Managing inbox: replying, forwarding, flagging, archiving, deleting, and organizing with labels/folders.
03
Web Browsing & Search EnginesUsing Google Chrome, Microsoft Edge, and Firefox. Understanding URLs and website addresses. Using search engines effectively — Google search operators and tricks for finding exactly what you need. Bookmarking and managing favorite websites. Browser settings — clearing cache, managing downloads, private/incognito mode, extensions, and security settings.
04
Text Chatting & Job Searching OnlineUsing text chat platforms — WhatsApp Web, Google Chat, Microsoft Teams. Professional communication etiquette in digital chat. Job searching online — using Naukri, LinkedIn, Indeed, Internshala, and government job portals. Creating a compelling online job profile. Applying for jobs online: uploading resumes and filling application forms.
05
Downloading & Uploading FilesSafely downloading videos, music, software, and documents from trusted websites. Understanding file formats and sizes. Using Google Drive, Dropbox, and OneDrive for cloud file storage and sharing. Uploading videos and music to YouTube and other platforms. File compression (ZIP/RAR) for faster sharing. Avoiding malware when downloading files.
06
Voice Chatting, Video Calls & WebcamSetting up and using Google Meet, Zoom, and Microsoft Teams for professional video meetings. Voice and video calling via WhatsApp, Skype, and Google Duo. Webcam setup — testing, lighting, and framing for professional appearance. Screen sharing during video calls. Recording meetings. Best practices for online meetings in professional and academic settings.
07
Introduction to Blogging & Social MediaUnderstanding social media platforms — Facebook, LinkedIn, Instagram, Twitter/X, and YouTube. Creating a professional LinkedIn profile for career growth. Introduction to blogging — what it is, platforms (Blogger, WordPress), and how bloggers earn online. Understanding digital marketing basics. Safe and responsible internet use: privacy settings, avoiding scams, and online security best practices.
What You'll Learn
Learning Outcomes
Graduate with the MS Office skills needed for any office, administrative, data entry, or clerical role — fully job-ready from day one.
Create Professional Word Documents
Produce polished, multi-page reports, letters, CVs, invoices, and legal documents with proper formatting, styles, Table of Contents, Mail Merge, and perfect printing — indistinguishable from expert office work.
Build Powerful Excel Spreadsheets
Create complex Excel workbooks using 100+ formulas, PivotTables, charts, conditional formatting, Macros, and data validation — handling real business data with speed and accuracy.
Design Impressive Presentations
Build animated, branded PowerPoint presentations with embedded media, SmartArt, custom slide masters, and dynamic transitions — confidently presenting to any audience, from classrooms to boardrooms.
Communicate Professionally by Email
Write, send, and manage professional emails with proper etiquette, attachments, CC/BCC protocols, and folder organization — handling digital communication with confidence in any workplace.
Use the Internet for Work & Career
Browse efficiently, search for jobs on professional portals, use cloud storage, participate in video meetings, and leverage social media and LinkedIn for career growth and professional networking.
Become Fully Office-Ready
Walk into any office, bank, school, government department, or corporate job with complete confidence — operating computers, managing files, drafting documents, analyzing data, and communicating digitally at a professional standard.
Who Should Join?
This Course Is For You
Whether you're a school leaver, job seeker, working professional, or business owner — this course gives you complete MS Office mastery for real-world success.
🎓
Students & Freshers
Class 10/12 passouts, college students, and recent graduates who need MS Office skills to apply for jobs, internships, and competitive exams requiring computer proficiency.
💼
Job Seekers
Anyone preparing for data entry, office assistant, accountant, administrative, or government job roles — where MS Office proficiency is a mandatory requirement for selection.
🏢
Working Professionals
Employees in any industry who want to upgrade their MS Office skills — mastering Excel formulas, PowerPoint design, and Word automation to work faster and impress management.
🏪
Business Owners
Small business owners, shopkeepers, and entrepreneurs who want to manage accounts in Excel, create professional quotations in Word, and present business plans in PowerPoint.
FAQ
Frequently Asked Questions
What is the fee for the MS Office course at PBA Institute?
The batch class fee is ₹3,000 for the complete course (40 classes, 40 hours). One-to-One personalized sessions are ₹6,000 with dedicated instructor attention and a fully flexible schedule. Both options include study materials, software installation support, and an ISO-certified certificate.
Do I need any prior computer knowledge to join?
No prior computer experience is required at all. The course begins from absolute basics — what is a computer, how to use a keyboard and mouse, how to create folders. Anyone who can read and write is eligible to join. Our Bengali and Hindi medium instruction makes learning accessible to all.
What can I do after completing the MS Office course?
After completing this course you will be able to create professional Word documents, build Excel spreadsheets with 100+ formulas, design animated PowerPoint presentations, manage email professionally, and use the internet for work and career development — making you fully job-ready for office, administrative, data entry, and many other roles.
Is MS Office knowledge still important in 2025?
Absolutely. MS Office remains the world's most widely used productivity software across every industry — banking, government, education, healthcare, retail, and corporate. Most job listings in India explicitly require MS Office proficiency. Excel alone is considered a fundamental skill for any data, finance, or administrative career in 2025 and beyond.
Is there an online option for the MS Office course?
Yes. PBA Institute offers both online and in-person classes from our Howrah campus. Online sessions are conducted live with the same instructor and identical content — with full screen sharing, live demonstration, and real-time doubt resolution throughout every class. You can join from anywhere in West Bengal or across India.
What certificate will I receive after the course?
You will receive a completion certificate from PBA Institute — ISO 9001:2015 Certified and MSME Government Registered. This credential adds genuine value to your CV and portfolio, demonstrating professionally verified MS Office training to employers, government departments, and educational institutions across India.
Start Your Office Career Today
Ready to Master MS Office?
Join PBA Institute's MS Office course in Howrah. Learn Word, Excel, PowerPoint, Internet & Email — earn an ISO certificate, become office-ready, and unlock jobs across every industry in India.
Explore More
Related Courses
Supercharge your career further with these courses at PBA Institute — perfect complements to your MS Office skills.