Microsoft Office Package
Duration: 14 Days
Course Fee: Rs.999 /-
Rs.3500
Course Overview:
Enroll in our comprehensive Microsoft Office course to master Excel, Word, and PowerPoint. Our training includes certification, hands-on exercises, and expert support. Perfect for enhancing office productivity and skills.
What you will learn
Master essential features of Microsoft Word for document creation and formatting.
Excel proficiency for data analysis
calculations
and visualization.
Create engaging and effective presentations using Microsoft PowerPoint.
Learn time-saving tips and keyboard shortcuts for increased productivity.
Understand collaboration features and best practices in Word
Excel
and PowerPoint.
Gain practical skills applicable to real-world work scenarios.
Materials included
Free Certificate
Life time video access
Future Support
Live sessions on Google Meet
Requirements
Anyone can join this course
Course Syllabus
Day 1: 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
Day 2: 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
Day 3: 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
Day 4: Links, Symbol and Page background
- 1. Screenshot
- 2. Hyperlink
- 3. Bookmark
- 4. Water mark
- 5. Equation and Symbol
- 6. Page borders
- 7. Page color
Day 5: Layout and Protect
- 1. Margins
- 2. Orientation
- 3. Page size
- 4. Columns
- 5. Indent
- 6. Wrap Text
- 7. Security Techniques of documents
- 8. OCR
Day 6: Merging Documents
- 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
Day 7: 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
Day 8: 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
Day 9: 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
Day 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
Day 11: Sort and Filter Data with Excel
- 1. Sort and filtering data
- 2. Using number filter, Text filter
- 3. Custom filtering
- 4. Removing filters from columns
- 5. Conditional formatting
- 6. Chart
- 7. Pivot Table
Day 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. VLOOKUP
- 19. SUBTOTAL
Day 13: Data Analysis and Page Setup
- 1. Paste Special
- 2. Slicer
- 3. Automated Data Entry Form
- 4. Data analysis
- 5. Page Setup
- 6. Print titles
- 7. Heading
- 8. Header & Footer
- 9. Page num, time, date, file path, picture
- 10. Print area set
- 11. How to print
Day 14: 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
- 5. Adding text, images, and shapes
- 6. Formatting slide content
- 7. Applying slide transitions
- 8. Adding animations to slide elements
- 9. Adding multimedia elements (videos and audio)
