Office Package Course in Nepal

Microsoft Office Package Course – Master Word, Excel, PowerPoint & Outlook Skills

Microsoft Office Package

Looking for the best Microsoft Office course in Dharan or Nepal?
Join the professional Microsoft Office Training at Code IT and learn to master Word, Excel, PowerPoint, and other essential Office tools for professional productivity.

This hands-on office productivity course is ideal for students across Nepal who want to strengthen their computer skills, gain practical experience, and develop job-ready Office expertise. You’ll create documents, spreadsheets, presentations, and reports used in real-world business and office environments.

Our training program offers live online classes accessible from anywhere in Nepal, along with hands-on classroom sessions in Dharan. Develop practical Office skills, work on real projects, and prepare for professional opportunities in administration, business, and IT support roles.

Master Microsoft Office tools, improve productivity, and gain the confidence to work efficiently in today’s professional environment.

Prerequisites

Anyone can join this course
Microsoft Office Package

Microsoft Office Package

Next batch starting soon

Mode: Online (Google Meet) Google Meet
Duration: 1 Month
Rs.2,499/-
Rs.9,500 Save 73%
Enquiry

Have any Question?

WhatsApp: 9862130505
Telephone: 025-575163

Everything You Receive

All-inclusive support — from training to real-world experience

Live Classes

Google Meet
7:00 PM - 8:00 PM

Lifetime Videos

Re-watch anytime

Certification

Industry recognized

Internship

Internship is not currently available.

Course Curriculum

Everything you'll learn — from fundamentals to advanced concepts

What you will learn

  • Microsoft Word (Document Creation)

  • Microsoft Excel (Spreadsheets & Data Analysis)

  • Microsoft PowerPoint (Presentations)

  • Integration & Real-World Projects

01 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
02 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
03 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
04 Links, Symbol and Page background
1. Screenshot
2. Hyperlink
3. Bookmark
4. Water mark
5. Equation and Symbol
6. Page borders
7. Page color
05 Layout and Protect
1. Margins
2. Orientation
3. Page size
4. Columns
5. Indent
6. Wrap Text
7. Security Techniques of documents
8. OCR
06 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
07 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
08 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
09 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
10 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
11 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
12 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
13 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
14 Automated Data Entry Form
15 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
16 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)

Earn Your Certification

After completing the course, you will receive a professional certificate from Code IT, verified by industry leaders in Nepal.

Share your achievement with pride on LinkedIn.
Certificate

Course Mentors

Learn directly from industry experts with years of hands‑on experience

Sita Katuwal

Sita Katuwal

Ms office package Instructor

CodeIT, Nepal 5+ Years of Experience
Get in Touch

Need More Information?

Our team will respond within a few hours

Why Enquire?

Payment plans & installment options
Certificate & accreditation details
Course level & suitability check
Flexible batch timings
Career guidance & job support

Join 100k+ successful graduates

We'll respond within 2-3 hours during business hours