Join the Best Microsoft Office Course in Nepal
Enroll in our comprehensive Microsoft Office course to master Excel, Word, and PowerPoint
Duration: 1 Month
Course Fee: Rs.1499 /-
Rs.9500
Course Overview:
MS office package is a widely used productivity software used for both personal and professional purpose or it can also used as educational purpose. At CodeIT, MS office package is designed to help individuals to master in essential tools productively and efficiently. in this course core topics are covered such as MS powerpoint, MS excel, MS word, etc these three essentials topics are mainly used in our daily life premises. This course is perfect for those who wants to improve their skills in these programs where they can mastered in shortcut keys and formulas in respective terms.
Course Objectives
By the end of this course, students will:
- Gain proficiency in creating, editing, and managing Excel spreadsheets for data analysis and reporting.
- Master the use of PowerPoint to design engaging and professional presentations.
- Learn to leverage advanced features like formulas, charts, animations, and transitions.
- Understand best practices for organizing data and delivering impactful presentations.
What you will learn
Microsoft Word:
Document creation and formatting.
Editing tools and features.
Collaboration and sharing options.
Microsoft Excel:
Spreadsheet creation and organization.
Formulas
functions
and calculations.
Data analysis and visualization.
Microsoft PowerPoint:
Presentation design and layout.
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)
