Prerequisites
Registration Open - Offer Ends Soon!
Join Our Live Class on Google Meet 
Seats Open for Prebooking
Have any Question?
Microsoft Office Package
Microsoft Office Package Course – Master Word, Excel, PowerPoint & Outlook Skills
Course Overview
Join the Best Microsoft Office Training in Nepal—Code IT Offers Affordable Courses with Free Certificate
Looking for the best Microsoft Office training in Nepal? Code IT offers the most affordable and practical Microsoft Office course in Nepal with free certification. Perfect for students, job seekers, and professionals from Dharan, Itahari, Biratnagar, Koshi Province, Mechi, and Kathmandu, this training is designed to boost your digital skills for today’s job market.
Whether you’re a complete beginner or looking to improve your existing skills, this Microsoft Office course in Nepal covers everything you need. Learn key programs like:
- MS Word – for professional document creation
- MS Excel – for spreadsheet management and analysis
- MS PowerPoint – for impactful presentations
Code IT offers Microsoft Office training online and offline, giving you the flexibility to study from home or join classroom sessions at your nearest location. If you're searching for “Microsoft Office training near me in Nepal”, this course is your perfect match.
Why choose Code IT?
- Affordable course fee
- Free certificate included
- Expert instructors
- Practical, job-focused curriculum
- Available in both online and physical classes
Upgrade your digital skills and enhance your CV with a recognized Microsoft Office certification in Nepal.
Enroll now with Code IT—the leading institute for Microsoft Office training in Nepal.
What's Included in the Course
Pre-Recorded Video
Perfect if you're outside Nepal or can't attend live sessions.
- Lifetime access to recordings
Course Syllabus
Explore the complete course syllabus to see what you'll learn from start to finish.
Introduction and Text Formatting in MS Word
- Typing the text, Alignment of text
- Editing Text: Cut, Copy, Paste, Select All, Clear
- Find & Replace
- New, Open, Close, Save, Save As
- Formatting Text: Font Size, Font Style
- Font Color, Use the Bold, Italic, and Underline
- Change the Text Case
- Line spacing, Paragraph spacing
- Shading text and paragraph
- Inserting bullets and numbered lists
- Working with Tabs and Indents
Working with Objects
- 1. Shapes, Clipart and Picture, Word Art, Smart Art
- 2. Columns and Orderings - To Add Columns to a Document
- 3. Change the Order of Objects
- 4. Page Number, Date & Time
- 5. Inserting Text boxes
- 6. Inserting Word art
- 7. Inserting Pictures
- 8. Inserting insert caption
- 9. Inserting Chart
- 10. Inserting Header and Footer
Styles & Content and Tables
- 1. Using Build- in Styles, Modifying Styles
- 2. Creating Styles, Creating a list style
- 3. Table of contents and references
- 4. Adding a Footnote
- 5. Adding Endnote
- 6. Creating Tables, Table Formatting
- 7. Table Styles
- 8. Alignment option
- 9. Merge and split option
Links, Symbol and Page background
- 1. Screenshot
- 2. Hyperlink
- 3. Bookmark
- 4. Water mark
- 5. Equation and Symbol
- 6. Page borders
- 7. Page color
Layout and Protect
- 1. Margins
- 2. Orientation
- 3. Page size
- 4. Columns
- 5. Indent
- 6. Wrap Text
- 7. Security Techniques of documents
- 8. OCR
Merging Documents and OCR
- 1. Typing new address list
- 2. Importing address list from Excel file
- 3. Write and insert field
- 4. Preview Result
- 5. Merging to envelopes
- 6. Merging to label
- 7. Setting rules for merges
- 8. Finish & Merge options
- 9. OCR
Macros and Proofing the document and Printing
- 1. View Macros
- 2. Record Macros
- 3. Make fillable form
- 4. Check Spelling As You Type.
- 5.Mark Grammar Errors As You Type.
- 6. Setting AutoCorrect Options
- 7. Page Setup, Setting margins
- 8. Print Preview, Print
Introduction to Excel and Formatting Excel Work Book
- 1. How to open excel
- 2. Title bar
- 3. Quick Access Tool bar
- 4. Tabs (Home, insert, page layout…..)
- 5. Ribbon Hide/Show
- 6. Name Box
- 7. Formula bar
- 8. Rows, columns, zoom in zoom out….
- 9. Sheet (Create and rename)
- 10. Row & Column (height, width….)
- 11. Fill Handel
- 12. Formatting Cells (font, size, color…)
- 13. Alignment (top, middle, bottom…)
- 14. Wrap text
- 15. Merge and center
- 16. Insert Row and Column
- 17. Number section (cell style)
- 18. Status Bar
- 19. File Save & Save as
Data entry and Formatting
- 1. Data entry work
- 2. Data transpose
- 3. Fill series
- 4. Keyboard navigation
- 5. Data entry Trick
- 6. Data entry form
- 7. Data validation
- 8. Flash Fill
- 9. Gridline, formula bar, heading…hide/show
- 10. Cell format & style (pcs, Rs,..)
- 11. Blank cell finds and auto fill
- 12. Blank row finds and delete
- 14. Remove duplicate
Number, Editing and Table
- 1. Across worksheet
- 2. Clear format & input data
- 3. Decrease & increase Decimal
- 4. Sum
- 5. Percentage
- 6. Average
- 7. Max
- 8. Min
- 9. Count Number
- 10. Create table
- 11. Table to range
- 12. Freeze pane
- 13. Data selection trick
Excel Data Analysis
- 1. Sort
- 2. Filter
- 3. Table
- 4. Conditional formatting
- 5. Highlight Cell Rules
- 6. Top Bottom Rules
- 7. Data Bars
- 8. Colors Scales
- 9. Icon Sets
- 10. Manages Rules
Perform Calculations with Functions
- 1. How to Apply Formula
- 2. SUM
- 3. Trace President
- 4. Subtraction
- 5. Multiplication
- 6. Percentage
- 7. Division
- 8. Count
- 9. Counta
- 10. Countblank
- 11. Countif
- 12. Rank
- 13. IF
- 14. IF OR
- 15. Number to Grade
- 16. Average
- 17. SUMIF
- 18. SUBTOTAL
- 19. VLOOKUP
Power Query
- 1. Split column in power query
- 2. Group by Power Query
- 3. Unpivot Column
- 4. Append Query
- 5. Merge Query
- 6. Append Multiple Table using Power Query
- 7. Date function in power query
- 8. Time Difference in power query
- 9. Add Column in Power Query
Automated Data Entry Form
Page Setup
- 1. Paste Special
- 2. Slicer
- 3. Page Setup
- 4. Print titles
- 5. Heading
- 6. Header & Footer
- 7. Page number, time, date, file path, picture
- 8. Print area set
- 9. How to print
Introduction to MS PowerPoint Interface and Advanced Features
- 1. Overview of slides, layouts, and themes
- 2. Ribbon, tabs, and command groups
- 3. Starting a new presentation
- 4. Adding and arranging slides
- 4. Adding text, images, and shapes
- 5. Formatting slide content
- 6. Applying slide transitions
- 7. Adding animations to slide elements
- 8. Adding multimedia elements (videos and audio)
Need More Information About This Course?
Have questions or need clarification? Our education specialists are ready to assist you. Complete the form below and we'll respond within 1 hours.
Frequently Asked Questions
Code IT is a professional IT training institute that offers both online and offline courses in various fields like Web Development, Networking, Graphic Design, and more.
Yes, you will receive a certificate upon successful completion of the course.
Internship opportunities are available for most students; however, some courses do not include internships.
Yes, we offer job placement support. Terms and conditions apply.
Yes, the course fee must be paid during registration to confirm your seat.
Yes, demo classes are available. You can find them at the top of this syllabus — click the "Watch Demo" button.
Yes, you will get access to recorded class videos, which you can watch anytime with lifetime access.
Yes, Code IT provides lifetime support to all students, even after course completion.
No, the fee is non-refundable. However, you can transfer to another class if you inform the administrator within 1 day of the course start date.
Similar Courses
Explore other courses that match your interest and help you upgrade your skills. Whether you're starting fresh or looking to specialize, these related courses are perfect next steps in your learning journey.
