Description
Microsoft Office Package is designed for the students who are already familiar with the computer and want to increase knowledge further. Microsoft Office Package teaches you advance of office package and many more. Basic knowledge of computer makes you easier to enjoy and learn this course.
Who Can Join Microsoft Office Package Course?
There are no pre-requisites for this training but basic knowledge of computers is necessary to join this course. As this course is targeted for people who want to develop and further their understanding and adeptness in advance computer operation, we will start this course from scratch.
This course is especially suited for individuals that need to work with computers in their professional and personal works. Whether you are a CEO or a research student you have to use a computer for your work. With this course, you will be able to develop proficiency in using a computer and understand its operation.
Syllabus
Unit 1: Microsoft Word (15 Hrs)
- Introduction and uses of Word
- Office Button
- Home Tab
- Clipboard
- Font
- Paragraph
- Styles
- Editing
- Insert Tab
- Pages
- Tables
- Illustrations
- Links
- Header & Footer
- Text
- Symbols
- Page Layout
- Themes
- Page Setup
- Page Background
- Paragraph
- Arrange
- References
- Table of Contents
- Footnotes
- Citations & Bibliography
- Captions
- Table Of Authorities
- Mailings
- Create
- Start Mail Merge
- Write & Insert Field
- Previous Results
- Finish
- Review
- Proofing
- Comments
- Tracking
- Changes
- Compare
- Protect
- View
- Document Views
- Show/Hide
- Zoom
- Window
- Macros
- Project Work
- Letters
- Different Cover Pages
- Question Papers
- ID Card/Business Card
- Advance Form
- Curriculum Vitae
- Advance Documents
- Report writing
Unit 2: Nepali Typing(5 Hrs)
Learn nepali typing and nepali keys placement on keyboard
Unit 3: Microsoft Excel (15 Hrs)
- Introduction and uses of Excel
- Concept of sheets
- Formula bar, Headings, zoom
- Office Button
- Home Tab
- Clipboard
- Font
- Alignment
- Number
- Styles
- Cells
- Editing
- Insert Tab
- Tables (table)
- Illustrations
- Charts
- Links
- Text
- Page Layout
- Themes
- Page Setup
- Scale to fit
- Sheet Options
- Arrange
- Formula
- Function Library
- Auto Sum (sum, average, count, max, min)
- Financial (FV)
- Logical (and, if, not, or)
- Text (lower, upper, text, concatenate)
- Date & Time (date, today, now, weekday, year)
- Lookup & Reference (hlookup, vlookup)
- Defined Names
- Formula Auditing
- Calculation
- Data
- Get External Data
- Connections
- Sort & Filter
- Data Tools
- Outline
- Review
- Proofing
- Comments
- Changes
- View
- Workbook View
- Show/Hide
- Zoom
- Window
- Macros
- Project Work
Unit 4: Microsoft PowerPoint (6 Hrs)
- Introduction and uses of PowerPoint •
- Concept of slides
- Office Button
- Home Tab
- Clipboard
- Slides
- Font
- Paragraph
- Drawing
- Editing
- Insert Tab
- Tables
- Illustrations
- Links
- Text
- Media Clip
- Design
- Page Setup
- Themes
- Background
- Animation
- Preview
- Animation
- Transition to this slide
- Slide show
- Start slide show
- Set Up
- Monitors
- Review
- Proofing
- Comments
- View
- Presentation View
- Show/Hide
- Zoom
- Color/Grayscale
- Windows
- Macros
- Project Work
Unit 5: Microsoft Office Access (3 Hrs)
- Concept of Database, Data type, Creating a blank database
- Datasheet
- Views (datasheet view, design view, form view)
- Create
- Tables
- Forms
- Reports
- Design
- Controls (Button)
- External Data
- Import (text file)
- Home
- Views (datasheet view, design view, form view)
- Clipboard
- Font
- Sort & Filter
- Find
- Project Work
Unit 6: Google Apps
Google, Gmail, Docs, Slide, Sheets, Docs, Drive etc
Unit 7: AI Tools (1 Hrs)
Introduction, ChatGPT and other AI tool
Unit 8: Project Work
Project work related to word, excel, power point and office access
