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.
Materials included
Free Certificate
Life time video access
Future Support
Live sessions on Google Meet
Requirements
Anyone can join this course
Course Syllabus
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)
